summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2023-10-08add a bookmark to Calc's Page Style page - COOL looks for thiscp-23.05.5-4cp-23.05.5-3cp-23.05.5-2cp-23.05.5-1Andras Timar
Change-Id: I74f42cc2e19761c380dde43c725d18ab482ef603
2023-07-08Mute l10n or string.Olivier Hallot
Change-Id: I1ecfc8a5bf6b64060a92be1a48cd0cf877671236 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148866 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> (cherry picked from commit bb8d72b1f2339d1f5df72ae49f4bd93f7d53c02c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148867
2023-02-14[cp] Revert the .xhp parts of "Deploy videos in New Help (WIP)"Jan Holesovsky
Partially reverts commit 93ebf037016819613322ef1c39951a3de893ec14. Change-Id: I21224f97e9c47d5dfeb8e000102237a5664d3d41
2022-12-07Add a note to the STYLE() function to not use it without reason..Eike Rathke
Change-Id: I74b30b58bdfbc5a4392f344a2de8a600b2eca030 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143804 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
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-12-06Fix typoOlivier Hallot
Change-Id: Ie6f0171043ce7f0efc3db60e1b9aab7f4c3a75c2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143716 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-28Adjust using label names to realityEike Rathke
Escaping a single quote with a backslash (\') was always wrong, and meanwhile the finding labels automatically feature was deactivated per default long time ago. Change-Id: I58057c36d1b7a23c60670e1972608a6b86ca7a07 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143415 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2022-11-27tdf#152162: link from Conditional Formatting help to (Cell) Styles helpStéphane Guillou
Change-Id: Ieaf4f4026ab29de490373946ff5a4428242b5dba Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143160 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-22replace "Function" string with correct button name "Formula"Stéphane Guillou
Change-Id: I1abb41a4677e570b2224a2841b699220d3dc7f03 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142929 Tested-by: Jenkins Tested-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2022-11-15Fix contents after translation reviewOlivier Hallot
Thanks to @lyzbet Change-Id: I8fc33fbe954e1467dac010cb6b7a253d92513568 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142682 Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-12tdf#152011 Improve View menu descriptionBogdan B
Change-Id: I36e11dde9ca5398f9f9bb5c6600cb300380ac114 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142626 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-12tdf#152011 Change "open" to "create" for a new documentBogdan B
Change-Id: If5e5476465baa225a54448a6bccfebef30fd3f05 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142624 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-12tdf#89358 Example of implicit intersection for array formulasOlivier Hallot
Change-Id: I6cb1b66a34f8bd95472e78dac03f8860c2cdd375 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142605 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-11tdf#150607 Change Truncate to RoundBogdan B
Change-Id: If37b518f0aebc8b5d7fb6eb4cd889c86f1ba14d2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142525 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2022-11-07tdf#149991 Replace Page with Page StyleBogdan B
Change-Id: I4d7a5178180aa49ca16c569b1c2a90bd248bedc5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142299 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-11-05tdf#151908: An error has crept into the documentation of SUMIF()Julien Nabet
Change-Id: Ifbaab9ecc270db4f70c6b4937c30c7d88f0547d4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142296 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-11-03tdf#134882 Improve help about changing label from 'fit' to 'shrink'Bogdan B
Change-Id: Ie7759eea6991defbbb785b7426cddde7f1cebdc2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142146 Tested-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Tested-by: Jenkins
2022-10-20Typo grab bagAdolfo Jayme Barrientos
Change-Id: I5065a95400934026fb8a52dbeb72793c66b8caf5
2022-10-11Turn conditional formatting help pages more friendlyOlivier Hallot
Change-Id: I6511663d80942720c5b9f1053e611f1f5209968c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141159 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-22TRUE/FALSE are functionsMike Kaganski
Samples using them as constants simply don't work Change-Id: I1cc6199fa418363b3176dd3c2f18d9cc6620957a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140385 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2022-09-19tdf#119421 Add sample files for conditional formattingOlivier Hallot
Change-Id: Id5826f32bd2de2e286eecf57dc817f4b60a2599b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140196 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-19tdf#119421 Enchancements to Conditional Format pagesOlivier Hallot
Add icons and how-to-get Change-Id: I1fb78ac737bc37745ee76d4508116edadd283938 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140130 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-18tdf#119421 Add details on conditional formatting data barsOlivier Hallot
Change-Id: I1215e909e73dfd9707299ed98f794eea689423d9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140111 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-17tdf119421 - More on conditional formatting/Icon setsOlivier Hallot
+ Housekeeping + handle icon images in the XSLT + Fill missing information on Icon Sets. Change-Id: Iaab3e1231ad4a2212adfc1d353a593cc116c7978 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140108 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-17Unclutter table in Conditional Format Help pageOlivier Hallot
Change-Id: Ia5b12237e4be3e674701ace0194994faa2a8b69d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140094 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-17Fix typoAndrea Gelmini
Change-Id: I599ef997dd6819c0d08e69afdac206a4c5da55f4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139820 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-12tdf#119421 Refactor conditional formatting Help pagesOlivier Hallot
* Still work to be done with other CF pages floating around * Strucutred the entry page for the CF dialog * Split conditions descriptions into sub-pages Many thanks to Roman Kuznetsov for the inputs. Change-Id: I5a9d91ab34febc127eb7dc762258428629ec5477 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139783 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-12Fix How to get section in pageOlivier Hallot
Change-Id: I2c17bdabd1e21dde126e98f254324832eea2dbd6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139784 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-09-10Remove blank and period nonsense in defined namesEike Rathke
Change-Id: I759474b9cfae8a02519108cad98863c5caac7507 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139752 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
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-28tdf#137649 Fix LOGNORM.INV optional argumentsOlivier Hallot
Change-Id: Ia239d14508c1bb6e86d3d4b1d67f50de0fdb5afc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136498 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-27tdf#149218 Add pivot table formatting help pageOlivier Hallot
Change-Id: I807b0e62998bac85cf0cf348d57cb1f99b1dc742 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136411 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-24Fix typoAndrea Gelmini
Change-Id: I7c898cbd8890c82c3ebcb0d3d0d4d22096b6f1d4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136400 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-24Fix (BIN|OCT|DEC|HEX)2(BIN|OCT|DEC|HEX) to mention string argumentsMike Kaganski
... and return types, and also fix the conceptually incorrect examples Change-Id: I9953d546c0c6ee8f224b866643f6975e538f44f5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136378 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.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-19tdf#149301 Update Navigator terminologyOlivier Hallot
+ Refactor, simplification of <switch> + Removed duplicated hid bookmark for Contents + Update icons and <alt> text + added some of the comments of tdf#178755 Change-Id: Ifaba80d212828e47d99275a9b0a1681eb3bc3430 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136105 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-19Update tdf#129679Laurent Balland
Remove Apache license as it is a new file Add some details. Change-Id: I9cf2b707d32772017ab56f093115419ca020398a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136106 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-06-11Add info on sparkline custom vertical max/minOlivier Hallot
Change-Id: I5e87f7036eb34b1d5cbd0c635b319417981a16b3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135639 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-11Relates tdf#36466 - Update help about copying visible cells onlyDietrich Schulten
Change-Id: Ia33f942232b73aaad53bb34a5e02b4c457a0d8bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135541 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-08Fix sentence about solver settingsRafael Lima
As pointed out by Adolfo in change 40ee3181de08d372b5a25bb691644a94d3ffe9bd, the word "beware" was used incorrectly. This patch fixes it. Change-Id: I3b2dd94b04b9c9c5ca5dc9c0b4c99a8e1c048941 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135384 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-07Related tdf#38948 Warn that Calc Solver does not save model to fileRafael Lima
Based on Comment 36 from bug 38948, the help should make it clearer that Solver models are not saved to the file by LO Calc. This patch changes the current <note> into a <warning> and makes it clearer that solver settings are not saved. Change-Id: Ie1cdf5a82c105c371e05b85ccad6736ed5e74a3f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135272 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-07Include metacharacters fragment in ICU regexp URIEike Rathke
So it leads to Regular Expression Metacharacters instead of just the page that starts with all sort of developer information not relevant to users. Change-Id: Id1efca75302d023a83b45a4bc81654ffe8c2980f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135471 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2022-06-06tdf#148817 Sparklines Help page.Olivier Hallot
+ add bookmark entry + update Calc Insert menu help page Change-Id: I76315d7c35a2a98731ef92d9090ebcba41f9e004 Co-authored-by: Tomaž Vajngerl <quikee@gmail.com> Co-authored-by: Roman Kuznetsov <antilibreoffice@gmail.com> Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135324 Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-02tdf#129674 Add index bookmarkOlivier Hallot
+ refactor help page Change-Id: I236737649aa20019db33b10e107cba15a20db342 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135305 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-02Fix broken links in CEILING functions help pageOlivier Hallot
Address comments from https://gerrit.libreoffice.org/c/help/+/92097 Change-Id: Id4ad0b4ed3d609f9e1ddb2482afd00f318d813bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135306 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-02tdf#129674 New command Go to SheetLaurent BP
Add help to "Go to Sheet" dialog Change-Id: Iede0523d0272b32b9b87489129bca0136d601a65 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/134951 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-04-05Minor string fixesAdolfo Jayme Barrientos
Change-Id: If1f76eacb11216a0b647948e956c7c99711f4c35
generated by cgit (git 2.34.1) at 2025-03-19 07:23:11 +0000