summaryrefslogtreecommitdiff
path: root/sc/qa
AgeCommit message (Collapse)AuthorFilesLines
2017-10-31Removed duplicated includeAndrea Gelmini1-1/+0
Change-Id: I492238cb7c16f240010266765a342c3514f989a5 Reviewed-on: https://gerrit.libreoffice.org/44061 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2017-10-31Rename class from ScAreaLink to ScAreaLinkObjJens Carl1-10/+10
Rename class for sc_arealink so it aligns with the rest of sc unit tests objects. Change-Id: If8b8497d841e0c3215a55171a1aa036718f8b387 Reviewed-on: https://gerrit.libreoffice.org/44038 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904: Move Java _XSheetFilterable test to C++Jens Carl3-7/+41
Change-Id: Ib94aeb98c9c659118800b2dcc327c44a77d5fcc6 Reviewed-on: https://gerrit.libreoffice.org/44019 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904: Move Java _XSheetFilterDescriptor tests to C++Jens Carl1-0/+102
Change-Id: If9bbef199f2c698f9ffeb3d57423b66ebd439a94 Reviewed-on: https://gerrit.libreoffice.org/43635 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904: Move Java _XSheetLinkable tests to C++Jens Carl1-17/+30
Change-Id: I0f99c3b4a74748d7f1c73ef584170ae84b08cd9a Reviewed-on: https://gerrit.libreoffice.org/43582 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904: Move Java _XSheetOperation tests to C++Jens Carl4-17/+155
Change-Id: I5aaeebd074882bb05a78e6d4057162e1da61d673 Reviewed-on: https://gerrit.libreoffice.org/43539 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904: Move Java _XSheetPageBreak tests to C++Jens Carl1-9/+16
Change-Id: I29111c3495fc9767d1b2c7bab38af5f89b7840f9 Reviewed-on: https://gerrit.libreoffice.org/43399 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904 Move Java _XSpreadsheet tests to C++Jens Carl1-6/+14
Change-Id: Idb398c87c89aa9b5613b9952bffde5929c1bc76b Reviewed-on: https://gerrit.libreoffice.org/43398 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904 Move _XSubTotalCalculatable Java tests to C++Jens Carl3-6/+59
Change-Id: I18199a9cc79e6a109c8de0026b37a67f85cf778a Reviewed-on: https://gerrit.libreoffice.org/42265 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-29tdf#45904: Move _XSubTotalDescriptor Java tests to C++Jens Carl1-0/+114
Change-Id: Ie1ec8879972f77c5278992aadf9324f755859d96 Reviewed-on: https://gerrit.libreoffice.org/42096 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-27Handle decimalSeparatorAlternative in ScColumn::ParseString(), tdf#81671Eike Rathke1-0/+1
Change-Id: I9f708b28ee5fdb23217e75386a64ab86dacfd3c4
2017-10-25loplugin:unnecessaryoverrideNoel Grandin1-6/+0
Change-Id: If90856d9d69c78a5e63fb437d6f34bae4ee5547f
2017-10-23loplugin:includeform: scStephan Bergmann33-236/+236
Change-Id: I2ed763e0584a188032c80fde60890de3c6985cbd
2017-10-23tdf#96505 Get rid of cargo cult long integer literalsudareechk1-12/+12
Removed 0L, 1L and 2L Change-Id: Icb38de1cdd8e1215a86118b0c8af993025fd790e Reviewed-on: https://gerrit.libreoffice.org/42567 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com>
2017-10-22sc lok: fix spell checking languages in CalcHenry Castro1-0/+51
Change-Id: Iadcc3b55a30ce2a2c785366fb3807ff6e4bda1fe Reviewed-on: https://gerrit.libreoffice.org/43581 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Henry Castro <hcastro@collabora.com>
2017-10-21coverity#1401307 document checked 'Uncaught exception'Caolán McNamara2-3/+3
markup std::unique_ptr where coverity warns a dtor might throw exceptions which won't throw in practice, or where std::terminate is an acceptable response if they do Change-Id: Icc99cdecf8d8b011e599574f0a05b59efd1c65c2 Reviewed-on: https://gerrit.libreoffice.org/41561 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2017-10-19tdf#113211: fix calculations with big integersMike Kaganski1-728/+528
... and munbers with few fractional bits Change-Id: I86c3e8021e803fed498fae768ded9c9e5337c8bd Reviewed-on: https://gerrit.libreoffice.org/43477 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com>
2017-10-19tdf#113268: Pivot table: Missing popup button after opening a ODSTamás Zolnai2-0/+30
Wrong row number was calculated here. This ++nCurRow is usefull only when headerlayout flag is set. It's a MSO compatibility flag so it's not there by default in LO created tables. Change-Id: Id7989d898f2647f1ba45ed95e0aa615e3b4fa311 Reviewed-on: https://gerrit.libreoffice.org/43552 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-10-19tdf#113159: Pivot table: tabular mode is converted to oultine modeTamás Zolnai2-0/+20
... after RT XLSX in Calc Change-Id: I9725ca55aed973133db1d5fe47463575148e00b8 Reviewed-on: https://gerrit.libreoffice.org/43537 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-10-18add CVE-2017-0199 test-casesCaolán McNamara2-0/+0
Change-Id: I562c16a1dfcf4d8ba6b893da71ae557c4811ac24 Reviewed-on: https://gerrit.libreoffice.org/43480 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2017-10-09tdf#45904: Move _XAreaLinks Java to C++Jens Carl1-0/+97
This allows to re-activate the test and fixes #i84701. Change-Id: Ifd295e9521a04e88a68aa96fad8f9e8e32f927fa Reviewed-on: https://gerrit.libreoffice.org/41855 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-08tdf#45904: Move _XSubTotalField Java tests to C++Jens Carl2-1/+119
Change-Id: I64528c4e315247583e185bc3ab0defbc22bd8726 Reviewed-on: https://gerrit.libreoffice.org/41826 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-10-07tdf#109016: Avoid to write the same pivot item member more timesTamás Zolnai2-0/+16
It seems it's allowed to have the same member name in a pivot table. We need to handle this in the filtering code. Regression from: 625653c8d119e720fb93b0c9f6f50d1eb625b179 Change-Id: Ic6f4110da3d83f4bbf5284e1b772e9e31b250bf1 Reviewed-on: https://gerrit.libreoffice.org/43230 Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com> Tested-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-10-06tdf#112946: Pivot table: Missing selector for a row field after RT in CalcTamás Zolnai2-0/+19
We need to explicitly set compact flags to false, since true is the default. It seems MSO prefers compact mode, when the file contains colliding mode flags. Change-Id: Ib311f1cf44345be294e6c6607c227c2baa0fb693 Reviewed-on: https://gerrit.libreoffice.org/43210 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-10-05tdf#112893: Pivot table: filtering of error item is not importedTamás Zolnai2-0/+32
... from XLSX Change-Id: Ib155852e5f0718f41e02596d1042513286c6d845 Reviewed-on: https://gerrit.libreoffice.org/43166 Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com> Tested-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-10-02TypoPranav Kant1-1/+1
Change-Id: I2ecf3050aa68a0f2986c43b651d71b662a77e55a
2017-09-30Fix typosAndrea Gelmini1-1/+1
Change-Id: Ic09de64e5672d66b7436a6525344f845550523f9 Reviewed-on: https://gerrit.libreoffice.org/42982 Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Tested-by: Julien Nabet <serval2412@yahoo.fr>
2017-09-30tdf#107711:Pivot table: filtering of non-string fields is not exported to XLSXTamás Zolnai6-0/+341
Same issue what we have in case of XLS filter. We need to have the right string representation of pivot field items. Change-Id: Ifb686ad268c61b03c7dcccc66f65e6f8247eab4f Reviewed-on: https://gerrit.libreoffice.org/42956 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-09-30tdf#112733: Pivot table is displayed wrong in Excel after saved in LO CalcTamás Zolnai2-0/+23
Change-Id: I5dad2ff95ab5dd090296cf8c6e4a8274355c262b Reviewed-on: https://gerrit.libreoffice.org/42955 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-09-29sc: fix loplugin:unnecessaryoverride warningMiklos Vajna1-6/+0
Change-Id: I3b7e7a5dae9f393e3388bc5a3ab3666f116570ab
2017-09-29Get rid of some pointless cleanups that fail anyway occasionallyTor Lillqvist1-6/+0
Change-Id: I758b4452bdf0cfcc75280a73993f219a57072e41
2017-09-28The OpenCL XIRR test fails randomly on some machines so bin itTor Lillqvist2-25/+0
We don't even use OpenCL for XIRR normally anyway. Change-Id: I4bd76e9c5a0ad2222bef47d801f956fda1da568c
2017-09-27Test also SUMIFS where no row matchesTor Lillqvist1-2/+9
Change-Id: Ifd4ab6f1760a5088744cb728a3e0c970388d8283
2017-09-26tdf#112288 Clarify Reschedule implementationsJan-Marek Glogowski1-1/+0
Application::Reschedule(true) must just process all currently pending events and ignore all new events generated while processing them. In contrast to Scheduler::ProcessEventsToIdle, this way it can't busy-lock the application with background jobs. This way we also can drop nMaxEvents from the Windows backend. This limit was also never implemented on OSX and for the KDE4 backend it's actually impossible to handle single events, and a call to QAbstractEventDispatcher::processEvents works like this. Also changes various call sites to just process all pending events instead of some made up number of times. Change-Id: I1ab95df89b079cc8c6319a808194fe3127144d1c Reviewed-on: https://gerrit.libreoffice.org/42659 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Jan-Marek Glogowski <glogow@fbihome.de>
2017-09-21tdf#112501: Pivot table: popupbuttons are placed on wrong cellsTamás Zolnai2-0/+69
...imported from XLS Change-Id: I45bc4a0182e6a62471bc02ac1bca31f9735e6566 Reviewed-on: https://gerrit.libreoffice.org/42508 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-09-20tdf#112005 xmloff: ODF export: export embedded object text *first*Michael Stahl1-0/+22
... before adding any attributes, so that the attributes don't erroneously get added to the paragraph element. Also fix the problem that if you set "ODF format version" to 1.1 or 1.2, export asserts in SvXMLNamespaceMap::GetQNameByKey() because the "loext" namespace isn't registered, and creates an invalid <p> element. Change-Id: I637f9d3ff746d877ced480e35ef53f4545a06a4b
2017-09-15Test joining two disjoint ranges into one by adding a third inbetweenTor Lillqvist1-0/+20
In particular, the case where the third one even overlaps one of the existing ones, not just borders it. Change-Id: I3a0dff51a68b048b615f60e579e6e698518cf1bd
2017-09-15Handle also the case where a range extends an existing one with overlapTor Lillqvist1-0/+34
Check for a new range being joined Extending an existing one in any of four directions (up, right, down, left), within a tab (sheet), that is. And add unit test for this. Change-Id: I4bd0525c2837f8b4b9d5a8967e0d5d661c6a5e2f Reviewed-on: https://gerrit.libreoffice.org/42304 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2017-09-15convert SvxCellVerJustify to scoped enumNoel Grandin1-2/+2
Change-Id: I9d1cdb4ddfee43b7a0990624d7d16e06679343c4 Reviewed-on: https://gerrit.libreoffice.org/42276 Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk> Tested-by: Noel Grandin <noel.grandin@collabora.co.uk>
2017-09-14Add test for joining a range totally contained in an existing oneTor Lillqvist1-0/+23
It is supposed to be "swallowed". Change-Id: I6184e5ff8560e5ad0c97dce1481123b9acecfabc
2017-09-13tdf#109096 Allow 0 as argument value(s) to GEOMEAN()Winfried Donkers1-9/+74
Both ODFF1.2 and the mathematical definition allow 0 as value(s). Excel does not allow 0 as argument value(s), but IMHO this is to be regarded as an aberration of Excel. Also added tests for no arguments or negative arguments, which is not allowed by ODFF1.2. Change-Id: I330206b6e817e0ec092fe19f713b044578da41d1 Reviewed-on: https://gerrit.libreoffice.org/42107 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins <ci@libreoffice.org>
2017-09-12tdf#112348: Pivot table: page field filtering is not imported from XLSTamás Zolnai2-0/+95
Change-Id: I3477cd17f679bdfefb9340656999630380713d3f Reviewed-on: https://gerrit.libreoffice.org/42201 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-09-12tdf#112337: Pivot table: empty / blank item is not imported from XLSTamás Zolnai2-0/+39
Change-Id: I7ed9e5cacdf6df80b2f100d040cbbeda33b085d3 Reviewed-on: https://gerrit.libreoffice.org/42181 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-09-12clang-tidy modernize-use-emplace in scNoel Grandin4-196/+196
Change-Id: Ifc38e1fc188fe957a0c717aec19cdd6637e4c658 Reviewed-on: https://gerrit.libreoffice.org/42183 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2017-09-11This test file was added by accidentTamás Zolnai1-0/+0
Change-Id: Ia00aa806fcaa890ef89a031ccb90e3aa831710d8
2017-09-11Fix typoAndrea Gelmini1-1/+1
Change-Id: Idbc04f7cdda586fd1505070a38f24f98ad69c0d4 Reviewed-on: https://gerrit.libreoffice.org/42147 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2017-09-10tdf#112306: containsSemiMixedTypes is true for blanks-onlyMike Kaganski2-34/+51
Also export containsNonDate Change-Id: I16283a272d51e6c305f8c381c359168c1e3848a8 Reviewed-on: https://gerrit.libreoffice.org/42130 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2017-09-09tdf#112278: Pivot table: filtering of non-string fields is not exported to XLSTamás Zolnai7-0/+353
It is needed to use the right string representation of field value. During export this representation is available directly, next to the actual value. During import we can use the number format attached to the corresponding pivot field. Change-Id: Ie8f731f6c72d7f55f43c318e52d63dc4e993d9c0 Reviewed-on: https://gerrit.libreoffice.org/42069 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-09-07tdf#107135 Add missing ODFF function SEARCHB.Winfried Donkers2-0/+1755
Change-Id: Ic72693ad8f33fb94c171751f82680eabad1d3d6d Reviewed-on: https://gerrit.libreoffice.org/41900 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com>
2017-09-07tdf#112177 remove incorrect constraint for Calc function NPER.Winfried Donkers1-9/+27
Change-Id: I123ea8ee2e333665ac448c6b3814c3bac0b687ab Reviewed-on: https://gerrit.libreoffice.org/42011 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com>