summaryrefslogtreecommitdiff
path: root/formula
AgeCommit message (Collapse)AuthorFilesLines
2013-02-26ocMacro and ocExternal need to be recalculated on load, fdo#60977Markus Mohrhard1-3/+3
Change-Id: I9e69ca2feae44bc645e8a49e349557f0933a23eb Reviewed-on: https://gerrit.libreoffice.org/2413 Reviewed-by: Fridrich Strba <fridrich@documentfoundation.org> Tested-by: Fridrich Strba <fridrich@documentfoundation.org>
2013-02-15CELL needs to be recalculated during import as well, fdo#60645Eike Rathke1-2/+6
(cherry picked from commit 9c55eab0309681991eae7382b682c26550786f56) use AddRecalcMode(RECALCMODE_ONLOAD), fdo#60645 related Instead of SetRecalcModeOnLoad() which sets the exclusive bit overriding RECALCMODE_ALWAYS use AddRecalcMode() that handles these cases. (cherry picked from commit ff319d052659974d1aa5d6ac8c468a7259a46cc4) ocColumn and ocRow do not need recalc on load, fdo#60645 related (cherry picked from commit 61c72ef4bebebdfa505176e7d5db82920ad3822e) Change-Id: I86e2d2c8156e50c14e4e9ae269e8b97e4560c68f Reviewed-on: https://gerrit.libreoffice.org/2168 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-02-01make it possible to update DDE links after loading, fdo#59032Markus Mohrhard1-0/+3
Change-Id: Iba49bec62cb9081cdcd9410215f269b59c1be304 Reviewed-on: https://gerrit.libreoffice.org/1940 Reviewed-by: Kohei Yoshida <kohei.yoshida@gmail.com> Tested-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2013-01-30ODFF: write RRI as RRI, not ZGZ, fdo#60077Eike Rathke1-1/+1
ODF OpenFormula defines the function RRI, the legacy OOo XML format stored that as ZGZ but that was not changed for the ODFF implementation. Correctly read/write RRI now but still accept ZGZ to be able to load existing documents. See also http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#RRI Change-Id: I617eaa37ff483e9a02a218e8432ba918f54bd61a (cherry picked from commit 8f9cb3dddd2ffe95ebd9934ddafc666a8df854bd)
2013-01-25import inherited number formats with cached values, fdo#59724Markus Mohrhard1-0/+3
Change-Id: I698f60daf4e591b57d8d99c130d2e524dc10c306 Reviewed-on: https://gerrit.libreoffice.org/1866 Reviewed-by: Kohei Yoshida <kohei.yoshida@gmail.com> Tested-by: Kohei Yoshida <kohei.yoshida@gmail.com>
2013-01-14fdo#56124 add functions IFERROR and IFNA to calc as in ODFF1.2Eike Rathke6-43/+117
Change-Id: Ic282e1510e121be8fe52320f1f0fe0acc4b9a652
2013-01-09fdo#58539: Correctly set cached matrix formula result.Kohei Yoshida2-2/+3
During the import, a cached matrix value only has an empty matrix of correct geometry, plus the token type of the top-left cell. The rest of the elements are imported as hybrid values. For now, this seems to do the trick. In the future we may want to change it to fully populate the matrix cache value during the import, and skip setting the hybrid values for the non-top-left elements. This commit also make several other trivial changes: * Mark pRawToken mutable so that we can mark those IsFoo() methods const. * Move the ScCompiler instance from static instance to member of ScXMLImport. Since we don't need the instance to persist once the import is over, this is more appropriate. Change-Id: I1abde03c0fcd91b02ef4dbf8b5526f7965eaf19c Reviewed-on: https://gerrit.libreoffice.org/1623 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2012-12-15tabs to spacesEike Rathke1-24/+24
Change-Id: Id832383518af0dd77e401e40512a890265b5d83e (cherry picked from commit 2a8470dca4726d512a33ac3af4ba140aed86909e)
2012-12-15calcishmakkica: #i114428# merge some XOR related codeMarina Plakalovic1-0/+1
Merged from Apache OO with adaptions, parts of http://svn.apache.org/viewvc?rev=1381446&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 1284060031 -7200 # Node ID 528da6bfd0daed4355d745590d5ac3a319b08fb4 # Parent 237cb91dd986ff11eb100cc631206cda102e91f7 Change-Id: If456792f23429a80582a48b022d268e6179316a1 (cherry picked from commit 07df025a730be05d087559b939858260df003b97)
2012-12-15calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, ↵Marina Plakalovic4-5/+70
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 (cherry picked from commit f2cb873631b8b21b54a55beaba532f4bd616a9c6)
2012-12-15calcishmakkica: #i101466# implement AVERAGEIFMarina Plakalovic3-2/+10
Merged from Apache OO with adaptions. http://svn.apache.org/viewvc?rev=1381445&view=rev Original Apache OO committer: Andrew Rist <arist@apache.org> Original Author: Marina Plakalovic <makkica@openoffice.org> Original Author: Eike Rathke [er] <eike.rathke@oracle.com> Original Committer: Eike Rathke [er] <eike.rathke@oracle.com> slightly reworked patch by <makkica> # HG changeset patch # User Eike Rathke [er] <eike.rathke@oracle.com> # Date 1284055400 -7200 # Node ID 237cb91dd986ff11eb100cc631206cda102e91f7 # Parent 1c32319bb02fdf173de6a609fca9f2e9c9f4c73a Change-Id: Id168462272dc8d618513319ebab41fde5c728b08 (cherry picked from commit fff5031898f743c3adf5fcc35bc95fff48094ebb)
2012-12-11fdo#58149: Recalculate HYPERLINK formula cells on load.Kohei Yoshida1-1/+4
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-11-22AllSettings with LanguageTagEike Rathke2-1/+2
Change-Id: I710ae66e51139662eb442b681fdf9cc9d158551d
2012-11-16Fix the Windows build breakage by reorganizing svtools headers.Kohei Yoshida1-0/+1
Also removed a fair amount of implicit inline methods to promote use of more forward declaration. Change-Id: I5ad21f0d7abc85281708b7e87f1036b02a053627
2012-11-01Remove unused method in formula moduleMarcos Paulo de Souza2-7/+0
Change-Id: I67259c5a3894be406b2d38900368a3f8aac86921 Signed-off-by: Marcos Paulo de Souza <marcos.souza.org@gmail.com>
2012-10-19Merge SvListEntry and SvLBoxEntry into SvTreeListEntry.Kohei Yoshida4-22/+22
Change-Id: I89cfc8c1288c00674fe64e791c149743d377d5ee
2012-10-11Merged SvTreeListBox and SvLBox.Kohei Yoshida3-3/+3
There is no reason to keep SvLBox separate. Change-Id: I0b34aa8f8ca539d4f4f0f9cea9fa9b8faec241e8
2012-10-11kill RefEdit constructor that does not initialize the highlightingMarkus Mohrhard2-8/+1
Change-Id: I5c277526fdf376bfa96466e25975388edc3c7950
2012-09-28gbuild: invert handling of standard system libraries:Michael Stahl2-4/+0
Always link in gb_STDLIBS, except when the library explicitly opts out with gb_LinkTarget_disable_standard_system_libs. Change-Id: I489a99114fbfa46d0421a27cf6c7b899dc268a4a
2012-09-28gbuild: replace direct gb_STDLIBS use with ...Michael Stahl2-2/+4
... new gb_LinkTarget_add_standard_system_libs Change-Id: Ib2bc843098db3d8c6822b45a3d21724e67f57d69
2012-09-28gbuild: split uwinapi out of gb_STDLIBSMichael Stahl2-0/+2
Change-Id: I53316e0b9369d806197bccb42cf22d3497af43e7
2012-08-27do not silently ignore a token API error, fdo#51926 relatedEike Rathke1-1/+6
Change-Id: Ie187dad84bd55bb76c795b5c4807566e80349b56
2012-08-25prefix more componentsMatúš Kukan2-2/+2
Change-Id: I9bf304a791b62f6b96711eb058f302cadfdb276a
2012-08-21add more runtime deps on resource files for unit-testsMatúš Kukan1-0/+4
Change-Id: Id9bbb2bbcafe335eada3f36ae103a9074a56848f
2012-07-30Typo ressource -> resourceStephan Bergmann4-12/+12
Change-Id: Id13e7acfbe34eca5e124c9032d36d6f158bfb831
2012-07-30Bug 48549 - System::Beep() removalMathieu Vonlanthen1-1/+0
Change-Id: I011048912af051a762a78af8646513a1fc624073
2012-07-23fdo#48549 System::Beep() removalMathieu Vonlanthen1-4/+0
Change-Id: I8fe133dd8d1f759fbe21d47ae358c0b5451812b5
2012-07-23-Werror,-Wshadow (Clang 3.1)Stephan Bergmann2-62/+62
...where a local variable in a nested class shadows a member of an outer class. Fixed by renaming the relevant outer class members as "m..." Change-Id: I6caa33914ff1060e08f66eadde879fb7b4e3e7cc
2012-07-09some UniString->rtl::OUStringCaolán McNamara2-5/+5
Change-Id: Ie69b30094da25df23a36baca2c7723d6a41f48c3
2012-07-03ditch String::CreateFromAsciiCaolán McNamara1-6/+6
Change-Id: I2b482bd323ac510629c5ee31868010b7cd6ce691
2012-07-02hrc cleanup: Remove include guardsThomas Arnhold1-4/+0
Also add some missing include guards. Change-Id: I320a3c017ca65d34f2cd516849bcde3dec9b33f1
2012-07-02Remove unused definesThomas Arnhold1-3/+0
Some of them were commented out for documentation purpose. Change-Id: I29a6b2cbe774b527f0c3a0be5675160817a7f3ce
2012-07-02targetted improvement of UNO API includes / usageMichael Meeks2-8/+2
2012-06-28re-base on ALv2 code.Michael Meeks37-846/+539
2012-06-27Remove unused include filesThomas Arnhold1-32/+0
Those never get included at any point in the code. Change-Id: I17736e005635b9e57759cfc95176a99e7c5e8988
2012-06-27Reduce newline bloat at eofThomas Arnhold2-4/+0
Change-Id: I494ceee07d6825f9466cab810742d7f85291fe14
2012-06-27Get rid of annoying IAccessibility2 commentsThomas Arnhold1-2/+2
Change-Id: Ic1d7ff88e2d9e638deb2579a5fd18f751302d561
2012-06-25Remove various commented out definesThomas Arnhold1-2/+0
Most of them in hrc files. Change-Id: I3944f6ed9befd2b498385f61b851790362221a4f
2012-06-22.xml files don't need executable bitsMichael Stahl1-0/+0
Change-Id: I399d086181a9f513cd95157e815551f0be9b9e95
2012-06-22re-base on ALv2 code.Michael Meeks1-23/+14
Change-Id: I8018d9b5fa01d1720c0392dc5fdc4a0656f25a35
2012-06-21re-base on ALv2 code.Michael Meeks7-173/+110
Change-Id: I6c145e984c885c7e06caa1c27bfb354ea49ad9ce
2012-06-21re-base on ALv2 code.Michael Meeks3-75/+48
Change-Id: Ice06e639213aeb6f7f23cbf4634947dd25613db1
2012-06-18convert LocaleDataWrapper to OUStringCaolán McNamara1-1/+1
Change-Id: Icb5f5adf9139d1c0f0e86d8128ea6742ce20b138
2012-06-13reduce use of UniString ctor from null-terminated unicodearrayCaolán McNamara1-2/+2
Change-Id: I98361309ada084d8f78517ce88f210d785f59cc0
2012-06-12fdo#50822 add function XOR to calc as in ODFF1.2Winfried Donkers4-2/+10
Change-Id: I994119c0520658775d07f776237d31a03f53ab52
2012-06-11remove EraseLeadingChars and EraseTrailingCharsCaolán McNamara1-5/+3
Change-Id: Ib9797fe97cd008cc6508ce8cec47dc5373416892
2012-06-09Remove superfluous include commentsThomas Arnhold4-17/+0
Change-Id: Icd57ca7fd89e30c190c1b06dbe67c30bea8d1b59
2012-05-29targetted SAL_N_ELEMENTS reversion.Michael Meeks1-4/+4
Change-Id: I30be93ccaeb1f9fd17cbe9e3ed3165e094810b2e
2012-05-16remove unneeded include of boost/bind.hppCaolán McNamara1-1/+2
Change-Id: I5a254459a491b9547530d8e312260dceed21f25c
2012-05-13fdo#44456 added calc function DATEDIF as in ODF1.2Winfried Donkers3-3/+11
Change-Id: I082ea20d02bf37d515fc33d627281696fc48fcb6