summaryrefslogtreecommitdiff
path: root/sc/inc/helpids.h
AgeCommit message (Collapse)AuthorFilesLines
2016-05-04tdf#97831 [part] Add Excel 2016 functions to CalcWinfried Donkers1-0/+2
Functions MINIFS and MAXIFS Change-Id: I4bd2e8b82f8377af81f4373d0c33ac286588b8df Reviewed-on: https://gerrit.libreoffice.org/24619 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-05-03tdf#97831 [part] Add Excel 2016 functions to CalcWinfried Donkers1-0/+2
Functions IFS and SWITCH. Change-Id: Ic43d42a933bcac883e9aa2213dd4ddeddf45abf0 Reviewed-on: https://gerrit.libreoffice.org/24424 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-04-26tdf#97831 [part] Add Excel 2016-Office 365 functions to CalcWinfried Donkers1-0/+2
Functions CONCAT and TEXTJOIN. Change-Id: I38092f77df719d11f6746ac10fe14dc53b7e93e7 Reviewed-on: https://gerrit.libreoffice.org/23601 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-03-03tdf#94635 Add FORECAST.ETS functions to CalcWinfried Donkers1-0/+8
Change-Id: Ifbfff1c27fb3960a06f467630da0fa39665f0ce4 Reviewed-on: https://gerrit.libreoffice.org/20073 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-01-05tdf#96198 add WEEKNUM_OOO compatibility function, tdf#50950 follow-upEike Rathke1-0/+1
The remaining cases when loading old and wrong ISOWEEKNUM that can't be mapped to either new WEEKNUM or ISOWEEKNUM now are mapped to WEEKNUM_OOO(date,mode) with calculations identical to the old and wrong OOo WEEKNUM. These WEEKNUM_OOO cases are still wrongly saved as ISOWEEKNUM so can be read by 5.0 or earlier versions as the old WEEKNUM, which should be changed for 5.3 or later. WEEKNUM_OOO is not offered in the Function Wizard to prevent deliberate usage. Also reverts the interim unit test change to sc/qa/unit/data/contentCSV/date-time-functions.csv that was necessary to catch the error generated by ISOWEEKNUM with two arguments. Change-Id: I874c4c7225900f03b879f2947512ae02270cbd4f
2015-12-24Kill useless headerMaxim Monastirsky1-1/+0
Change-Id: Ida0302a4d7b801765a4be2aae0de2b7ea0ba62d1
2015-12-17Clean unused defines after src->xml conversionMaxim Monastirsky1-5/+0
... in 1c035f1b0eb6f5e5fbb6c54bf2eea9a6c983eb8f Change-Id: I71271824b68ed21ac5db95b01fee61337fde189b Reviewed-on: https://gerrit.libreoffice.org/20736 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Maxim Monastirsky <momonasmon@gmail.com> Tested-by: Maxim Monastirsky <momonasmon@gmail.com>
2015-12-17add RAWSUBTRACT spreadsheet function, tdf#71459Eike Rathke1-0/+1
Change-Id: I2ae13771c85044b771e253a8189a30cb4aecb30f
2015-10-06tdf#50950 Add ODFF1.2 Calc function ISOWEEKNUM,Winfried Donkers1-0/+1
make Calc function WEEKNUM compliant with ODFF1.2, provide backward compatibility for Calc function WEEKNUM, add unit tests for ISOWEEKNUM, WEEKNUM and backward compatibility. Change-Id: I63af5543cea2f470d710462e55404ac754022c89 Reviewed-on: https://gerrit.libreoffice.org/18760 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-06-11tdf#69552 [part 2] support all ODFF1.2 and Excel2013 variationsWinfried Donkers1-0/+2
of CEILING and FLOOR Change-Id: I9537d9bd8dbca2eac769e74e9d3d5b298b76f594 Reviewed-on: https://gerrit.libreoffice.org/16016 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-05-05fdo#77985 make calc function NETWORKDAYS comply with ODFF1.2Winfried Donkers1-0/+1
Change-Id: I523b0c71bc0fed501a4d5fffd75c5a4704f6dd13 Reviewed-on: https://gerrit.libreoffice.org/9827 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-04-29fdo#69552 [part 1] make calc functions CEILING comply with ODF1.2Winfried Donkers1-0/+2
Also, add support for CEILING.MATH and fix small deficiencies with CEILING functions, as most are interwoven. Change-Id: I0d9a46fb17e982ccf1e9d9e403b58926172c1a7a Reviewed-on: https://gerrit.libreoffice.org/7088 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-01-26fdo#76870 Add support for Excel2013 function ENCODEURLWinfried Donkers1-0/+1
Change-Id: I369bcd58055364757b6a098fc3aa0c0065c79b67 Reviewed-on: https://gerrit.libreoffice.org/13478 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-01-14add ODF1.2 function ERROR.TYPE to CalcWinfried Donkers1-0/+1
Also, improve exchange between Calc and Excel2013. Change-Id: I491f9e2100a9a2c38e23cf55dd1eda4b5e96db96 Reviewed-on: https://gerrit.libreoffice.org/13101 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-01-08brute-force find-and-remove of unused #define constants.Noel Grandin1-80/+0
Change-Id: I7223530ae37297a76654cd00cc1fedb56dbe3adb
2014-11-03fdo#84844 Use SvxColorToolBoxControl for border colorMaxim Monastirsky1-1/+0
Change-Id: Id177964ec35d6b5a08c46b8ba96615c2a4729136
2014-10-27fdo#84844 Sidebar: Use SvxColorToolBoxControl for cell fill colorMaxim Monastirsky1-3/+0
Change-Id: I4a067b31b4b518c56a0d18c6e6709955562d77fa
2014-07-03Typo in HID for ERFOlivier Hallot1-1/+1
Change-Id: I5da8029c9b4102472deb2ab1f68ec23b13898e50 Reviewed-on: https://gerrit.libreoffice.org/10038 Tested-by: David Tardon <dtardon@redhat.com> Reviewed-by: David Tardon <dtardon@redhat.com>
2014-05-19add COLOR functionMarkus Mohrhard1-0/+1
This function makes property mapping in charts more user friendly. Change-Id: I01cfb31edd749ee474d5078042fa5c4b4a270f86
2014-05-11fix-includes.pl: scThomas Arnhold1-2/+2
Change-Id: Iade3fedac5d2f8e978b7dd9c30f001d7d1564946
2014-04-25fdo#73148 (partial patch) Add Excel 2010 function AGGREGATEWinfried Donkers1-0/+1
Change-Id: If8fc8608699a14e573456af2e1180342be942dd1 Reviewed-on: https://gerrit.libreoffice.org/8475 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-04-11fdo#73149 add Excel 2010 functions ERF.PRECISE and ERFC.PRECISEWinfried Donkers1-0/+2
Change-Id: I3199470ec92923e8cc12156f21dd397d870cc1e0 Reviewed-on: https://gerrit.libreoffice.org/8930 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-04-02fdo#73147 add Excel2010 functions NETWORKDAYS.INTL and WORKDAY.INTLWinfried Donkers1-0/+2
Change-Id: I3ab9dde5c421a3a3e6022a27be37f23547197317 Reviewed-on: https://gerrit.libreoffice.org/8772 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-03-10convert pivot filter dialog to .uiCaolán McNamara1-2/+0
Change-Id: I795d296bae700d1e3a273fbe71fc842d145c5138
2014-03-10fdo#71720 Add Excel 2010 functionsWinfried Donkers1-0/+3
CEILING.PRECISE, ISO.CEILING, FLOOR.PRECISE Change-Id: I047b65ca3adafb89fce9b6493948aa851ddca765 Reviewed-on: https://gerrit.libreoffice.org/8488 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-03-05Converted group by [number|date] pivot table dlg to .uiKatarina Behrens1-3/+0
Change-Id: I3c6256f1b2d176790a8eb7c094c1583ce053971b Reviewed-on: https://gerrit.libreoffice.org/8382 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2014-03-05fdo#72197 Add Excel 2010 functionsWinfried Donkers1-0/+4
MODE.SNGL, MODE.MULT, NEGBINOM.DIST, Z.TEST Change-Id: I55eb05e1ebdb9dbc3ce9ae84e3cdacfdfa112091 Reviewed-on: https://gerrit.libreoffice.org/7776 Tested-by: LibreOffice gerrit bot <gerrit@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-02-14convert Data Field Options Dialog to .uiCaolán McNamara1-2/+0
Change-Id: Ie940352828a9b58d35dd1644d030d6fb5b72d386
2014-02-13Various adjustments of the pivot tableCaolán McNamara1-7/+0
especially relative positions were relative to the dialog which was assumed to be then a direct parent of the widgets so that a simple calculation could make the positions relative to the widgets also now the pivot table fits into a 768 pixel high screen Change-Id: I86a4155439872e8273943b90f15320e560e237a4
2014-02-04convert select data source dialog to .uiCaolán McNamara1-1/+0
Change-Id: Iecca542c2c425a34184ba2c3ae0e34d093fa6a06
2014-02-02convert import options dialog to .uiCaolán McNamara1-1/+0
Change-Id: Iaf20b6d2306ba76f21cb5f7be231f40b403c790a
2014-01-30fdo#73146 Add Excel 2010 functionsWinfried Donkers1-0/+8
PERCENTILE.EXC, PERCENTILE.INC PERCENTRANK.EXC, PERCENTRANK.INC QUARTILE.EXC, QUARTILE.INC RANK.EQ, RANK.AVG Function ScInterpreter::ScRank() has been rewritten to give the function the same way of computing as the related functions in this patch. Change-Id: If3096b265bd47ca5f4afcab7ff746f7c8511df82 Reviewed-on: https://gerrit.libreoffice.org/7319 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-01-27fdo#72793 Add Excel 2010 functionsWinfried Donkers1-0/+6
T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, T.TEST Also, fixed some incorrect string assignments in formula/source/core/resource/core_resource.src from previously added Excel 2010 functions. Change-Id: Ia4d13e7597d2a054d345a08b66b878f91c43f872 Reviewed-on: https://gerrit.libreoffice.org/7226 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2014-01-17convert pivot table subtotals data field dialog to .uiCaolán McNamara1-1/+0
Change-Id: I4ac7fb3a13cdc03d3c75cdd730bf39a7d814de99
2014-01-17convert data field dialog to .uiCaolán McNamara1-1/+0
Change-Id: I68da93c1227e8140511f3ad4071c87b3cf0443c0
2013-12-30convert solver options dialog to .uiCaolán McNamara1-3/+0
Change-Id: I319210233dd1b71f6e717c7322b953de8f093150
2013-12-30convert solver progress dialog to .uiCaolán McNamara1-1/+0
Change-Id: I259f7d75591121be584e3a8cfe514232a404c0fa
2013-12-29convert solver success dialog to .uiCaolán McNamara1-1/+0
Change-Id: Ia9062a21afde96510a4953d1b51e7e59e9012fb7
2013-12-20convert solver no solution dialog to .uiCaolán McNamara1-1/+0
Change-Id: I94ba29d328c443e0f944fef8d33fc25cdc0e9694
2013-12-19set mnemonic widgets and a max heightCaolán McNamara1-9/+1
Change-Id: If52541caf94b76b38b3ec8b606db7bbc734d2591
2013-12-16fdo#72158 Add Excel 2010 functionsWinfried Donkers1-0/+6
LOGNORM.DIST, LOGNORM.INV, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV Change-Id: I695e0645642af1757a1dd7d7f0f15c9515e21309 Reviewed-on: https://gerrit.libreoffice.org/6883 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-11-29fdo#71936 Add Excel 2010 functions GAMMA.DIST, GAMMA.INV, GAMMALN.PRECISEWinfried Donkers1-0/+3
Change-Id: I96f6beb34c1ce7f7191c6e9d379145ba98320c87 Reviewed-on: https://gerrit.libreoffice.org/6775 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2013-11-22fdo#71722 add Excel 2010 functionsWinfried Donkers1-0/+4
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>
2013-11-20fdo#71436 add Excel 2010 functions for F-distributionWinfried Donkers1-0/+5
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-14fdo#71350 add Excel 2010 function CONFIDENCE.NORM and CONFIDENCE.TWinfried Donkers1-0/+2
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-0/+5
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/+2
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-10-31fdo#71008 add Excel 2010 functions BETA.DEST and BETA.INVWinfried Donkers1-0/+2
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-30fdo#61002 add Excel 2010 functions VAR.P and VAR.SWinfried Donkers1-0/+2
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-0/+4
Change-Id: I4d3cb89501f287fa2b278881352a766715ec7c6e
generated by cgit v1.2.3 (git 2.39.1) at 2024-05-20 15:42:06 +0000