summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2020-07-10Fix mistake in Help page for VDB()Olivier Hallot
Change-Id: Ib3780415a1ca5385dd27391f2b33fd1904e5e24b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/98523 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-07-01tdf#134376 Add Calc cell style Help pageOlivier Hallot
Change-Id: I57f32bdfc4435cbe21b7cca1cb5170892e69447d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97622 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-01Adjust OFFSET() note to realityEike Rathke
It was never necessary to enter OFFSET() as an array formula if a cell range reference is returned. Whether to use an array formula entirely depends on how the resulting range(s) are to be used as arguments to calling functions. Change-Id: Icb771c680f1b9c076017ebd2c78f440529ecc1b2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97620 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2020-06-25tdf#132464 Enhance Help for sumation iconOlivier Hallot
Change-Id: Iec55f78002beb2052e0d49089f1b3a09171fa43f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96784 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-22Review Area tab called by many modules.Olivier Hallot
Change-Id: I9afa69a68c538647d4643e9b68077c97ff4eb079 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96900 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-22Fix label contents for Text CSV importOlivier Hallot
Change-Id: Ifdfc8ad238b6ef070ca2fa46af7bd50be77c17d0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96844 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-17tdf#134032 Calling Calc function from basicOlivier Hallot
Change-Id: I7c3c64e0df4d89b46e49afb869f3e2de0825a6e2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96485 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-11Unmute L10N in stringOlivier Hallot
Change-Id: I89116a7fb1e94ded67629d5e4f397a2ff292eaa4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96073 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-05tdf#132643 Translate German section IDsJohnny_M
Change-Id: I08aa7661f7888b06c09206226f951f8269751dfe Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95586 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-03Improve readabilty of SERIESSUMOlivier Hallot
Change-Id: Ia5f4c2ccd335f9be8606bb192cc88d703d80d00c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95436 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-03Improve help information for ACCRINT() function to better explain the ↵Steve Fanning
behaviour of the Par argument. Change-Id: Ia1fb54abe828dc9d0310e83f9552099759b96d40 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95329 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(ful_func.xhp) Update common defintions for lengthy argument lists, to ↵Steve Fanning
contain more white space and give greater consistency across Calc functions. Change-Id: I053486715c5cb8f0687b6b02c218e470db163b8d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95249 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01Correct argument separation character in CEILINGOlivier Hallot
Change-Id: Iac4caaba8c04232726529a201576a20f29b1a14f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95296 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(04060185.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Change-Id: I8d099d9babe118c7592b060027dd037e9fbdadaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95245 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(04060184.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Change-Id: I20270c2acaa2d9f9957691ce3452986d35126a0e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95243 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(04060183.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Change-Id: I53c9d01dfd75cdab6bac7284b2d775d36a1d9311 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95241 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(04060182.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Also updated GEOMEAN() and HARMEAN() to cater for up to 255 arguments rather than 30. Change-Id: I706f1f8426b04b3ec06064d505116151b55f2b00 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95240 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(04060119.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Note: PMT() and PPMT() functions - syntax now matches ODF 1.2. Change-Id: I7c291ed84eaf875953e86996cc74c2c9a956e13c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95235 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-01(04060181.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Change-Id: Idade23cd4fd95210ecc0bd1684f30f30c9d2ccbc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95236 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(04060116.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Change-Id: Ife2ccaeb06062c1cedaa8cba8511a0a86be1fc1a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95209 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(04060118.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. ODF 1.2 used to confirm configuration of brackets for FV(), NPER(),and RATE(). Change-Id: I7b109974d3e1dbc6670c32628a5425741d882f4e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95208 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_color.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameter. Change-Id: I648260ba137015b29443944c983aac16f497b7d6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95207 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_findb.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameter. Change-Id: Ib21893f9f1d61a164957a82114f9a1dc0255b9ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95206 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_fourier.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameters. Change-Id: I4f5a108e6e588dd97b4501a8b2d13be628536a6d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95205 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_networkdays.intl.xhp) Include square brackets in syntax section to ↵Steve Fanning
indicate optional parameters. Note: Exact configuration of square brackets based on that for NETWORKDAYS(). Change-Id: I0f1f7100add3f50d2ba3946087cca292d7a51d65 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95204 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_networkdays.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameters. Note: Exact configuration of square brackets inferred from ODF 1.2. Change-Id: Ie607da08555aac5bc3d1a46b53f8d4b5c90d33ff Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95203 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_numbervalue.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameters. Change-Id: I7f4018a666d42909bd669eb0c5732c470b0c7255 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95202 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_opt_barrier.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameter. Change-Id: Ide89b5a29ab7846ffa77ccf4a8bc7becfe776cdb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95201 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_opt_prob_inmoney.xhp) Include square brackets in syntax section to ↵Steve Fanning
indicate optional parameters. Change-Id: I31d3a3f9b5434fe16eb7ed33a56492c1391d4753 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95200 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_opt_touch.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameter. Change-Id: Ib1d07ed5c135176fb95b94d44b0cf7bb78937f28 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95199 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(func_searchb.xhp) Include square brackets in syntax section to indicate ↵Steve Fanning
optional parameter. Change-Id: I6b3cdf9d6a98b8183b641c94b4cbeceb4add0183 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95198 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-31(04060115.xhp) Update syntax statements to clarify which arguments are optional.Steve Fanning
Change-Id: I9810870dfef24ab8876c2be0fb6ce6770c60f257 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95196 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-30(04060110.xhp) General updates to function syntax statements in Help file, ↵Steve Fanning
to include square brackets indicating optional parameters. Also updated example for PROPER() function to reflect more appropriate sample string! Change-Id: I42f485f3e312c2d870059b60b3dcdc7d8921a0d8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95195 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-30The syntax of the GROWTH() function is still not quite correct in the Help. ↵Steve Fanning
GROWTH() is special in that the 2nd and 3rd parameters are not only optional but may also be specified empty/omitted, in which case they are set to defined values. This makes the syntax a bit more complex but it can be checked against the specification in ODF V1.2. Change-Id: Idf050f59cce194aba80dcd4887ee636dcd00ec38 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95194 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-30The change to the CHOOSE function needs to be re-worked (as advised by Eike ↵Steve Fanning
Rathke). TDF #95124 has very recently fixed a bug in Calc's Function Wizard. CHOOSE() supports only 30 jump targets, and this should now be limited in the dialog. Update Help again to reflect this correction. Change-Id: I5591e36dc69301b5a6a22a22d35d4ae27b5b2459 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95193 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(04060109.xhp) Changes to syntax statements to readily identify optional ↵Steve Fanning
parameters. Also implemented modification required to CHOOSE function syntax - the Function Wizard allows 250+ arguments, not 30. Change-Id: Ia623c6c908a9efec219cdf8469c26e24ceca0858 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95121 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(WEEKDAY fn) Minor tidy-up for consistencySteve Fanning
Change-Id: Ie5f2031b09afd836c1e92a8f4fe837393442a0c2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95115 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(04060107.xhp) Update syntax section for four functions to include square ↵Steve Fanning
brackets, indicating optional parameters. Change-Id: Ie1b2a487be11c9e6b2ed17eae8e0b067510c8b61 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94953 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(04060105.xhp) Minor changes to correct syntax statements.Steve Fanning
Change-Id: I963a2458d10e4d329f16975540246c981629f79b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95120 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(IF func) Minor correction to syntax statementSteve Fanning
Change-Id: Ib97051224752f5740e7afa0a6da336bfdf7beeb7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95119 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(CELL func) Minor update to syntax statementSteve Fanning
Change-Id: Ib16650fdde78757220497996cdd0c699e15a20bf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95118 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(04060103.xhp) Corrections to function syntax statementsSteve Fanning
Change-Id: Ic058b98ada2d384ef8128776bdbef9f73afe870a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95117 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29(WORKDAY.INTL func) Correct syntax statementSteve Fanning
Change-Id: I07e5857bbccf5597d5506e224088060310dce1b4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95116 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-29Minor change to layout of syntax statement (for consistency and clarity)Steve Fanning
Change-Id: I782d27823c19d91bb0123c16ffbd5646e71b457b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95071 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-28Minor change to layout of syntax statement (for consistency and clarity)Steve Fanning
Change-Id: Iebd6bfa9c23c9b02db16a03f82cac6c1bff09708 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95070 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-28Update syntax section for six functions to include square brackets, ↵Steve Fanning
indicating optional parameters. Change-Id: I27d069e76e448b2f019bd8678a1769b82f2f5c20 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94952 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-27tdf#132586 Add RAND.NV() and RANDBETWEEN.NV()Olivier Hallot
Change-Id: I181d4f7ce0ccca38339568c034754c40ef345026 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94724 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2020-05-26Added square brackets around applicable parameter in eight syntax statements ↵libreoffice-7-0-branch-pointSteve Fanning
(to indicate parameters are optional). All changes contained in one XHP file. Change-Id: Ia4855d44b49f7d4198e8d644f5b53741b5083371 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94838 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-26Add square brackets around final two parameters in syntax statement (to ↵Steve Fanning
indicate parameters are optional) Change-Id: Icbe4f4d834244dc8bb397b0eb5fa5df5d543ddbb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94840 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-26Add square brackets around final parameter in syntax statement (to indicate ↵Steve Fanning
parameter is optional) Change-Id: I9703c7e556009613e377324b30a2a15accd33f5d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94839 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2024-07-30 02:43:28 +0000