summaryrefslogtreecommitdiff
path: root/AllLangHelp_scalc.mk
AgeCommit message (Collapse)Author
2024-06-07tdf161442 Help page for Calc LET functionOlivier Hallot
Change-Id: I81a5304786f626eaf7b556bb5faf6fa90f2eab34 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168508 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-03-23#tdf120179 Rewrite SUMIF Help PageDione Maddern
Created a new file named text/scalc/01/func_sumif.xhp. This file includes updated help information for the SUMIF function, including a more precise definitiion of and more detailed examples. Added the new file text/scalc/01/func_sumif.xhp to AllLangHelp_scalc.mk so that it will be included in the Help application. Replaced the content in text/scalc/01/04060106#Section15 ("SUMIF") with an embed link to the new text/scalc/01/func_sumif.xhp, so that only the definition and a link to the main SUMIF Function page appears in the list of Mathematical Functions. Updated the "Related Topics" sections of text/scalc/01/func_sum.xhp and text/scalc/01/func_sumifs.xhp so that they link to the new SUMIF Function page. Change-Id: I224dffb0c3c6411ea416bba308559f9fe3896dd2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165186 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-26tdf#159872 Prepare Help page for RANDARRAY functionOlivier Hallot
Contents will be added upon tdf#126573 Change-Id: I54fed6b04b87f1dd5d9d7f344c022dd31a57b680 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163894 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-26tdf#159872 Prepare Help page for SEQUENCE functionOlivier Hallot
Contents will be added upon tdf#126573 Change-Id: Ifa8a0e984d4118aaa7b14e6e4a9cfe8c71023ef2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163893 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-26tdf#159872 Prepare Help page for SORTBY, UNIQUE functionsOlivier Hallot
Contents will be added upon tdf#126573 Change-Id: I93fd31c6bf3764a09921642cc245e8e51c1b6959 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163892 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-26tdf#159872 Prepare Help page for SORT functionOlivier Hallot
Contents will be added upon tdf#126573 Change-Id: Ifcc953b22d44139b9dcb003971fc9fd3d43aa8f5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163891 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-26tdf#159872 Prepare Help page for FILTER functionOlivier Hallot
Contents will be added upon tdf#126573 Change-Id: Ia488f8f855f19cef2f15f1004ff5719309576d8b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163890 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-19tdf#159771 Add XMATCH help pageOlivier Hallot
Change-Id: Ieb8d83a73c6a598614ed5ac76004915fc6cf6de7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163603 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-19tdf#159596 Help page for XLOOKUP functionOlivier Hallot
+ Added new entries for release numbers + refactoring of some other files Change-Id: I125fc35f1a38599e68857ad0959a5d3777a0a63e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163602 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-02-14Remove text/scalc/01/02120000.xhp because it has been superseded by ↵Dione Maddern
text/shared/01/05040300.xhp. Change-Id: I1e38debd8a4a3148bf2f7184544d6208e8eb189b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163346 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-01-22tdf#159111 add .uno:PickList to HelpOlivier Hallot
+ File menu command is now .uno:PickList and not .uno:FileMenu anymore + .uno:PickList is common to all modules + Refactor file menu into one Help page, with module switch + Adjust tree + remove old file menus help page main0101.xhp Change-Id: I7fc9d07fdcca1d4a3062e656f81a0bafd6bafa44 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/162415 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-12-19tdf#155876 UI cmds Calc-Sheet menu (34)Olivier Hallot
+ Sheet menu for Calc, end + refactoring Change-Id: Iddbd6f37722ea6eb020431cecf42966ffee703ba Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160959 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-12-19tdf#155876 UI cmds Calc-Sheet menu (33)Olivier Hallot
+ Sheet menu for Calc: manage Comments submenu + untangle Calc comments from Writer + refactoring Change-Id: I22b8e79b96d72b8918da04bc802cdd29c5d9dba0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160958 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-12-16tdf#155876 UI cmds Calc-Sheet menu (32)Olivier Hallot
+ Sheet menu for Calc: manage Names + untangle manage names and define names + refactoring Change-Id: I27fe448ae251cb98a829e92c307fc31ad3b2c967 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160845 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-12-13tdf#155876 UI cmds Calc-Sheet menu (30)Olivier Hallot
+ Sheet menu for Calc: clear cells, references, fill + refactoring Change-Id: I0c0c10af4a9983e893907aa5c0a491b5814dae22 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160657 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-12-13tdf#155876 UI cmds Calc-Sheet menu (29)Olivier Hallot
+ Sheet menu for Calc, insert sheets, external links + refactoring Change-Id: I79838e7b1f25240a2a0932138c2cd62e70feea6d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160656 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-12-03tdf#155876 UI cmds Calc-Format menu (24)Olivier Hallot
+ Sparklines and more + refactoring Change-Id: Ie320018d7c3cf13d25bed7f6d7b6af4b2c9f9b26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160251 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-11-01tdf#155876 UI cmds Calc-Insert menu (17)Olivier Hallot
+ refactoring of Insert Field menu Change-Id: I72dcab2a45ddfe78025ceba699aa8b1428d4bdb4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158772 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-11-01tdf#155876 UI cmds Calc-Insert menu (16)Olivier Hallot
+ refactoring of Insert Date and time Change-Id: I95db763eb928d683b501cc35b06150cf5f061306 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158770 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-10-29tdf#155876 UI cmds Calc-View menu (08)Olivier Hallot
+ refactoring Change-Id: I0f8fa1f36ff535fd21dd0aaab468b122c359c5fc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158595 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-10-27tdf#155876 UI cmds Calc-View menu (07)Olivier Hallot
+ refactoring Change-Id: I766345780bb12a3ba9d9c8c3135f77d4d04bc78d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158519 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-10-27tdf#155876 UI cmds Calc-View menu (06)Olivier Hallot
+ refactoring Change-Id: Ic6a1cf590f8952ef82e540459603a0a499732ecf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158518 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-10-17tdf#155876 UI cmds Calc (04)Olivier Hallot
+ refactoring + Edit - cell edit mode Change-Id: I43bcbd6f0467f0e923450a3b74b197b7166db15c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158095 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-10-17tdf#155876 UI cmds Calc (03)Olivier Hallot
+ refactoring + Edit - Select menu and commands Change-Id: I2c1e7c37cf40184391f04c29b0b6f49f43bef0e5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158087 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-09-29Housekeeping navigation of Tools menuOlivier Hallot
tdf#155875 tdf#155876 tdf#155877 tdf#155878 Change-Id: I899bb3c5d91645381a868fb8184dba045022a118 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/157392 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-09-08tdf#155875 UI cmds Writer/Table in Help(35)Olivier Hallot
+ refactoring + Table - AutoFormat Styles (part 35) + uno:AutoFormat refers to similar dialogs in Calc and Writer + but each on its module + merged in shared/01/AutoFormat.xhp with app switch + removed obsolete files (merged) Change-Id: I9324c517f19934027311c297d012397650b60cf4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/156685 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-09-08tdf#155875 UI cmds Writer/Table in Help(34)Olivier Hallot
+ refactoring + Table - Protection (part 34) + protection is called by "uno.Protect" in menus + in Calc: protect sheet dialog + in Writer: protect cell directly + merged in shared/01/Protect.xhp with app switch + removed obsolete files Change-Id: Ieada8a774a14a19f79f58e22fd807bf5aacaf64b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/156678 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-09-06tdf#155875 UI cmds Writer/Table in Help(32)Olivier Hallot
+ refactoring + Table - merge menu (part 32) + includes Calc merge cells + Some pages will be revisited Change-Id: Ic6ebfedd363421ab33ad325609f2427cc2043998 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/156618 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-09-06tdf#155875 UI cmds Writer/Table in Help(31)Olivier Hallot
+ refactoring + Table - Size menu (part 31) + Merges optimal row/height into shared file + delete obsolete help pages + delete pages with no HID (obsolete) + Some pages will be revisited Change-Id: I06593f96f3953f0de43a290a956acab94af09b34 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/156584 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-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-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-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-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>
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-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-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 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-03-15tdf#147977 Add Share Spreadsheet help pageOlivier Hallot
Change-Id: Ic4d77dd4b33d3e0bd74c48a195a3d97b2ad647e4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131553 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-02-23tdf#145898 Formula to Value and Recalculate HardOlivier Hallot
Review of the Data - Calculate submenu - Added Recalculate Hard page - Added Formula to value page - Links and embed for navigation - Some precisions regarding non-volatile functions Change-Id: Ic39b61feb851b9cc7c8cb2ae6907651a64a81a6e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/130180 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2022-01-31tdf#67026 Limitation of Calc precision documentedOlivier Hallot
Contents borrowed from M. Kaganski FAQ page at https://wiki.documentfoundation.org/Faq/Calc/Accuracy Change-Id: I89ba43c78d10ed4671b66ba0acc7df2e9947783a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128359 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-19tdf#145332 Improve help pages for TRUNC and ROUNDDOWNRafael Lima
Since TRUNC and ROUNDDOWN perform the same function, the help pages are now more consistent. The help pages were created in separate files. Change-Id: I68092c61f2cb80c66e798c188d9c4172de5d48c0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128244 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
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-11-09Improve Example section of help description for Calc's SUM() functionSteve Fanning
The ability to use SUM in an array formula is important but the help description of an example array formula is uncharacteristically long. Now that the wiki has a more specific example, it is appropriate to shorten the Example section of this help topic. Also moved SUM description to its own XHP file. Change-Id: Ic062686c53a1ae8b81100e2b49781aaa79e6ee50 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124696 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> 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-10-01tdf#33749 - revised help text for merge and split in CalcRoss Johnson
The earlier change (reverted) overlooked the difference between "Merge Cells" and "Merge and Center Cells", leaving users without adequate means to merge cells while retaining text alignment. This patch restores previous usability and moves forward to resolve the issues raised in this bug report. Reverted the two changes from earlier work on tdf#33749: 1) Cell context menu back to 7.2 2) Format - Merge Cells menu back to 7.2 3) Help pages to reflect that Moving forward with the following changes: 1) Rename "Split Cells" to "Unmerge Cells" (Calc only) 2) Add "Merge Cells" and "Unmerge Cells" to the Formatting toolbar alongside "Merge and Center Cells". 3) Re-label the Format - Merge Cells menu to Format - Merge and Unmerge Cells. 4) Help pages to reflect core including fixing the duplicate entry in the built help/hid2file.js by consolidating the relevant Calc and Writer help pages together to remove the duplicate bookmark hid branch value. Removed the module specific version. 5) Removed duplicate entry from helpers/unocmds.txt. Change-Id: Ica50f507eea74acd430bef3042fb9739d1cff7b2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122810 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-27Create help page about how to Remove Duplicates in CalcRafael Lima
This patch creates a new "guide" page on how to remove Duplicate values in Calc. This is a question I see being frequently asked in forums and I could not find any entry in the Help that explained how this can be done. Change-Id: I6e115739752fdc1f5aa35cf45f041655b3e614be Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121067 Tested-by: Jenkins Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-18tdf#142574 Create help page on "wildcards"Rafael Lima
This patch creates the wildcards.xhp help page and makes the required adaptations in tree files to disambiguate "wildcards" and "regular expressions" in the help system. Change-Id: I82f1e192b6bf9e605fc3cfde50b648ce902cefdb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/120573 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
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-05-21tdf#141929 Improve CONVERT help and move to a separate fileRafael Lima
Updates the content of the CONVERT help page to better match the description in the wiki, focusing in unit measurement and prefix tables. Also moves the CONVERT help page to a separate file and removes it from the original location 04060116.xhp. Change-Id: I591ce3d2cd36e224daf5d00593418cba7832e574 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115209 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-01-25 02:08:02 +0000