summaryrefslogtreecommitdiff
path: root/sc/qa
AgeCommit message (Collapse)AuthorFilesLines
2017-09-06tdf#107135 fix too tight constraint for FINDB.Winfried Donkers1-145/+80
Change-Id: I72e7214f14840146305fcb7daec7db89fcf112c9 Reviewed-on: https://gerrit.libreoffice.org/41959 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com>
2017-09-02tdf#111974: Ensure sufficient space for all sheets in FormulaBuffer...Dennis Francis2-0/+10
and not just for the number of sheet fragments. This is important because we changed the internal storage of FormulaBuffer from based on std::map to std::vector in d17a83fa549f828f29e6939b16ba8b568a75f95e With help from Markus Mohrhard, was able make a simple unit test working in subsequent_filters-test.cxx after adding the missing the component emfio to CppunitTest_sc_subsequent_filters_test.mk Change-Id: I7320dd537266e540d585d3fccfbb8665bba457c7 Reviewed-on: https://gerrit.libreoffice.org/41792 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Dennis Francis <dennis.francis@collabora.co.uk>
2017-09-01Fix typosAndrea Gelmini2-1/+1
Change-Id: I4496faa9ce7cad393bf06ca789099b045aea2741 Reviewed-on: https://gerrit.libreoffice.org/41785 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2017-09-01tdf#89139 Fix exporting of DateTime to CacheDefinition according to ISO 8601Bartosz Kosiorek3-47/+85
With this commit, the date is saved in Excel format, like: "2009-07-06T10:53:02" We are now exporting attributes: "minDate" "maxDate" "containsDate" This is necessary to export properly .xlsx file. Without that MS Office 365 is displaying error, and it is not even trying displaying .xslx file content Change-Id: I1239f5582173afe99bf9178fd4edd1dc5ca28e8e Reviewed-on: https://gerrit.libreoffice.org/41162 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Bartosz Kosiorek <gang65@poczta.onet.pl>
2017-08-30tdf#112106: Corrupted pivot table after XLSX -> XLS conversion in CalcTamás Zolnai2-0/+33
Always write out a data layout name. Change-Id: Ic0b43d9c0365eca5e417fe9f2fe4b77b538f3278 Reviewed-on: https://gerrit.libreoffice.org/41739 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-08-30loplugin:constparam in variousNoel Grandin8-24/+24
Change-Id: I6821a3946f2e8fabf26558a84370c16ac8827fed Reviewed-on: https://gerrit.libreoffice.org/41721 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2017-08-30tdf#108352: Structure of pivot table coming from XLS is altered in LOTamás Zolnai2-0/+73
Change-Id: I001daeaa12cd41cc36033a26457f960d8b8a5c0e Reviewed-on: https://gerrit.libreoffice.org/41713 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tamás Zolnai <tamas.zolnai@collabora.com>
2017-08-29disable unstable UNO API testsMarkus Mohrhard1-2/+3
Change-Id: I2a2ea122c1e95fca0e14884e8194f5c75c591bdf
2017-08-27tdf#45904 Move _DataPilotItem Java tests to C++Jens Carl1-0/+150
Change-Id: Ia20630f4cc187bd6f1a47bb6d747fda3c8b39e86 Reviewed-on: https://gerrit.libreoffice.org/41551 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-27tdf#45904: Move _DatabaseRange Java tests to C++Jens Carl1-2/+20
Change-Id: Iefe319c379ac8fffbb167b4bd4bcb235defabfa9 Reviewed-on: https://gerrit.libreoffice.org/41541 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-27tdf#45904 Move _CellAreaLink Java tests to C++Jens Carl1-2/+11
Change-Id: I82dac69dfed136eaf96771bf1ef2b8dfbf4e05aa Reviewed-on: https://gerrit.libreoffice.org/41488 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-27fixed image and textbox rotation on xlsx files tdf#83672serdarot52-0/+21
Change-Id: If91e64e46601e1f8b5834d278f14182f8c949a2b Reviewed-on: https://gerrit.libreoffice.org/40790 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-26tdf#89139: list all items in pivot table definition, incl. hiddenMike Kaganski2-0/+18
Change-Id: I14ce935185a6e0e3739fcf01fdefa031d814e821 Reviewed-on: https://gerrit.libreoffice.org/41509 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2017-08-25tdf#107806: Semantic and syntax for .uno:RowHeight have been changedHenry Castro3-11/+48
Change-Id: If9ce7ff36ef3ba8e55103765f3260e74ab2eebd4 Reviewed-on: https://gerrit.libreoffice.org/41567 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Henry Castro <hcastro@collabora.com>
2017-08-25tdf#111876 Save correct relative links in CalcSzymon Kłos2-0/+22
Relative links were saved as: file:///a/file.odt instead of: ../a/file.odt Relative path was based on source document, not target. Unit test contains spreadsheet with relative link to the "../xls/bug-fixes.xls" file. Change-Id: I803b7b8936bde9644ae5760756ee7249677f2641 Reviewed-on: https://gerrit.libreoffice.org/41500 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Szymon Kłos <szymon.klos@collabora.com>
2017-08-25add reference operators testsZdeněk Crhonek1-0/+5547
from AOO#32341 ODFF: OpCode 'ocUnion' to pass multiple ranges as one parameter Change-Id: Ie718ccb43e7fac3b168ce56818c8b45cba51b94a Reviewed-on: https://gerrit.libreoffice.org/41514 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Zdenek Crhonek <zcrhonek@gmail.com>
2017-08-24Consistently use OUString in test::DirectoriesStephan Bergmann2-2/+2
Change-Id: Ia5fd8af34ee9d2f37e4450ab241f6bb9a06445b2 Reviewed-on: https://gerrit.libreoffice.org/41466 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Stephan Bergmann <sbergman@redhat.com>
2017-08-23Fix typoAndrea Gelmini1-1/+1
Change-Id: I04ca767a317af6afa8f3ef82fee137c86211e34a Reviewed-on: https://gerrit.libreoffice.org/41479 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-08-23tdf#45904 Move Java _XUniqueCellFormatRangesSupplier test to C++Jens Carl3-12/+45
Change-Id: I66c62f1676515437197d1875600407408040ca74 Reviewed-on: https://gerrit.libreoffice.org/41445 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-23tdf#45904 Move Java _XAreaLink tests to C++Jens Carl1-0/+105
Change-Id: I95112555de3a5dd5a75c478edb5856cf79919db9 Reviewed-on: https://gerrit.libreoffice.org/40859 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-23Clean up string constructionStephan Bergmann1-2/+1
Change-Id: I41ca0c7c9ac1892cc87eb4dbba858527aa340c75
2017-08-23ScFiltersTest::testUnicodeFileNameGnumeric only works with UTF-8Stephan Bergmann1-0/+7
Change-Id: If31062abf50125c65a90566f1276f37d6725f73c
2017-08-23Make ScBootstrapFixture::createFileURL generate properly encoded URLsStephan Bergmann9-13/+17
Requires the rsBaseString arg to the ScBootstrapFixture ctor to consitently be passed as a relative path without a leading slash. Change-Id: Ieff38d465b0053fdae42acc4babfb34d1a4827bd
2017-08-20tdf#83562: Make the EditTextObject export of automatic colors...Dennis Francis1-1/+66
... use the xml token "use-window-font-color" instead of "color" to encode a boolean value of whether an auto color is used or not. This is because the "auto" color is 0xffffffff and cannot be written into "color" xml field which can store only 3 byte-hexcode. This commit also adds a unit test in subsequent_export-test.cxx to ensure the correct export of automatic color. Change-Id: I42aab926f31669c1423bc09b96b45c410c9732de Reviewed-on: https://gerrit.libreoffice.org/41252 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Dennis Francis <dennis.francis@collabora.co.uk>
2017-08-18tdf#45904 Move Java _XViewFreezable tests to C++Jens Carl1-5/+8
Change-Id: I75a0363304dbaaeb5988f2ec027d8211f4e01a4f Reviewed-on: https://gerrit.libreoffice.org/40872 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-17Fix typosAndrea Gelmini1-2/+2
Change-Id: Iaa9c0aea3ea1a239e378bd714ba335f91bb1faf3 Reviewed-on: https://gerrit.libreoffice.org/41194 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com>
2017-08-17Clean up uses of OUString::fromUtf8 around string literalsStephan Bergmann1-12/+12
Change-Id: I9a2990e49c95a01ce505f13408be8c19db1cf5d1
2017-08-16add a test for storing formula cells in the cacheMarkus Mohrhard1-0/+32
Change-Id: I094491c7a9be5384f88c30ed6a3271aa73674ad8 Reviewed-on: https://gerrit.libreoffice.org/41222 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-16add a way to restore from our new cache formatMarkus Mohrhard1-0/+19
Change-Id: I6eeaaf9ca05bed2a908143ae5f4daab6e098799c Reviewed-on: https://gerrit.libreoffice.org/41199 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-16introduce a way to write a simple data representation to a streamMarkus Mohrhard1-0/+71
The format used is column orientated and allows quick import and export of the table content. This will be used for the external data to cache the results of each transformation step in the UI. Change-Id: I6e1bfd3b3384cbfadeb98fb995dfd0b03d5e6eb6 Reviewed-on: https://gerrit.libreoffice.org/41198 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-16external data: add HTML data provider testMarkus Mohrhard2-0/+86
Change-Id: I594581ce388221760554f6272ee3af761f172c05 Reviewed-on: https://gerrit.libreoffice.org/41197 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-15external data: add merge column transformationMarkus Mohrhard1-0/+28
Change-Id: I112650bbb0ed279b386389e7df6b372bde080b62 Reviewed-on: https://gerrit.libreoffice.org/41157 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-15external data: add split column transformationMarkus Mohrhard1-0/+26
Change-Id: I7a06f1a5c3f28b47288b0a2b191a34cd81efb439 Reviewed-on: https://gerrit.libreoffice.org/41156 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-14Fix typosAndrea Gelmini1-1/+1
Change-Id: Ic95ec7c8a36ef5d19eac93b7eed8a7de2ec8904f Reviewed-on: https://gerrit.libreoffice.org/41153 Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Tested-by: Julien Nabet <serval2412@yahoo.fr>
2017-08-14external data: add first test for data transformationsMarkus Mohrhard1-0/+105
Change-Id: I300cf3b9f094c912eb4b7618e405ad320e43e008 Reviewed-on: https://gerrit.libreoffice.org/41147 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2017-08-14Fix testVLOOKUP to actually use formula groupsTor Lillqvist1-12/+22
Change-Id: I3e2b626731a3508d1c4cd8abbe6de1660dbef11f
2017-08-14Test VLOOKUP, try to handle various special cases and errorsTor Lillqvist1-0/+65
Change-Id: I0ea9b9d882bf95c81ad784537671e22cb48d8c65
2017-08-14Test division and especially error handlingTor Lillqvist1-0/+29
Change-Id: Ife4396bf8856178194497b724d4635468a58994d
2017-08-14Bin some unnecessary temporary codeTor Lillqvist1-13/+0
Change-Id: Ia9fef2a500ed0a6177612e845aa58976c602a66f
2017-08-14Delete sheet when doneTor Lillqvist1-0/+2
Change-Id: Ic35d21ee2cc5ab1481dd5b72150bfc8c82237f80
2017-08-13fix loplugin:externandnotdefinedMarkus Mohrhard1-2/+0
Change-Id: Ic819c0304b2f45481a77e53c4b6564d5ac3f2950
2017-08-13external data: add a test that shows that cropping to DB area worksMarkus Mohrhard1-0/+30
Change-Id: Ic883a5f625d54bf8cc95785a9ab1a83f0c8aa2ec
2017-08-13external data: reenable the test and adapt to new interfacesMarkus Mohrhard2-42/+39
Change-Id: I2d82b560e0bd499eb85c6ce22f5969f82dfe8937
2017-08-12tdf#89139 Fix PivotCache fields according to OOXML specificationBartosz Kosiorek2-1/+68
Apply changes to fields: - XML_containsInteger - XML_containsBlank - XML_containsMixedTypes - XML_containsSemiMixedTypes According to OOXML specification https://technet.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.shareditems.aspx Generally OOXML specification allows listing items for mixed items (example: STRING + NUMBERS). This patch is fixing that. Example of mixed types: <cacheField name="pwdLastSet" numFmtId="0"> <sharedItems containsDate="1" containsBlank="1" containsMixedTypes="1" minDate="2014-07-07T09:30:31" maxDate="2017-03-24T08:38:46" count="4"> <m/> <d v="2016-06-15T12:18:34"/> <s v=""/> <d v="2017-03-21T10:27:39"/> </sharedItems> </cacheField> Change-Id: I02b07c79bea60890e3c995dd70cb5c72901a3d4a Reviewed-on: https://gerrit.libreoffice.org/40610 Reviewed-by: Bartosz Kosiorek <gang65@poczta.onet.pl> Tested-by: Bartosz Kosiorek <gang65@poczta.onet.pl>
2017-08-11CppunitTest_sc_parallelism: fix loplugin:stringconcat warningMiklos Vajna1-2/+2
Change-Id: Ibab8db1c798312f34a5b8e0178b10c21299a5c7c
2017-08-11Add a unit test to be used to test parallelised calculations in CalcTor Lillqvist1-0/+181
Currently only tests SUMIFS. Yes, it would be nice if some of the already existing unit tests would work for this need, too. But there are various reasons wny not. Also, don't want to interfere in ongoing work by others. Change-Id: Ie9008a4a1a8c26eff4f2ab0bc91294b2239f0ae1
2017-08-11convert std::map::insert to std::map::emplace IINoel Grandin1-2/+1
Change-Id: Ief8bd59c903625ba65b75114b7b52c3b7ecbd331 Reviewed-on: https://gerrit.libreoffice.org/41019 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2017-08-08Fix for failing tests of xcellseries with ScCellRangeObj ...Jens Carl1-0/+18
... (CppunitTest_sc_cellrangeobj) introduced by commit 27cbca2c8dccbbb299621b49e5ffd836188202f0. Change-Id: I97be4f70de52abd974bf1198063d28f2ff419dbd Reviewed-on: https://gerrit.libreoffice.org/40871 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com>
2017-08-08tdf#110440 drawingML import: fix handling of group shape propertiesMiklos Vajna2-0/+21
The handler for nvGrpSpPr is "this class", not "no class". Change-Id: I7fc40681d77f94b7473d2f677d813d2ae246f6ac Reviewed-on: https://gerrit.libreoffice.org/40854 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Miklos Vajna <vmiklos@collabora.co.uk>
2017-08-08tdf#45904 Move Java _XUsedAreaCursor tests to C++Jens Carl2-5/+11
Change-Id: I6a288fa333d6805540156f63040468f07967c0c6 Reviewed-on: https://gerrit.libreoffice.org/40817 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>