summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2023-06-07Calc Sheet Tab Navigator help page fixOlivier Hallot
Change-Id: I1f26bcaaf01c7cf35c104978199a55796222bd61 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152700 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-25Add Sheet Events Help page, update command pathsOlivier Hallot
Change-Id: I90d0b82c143d467e48aed65bb422c0323875ece2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152285 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-25tdf#154996 Add tabbed UI commands in Help pageOlivier Hallot
+ refactoring Change-Id: I404321de45f8d4c4621a64d2f30a48421f65f86e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152249 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-25tdf#154996 Tabbed Interface command in Help pagesOlivier Hallot
+ review the Hide / Show sheet command Change-Id: I5dd3e9fe40f06c006282c1b62de38daadd01d2a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152248 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-24Fix typoAndrea Gelmini
Change-Id: I68cced3d3101be527beea717e828da418834f117 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152134 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-23Add missing fileOlivier Hallot
this must fix https://gerrit.libreoffice.org/c/help/+/152130 Change-Id: Ic7c418c5993429cc622aa9a61023be3a58bb6f3e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152159 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-22Calc Sheet Tab Navigator help pageOlivier Hallot
Change-Id: Ie79a7e1b6e3383d52660e48d145bec5ca7ca89af Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152130 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-22tdf#140091 Precisions for the (+) button in sheet tabs bar.Olivier Hallot
Change-Id: I6c125b5fa230690f598399b68e1f310f4cbc25d5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152129 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-18Fix typoOlivier Hallot
Change-Id: I11c8cfde4e8a53b541cea2ae165044fac11dcae7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151919 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-17Exclude file from indexingOlivier Hallot
This file is source for embeds and don't need to be indexed. Change-Id: I458da5804e7152bc5e684e356df5d62e8dbca9e3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151908 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-17Remove bad exampleOlivier Hallot
Change-Id: Ic6307c884458c0303f88d42e19b8a4f1c924c05b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151777 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-09Size in characters, not bytes; tdf#153574 follow-upEike Rathke
Change-Id: I67a23a18801d152579f521692550d22493e0cb24 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151577 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2023-05-08tdf#153574 Update error code Help pageOlivier Hallot
+ add #N/A error + removed 526 + updated 521, 504, 513, 514, 525, 538 + Change-Id: Ie1bf57cd8f13fb60e64d89c14a20bb2d8a04fb4a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151078 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-07ProofreadingAdolfo Jayme Barrientos
Change-Id: I314b97f7472ba5159ec7394e243991c2a3e08969
2023-05-03Include Date add-in functions in Date&Time Help pageOlivier Hallot
Change-Id: Icf4b9bb113b778b059928eb117d88084551ba6ac Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151341 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-03Refactor help page - no contents changeOlivier Hallot
Change-Id: Ib45b27e20c047b9c1b65251729a54dcac40e48ba Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151340 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-05-03tdf#155100 LibreOffice treats 1900 as a common year, not leapOlivier Hallot
Change-Id: Id8ab89baa623f04a49a307856ea063a2301a2ce3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151302 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2023-04-28tdf#139027 More on INDEX() functionOlivier Hallot
+ Review after erack comments Change-Id: Ibc294c35dd98cbd5c9f2b638db4e9cf31e768edd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151175 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2023-04-28Refactor page - no change in contentsOlivier Hallot
Change-Id: I5686fda46a1e572a6156b125f6dc9d11416af4d5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151174 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-04-26Refactor page - no content changeOlivier Hallot
Change-Id: I0f97c79e69234b52147c0812066f50f952705bd9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151077 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-04-26tdf#153547 Fix typoOlivier Hallot
+ Reference to comment #2 + Refactor of whole file Change-Id: I1c167c9ca1a0cf8e6d3f10ecb9da02eac9060ba3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151071 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-04-15tdf#132465 "Trim input range..." option on Calc's Moving Average dialogOlivier Hallot
Refers to tdf#99938 Change-Id: Ia8bac690c0090c7fedf635cdf6987cfc1e3c8cb2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/150424 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-04-15Refacter help file, no content changeOlivier Hallot
Trim xml-lang Change-Id: I86695d593cbd3d99dda1ad65ff13897cee5b3bd1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/150423 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-04-06tdf#154622: correct validity dropdown expand shortcut to Alt + DownStéphane Guillou
Change-Id: I44c8516ca808491187784dc5cf3e198b9facb843 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149991 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-27Related tdf#151309 Use t-test instead of T TestRafael Lima
As discussed in the ticket, we should use "t-test" instead of "T Test". A previous patch fixed the occurrences in the UI. This patch fixes this only occurrence in the help files. Actually the entire text uses "t-test" but the page title uses "T Test". So here I made the page title better match the title used in the heading <h1>. Change-Id: I50d8814af5d4f93568aca7e5c299d95664bdb582 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149607 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-26Fix XHP tagOlivier Hallot
Change-Id: I90f3290ba28baa88d8d60808234a3ed510d81d19 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149596 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-24Fix bad link for SUMIFOlivier Hallot
Change-Id: I8f7bfe2a4427c5465d8bd428fd58510cf90cca57 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149473 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-23Fix typoAndrea Gelmini
Change-Id: I53670595539d0c34ef6ce21f463cc19cd9c0f5ba Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149352 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-03-22tdf#139027 Help information for Calc's INDEX() functionOlivier Hallot
Change-Id: I23b4b923329ba6d2783d4a2f02d9e02d3786f708 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149179 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-16convert paragraphs with role="heading" & childelements to → h<level>Christian Lohmaier
and also drop the language that was changed to implied previously/defaults to en-US unless specified. This change doesn't affect translations, only the content of the paragraph/headings is extracted. done with: perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>.*?)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g' and manually undoing the one that uses <sup>in body that's not valid according to the dtd in the h tags. Change-Id: Ibd4aed3157ed168cd5005161575672a392e59202 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148797 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-16convert plain paragraphs with role="heading" → h<level>Christian Lohmaier
i.e. without child elements and also drop the language that was changed to implied in the dtd previously/defaults to en-US unless specified. This change doesn't affect translations, only the content of the paragraph/headings is extracted. done with: perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>[^<]+)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g' (all permutations re order of attributes, and xml-lang="en-US" being optional / implied) Change-Id: I365a2bb983a3969af9390753fce7b7f3597c7b8b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148795 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-14Mute 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>
2023-03-14Related tdf#145332 Fix sentence about TRUNC functionRafael Lima
As discussed in the original commit [1] the wording about the TRUNC function was incorrect. This patch fixes the sentence. [1] 6b1075e1e032be5bb6cba1dbdcc11de2a1824add Change-Id: Iec86eb4c881dbfbbb3e2020a7aedd6ff59bf0e61 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148767 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-14Related: tdf#154167 ERROR.TYPE() list both alias name and Err:... valueEike Rathke
Change-Id: Ice9252d0aba19719737d47090f426ee52a0eabc7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148882 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2023-03-14Related: tdf#154167 ERROR.TYPE(#NULL) is for Err:521Eike Rathke
Change-Id: Id30b59e13feac935fb5307f67bd5a5423b1e9fb0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148881 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2023-03-13Fix bad linkOlivier Hallot
Change-Id: I1943382ae49c3085e8619c1b2d99c7be3c76e35f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148786 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-12Remove wrong reference to ODFF.Olivier Hallot
Related to https://gerrit.libreoffice.org/c/help/+/127817 Change-Id: I8a3dd1bcd0481acfdf8e0faa794f8e0214f49b89 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148735 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-10TDF#153108 Calc Zoom Help PageAngelle Leger
* New help page by Angelle Leger * Refactoring by ohallot. Change-Id: I8c0d47414ec257b21d0f0369912147038d440d47 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148530 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-28Remove duplicate reference to wiki pagesOlivier Hallot
Change-Id: I645d4c5195e28ef54535bd70bb65277397fb5b77 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147963 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-28Fix "D'oh! you found a bug" in Help pageOlivier Hallot
Change-Id: I15d47f59bb75d6c4f31450d227b78d88a8b9b384 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147956 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-22Add links to wiki for Calc Functions (part)Olivier Hallot
Change-Id: I454e60818fb30d154653d7ba2d343f72dc2f8581 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147427 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-22Refactor headings of calc functions filesOlivier Hallot
* Adjust headings * reduce clutter of embeds (WIP) * Note: this patch should not trigger retranslation Change-Id: I4c87f59ebc1377ea4f487bcf0efc98f83caf64cb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147409 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-13Rename Extension Manager to ExtensionsAdolfo Jayme Barrientos
Follow-up to core commit ef3c81d0fca9c8f80fd0d4e4025c37a114528344 Change-Id: I904f88bd184fb4ea10eb050c21d40041494e2e33 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146952 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-01-29Update Autofilter help pageOlivier Hallot
+ Autofilter options were changed, the patch synchs with current menu + Missing bookmarks for filtering by color Change-Id: I96d5af98dd9c70bfd4e8c376891b67dbd5853767 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146299 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-01-27Remove support for AIXStephan Bergmann
This is a companion to <https://gerrit.libreoffice.org/c/core/+/146057> "Remove support for AIX". Change-Id: I705f7bf702e9080dd850518b492c8a7be7e325d5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146063 Tested-by: Jenkins Reviewed-by: Stephan Bergmann <sbergman@redhat.com>
2023-01-24tdf#118008 (part) Format menu updateOlivier Hallot
* Include align and number format menu entries * collected default number formats in one help file Change-Id: I01db0099ec0b4c421a717656ff3957f190501f53 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146094 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-01-11Adjust End and Shift+End shortcut description to realityEike Rathke
It's the last column with data in any row, not the last cell with data in the current row. Change-Id: Ib5e719ed6b50c2c5f2b48a8d4cad8bd9f52a3cac Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145355 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2023-01-11Fix typoAndrea Gelmini
Change-Id: I437e33f36455f4f9340051fe9d8a74d0f6d88d3e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145332 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-01-11Fix typoAndrea Gelmini
Change-Id: I63f80ef205f901313d4b2c5ec54d7d4864b3cddd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145331 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-01-11tdf#152412 Improve the STYLE function help pageRafael Lima
This patch creates a separate help page for the STYLE function and improves its text and examples. Change-Id: I3630fbc99ac822ea138f08283e92d88ffa4acaf8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145299 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-02-02 10:44:54 +0000