summaryrefslogtreecommitdiff
path: root/AllLangHelp_scalc.mk
AgeCommit message (Collapse)Author
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> (cherry picked from commit 0565c612d43abbbd3ad454843d59770349b82487) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160937
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> (cherry picked from commit afcd5a5df56c3d4ad3b265572ff1a343c4e4ba18) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160936
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> (cherry picked from commit 2a305eedde1c9f9e1ba4af534688b4f83ea814d8) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160854
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> (cherry picked from commit 4953ea62c3603c2c3f66faf67dac67ba987476c9) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160638
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> (cherry picked from commit dfd902c240c11e611732f1c26345869354a56ba6) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160637
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>
2021-02-03tdf#140111 Synch Help page w/ Calc View menuOlivier Hallot
Change-Id: I3e3d19f3ba3229843811528ce5376fea53795556 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110335 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-01-14tdf#139436 Add Help page for Format - Conditional - Data bar - More Options ↵Balaharipreetha Muthu
dialog Change-Id: I83faa2d1edb8f5cba08a7b1054bd66fc17f835b9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109129 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-12-17tdf#116381 - Add help file - anchor types for an image in CalcBalaharipreetha Muthu
Change-Id: Ib2d9cbd0607e47f1adeb74f5c4a31e984d07197a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107545 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-01tdf#134376 Add Calc cell style Help pageOlivier Hallot
Change-Id: I57f32bdfc4435cbe21b7cca1cb5170892e69447d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97622 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-22tdf81599 Better Help pages for Calc SolversOlivier Hallot
Add information on algorithms paramenters Change-Id: I36f330593687efa616594e397cb7d6054c2198ed Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94703 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-09tdf#131960 Clarification of FLOOR functionsSteve Fanning
+ refactor, grouping all FLOOR variants into one file Change-Id: I522674c51de531054991457cdc19a2245df4244d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91856 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-09tdf#131960 Clarification of CEILING functionSteve Fanning
+ refactor, grouping all CEILING variants into one file Change-Id: Ie82a1c72c8eab69457391ccc82543497fe168fa2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91855 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-26tdf#126923 Add guide for subtotals toolOlivier Hallot
Change-Id: I941214be272d6e959c1129b074891bb6f229ba26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-20Refactor Data analysis Calc help pageOlivier Hallot
Comply with menu Data > Statistics Change-Id: I06a5ed00ef162064ea2768f3040511e599993c3f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90837 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-20Review, refactor Calc Data Menu Help pagesOlivier Hallot
- update to latest menu entries - embed headings from individual Help files - WIP: Statistics menu entry will come later Change-Id: I66a2627b7bea65945210b6dcc2d1c3ed8783aec9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90796 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-11-30tdf#92084 Help Pages for OPT_* Calc functionsSteve Fanning
Note: The OPT_* functions implemented in release 4.0 have no HID_ defined. Dummy HID contants were inserted waiting for tdf#129115. Change-Id: Iac253a86ff8cbf8fd1a222c6326abc7e0c9f4f76 Signed-off-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-on: https://gerrit.libreoffice.org/84122 Tested-by: Jenkins