summaryrefslogtreecommitdiff
path: root/sc
AgeCommit message (Collapse)AuthorFilesLines
2013-05-27fix for bnc#819865 itemstate in parent style incorrectly reported as setNoel Power2-14/+12
Problem occurs because attrs set with default values are reported as set when queried Change-Id: Ic49e5e9908a6f11105cd255b8a70a95c83a512a8
2013-04-30bnc#816516: Implement easy access to the recent documents.Jan Holesovsky2-0/+5
This adds a dropdown to the 'Open' toolbar tool. Change-Id: I5b4aa99476e721c1479152b46bbc79cc0b095318
2013-04-24follow fix for bnc#813528Noel Power1-2/+0
Change-Id: Id6c9cd01bc68e13b87c845d9272c7b85756987c5
2013-04-15bnc#813528 stub out some missing XPageSetup apiNoel Power2-1/+32
Change-Id: I992a444c844d4103fcf3dd762aaeec85dc4c011d
2013-04-05fix Worksheet.Cells by now allowing TableSheet range to change from updatesNoel Power2-1/+12
Change-Id: I19cd39ec58b778f4634258352676da7e04822b65
2013-04-04squash NoSuchElementExceptions when modifying keybindingsNoel Power2-1/+16
Change-Id: If83183ae652e7a92b0795774b0f0a8a0b6c1ec82
2013-04-04Added and fixed various vba APINoel Power4-3/+59
Added OLEObject.LinkedCell Added ComboBox.LinkedCell Added Validation.Type re-enabled build ( and associated header delivery ) of bindablecontrolhelper provided a 'real' implemenation for AutoSize member ( applicable to various controls ) Change-Id: Iee985ef1615b1b0950e578c0ed0ca10ff3db55fb
2013-04-04prepend Validation.Formula1 results with '=' for anything not a addressNoel Power3-3/+21
Change-Id: If8e0b720bca4198123b1717967fc9e0beff6f874
2013-03-13bnc#798309 inherit group style from parentNoel Power1-1/+1
Change-Id: Ic689a0a17f1d88466feba0cba0d5e96a13ddb99f
2013-03-07fdo#54651: Only pick non-default number format for pivot field.Kohei Yoshida1-1/+3
Change-Id: Ia88282803c8df8389ed24efd8b1ca7600a39bf23
2013-03-06enable bag load of excel specific VBA api testsNoel Power19-1/+76
Note: some of the test documents have some tests disabled in order to run without errors, these are identified by the following lines Rem [#FIXME disabled 3.6 ] in the macro source. note: some of these errors are expected and were always happening, some errors e.g. those pastespecial specific ones in qa/unit/data/xls/TestCalc_Rangetest2.xls seem to be to do with problems with the test harness. note: there are some others ( e.g. in Window.xls & windows2.xls ) that seem to be related to hard sizes and screen resolution ( these should be adjusted sensibly ) Change-Id: I0e798fc763ee988f8f032829a912239594a35583
2013-03-05Merge branch 'distro/suse/suse-3.6' of ssh://logerrit/core into suse-3.6Petr Mladek5-5/+5
2013-03-04support new attribute also in 3.6, fdo#60760Markus Mohrhard3-1/+6
Change-Id: I8beab492a3b9b42b323d7d6d9cebfbda1eae0ce1 Reviewed-on: https://gerrit.libreoffice.org/2159 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Fridrich Strba <fridrich@documentfoundation.org> Reviewed-by: Fridrich Strba <fridrich@documentfoundation.org>
2013-03-04resolved fdo#60366 make MATCH() accept a single cell referenceEike Rathke1-0/+6
Change-Id: I7059abdb6232b95e0b940b34f74bf87182510146 (cherry picked from commit c0fdab890086c2cb749c348db42eb760e31539de) Reviewed-on: https://gerrit.libreoffice.org/2019 Reviewed-by: Norbert Thiebaud <nthiebaud@gmail.com> Reviewed-by: Kohei Yoshida <kohei.yoshida@gmail.com> Tested-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2013-03-04resolved fdo#59583 prevent inappropriate column/row label detectionEike Rathke1-1/+3
If followed by '(' (with or without space inbetween) an identifier can not be a column/row label. Prevent arbitrary content detection in case a macro function of the same name is meant (fdo#59583) or if it wouldn't resolve to a known function name at all, that earlier resulted in #REF! instead of #NAME? in the case of unknown function but label found. (cherry picked from commit aa2b8bde171bf9562536dc14b2cf81d81e31b438) Change-Id: I28d2e2492bddc02c07e139edbc69595a4f3f4a63 Reviewed-on: https://gerrit.libreoffice.org/1797 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-03-04reset one of the sort containers before refilling, fdo#57465Markus Mohrhard1-0/+2
Change-Id: I758af67efec980a56ec83d8e5e6f5f60a0523ac5 Reviewed-on: https://gerrit.libreoffice.org/1753 Reviewed-by: Kohei Yoshida <kohei.yoshida@gmail.com> Tested-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2013-03-04Merge tag 'libreoffice-3.6.5.2' into suse-3.6Petr Mladek14-75/+75
Tag libreoffice-3.6.5.2 Conflicts: editeng/source/editeng/impedit3.cxx instsetoo_native/util/openoffice.lst oovbaapi/UnoApi_oovbaapi.mk sc/source/filter/oox/workbookhelper.cxx sc/source/ui/app/scmod.cxx sc/source/ui/cctrl/checklistmenu.cxx solenv/inc/minor.mk writerfilter/source/dmapper/DomainMapper_Impl.cxx writerfilter/source/dmapper/DomainMapper_Impl.hxx writerfilter/source/dmapper/PropertyMap.cxx Change-Id: I7ea70b82b3b874cbe78354d5dd97307e63842e72
2013-03-04Make LO buildable again after the GraphicFilter move.Jan Holesovsky5-5/+5
Conflicts: cui/source/dialogs/SpellDialog.cxx editeng/source/items/frmitems.cxx filter/qa/cppunit/filters-pict-test.cxx sd/source/filter/grf/sdgrffilter.cxx sd/source/ui/app/sddll.cxx svgio/source/svgreader/svgimagenode.cxx svtools/Library_svt.mk svtools/Module_svtools.mk svtools/Package_inc.mk svtools/source/filter/exportdialog.cxx svx/source/core/graphichelper.cxx svx/source/dialog/compressgraphicdialog.cxx sw/source/ui/shells/grfshex.cxx sw/source/ui/uiview/view2.cxx sw/source/ui/utlui/glbltree.cxx test/source/bootstrapfixture.cxx tubes/source/contacts.cxx vcl/Library_vcl.mk vcl/qa/cppunit/graphicfilter/filters-test.cxx vcl/source/filter/FilterConfigCache.cxx vcl/source/filter/graphicfilter.cxx writerfilter/source/rtftok/rtfdocumentimpl.cxx Change-Id: I3455a7294b136400f32163626d5a7a7f2bfa898c
2013-02-13bnc#802350: Cell validation is not a special (cell) content.Kohei Yoshida1-2/+1
Cell validation is stored as cell attributes which are stored with columns not with cells. When HasSpecialContent() is true, it flags the *cell* not empty, which in turns causes AddTextAndValueCell to iterate over every single cell position for all repeated columns and rows. That can very very slow when the number of repeated rows is very high. Since cell validation is stored with columns, skipping empty cells even when they have cell validation settings set won't cause any issues, and all cell validation settings are imported correctly even after this change. With the test document I have (confidential), this change alone reduces the load time from 30 seconds to 0.3 seconds. 3.6 cherry-pick note: The 3.6 branch doesn't have HasSpecialContent() method, but the logic was still the same and I've applied equivalent fix for this branch. Change-Id: Ifa6c6d70fa926d0a0037b35149373cfaf29db431
2013-02-05fdo#39135: Prevent integer overflow & update the character during loop.Kohei Yoshida1-0/+5
These two errors in the code contributed to the reported bug. Let's fix them. Change-Id: If82a1bd4d1e27145b48e722b30388cc9dc4a8a6e
2013-02-05fdo#59426: Don't try to repair package during flat detection phase.suse-3.6-10Kohei Yoshida1-3/+9
Conflicts: comphelper/source/misc/mediadescriptor.cxx sc/source/ui/unoobj/scdetect.cxx Change-Id: I35968241a79db0aabe06e25c0efac2aa3d1c5b84
2013-02-05Disabling sc_chart_regression_test (like on Master)Muthu Subramanian1-1/+3
Change-Id: I18d8fb4b993771d3365bf3dbfbb781ef17ed20ab
2013-02-01bnc#801152: Scan all columns to determine the first data row.Kohei Yoshida1-3/+4
When scanning the entire data range in an attempt to determine where the first data row is, we shouldn't stop at the first column. We should scan all data columns to make sure we pick the lowest value row position among all columns. Change-Id: I693ec169857b181c6b4237efcba3fa6a46eaa531
2013-01-30bnc#492440: Sort autofilter popup items correctly.Kohei Yoshida1-5/+5
Use locale-aware collator to sort strings, instead of using the transliterator. The actual sorting algorithm for cell sort uses collator. Let's be consistent with it. Change-Id: I6729553ce92d50e45fa1ea6e1c35581fd791807d
2013-01-30Fix the build.Kohei Yoshida1-1/+1
Change-Id: Iea8a02ceab7b603b5363b9df74e1381f152d70e1
2013-01-30Don't overwrite bCalcAll when it's already set & remove SetCompile().Kohei Yoshida2-2/+2
Change-Id: Ieaf84e8d36efa8314729903be029f83c31bcbdf3
2013-01-30bnc#615357: Recompile cells with #NAME! for English function name option.Kohei Yoshida7-6/+102
When the option for using English function name changes, we should re-compile all cells with #NAME! as the error may have been caused by unresolved function name which may be fixed after the option change. Change-Id: Id340ce9b5db3ed368b98e814861be5c3f96df071
2013-01-16one more improvement around cond format rendering, fdo#57896Markus Mohrhard1-1/+4
Change-Id: I5eb267ec2d1666edd53f5b9d58fd2a0cec044aa1 Reviewed-on: https://gerrit.libreoffice.org/1684 Reviewed-by: Noel Power <noel.power@suse.com> Tested-by: Noel Power <noel.power@suse.com> Reviewed-on: https://gerrit.libreoffice.org/1710 Reviewed-by: Fridrich Strba <fridrich@documentfoundation.org> Reviewed-by: Thorsten Behrens <tbehrens@suse.com> Tested-by: Thorsten Behrens <tbehrens@suse.com>
2013-01-14Fix fdo#51121 OWA misbehaviour with uncompressed meta.xmlThorsten Behrens2-9/+7
Change Calc to save ODF with compressed meta.xml as well, since there's no reason not to. Change-Id: Ib591b0e771a6f394d955f2ea9b43d6fb7c30ecdf Signed-off-by: Michael Meeks <michael.meeks@suse.com>
2013-01-12Let's not return here to prevent memory leak.Kohei Yoshida1-2/+1
There are several heap objects that are deleted at the end of the method. Returning prematurely would leak those objects. Change-Id: If70cb3c9c02e47229d10b30f1542f7b25534d593 Reviewed-on: https://gerrit.libreoffice.org/1654 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-01-11fdo#59084: Sync dimension members after reloading the group data.Kohei Yoshida1-2/+2
Else the syncing would end up syncing to the older version of the group data before the reload, which (as you can see in the bug report) may lead to a crash. Change-Id: Ibd674a97a59205e5e28efd007f8857731e8df4d3 Reviewed-on: https://gerrit.libreoffice.org/1635 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-on: https://gerrit.libreoffice.org/1651 Reviewed-by: Noel Power <noel.power@suse.com> Tested-by: Noel Power <noel.power@suse.com>
2013-01-02fdo#47466 FORMATTING: Autoformat empty rows causes app to crashJulien Nabet1-0/+2
Thank you John LeMoyne Castle for your support http://nabble.documentfoundation.org/Wrong-indentation-which-leads-to-segfault-in-sc-source-ui-docshell-docfunc-cxx-td4026726.html However, the weird thing is I reproduced the crash with master sources but didn't with 4.0 branch nor with 3.5.4.2 Debian packages Change-Id: Ia5366f479a1066106551b77b5a6315fb78e1bf7d
2013-01-02fdo#47466 FORMATTING: Autoformat empty rows causes app to crashJulien Nabet1-0/+2
Thank you John LeMoyne Castle for your support http://nabble.documentfoundation.org/Wrong-indentation-which-leads-to-segfault-in-sc-source-ui-docshell-docfunc-cxx-td4026726.html However, the weird thing is I reproduced the crash with master sources but didn't with 4.0 branch nor with 3.5.4.2 Debian packages Change-Id: Ia5366f479a1066106551b77b5a6315fb78e1bf7d
2012-12-21we need to catch the exception here, fdo#57451Markus Mohrhard1-1/+8
Change-Id: I203aa640e7d4373f3a090a4988c28c6059b93064 Signed-off-by: Michael Meeks <michael.meeks@suse.com>
2012-12-18adapt cond format range when copying sheets, fdo#56742Markus Mohrhard1-1/+5
Change-Id: I9b28ac161f326ebeeaf0fa22e0a96915187d7c94 (cherry picked from commit 1c60abfdb617039cedc53982c7c8eca640e28cac) Signed-off-by: Eike Rathke <erack@redhat.com>
2012-12-18fdo#56937 - mac a11y hang related to traversing vast, broken hierarchies.Michael Meeks2-5/+17
Change-Id: Iff0537a69b2c6ae929da6a05f26c0d55415d6d8a Signed-off-by: Tor Lillqvist <tml@iki.fi>
2012-12-18finalize pivot *before* scenario sheet to ensure table numbers are correctNoel Power1-5/+6
Change-Id: I15cf378b51b1ecfbd05c7013e5a5b69fb87fdafb Signed-off-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2012-12-18fix sometimes data corruption with xlsx import ( with scenario sheets )Noel Power1-5/+2
formula import is buffered 'till the end of import. The processing of the formula data need to happen before the scenario import happens. This is necessary because sheet numbers stored in the formula addresses can become invalid as scenario import insertes new hidden sheets upsetting the previous table order Change-Id: I9357f028f31bec1b1504ca991f5534f80d79c9bc Reviewed-on: https://gerrit.libreoffice.org/1338 Reviewed-by: Kohei Yoshida <kohei.yoshida@gmail.com> Tested-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2012-12-18fix fdo#58237 import hyperlinks for shapes in xlsx documentsNoel Power3-1/+43
Change-Id: Ib0c661dbb3ce9a2f8c8d29707a1cf0c65aadc81f Reviewed-on: https://gerrit.libreoffice.org/1337 Reviewed-by: Kohei Yoshida <kohei.yoshida@gmail.com> Tested-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2012-12-15Do extra check on source range to make sure no funny things happen.Kohei Yoshida2-0/+13
Like a crash in the pivot layout dialog... :-/ Change-Id: I9a330ee3f39ebacb7299d24868bb13ee2a9c3ec5 Reviewed-on: https://gerrit.libreoffice.org/1345 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2012-12-14Do extra check on source range to make sure no funny things happen.Kohei Yoshida2-0/+13
Like a crash in the pivot layout dialog... :-/ Change-Id: I9a330ee3f39ebacb7299d24868bb13ee2a9c3ec5
2012-12-14fix sometimes data corruption with xlsx import ( with scenario sheets )Noel Power1-5/+2
formula import is buffered 'till the end of import. The processing of the formula data need to happen before the scenario import happens. This is necessary because sheet numbers stored in the formula addresses can become invalid as scenario import insertes new hidden sheets upsetting the previous table order Change-Id: I9357f028f31bec1b1504ca991f5534f80d79c9bc
2012-12-14fix fdo#58237 import hyperlinks for shapes in xlsx documentsNoel Power3-1/+43
Change-Id: Ib0c661dbb3ce9a2f8c8d29707a1cf0c65aadc81f
2012-12-13bnc#791706: Support multiple selection in page fields.Kohei Yoshida28-408/+405
This change allows selecting multiple items in page field popups in pivot table. Conflicts: sc/source/ui/cctrl/checklistmenu.cxx sc/source/ui/inc/viewdata.hxx Change-Id: I692e13c0815211bac6da47fefd83bba18c901c5c
2012-12-13Revert "fix for bnc#791731 preserve cell formatting of datapilot area ("Kohei Yoshida5-33/+7
This reverts commit 3bc88c4fdc2a05f816f29cb42b7d4f609214357c. This needs a new solution.
2012-12-08fdo#57497: Remove group table data when all group dimensions are gone.Kohei Yoshida5-37/+86
Otherwise ungrouping date grouped dimension may crash, or produce incorrect results. Change-Id: I3634e3c0bf8336fc1221f5d234cb7e01eb1f07c6 Reviewed-on: https://gerrit.libreoffice.org/1247 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2012-12-06bnc#792528: Import static data series labels from xlsx correctly.Kohei Yoshida2-52/+40
Static data series label is a data series label whose value is a string value rather than a cell reference. Also, when inputting static string label in the UI, we don't have to manually check for quotes; the formula compiler will take care of that later. Change-Id: I1657fc9879a7f652bba84898e308c3a5d5ba87a3
2012-12-06Avoid activating window pane when launching popup window.Kohei Yoshida2-17/+26
Else, activating another window pane where the cursor is not would cause the pivot table field popup to immediately get dismissed after launch because ClickExtern() gets called from ActivatePart(). For example, imagine a field popup button is on C2, the cell cursor is on E5, and the window is frozen between rows 2 and 3. Clicking the popup button in C2 would launch it for a brief second and dismiss it immediately afterward. Conceptually, launching a popup in another pane shouldn't activate that pane anyway. So it makes sense not to activate it for that scenario. Change-Id: Ib970cb898fb9c79d254411e2519cfce74c60b72f
2012-12-06fdo#57497: Remove group table data when all group dimensions are gone.Kohei Yoshida5-37/+86
Otherwise ungrouping date grouped dimension may crash, or produce incorrect results. Change-Id: I3634e3c0bf8336fc1221f5d234cb7e01eb1f07c6
2012-12-05fix for bnc#791731 preserve cell formatting of datapilot area (Noel Power5-7/+33
also uses the cell formatting to set up the field buttons background & text/font attributes Change-Id: I5f5a46bfc7f0b7aabb8872c25b3c3134e90611ac