summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060110.xhp
AgeCommit message (Collapse)Author
2022-12-07tdf#152323 drop name attribute from <link> elementsIlmari Lauhakangas
Replacement done with find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \ 's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g' (note some inconsistencies with space between name and = and also having empty value, and some more complicated expression to also clear up double space before/after the attribute) translation files will be prepped with: find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \ $'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/' (note that not all languages use the " as quote character for the attributes, but that also single quotes appera in the po file. Hence the use of the shell $'string' syntax to be able to quote ' as \' It also requires to quote the backslash, so that it needs to be escaped once for the shell, then another time for perl. Also don't work on obsolete strings (those are prefixed with #~ in the po files) Also note that <link..></link> gets turned into <link ../> during translation extraction (along with removal of the space between the attribute name and the value), so the pattern needs to be slightly different here) Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713 Tested-by: Jenkins Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2022-07-19Fundamental confusion: *“Beware that” → “Be aware that”Adolfo Jayme Barrientos
Change-Id: I7f6b830a87bbdf2380c32d515554cb9836b50848 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/137211 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-22Numeral systems are "based" on digits, not numbers nor charactersMike Kaganski
Change-Id: I9c411fe39e81d734d68c9e98253b3d125978f3bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136239 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2022-06-22Drop this nonsenseMike Kaganski
Phrases like this look like an explanation form a clueless person. The help should rely on basics (like differentiating text from names), and not suggest to "place the number in quotation marks" when the argument is documented to be a text. If needed, the word "text" may link to a glossary article with syntax explanation. Change-Id: I32e7a3c68659f74db6bc30c5a3fa9acdd158acb4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136238 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2022-06-21tdf#149393 cross-ref DECIMAL <-> BASE functionsOlivier Hallot
Change-Id: I5f8a2e5d93ca0d723a6adfc31aa6cd3fcc7568c5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136085 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-15Fix some function descriptionsMike Kaganski
Change-Id: I85bd929ab1febed3f1567a911ee188e134afe847 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135876 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2022-01-01tdf#94537 COM.MICROSOFT.* namespace informationOlivier Hallot
+ Covered all COM.MICROSOFT namespace of wiki page in the bug report. + refactor of other info such as release number availability. + Muted l10N in a table and drop duplication. Change-Id: Id77f9657f164193d5e672e9edf82a2170b5f4040 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127817 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2021-11-24tdf#143846 Separate help pages for ASC/JIS text functionsRafael Lima
Change-Id: I9b5ae9b14ea98fe9edbf84a433ad4b7ed3bfcf39 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125720 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-10-21Related tdf#143846 Improve Arabic/Roman help pagesRafael Lima
Change-Id: I4be244dba35f137c1b7d356aab658c5e08604e51 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123523 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-17Improve VALUE function help pageRafael Lima
The help page for the VALUE function is created as a separate help page func_value.xhp. This patch also refactors related help pages NUMBERVALUE, DATEVALUE and TIMEVALUE. Their main header was <h2> instead of <h1>. Change-Id: Ic67893f0c35a58a19f13af1d34d68956e901a4a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/120361 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-07-15Delete erroneous statement from help description of Calc's REPT function.Steve Fanning
Change-Id: I5958f787798d309a7896ac47e1caa5eeeefbef96 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118926 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-07-13Improve NUMBERVALUE help pageRafael Lima
This patch improves the help page by adding some of the new contents available in the Wiki: https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE Change-Id: Icf21b924973d7e12a67e11c3c213765a3a06c0fc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118494 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-07-07tdf#143229 Remove empty paragraphsRafael Lima
Change-Id: I4dbb2eb2cfbb140a129c02290642a777c8f9f327 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118496 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-07-02Fix minor typos in help descriptions of Calc's text functions.Steve Fanning
(a) Added equals sign before examples given for MIDB function, for consistency with other help topics. (b) Added statement of default value for Number argument of RIGHT and RIGHTB functions. Change-Id: I6de1b35ce1e78e4403f957bb32878f40598a7269 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118252 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-06-29MinorAdolfo Jayme Barrientos
Change-Id: I8784fd6f43f5568db739e50a421bfff8184fd5d3
2021-06-28Fix minor typos in help examples for Calc's LEFTB function.Steve Fanning
Change-Id: I5d8cdf1898f9b5823acc1e3381bbe3abb06551e3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118052 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-06-23Document how to escape double quotes in help for Calc's text functions ↵Steve Fanning
(TDF#113976) Change-Id: I14c4afc919343dda2e1f30c49c69f434cf1104f1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117717 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-06-19tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ib0b47a24b5a00817c362a00c2d012e2f016c48a9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117494 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-31Clarify example in help description of Calc's DOLLAR function.Steve Fanning
Change-Id: Iab2333cbd98bd4bb13ba35a07d4dbcd66fc840a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116166 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-21Add example to help description for Calc's CLEAN function.Steve Fanning
Change-Id: Iae7a1f0b8b84be33f5f54a9a7116c0c48670f917 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115833 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-15tdf#132643 Translate German section IDsJohnny_M
Change-Id: Iab660ef9810902be11dd51c830e1a6f537352427 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115649 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-09Fix =FIXED() exampleOlivier Hallot
Change-Id: I45a820aa6967756e9554aeec7c2c7ee7437a11df Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115211 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-04-15Fix sort order of Calc functionsOlivier Hallot
Change-Id: I8237b0d52b8b0f29fc35196d34648ed7b51669d1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114113 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-04-01tdf#140553 =FIXED documentationAlain Romedenne
Change-Id: Id1326425a51e9c687c322e61a17d47ab9072eb4d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113364 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
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-03-26tdf#131361 Adjust number of function parameters (3)Steve Fanning
Fix for STDEV, STDEV.P, STDEV.S, STDEVA, STDEVP, STDEVPA, VAR, VAR.P, VAR.S, VARA, VARP, VARPA, AND, OR, XOR, SUMPRODUCT, CONCATENATE Change-Id: I869f6d7fc687e645b9ee8c0ca36ff690c4108db3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91103 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-26Clarify TEXT spreadsheet function's first parameter (not only number)Mike Kaganski
Change-Id: Icf5c8a6ff2fe5f9238afdb9c35e22eb91937f778 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91106 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2020-03-20tdf#131361 Correct param's GCD, LCM, PRODUCTSteve Fanning
- Also re-label sections to a better mnemonic id's Change-Id: I7b54216891116e9e9bb515d20218955b3d92fff9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90848 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-18tdf#131360,tdf#131361 (part) 256 argumentsOlivier Hallot
- update argument limit from 30 to 256 - create embeddedable text reusable for many functions listed in tdf#131360 and tdf#131261 when arguments are strings, integes, numbers, logicals, complex and references - with reduced translation job - fixes CONCAT, TEXTJOIN and CONCATENATE with String arguments. Change-Id: I8a32914c5ef31d796a21cf2ee705b92de7b58f90 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90613 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-11-12Add FINDB, SEARCHB and REPLACEB Help pageslibreoffice-6-4-branch-pointOlivier Hallot
Change-Id: Ie8a7c5762f41484d36837008226cc446584e3110 Reviewed-on: https://gerrit.libreoffice.org/82481 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-11-08tdf#128503 Clarify numeric x regex conversionOlivier Hallot
+ refactoring headings Patch set 2 - reposition comment on regex vs. numberex - included in ref for regex, aka "regulaer" and available for all functions with search criteria - Rephrased regexnumex. Patch set 3 -Fix to comply w/ DTD Change-Id: I3f5a488bb05b5ea61709e574ca5d859634158bc4 Reviewed-on: https://gerrit.libreoffice.org/82094 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-27tdf#123803 Add release info in Calc functionsOlivier Hallot
Change-Id: I0476c79fe5407c3e7252ef16da4110a026b29fa8 Note: some Calc functions still lack help pages. Reviewed-on: https://gerrit.libreoffice.org/71331 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-26tdf#120927 Webservice functions needs linking toOlivier Hallot
Change-Id: I8d96025238fc2005dab37c1050a0c7915210d73a Reviewed-on: https://gerrit.libreoffice.org/64055 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-16tdf#121084 Help page for Calc REGEX functionOlivier Hallot
* honor DTD * follow erAck advise Change-Id: Ib911888fbc5aae9c4a749c9343218081df9f6783 Reviewed-on: https://gerrit.libreoffice.org/63430 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-10-02Reduce L10N workload for repetitive stringsOlivier Hallot
Change 'Syntax' and 'Examples' heading into an embedded string translated only once. Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d Reviewed-on: https://gerrit.libreoffice.org/61143 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-22SEARCH spreadsheet function returns error when text not foundMike Kaganski
... as per OASIS ODF OpenFormula specification: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018874_715980110 Change-Id: I16b81de40dcc4b103e44cc1e3784eea830bf8ffa Reviewed-on: https://gerrit.libreoffice.org/60891 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-07Mention custom format codes for Calc's TEXT() functionMike Kaganski
Change-Id: I29271e2f555cbc231b616e75b43b37775143feae Reviewed-on: https://gerrit.libreoffice.org/59984 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-04-16replace http links with https equivalentsdennisroczek
* mainly http://wiki.documentfoundation.org * http://en.wikipedia.org * http://api.libreoffice.org Change-Id: I3587d8d5e6a6de4a7c7013920b9e135e4adc977c Reviewed-on: https://gerrit.libreoffice.org/52354 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-10-24Better example of TRIM()Olivier Hallot
After translator suggestion (mbalabanov) Change-Id: I7d39b3ec1826c199e56cf31352782ab9295b31e8 Reviewed-on: https://gerrit.libreoffice.org/43762 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-05-08Make wording clearerIlmari Lauhakangas
Change-Id: I5423b72f9f612749ca4dc92c4740915c4c6d0597 Reviewed-on: https://gerrit.libreoffice.org/37299 Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de> Tested-by: Katarina Behrens <Katarina.Behrens@cib.de>
2017-05-03tdf#103457 link UNICODE() to UNICHAR() in HelpOlivier Hallot
Change-Id: I80f7bdf22dc302b8bb8cab1cd278b06989a14f6b Reviewed-on: https://gerrit.libreoffice.org/37181 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-09-27Improved topic relations for a selected set of pagesJohnny_M
Following pages are affected by this update: 1. "Functions by Category" (https://help.libreoffice.org/Calc/Functions_by_Category): - Added a variable to its heading, so that it can be referenced from other places - Removed self-referece in its "Related Topics" (it was turned into the above heading reference instead, thereby also correcting the remote HTTP page reference to local help file referece). Note: Pages already using the reference will auto-ajust (e.g. "Related Topics" of https://help.libreoffice.org/Calc/Statistical_Functions_Part_One) - Corrected "Operators" reference location by moving it into "Related Topics" 2. "Statistics Functions" (https://help.libreoffice.org/Calc/Statistics_Functions): - Added a variable to its heading, so that it can be referenced from other places (point 6 below) - Cleaned up references by adding a "Related Topics" section - Using links to heading variables in "Related Topics", for improved heading string consistency 3. "Text Functions" (https://help.libreoffice.org/Calc/Text_Functions): - Added a variable to its heading, so that it can be referenced from other places (point 5 below) 4. "Add-in Functions" (https://help.libreoffice.org/Calc/Add-in_Functions): - Added a variable to its heading, so that it can be referenced from other places (points 5 and 6 below) 5. "Add-in Functions, List of Analysis Functions Part One": - Added a variable to its heading, so that it can be referenced from other places (point 6 below) - Moved "Related Topics" chapter to the bottom of the page - Using links to heading variables in "Related Topics", for improved heading string consistency 6. "Add-in Functions, List of Analysis Functions Part Two": - Added a variable to its heading, so that it can be referenced from other places (points 2 and 5 above) - Moved "Related Topics" chapter to the bottom of the page - Using links to heading variables in "Related Topics", for improved heading string consistency The updated pages were tested as described in https://wiki.documentfoundation.org/HelpContent#Without_the_LibreOffice_Core_Repo on 32-bit Debian Linux with: Version: 5.3.0.0.alpha0+ Build ID: d15082cac2306fb9562ff126eb5827b7b9eee1e1 CPU Threads: 2; OS Version: Linux 4.6; UI Render: default; TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:master, Time: 2016-09-19_05:41:30 Locale: en-US (en_US.UTF-8); Calc: group Change-Id: Icbb3725fd16d3ff76e5e4244c2284349332cffb7 Reviewed-on: https://gerrit.libreoffice.org/29306 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2015-02-12add examples for functions dealing with DBCSStanislav Horacek
by Jesper Hertel (jesper.hertel@gmail.com) see http://listarchives.libreoffice.org/global/l10n/msg08594.html Change-Id: I2c281aab12ba9c10184658eff9837d39e397af09 Reviewed-on: https://gerrit.libreoffice.org/14092 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2014-06-30Fix fdo#80442, Calc DBCS functionsOlivier Hallot
write help pages for LEFTB, LENB, MIDB and RIGHTB spreadsheet functions working on DBCS Change-Id: I31e42712f8e8ccbc8ad5ef4f933fcb7974489aa5 Reviewed-on: https://gerrit.libreoffice.org/9970 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2013-12-08fix typo in example for TRIM functionStanislav Horacek
Change-Id: Id1bb170188f62d8f7d335d0797f2ffe027d16efe Reviewed-on: https://gerrit.libreoffice.org/6976 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com>
2013-09-17more illustrative example for TRIM functionStanislav Horacek
in old example function has no effect Change-Id: If0c0778d61569b37c091e6d1a3b96eea75b37285 Reviewed-on: https://gerrit.libreoffice.org/5928 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2012-12-13re-base on ALv2 code. Includes:Michael Meeks
Patch contributed by Oliver Rainer-Wittmann i#118572 - remove ui string and help content regarding usage of Java Mail in Writer's Mail Merge as Java Mail is not used. http://svn.apache.org/viewvc?view=revision&revision=1197035 Patches contributed by Herbert Duerr updated help text for regexp word boundaries http://svn.apache.org/viewvc?view=revision&revision=1228026 improved help text for word boundary regexp expression \b http://svn.apache.org/viewvc?view=revision&revision=1234738 Patches contributed by Jurgen Schmidt remove onlineregistration with dependencies http://svn.apache.org/viewvc?view=revision&revision=1240245 Patch contributed by Regina Henschel Extended tips for corner and cap style http://svn.apache.org/viewvc?view=revision&revision=1242287 * re-enable on-line update help, remove obsolete on-line purchasing.
2012-10-16move help structure one directory upNorbert Thiebaud
Change-Id: Ie970e39fbb6795a92d9fdd13510409d7dcd071bc
generated by cgit (git 2.34.1) at 2025-02-02 23:54:47 +0000