summaryrefslogtreecommitdiff
path: root/sc/source/ui/src/scfuncs.src
AgeCommit message (Collapse)AuthorFilesLines
2014-01-06fdo#73117 fix switched true/false explanation for HYPGEOM.DISTWinfried Donkers1-2/+2
in function wizard. Change-Id: I768620967728c619e051e35e8ff472ae12f1404d Reviewed-on: https://gerrit.libreoffice.org/7274 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com> Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-12-16typo: start period is S, thus 'A = 1' -> 'S = 1'Andras Timar1-2/+2
Change-Id: I23ffb5288cda22dcf98bba2d16ae7cf6f9d66825
2013-12-12resolved fdo#67205 CRITBINOM and BINOM.INV, use ODF OpenFormula descriptionEike Rathke1-2/+2
Change-Id: Ibbf2f47b3d6fb67cd49d78d437e28a6399f42691 (cherry picked from commit 0c447b5d32b5d65960e61969d1a0ead4f4dbe7c0)
2013-12-12probabilty -> probabilityEike Rathke1-1/+1
Change-Id: I77fd6a82895f3a65c31f1c166e25b27153ab194a (cherry picked from commit c0c37983b61af172539d8af88f101929f4de56b0)
2013-12-03fdo#70797 fix incorrect argument handling of CHISQ.DISTWinfried Donkers1-1/+1
Change-Id: I6187aa673034e6dc18f48f7b6b7ac88989ab55ec Reviewed-on: https://gerrit.libreoffice.org/6914 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit c3760e9099db9cf1be696347e2a0743a3cae1b20)
2013-11-22fdo#71722 add Excel 2010 functionsWinfried Donkers1-0/+184
EXPON.DIST, HYPGEOM.DIST, POISSON.DIST, WEIBULL.DIST Change-Id: Ib9f648739ec0af90cdf2f576c7f548a6acb7b4a6 Reviewed-on: https://gerrit.libreoffice.org/6748 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit e434c1ce0557454ef4cdd98435c5c0b1d5181bcf)
2013-11-20fdo#71436 add Excel 2010 functions for F-distributionWinfried Donkers1-0/+200
Added F.DIST.RT, F.INV.RT, F.TEST, which are renamed FDIST, FINV and FTEST and handle the right tail F-distribution. Added F.DIST and F.INV, which are new functions and handle the left tail F-distribution. Change-Id: Ia7fa26a25f3188249f280733d6111951e2600704 Reviewed-on: https://gerrit.libreoffice.org/6701 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-11-17fdo#71652 - change thousand separate descriptionJoel Madero1-1/+1
Minor change to the text found in thousand separator parameter use description to make it a bit clearer. Change-Id: Idfa83e04c123458913af0795c78ea4fae616e24c Reviewed-on: https://gerrit.libreoffice.org/6690 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-11-14fdo#71350 add Excel 2010 function CONFIDENCE.NORM and CONFIDENCE.TWinfried Donkers1-0/+80
Change-Id: I341b0c7a61047627aac1f12bc4653b6f9e65b2e3 Reviewed-on: https://gerrit.libreoffice.org/6625 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-11-08fdo#70797 add Excel 2010 functionsWinfried Donkers1-1/+173
CHISQ.DIST, CHISQ.INV, CHISQ.TEST, CHISQ.DIST.RT, CHISQ.INV.RT Change-Id: If32530a82b2e5fa1aa30a8c80090742be5acf3eb Reviewed-on: https://gerrit.libreoffice.org/6611 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-11-04fdo#71081 add Excel 2010 functions BINOM.DIST and BINOM.INVWinfried Donkers1-0/+88
Change-Id: Iaecccd9ec6ab6a08c6c7ee8c024a3eba48ca1682 Reviewed-on: https://gerrit.libreoffice.org/6521 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-11-04fdo#71128 arguments of calc function MMULT have same nameWinfried Donkers1-2/+2
Arguments 1 and 2 of MMULT have the same name in the function wizard, which is both confusing for the user and inconstent with other argument names for matrix functions. Patch simply changes the names to match the description of the arguments of MMULT. Change-Id: I9fc35907133aa61248182bd3b253a7f90ba7cd2c Reviewed-on: https://gerrit.libreoffice.org/6526 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-10-31fdo#71008 add Excel 2010 functions BETA.DEST and BETA.INVWinfried Donkers1-0/+120
Change-Id: I65863031cc2795713bf80c17dfc787e2700a556a Reviewed-on: https://gerrit.libreoffice.org/6505 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-10-31fix incorrect strings for calc functions STDEVP and STDEV.PWinfried Donkers1-2/+2
Change-Id: I13f7127afbc05a352ffd74a4715e6cc6260a1a07 Reviewed-on: https://gerrit.libreoffice.org/6506 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-10-30fdo#61002 add Excel 2010 functions VAR.P and VAR.SWinfried Donkers1-0/+48
Change-Id: I23f286eaaef79d196a65e8079b62cf577539e9f1 Reviewed-on: https://gerrit.libreoffice.org/6477 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-10-30added missing HIDs instead of using copy&paste IDs of other functionsEike Rathke1-4/+4
Change-Id: I4d3cb89501f287fa2b278881352a766715ec7c6e
2013-10-30using dbgutil builds is good for you (TM)Eike Rathke1-3/+3
Init of function description resources displayed "Class: 272, Id: 412. Classpointer not at the end!" that was due to resource SC_OPCODE_WEBSERVICE having an extraneous parameter flag in ExtraData that wasn't read because the function has 1 and not 2 parameters. Additionally added HID_FUNC_FILTERXML and HID_FUNC_WEBSERVICE where the resources used a copy&paste HID_FUNC_BITLSHIFT instead. Change-Id: Iaf5a860901d5e02581965a4b33cfc50c1a601b1f
2013-10-25fdo#44134 adding Excel 2010 functions STDEV.P and STDEV.SWinfried Donkers1-0/+48
Change-Id: If7b2767a69285ac72fa7120b1149a66f118cce8f Reviewed-on: https://gerrit.libreoffice.org/6354 Tested-by: Eike Rathke <erack@redhat.com> Reviewed-by: Eike Rathke <erack@redhat.com>
2013-10-22Bin comments that claim to say why some header is includedTor Lillqvist1-2/+2
They are practically always useless, often misleading or obsolete. Change-Id: I2d32182a31349c9fb3b982498fd22d93e84c0c0c
2013-10-18fdo#70000 add support for COVARIANCE.P and COVARIANCE.S functionsWinfried Donkers1-1/+65
These functions have been introduced with Excel 2010, but were not supported yet in calc. COVARIANCE.P (population) replaces the COVAR function, but the COVAR function remains present (in Excel as well as in calc). COVARIANCE.S (sample) is a new function. Change-Id: If5501b4090fb716adfb3d121c7898528fd1b7ad4 Reviewed-on: https://gerrit.libreoffice.org/6135 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-09-23fdo#69536 - Moved Averageif(s)Joel Madero1-2/+2
Moved averageif and averageifs to statistical category instead of mathematical Change-Id: Ibcf7f5a5e12b528c4877232e4c56d5167b1df40a Reviewed-on: https://gerrit.libreoffice.org/6010 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-09-23fdo#69685 - move count functionsJoel Madero1-3/+3
Moved Count functions (countif, countifs and countblank to statistical instead of mathematical group) Change-Id: If8faeabb8f43810a96d919b59116157ae107c12c Reviewed-on: https://gerrit.libreoffice.org/6022 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2013-08-15corrected description strings of 'criteria'Eike Rathke1-7/+7
Criteria in SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS are not cell ranges. Change-Id: Iace25057ab3c9af1e2ec3c45c6803d42272f962b
2013-08-15get rid of tabs from mergeEike Rathke1-151/+151
Change-Id: I39e41abc17979f6b84b787d1078de05475ea8a62
2013-06-16another merge errorMarkus Mohrhard1-1/+1
Change-Id: Iec1f5d090581b1613782b521139387853e4c902f
2013-06-16fix merge errorsMarkus Mohrhard1-1/+2
Change-Id: I0d9cae8f5ac06a90f4e3e000c6a3648a5cefe839
2013-06-16add initial version of WEBSERVICE functionMarkus Mohrhard1-0/+23
Change-Id: I8a835278c0d1b8f3a463aa5765b145410605aba4
2013-06-16inital work on FILTERXML functionMarkus Mohrhard1-0/+30
Change-Id: Ifb884a52b275df818812f8be6cd7650dcb97849d
2013-06-11Resolves: #i121120 Support RightB(), LeftB(), LenB() and MidB()Wang Lei1-0/+124
Patch by: Zhang Lu Review by: Wang Lei (cherry picked from commit 424079cb8348d77e40f7d3291578bdffbe662f34) Conflicts: formula/inc/formula/compiler.hrc formula/inc/formula/opcode.hxx oox/source/xls/formulabase.cxx sc/inc/helpids.h sc/util/hidother.src sc/util/makefile.mk Change-Id: Ia04aa69aa2764842507b36ba7cc8c99e99a314e9
2013-03-08fdo#60691 add modelines to *.src and *.hrc filesBorim1-0/+3
use solenv/bin/add-modulelines script for the task and remove all UTF bom from *.src and *.hrc files svx/source/dialog/hdft.src Change-Id: I745d4f0fe9b05436a142a03f8512970f91c41bd4
2013-02-08fdo#60322 add calc function SKEWP as in ODFF v1.2Winfried Donkers1-0/+24
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-02fdo#57180 add calc function NUMBERVALUE as defined in ODFF1.2Winfried Donkers1-4/+12
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-12adapt function description to changed place, fdo#58957Markus Mohrhard1-1/+1
Change-Id: I1abdae0f924bf919fbf43e5a07f950a8a10861a9
2013-01-11fdo#56124 changes to "add functions IFERROR and IFNA"Eike Rathke1-7/+7
* 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/+64
Change-Id: I6403b51ac8c710ad3b8d2625e1482971f50e6b1d
2012-12-15calcishmakkica: #i114428# merge some XOR related codeMarina Plakalovic1-1/+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#Eike Rathke [er]1-7/+9
* For SUMIFS, AVERAGEIFS and COUNTIFS: * All ranges must be of same dimension and size. * Bail out if error encountered for any parameter, without calculating remaining parameters. * Adapted ScParameterClassification to cope with paired repeated parameters. * In function resource have a trailing blank for repeated parameters so the number is appended with a blank between. Merged from Apache OO with adaptions. http://svn.apache.org/viewvc?rev=1381448&view=rev Original Apache OO committer: Andrew Rist <arist@apache.org> Original Author: Eike Rathke [er] <eike.rathke@oracle.com> Original Committer: Eike Rathke [er] <eike.rathke@oracle.com> # HG changeset patch # User Eike Rathke [er] <eike.rathke@oracle.com> # Date 1288820521 -3600 # Node ID 79da8a1033b663c919f0dc48799f70256bffa497 # Parent 02cf226fcde498f6fd926d45df497e9fb412fe0f Change-Id: Ica4faa4e7a46cd5f480cb898785daa51a50ec23b
2012-12-15calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, ↵Marina Plakalovic1-0/+115
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 Plakalovic1-0/+41
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-04re-base on ALv2 code. Includes:Michael Meeks1-23/+14
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-07-20fdo#52293 Changed "discreet" to "discrete"Kevin Peng1-1/+1
Change-Id: I305883239dbcd6f46d6ed5614c4968e0b59055ca
2012-06-12changes to patch "fdo#50822 add function XOR to calc as in ODFF1.2"Eike Rathke1-1/+1
* removed XOR entry again from sc/source/filter/oox/formulabase.cxx saFuncTableBiff5 * changed XOR entry in sc/source/filter/excel/xlformula.cxx saFuncTable_Odf from ocNoName to ocXor to have it written as _xlfnodf.XOR * changed description of function in Function Wizard
2012-06-12fdo#50822 add function XOR to calc as in ODFF1.2Winfried Donkers1-0/+24
Change-Id: I994119c0520658775d07f776237d31a03f53ab52
2012-05-13changes to patch fdo#44456 added calc function DATEDIFEike Rathke1-5/+5
* use operator && instead of 'and' * use correct types * long operator -(Date,Date) * sal_uInt16 GetDay(), GetMonth(), GetYear() * check for error after argument pop and bail out if so * day difference can be pushed and return immediately without further calculation * ensure only one value is pushed * correct calculation of years and months * only complete years and months are to be returned, same day,month in different years is a complete year (birthday-like), same day in different months is a complete month. * "y" returned 1 for 2012-02-29,2013-02-28 or 2012-03-29,2013-03-28 * must be 0 instead * "y" returned 0 for 2011-03-28,2013-03-29 * must be 1 instead * negative values are never returned * reversed arguments are not allowed * algorithm for "md" extracted from Excel behavior, see source * changes to other intervals as well * changed term Format to Interval in FormulaWizard (and code) for clarity * mention interval arguments in FormulaWizard * in sc/source/filter/oox/formulabase.cxx reverted the entry's move from saFuncTableBiff5 to saFuncTableOdf * saFuncTableOdf member's are "Functions defined by OpenFormula, but not supported by Calc or by Excel", this function now is supported by both * instead, changed FUNCFLAG_IMPORTONLY to 0 in entry of saFuncTableBiff5 and added FunctionData::mpcOdfFuncName "DATEDIF" * otherwise with the FUNCFLAG_MACROCALLODF a macro call is generated for Excel export that Excel doesn't know and can only be imported by LibO again, and without the BIFF function identifier the function could not be imported from original binary Excel documents
2012-05-13fdo#44456 added calc function DATEDIF as in ODF1.2Winfried Donkers1-0/+46
Change-Id: I082ea20d02bf37d515fc33d627281696fc48fcb6
2011-12-31Correct ARCCOSH()'s parameter descriptionKorrawit Pruegsanusak1-1/+1
2011-11-28dr78: #i111413# new ODFF interpreter functions SEC, SECH, CSC, CSCH; patch ↵Eike Rathke1-0/+99
from <regina>, slightly reworked # HG changeset patch # User Eike Rathke [er] <eike.rathke@oracle.com> # Date 1291394833 -3600 # Node ID ff05fcb4fe392f8c336466982a25fdfda207515a # Parent 4ca136c3f3c8eb330664884c2ff79e2027d8e4eb
2011-09-07BITxxx functions according to ODF 1.2 OpenFormulaWolfgang Pechlaner1-0/+156
Implements BITAND, BITOR, BITXOR, BITLSHIFT and BITRSHIFT as specified by OASIS OpenDocument Format 1.2 OpenFormula / ODFF. Changes made by the committer: * Original submission added the new functions to the Logical group, that group has only functions though that return a logical value 1/0/true/false. ODFF groups them under "Bit operation functions" that currently is not available in Calc. Added the functions to the Mathematical group instead. * Changed descriptions of functions in the Function Wizard. * One sal_uInt64 constant instead of several identical literal 281474976710655 values. * Replaced 'or' operators with || * Don't push two return values, if PushIllegalArgument() was used don't use PushDouble() thereafter. * Treat double values with ::rtl::math::approxFloor() to obtain integer values. * For BITLSHIFT and BITRSHIFT implemented a different algorithm following the ODFF specification that allows larger shift values. * Use our block braces style, respectively don't use block braces for one-line if-statements. * Fixed indentation levels. * Adapted RTL_LOGFILE_CONTEXT_AUTHOR to say "pechlaner". Credit to whom credit is due ;-)
2011-01-24dr79: #i116540# change 'DataPilot' to 'Pivot Table' in Calc GUI; recover ↵Daniel Rentz [dr]1-4/+4
lost changes in resource file pivot.src, remove unused code
2010-07-10CWS changehid: #i111874#: change code to support HelpIds as byte stringsMathias Bauer1-1/+2
generated by cgit v1.2.3 (git 2.39.1) at 2024-04-27 02:34:41 +0000