summaryrefslogtreecommitdiff
path: root/sc/qa
AgeCommit message (Collapse)AuthorFilesLines
2013-01-24New test for importing chart object with references to cell ranges.Kohei Yoshida2-1/+76
Change-Id: I2167d1a2c7ea70415581caf29acf620e4b116e69
2013-01-24calling loadDoc is simpler.Kohei Yoshida1-13/+1
Change-Id: I6a507825252f316c8106ea4b856bf166a010c15b
2013-01-24sc test XSheetOutlineLaurent Godard2-0/+108
Change-Id: Iea0576e61963dbdb72c88fe332c7cfe3e8ab7ff0 Reviewed-on: https://gerrit.libreoffice.org/1794 Reviewed-by: Noel Power <noel.power@suse.com> Tested-by: Noel Power <noel.power@suse.com>
2013-01-24disable these two tests for nowMarkus Mohrhard1-2/+2
Change-Id: I579694780b64e532b0e61017783bc4e72f8d2936
2013-01-18fdo#58988, fdo#58562: Populate draw clip document with data for charts.Kohei Yoshida1-1/+30
Without populating the clip document, copying a chart (or charts) into clipboard makes the charts lose all their referenced data, which causes the pasted chart to appear empty. Change-Id: I3675f76baed19b48cec403964c19df00725a044b
2013-01-17sc test for XSheetAnnotationsLaurent Godard1-0/+117
Change-Id: Ie5ceb7f8d828eb9c1f4c92996ebb02c8a83f4cac Reviewed-on: https://gerrit.libreoffice.org/1738 Reviewed-by: Noel Power <noel.power@suse.com> Tested-by: Noel Power <noel.power@suse.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-01-17sc test for XSheetAnnotationLaurent Godard2-0/+134
Change-Id: I1fa77c874c6307ff71ea0aeee653acf1305f2646 Reviewed-on: https://gerrit.libreoffice.org/1736 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-01-15add test case for fdo#59293Markus Mohrhard3-3/+17
Change-Id: I5972a2805d8bc03b84a42fbba4b67923b3b77249
2013-01-15with the new recalc of matrix with errors, this assert is no longer trueMarkus Mohrhard1-1/+1
We need a new test case for this with a matrix that does not contain cells with error values. Change-Id: I7fb9efb5077cf6e43cbfd32c64274777d371b956
2013-01-14Keep this simple. No need to wrap literals with OUString any more.Kohei Yoshida1-2/+2
Change-Id: Idedd6be54cf74efc69a48d39018011aba018973e
2013-01-14Figured out why testFuncMATCH was failing. Fixed it, all green.Kohei Yoshida1-1/+1
Change-Id: Id45f4c853bf689afa8a46edc02e1e5f8c43894bc
2013-01-14Add new unit test to test pivot table functionalities via ScDBDocFunc.Kohei Yoshida1-11/+86
This change also introduces the following changes: 1) Special initialization routine just for the unit test runs. In particular, SfxMedium instance needs to be set even for a brand-new document (as in the actual run-time), or else the document would be always labeled "read-only". This prevented us from testing various code in Calc, which this commit fixes. 2) Several cppunit checks that checked for incorrect results, which passed because we happened to be getting those incorrect results due to the issue with the SfxMedium instance not being set. 3) Unfortunately now the test for cell function MATCH fails for some mysterious reason. The test is disabled temporarily until we figure this out. Change-Id: If231fd99e0ffddcd74f65c7cb5476e7a25f0ac7d
2013-01-11Let's remove this underused bAlive flag....Kohei Yoshida1-1/+0
It's no longer that useful in today's pivot table design. Change-Id: I665a7707126793dfde17a2221ba563d22a59aad1
2013-01-12at least use correct test data ...Eike Rathke1-9/+18
Change-Id: Icb5bb61108f6bb674016ce044ecbe6a366b4f9c6
2013-01-12make this compile with a not so recent code baseEike Rathke1-2/+2
Change-Id: I9b3f8ca9c5af326735ff9c95359e6a0917d6898b
2013-01-11Actually call testFuncIFERRORStephan Bergmann1-14/+10
TODO: Commented out for now the tests that currently fail. (Also improved the code by calling CPPUNIT_ASSERT_EQUAL_MESSAGE.) Change-Id: I726089ad046b97ce64fd655269b2be652e78efe9
2013-01-11fdo#56124 changes to "add functions IFERROR and IFNA"Eike Rathke1-20/+24
* reimplemented actual ScIfError() function for matrix cases and simpler pop/push of non-error values * various smaller adaptions, see also inline comments of https://gerrit.libreoffice.org/1522 Change-Id: I80a8235a2cbb548c0ef993862e76741af46e30d2
2013-01-11fdo#56124 add functions IFERROR and IFNA to calc as in ODFF1.2Winfried Donkers1-0/+67
Change-Id: I6403b51ac8c710ad3b8d2625e1482971f50e6b1d
2013-01-09re-apply calc /tmp unit test file leakage.Michael Meeks1-0/+10
2013-01-09Revert "fix a few /tmp file leaks"Miklos Vajna1-10/+0
This reverts commit 92045e69dab8be60a1c84774f04c437066c3c2bf. Broke a unit test and made all tinderboxes red. Requested-by: Stephan Bergmann <sbergman@redhat.com>
2013-01-08fix a few /tmp file leaksMichael Meeks1-0/+10
Thanks to Jean-Baptiste Faure for digging for these.
2013-01-08Add new ods import test for rich-text cell contents.Kohei Yoshida2-0/+183
Change-Id: I23eb8d53b8a2c48514900a5ab07ed7ec71d3ef99
2013-01-07Adjusted all test methods for loadDoc.Kohei Yoshida2-120/+46
There was already a method that did the same thing (loadDoc). Let's stick with loadDoc instead. Also took advantage of automatic literal to OUString conversion while I was at it. Change-Id: I184f6278dd4bf8e3f2f7e5eda1e5e293303df68c
2013-01-07Remove duplicated code blocks.Kohei Yoshida1-65/+23
Change-Id: I332a39fe86fee385bcd2cce33fe2096043111472 TODO: Do this in the other tests as well.
2013-01-07Append ODS to the test method name.Kohei Yoshida1-3/+3
Change-Id: I024d142b59ccceed944d641b6306f47dcf03ef9d
2013-01-07New test for pivot table with field references.Kohei Yoshida1-0/+178
Change-Id: I65d932d6c258b965a6084acb07298387b7274215
2013-01-07split out numbering position page to cui and adapt codeCaolán McNamara1-1/+1
and move SvxNumberingPreview from svx to cui where its ::Paint impl already lives Change-Id: I2b7bebeb9914d74d0f391d3b178b0ad3d778c479
2013-01-05enable the unit testMarkus Mohrhard1-1/+1
2013-01-04add unit test for dependency tree during ods importMarkus Mohrhard2-0/+30
Change-Id: I92bff38304959237042b9a0078be25948d642b25
2013-01-04New ods test document to check the import of row height values.Kohei Yoshida2-0/+56
Test disabled as it currently fails. Change-Id: I33ea3c95357fd7fdb9deaba30372567cfb69ebd6
2013-01-02fdo#58539: Resizing matrix should also resize the flag storage too.Kohei Yoshida1-0/+10
Or else resizing and then putting empty elements may crash. The flag storage is used only for empty elements. Change-Id: I1ada8f795a01336af185e6180bc03247c44472ba
2013-01-02fdo#56278: Write a unit test for this.Kohei Yoshida1-0/+34
The reported bug description was very concise and unit-testable. We should turn it into a real test. Change-Id: I7383316e8fcf799a59b1c32a1722fd4b6b224d1c
2012-12-26fix operator lookup with clangLuboš Luňák1-8/+3
I'm not sure if this is clang being more strict or buggy, probably the latter. Change-Id: I900ba2cd2b1d4c23e41e4787be4263954ce8b4c0
2012-12-26add a unit test for new method in ScRangeListMarkus Mohrhard1-0/+33
Change-Id: Id27973cc82c71daffec62cbaccba30777c08612b
2012-12-21fdo#46808, Convert frame::Desktop to new style service.Noel Grandin2-6/+4
I had to drop XEventBroadcaster from the merged interface because it introduced method name conflicts (addEventListener). Shouldn't be an issue since it was scheduled to be dropped anyhow, and the service implementation still implements it, so existing clients will be fine. I dropped the interface XPropertySet from the combined IDL because nobody seems to be using it, and it's primary purpose appears to be to set weird flags. I dropped the optional interfaces XStatusIndicatorFactory XDispatchInformationProvider from the combined IDL because the service does not implement them, and nobody seems to be using them. I suspect they were mistakenly copied from XFrame. I also did not convert the Title, UserDefinedAttributes and LayoutManager properties to attributes, again because no-one is using them. Change-Id: I678a00006ed2cca2d6c37c4e39465811442c33af
2012-12-18fix the test for cond format exportMarkus Mohrhard1-5/+5
Change-Id: I01e0b3e76e39bf26d2398745bf706cfa60d5621f
2012-12-15calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, ↵Marina Plakalovic1-0/+3
COUNTIFS Merged from Apache OO with adaptions. http://svn.apache.org/viewvc?rev=1381447&view=rev Original Apache OO committer: Andrew Rist <arist@apache.org> Original Author: Marina Plakalovic <makkica@openoffice.org> Original Committer: Eike Rathke [er] <eike.rathke@oracle.com> # HG changeset patch # User Eike Rathke [er] <eike.rathke@oracle.com> # Date 1288810126 -3600 # Node ID 02cf226fcde498f6fd926d45df497e9fb412fe0f # Parent 528da6bfd0daed4355d745590d5ac3a319b08fb4 Change-Id: I08754653cd2ff20536ad3e9f260f747cb127ccdd
2012-12-15changes to "calcishmakkica: #i101466# implement AVERAGEIF"Eike Rathke1-0/+1
changes to commit bcf8581d3dbbfbc4d3e507371691378d8cab050a * adapted IterateParametersIf() to current ScSumIf() code * added AVERAGEIF to unit test * moved ocAverageIf to proper position in parclass.cxx Change-Id: I51c793570cea9c75faa9be13abd91e8df3b5fd5a
2012-12-14bnc#791706: Support multiple selection in page fields.Kohei Yoshida1-0/+1
This change allows selecting multiple items in page field popups in pivot table. Change-Id: I692e13c0815211bac6da47fefd83bba18c901c5c
2012-12-11fdo#58149: Recalculate HYPERLINK formula cells on load.Kohei Yoshida1-5/+5
The current implementation of HYPERLINK relies on its result being 1x2 matrix while only the first element is displayed visibly. The second element stores the URL which is only used when querying for the URL (tooltip or launch URL event). Starting with 4.0 we load cached formula results to avoid full recalculation on load. That unfortuntely ended up breaking the HYPERLINK because the result was a simple string value rather than a matrix; hence the need to recalculate it on load. But unlike volatile formula cells, cells with HYPERLINK don't need to be recalculated on every cell input change; only once when the file is loaded. P.S. This commit also reverses the logic of bNoProgressBar flag for CalcFormulaTree(), to make it easier for human brain to process what it means. Change-Id: I7a24d96d225910b88071a8fe6320f59bf7a47163
2012-12-07-Werror,-Wunused-resultStephan Bergmann1-2/+1
Change-Id: I91633af096dd82960867f3ef6eb962b7b20c3960
2012-12-05fdo#57497: Remove group table data when all group dimensions are gone.Kohei Yoshida1-0/+29
Otherwise ungrouping date grouped dimension may crash, or produce incorrect results. Change-Id: I3634e3c0bf8336fc1221f5d234cb7e01eb1f07c6
2012-12-04Fix the testPasswordExport test.Kohei Yoshida1-4/+10
Change-Id: I9ef9be5d31a08813db9ecfed8eeb0ba8579309e9
2012-12-04Remove duplicate code blocks.Kohei Yoshida1-41/+16
Change-Id: If44f44ad076313ab67968fd70f244d781356028d
2012-12-04More adjustment of file load code in the unit test.Kohei Yoshida1-0/+4
And remove the try catch block, which shouldn't really be necessary there. Change-Id: I91db12203332b31b208b107db810c33705a57f0b
2012-12-04Disable user interaction here too, to prevent dialog launches.Kohei Yoshida1-0/+2
Change-Id: I6b193ddf7e03dd6706326e9fe8a523423435812f
2012-12-04Ask the user if she wants to do full recalc on load, for ods and xlsx import.Kohei Yoshida2-0/+4
But allow it to be disabled for filters tests as well as external document loading. Change-Id: I5b8533532c6be8b7c2cfcbe15faf780d621aec65
2012-12-04re-base on ALv2 code. Includes:Michael Meeks3-2/+57
Patches contributed by Herbert Duerr i#118735 prevent endless loop if vlookup/hlookup doesn't find anything http://svn.apache.org/viewvc?view=revision&revision=1239673 Patches contributed by Andre Fischer remove lp_solver http://svn.apache.org/viewvc?view=revision&revision=1199180 i#118160: Added external CoinMP library. http://svn.apache.org/viewvc?view=revision&revision=1233909 Patches contributed by Armin Le-Grand i#118485 - Styles for OLEs are not saved. http://svn.apache.org/viewvc?view=revision&revision=1182166 i#118524: apply patch, followup fixes to 118485 http://svn.apache.org/viewvc?view=revision&revision=1186077 Patches contributed by lihuiibm i#108860 - Fix range validation. http://svn.apache.org/viewvc?view=revision&revision=1242846 i#118954 Chart data will lost after copy to different file http://svn.apache.org/viewvc?view=revision&revision=1301345 Patches contributed by Ariel Constenla-Haile Fix Linux build breaker: extra qualification on member http://svn.apache.org/viewvc?view=revision&revision=1301591 i#118696 - i#118697 - Fix some Sheet Tab Color API issues http://svn.apache.org/viewvc?view=revision&revision=1225428 i#118697 - Fix uninitialized variable http://svn.apache.org/viewvc?view=revision&revision=1225859 i#118771 - ScUndoImportTab should preserve tab background color http://svn.apache.org/viewvc?view=revision&revision=1230356 i#118921 - Repaint linked sheet tab background color after updating link http://svn.apache.org/viewvc?view=revision&revision=1245177 i#118927 - Undo/Redo "Update Link" does not reset sheet tab color http://svn.apache.org/viewvc?view=revision&revision=1245241 i#118747 - Copy tab color when transferring sheets across documents http://svn.apache.org/viewvc?view=revision&revision=1230355 Patch contributed by Oliver Rainer-Wittman i#118012 - methods <ScBroadcastAreaSlot::AreaBroadcast(..)> and <ScBroadcastAreaSlot::AreaBroadcastInRange(..)> adapt stl-container iteration in order to avoid destroyed iterators during iteration. http://svn.apache.org/viewvc?view=revision&revision=1297916 Patches contributed by Mathias Bauer gnumake4 work variously http://svn.apache.org/viewvc?view=revision&revision=1394707 http://svn.apache.org/viewvc?view=revision&revision=1394326 http://svn.apache.org/viewvc?view=revision&revision=1396797 http://svn.apache.org/viewvc?view=revision&revision=1397315 Patch contributed by Daniel Rentz calc69: #i116936# fix VBA symbol Cells http://svn.apache.org/viewvc?view=revision&revision=1172135 Patches contributed by leiw: i#118546 CPU 100% on switched off AutoCalculate with Conditional Formatting on date values http://svn.apache.org/viewvc?view=revision&revision=1301380 Re-add new function documentation. Many various cleanups. Add missing calc66: #o11817313# also look at formula result number format, remove redundant binaries.
2012-11-20Enforce use of accessors on gen.hxx structuresMatteo Casalin1-2/+2
Change-Id: Icd1b2937fdeaba6de1877258731f53ddf996002e Reviewed-on: https://gerrit.libreoffice.org/936 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com>
2012-11-19database names are case insensitive, fdo#51309Mathieu D1-2/+2
Change-Id: Iac9ac4e48115ea09aeffa11bbd8da399266aede9