summaryrefslogtreecommitdiff
path: root/formula
AgeCommit message (Collapse)AuthorFilesLines
2013-02-28remove all d.lstMichael Stahl1-0/+0
Change-Id: Icba4218c5f9fe89d183d25ea82a8eae52881f885
2013-02-25ocMacro and ocExternal need to be recalculated on load, fdo#60977Markus Mohrhard1-3/+3
Change-Id: I9e69ca2feae44bc645e8a49e349557f0933a23eb
2013-02-25loplugin: unused variablesThomas Arnhold1-1/+0
Change-Id: I63553a09eec81e5ae28aa79ee1d3281053b23d06
2013-02-24loplugin: unused variablesThomas Arnhold1-1/+0
Change-Id: I7fc203900256839e679bf73b717d121fedc42087
2013-02-15ocColumn and ocRow do not need recalc on load, fdo#60645 relatedEike Rathke1-0/+2
Change-Id: I34fc7af10aca3484d30b443c6b0257451a218ed5
2013-02-15renamed SetRecalcMode...() to SetExclusiveRecalcMode...()Eike Rathke3-12/+13
To emphasize exclusiveness of the four basic recalc modes renamed the corresponding methods. Change-Id: If6f99d2c84e4a042a3a3e3640cf416d306a2d0c5
2013-02-15use AddRecalcMode(RECALCMODE_ONLOAD), fdo#60645 relatedEike Rathke1-3/+3
Instead of SetRecalcModeOnLoad() which sets the exclusive bit overriding RECALCMODE_ALWAYS use AddRecalcMode() that handles these cases. Change-Id: Ieeeff67d4dda1493e8c48f231b870513f655839a
2013-02-14CELL needs to be recalculated during import as well, fdo#60645Markus Mohrhard1-0/+2
Change-Id: If981199f01d4b33270d82c65fb033fa51222fb62
2013-02-08fdo#60322 add calc function SKEWP as in ODFF v1.2Winfried Donkers3-2/+10
Change-Id: I4851df1473fc7788af1ac642bb0fb527ec872821 Reviewed-on: https://gerrit.libreoffice.org/2020 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-02-06remove a useless PMD report, possibly checked in by mistakeAndras Timar1-190/+0
Change-Id: Ia3ce43629346c6c705ea6f0aff8e3002b420913b
2013-02-06remove obsolete hidother.src filesAndras Timar1-41/+0
Change-Id: Ieb30afd81d16d184e0276ce7699b848f26a00013
2013-02-02fdo#57180 add calc function NUMBERVALUE as defined in ODFF1.2Winfried Donkers1-1/+1
Conflicts: sc/source/filter/excel/xlformula.cxx sc/source/filter/oox/formulabase.cxx Change-Id: I6ee01764ae9fc27854fd3bd8a630b9d3560192e5 Reviewed-on: https://gerrit.libreoffice.org/1477 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-01-30make it possible to update DDE links after loading, fdo#59032Markus Mohrhard1-0/+3
Change-Id: Iba49bec62cb9081cdcd9410215f269b59c1be304
2013-01-30ODFF: write RRI as RRI, not ZGZEike 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
2013-01-26gbuild: do not copy boost headers aroundMichael Stahl2-0/+4
- do not use gb_UnpackedTarball_copy_header_files for boost - adapt the optimization in concat-deps.c for new path - use boost_headers in all LinkTargets that require it - add explicit include paths to mysqlc, mysqlcppconn, libvisio, liborcus Change-Id: I0c43e73ed43cc9d2e6bce8faf55e992d655a0bb9
2013-01-24restore the helpid for impress animation dialog after initializationCaolán McNamara1-3/+2
Document and centralize the uses of undoing the helpid clear after helpid->uniqueid hack Change-Id: I4e651235407a0eca26dc0acfc089ef8f8ce57b13
2013-01-24import inherited number formats with cached values, fdo#59724Markus Mohrhard1-0/+3
Change-Id: I698f60daf4e591b57d8d99c130d2e524dc10c306
2013-01-22fdo#38838 Some removal/replacement of the String/UniString with OUStringJean-Noël Rouvignac1-4/+4
Also used the new OUString::number(...) methods. Change-Id: I3174c43d56d1ae359901bb8a13fe0096f2c74808 Reviewed-on: https://gerrit.libreoffice.org/1766 Reviewed-by: Luboš Luňák <l.lunak@suse.cz> Tested-by: Luboš Luňák <l.lunak@suse.cz>
2013-01-21Changed SetText() / GetText() to take/return OUStringChr. Rossmanith1-1/+1
replaced lots of Len() with isEmpty() Change-Id: I6b82d48245ee2a0782e05a326f7934e9357227d0 Reviewed-on: https://gerrit.libreoffice.org/1795 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com>
2013-01-12fdo#56124 IFERROR IFNA Excel import/exportEike Rathke1-0/+2
Change-Id: I796e99f8893cb48fa2351f7799bb247a3488ce69
2013-01-11fdo#56124 IFERROR IFNA function names were swappedEike Rathke1-2/+2
Change-Id: I3d13ab04b126a3268352df93a7ed4a35d7a085f2
2013-01-11fdo#56124 changes to "add functions IFERROR and IFNA"Eike Rathke2-15/+57
* 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 Donkers5-36/+66
Change-Id: I6403b51ac8c710ad3b8d2625e1482971f50e6b1d
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
2012-12-22Some cppcheck cleaning in formulaJulien Nabet2-6/+5
Change-Id: I410ab7bbd74b616fcb0a3ed3b0c917cebeac23c6
2012-12-15tabs to spacesEike Rathke1-24/+24
Change-Id: Id832383518af0dd77e401e40512a890265b5d83e
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
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
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
2012-12-12Remove xml2cmp leftoversStephan Bergmann1-31/+0
Change-Id: I7c0ba8b653b8e0534ae17bd879b93b75c6554893
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