summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2020-09-28Add Calc XML source screenshotOlivier Hallot
Change-Id: Ie39d4933a568e511b243b54a1801db869b2f74f2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101035 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 98dbecc36765a4e82574db6e433ece4e8a5008d0) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101061 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-08-04Fix tag contentsOlivier Hallot
Found you finally... Change-Id: I71e11b570e31ad1cc470dfea3e54935e000d80f0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100011 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 8b7b468cfcb1591972ee2e47a295ee4cf86a46e8) No Impact on translations Change-Id: If2f64048ef18595aed9c3f2ef193494c14558fcc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100057 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
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 (cherry picked from commit c8683685e228f1daae3d039886245b6dfea6d138) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97580 Tested-by: Eike Rathke <erack@redhat.com>
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> (cherry picked from commit 93de72b7c394831e52794e4d37905fd424d51722) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97133
2020-06-23Fix 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> (cherry picked from commit d2fe8fae9d249659c389e374a253072ae92506ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96870 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
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> (cherry picked from commit 7af288d0fa90e5e31c29014501f06f776a00366a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96504 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-06-08Improve 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> (cherry picked from commit 67026c44ece5d04b41eb1c2f2c3ebf086d558bbd) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95740 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08Improve 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> (cherry picked from commit e04a83713f38be33d0c51cc35d0c457919a3f213) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95739 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit e10bfae45bc138b0c2351a7cb6bd3cc591bea388) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95738 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08Correct 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> (cherry picked from commit a85505fe14d6f677e10e1b1d08ca28ccac0d126c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95737 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 79dfc48af63b0834aee096c65f92f1bc96fc1b6c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95736 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 427ff3dd99a459af6a3f911ad5b23f94d91b4a62) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95735 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 57145b91d3e06b07d714e65e00d9e19626dbca52) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95734 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95733 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 4b4e25cad5a6971b1be4f077bbe42fd08366b4fd) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95732 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 5dd2cc30687d259990a9882d1c0874993fb60747) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95731 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 16b1c5d9c3ead98647e6cc816a9b81e39be48ca5) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95729 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit cf09e34b35c8f0803ecfb5151bdbf1a1cf1ccc68) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95728 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 6a31cba2f22a5a7cf60c1590b1189423fed285b3) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95727 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit cae5dda033a7b19ecdb37a8abc571f31a5b798d4) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95726 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit f35181a3fb8f5db8ac323ec7537d64e693546420) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95725 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 1637dffb6225234b599ee586c796fd6924aecf8a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95724 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 2d5a11ff0c0ce386c2e6e634b620448d9e0e4824) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95723 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit e02854641f31d183f6405f9ea7ad03ff0c7a4007) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95722 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 560fefa866227fbdfdae1e99a0761052686e5660) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95721 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 9d29678214cb17a3aafbb6c0f31af950b3c9429e) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95720 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit c3154e19796f918beced9b8a4bc3131c97b2b2a5) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95719 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit d05d21b99076ad1b3f1fec00058966ecc4ffd179) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95718 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 980d7730dbc2275d80fd059f58db56d37a225247) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95717 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 4bafa9e1d40f614b8d23637ce7fe49c0460f6553) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95716 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 69ce0305af2d911457274e4889334b335640c5da) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95715 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 5f22c5046e8a89d22d186052bc99e605c48c48b1) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95714 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 1a010a1c18a0d992afd907efc201f04f799f9c4a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95713 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit 8e5429d50be89dc929cb2e03f339e837481abc9a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95712 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit a93fb9c93b1d78caeae85847a7eae0139ead5384) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95711 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit c6213b839442ecafd54eb6396e63b058a00af376) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95710 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08(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> (cherry picked from commit fc04f3ae3696e577404e675af3967b9caad49f30) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95689 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08Minor 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> (cherry picked from commit e1cf49b4cfcb8f14fdb67d7ca879c25b1b8ca073) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95688 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08Minor 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> (cherry picked from commit 184c50cd4da27926f185e1fc79f6e6fcd9a10cc6) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95687 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-06-08Update 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> (cherry picked from commit 98cb0fc30637973a7ff8d15b86ec22a34a813c5a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95686 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-05-28tdf#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> (cherry picked from commit 7e39048579d0049c19299c1e31a2878e21e218ec) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94967 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.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>
2020-05-26Add square brackets around final parameter in syntax statement (to indicate ↵Steve Fanning
parameter is optional) Change-Id: I9c60cc607f157114da48e5369866adf68394dcf4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94837 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 parametes are optional) Change-Id: I756376f90b8c9f51875ad1887142a82c6595daed Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94836 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-26Add square brackets around final parameter in syntax definition (to indicate ↵Steve Fanning
that the parameter is optional) Change-Id: If2e6489a28c7429b8c638c9bcdc6cc28ff3d8078 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94834 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: I6ef58dab8926eb739b7477493ce228e43606124c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94833 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-24tdf#132643 Translate German section IDsJohnny_M
Change-Id: I5b65497ca615ca736a6426940e190da777221482 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94750 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-24tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ie9752e22b0ce3688df3bb9731a1056fb19e73ffe Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94752 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>