summaryrefslogtreecommitdiff
path: root/source/text/scalc/guide
AgeCommit message (Collapse)Author
2021-10-21Fix <embedvar> tags for better l10n (Part 1)Rafael Lima
This is Part 1 of the fixes requested by translators concerning the use of the <embedvar>. Change-Id: Iee5ea4289034449c33156d4e20483943eb872ae0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123782 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-09-27Revert "tdf#33749 - HTML Help pages - reflect changes to cell merge in Calc"Ross Johnson
This reverts commit 7a45cfda035abefcda03767a4c81f93c69d593b1. Reason for revert: Change to core have been reverted due to their regressive nature as reported. This revert is for sync. There is a new patchset coming to resolve the issue. Change-Id: I30e224b7fc79a9620058e26ee5055f9ff5ce8819 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122647 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2021-09-27Assorted string fixesAdolfo Jayme Barrientos
• Removed some hardcoded product names • Updated color palettes referred to in a string • Updated an option’s name I missed in d599028d4f126c8a2badc3787e3fdf8277219c96 because I didn’t expect the Help would be inconsistent with the UI when searching. Change-Id: I75a33ae802e1baa01c99d274b8418dfe049d39c6
2021-09-25typoOlivier Hallot
Change-Id: Iae51822e330a1479aa6f5616db17c9d7552e217b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122448 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-09-20tdf#33749 - HTML Help pages - reflect changes to cell merge in CalcRoss Johnson
Replaced the entire "Format > Merge Cells" submenu with the single "Format > Merge and Center Cells" button with all the same behaviour it has on the Formatting Bar. Replaced the "Split Cells" button from the context menu of a selected merged cell with the "Merge and Center Cells" button showing the current merge status, as it does elsewhere. Also, add the "Merge and Center Cells" link to the Formatting Bar Description Help page. It was missing. Change-Id: I8f200faa7a218adae533752def032f4b7f28eed6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122313 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-09-16tdf#144332 fix bookmark typo + refactorsOlivier Hallot
Change-Id: I990a9edff16d1c7e1f828f291a123c3aa12f69cf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122188 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-09-03tdf#121613 Add information about Adjacent CellsRafael Lima
Change-Id: Ia16b0dd8c1cd7ae157b16c180fcd6737f58e7f4d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121415 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-31tdf#105152 Update Calc AutoFormat instructionsRafael Lima
Change-Id: I8fbc4b554947f9132d7ef357f1c7b02c98250bd6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121280 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-07-02tdf#102523 Improve Advanced Filter help pageRafael Lima
This patch embeds the page specialfilter.xhp and 12040201.xhp into the 12040300.xhp file, which is the landing page when the user clicks the Help button in the Advanced Filter dialog. As a result, the landing page now covers all the features in the dialog and also presents a useful example. This also updates the .tree file. Change-Id: I25d31838fa2604851962fdf8200b887255489017 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118191 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-22tdf#142389 (final) update autofilter HelpOlivier Hallot
- Add definitions for each autofilter command - Add info on fitering by color Special collaboration by Steve Fanning. Change-Id: I51e8e6e495736d0d5e1b5d40e74a926c813fb49a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115895 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-15tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ib6cd1b3d8fde7b33d1c99403dd74a71b3e1c39db Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115553 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-04-26tdf#141766 Update cell protection Help pageOlivier Hallot
Add new options available since LO 5.4 Change-Id: I1b283d5f4b6d43ed4167cbbbee969406935913bd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114668 Tested-by: Jenkins Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2021-03-28add missing spaceStanislav Horacek
Change-Id: I38d46c568021861c2cd1cc2c614b2f9d8742770f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113190 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-02-10typosOlivier Hallot
Change-Id: I5d454f184d5787eccdff2f732a43eac056c9ad49 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110679 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-01-21Review Calc's Change Image Anchor help pageOlivier Hallot
Change-Id: Ic37f8960a05c8207210efc688b2161833c433cda Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109725 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-01-18tdf#139616 Updating a conditional formatting help pageRoman Kuznetsov
Change-Id: Id34c8e5e003802635e30a7e038d9f413625f1306 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109404 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2021-01-16Update specialfilters.xhpOlivier Hallot
* synch with UI strings * Mute l10n on numbers and sheet headers Change-Id: Iad23a22b01200ac378b571e4b24b5e62f7398703 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109377 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-01-08Use switches for Ctrl vs. Command on macOSIlmari Lauhakangas
Change-Id: Ib0c3b971e927d7828290549dee0c2ffca9873f6a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108974 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-01-04"page fields" in pivot table have been renamed to "filters"Stanislav Horacek
Change-Id: I4b13bdbb91e5953833a518a5068b7db45147a3ea Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108447 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-12-21Fix a "D'oh! you found a bug"Olivier Hallot
+ Some refactor on the pages. Change-Id: Iec37d94dfa40292eeaae3dae3cf6ab1189fa8d2a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108124 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-12-10Related to: tdf#138662 improve help for renaming Calc sheetsSeth Chaiklin
* move <tip> and <note> to better location * move prefix explanation to better location with own <h2> - drop links to page that does not give any help about prefixes and add menu command sequence to get to the relevant place. * Revise explanation about naming (drop select, add double click) + add explanation about single quote restrictions. - drop warning about WindowManager (which was added in 2006) + add <literal> to restricted characters + add new <h2> headings to clarify page content * convert one "note" to a paragraph under a new heading * where paragraphs were changed, add <menuitem> as apppropriate * update to <tip>,<note>,<h1> Change-Id: I8a0e97b871331e0e3300a68252ae4096500aeeb1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107380 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-12-08tdf#95147 Add note to use Optimal Height with wrapping in XLS filesgar Soul
Change-Id: Ia7a0f3a1cdbb514f95a19cf1496b0b82bd1626cd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107308 Tested-by: Jenkins Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-11-30tdf#134602 repair menu sequence for Freezing Rows or ColumnsSeth Chaiklin
* change View - Freeze Cells - Freeze Rows and Columns --> View - Freeze Rows and Columns * update to <h1> Change-Id: I3d4b29cbabe5195c10d95fe7da56f1129befe6e9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/106934 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Tested-by: Jenkins
2020-10-31tdf#137724 repair access command to Basic Macro editing in CalcSeth Chaiklin
* change two menu command sequences + add step about selecting where Module is stored. - remove a word from a menu sequence + <menuitem> Change-Id: I694e544de5977a1ca74b5a3ae572a944f148b830 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104951 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-07-20tdf#132052 Finding currency symbols with Formatted DisplayIlmari Lauhakangas
Change-Id: If0e853f247c262e5369b96f1688250bbd6e17d64 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/99103 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-06-22Review Area tab called by many modules.Olivier Hallot
Change-Id: I9afa69a68c538647d4643e9b68077c97ff4eb079 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96900 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-22Fix label contents for Text CSV importOlivier Hallot
Change-Id: Ifdfc8ad238b6ef070ca2fa46af7bd50be77c17d0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96844 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-27Some more copyediting…Adolfo Jayme Barrientos
Change-Id: I43d4535b5c0ea659fd19177775ad00db71a2d7b3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91001 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-04-26Highlight dialog objects in textOlivier Hallot
Change-Id: I9a0a65988a79602bf1e43006f2266bb8ab1471ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92778 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-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>
2020-03-19Apply correct style for table head in pageOlivier Hallot
Change-Id: I042e1ee043a9dc2034f9fa9c77100286cad02770 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90726 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-02-17Fix image size in pageOlivier Hallot
Change-Id: I8b3c885bb98d59880dfce42339344e6119fbf1c8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88893 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-02-04Correct string "has value 0" to "is ignored" for the SUM functionEike Rathke
Which doesn't exactly matter for SUM but would for AVERAGE, for example. Change-Id: If2d416123890349f4458ca10274e3fb3dd7d15c5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/87980 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2020-01-11Fix typosOlivier Hallot
Change-Id: I7cb128508b827261e82fa6ca90d4c13d97b6e825 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/86556 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-11-25Clarify some unmentioned disallowed naming casesMike Kaganski
Change-Id: Idaf82835d571500d62a8a7cf5ad0d7f5335be524 Reviewed-on: https://gerrit.libreoffice.org/83269 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
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-11-07Housekeeping page on Calc custom functionsOlivier Hallot
+ Proper code formatting + proper menu path with MAC option + refactor some tags Change-Id: Ib54ade5fd1db56e27e67e4bcc1f7808cddb07341 Reviewed-on: https://gerrit.libreoffice.org/82215 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-10-29Fix wrong/obsolete embedsOlivier Hallot
Change-Id: I59e5a18c403caef79b1f08a8575c310faa724f08 Reviewed-on: https://gerrit.libreoffice.org/81659 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-10-26Improve "Referencing Other Sheets" documentationMike Kaganski
Change-Id: Iceb396337a189958919811206dfcfdf8510a24a7 Reviewed-on: https://gerrit.libreoffice.org/79482 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2019-09-06tdf#42990 Different handling of Text Cells in CalcOlivier Hallot
Change-Id: I96d54394fc4191ae80f593040b2b870e8a6e9e39 Reviewed-on: https://gerrit.libreoffice.org/78612 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2019-06-26tdf#122753 Calc AutoFormat Styles updateOlivier Hallot
Change-Id: I7b099f3b94f901af1885b942ce71c5815c1a4918 Reviewed-on: https://gerrit.libreoffice.org/74711 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-19Fix code formatting in validity help pagesOlivier Hallot
Change-Id: I9b0558bb805512c98223eaf2305d37861e10c82c Reviewed-on: https://gerrit.libreoffice.org/65458 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-11Correct some Format - Row/Column/Cell pathsSabri Unal
Some Format - Row/Column/Cell paths are corrected as Format - Rows/Columns/Cells Change-Id: If9795322ca50f3f5646b9195de69eb1e348662cf Reviewed-on: https://gerrit.libreoffice.org/64985 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-11Fix contents after translators reviewOlivier Hallot
Change-Id: I674796639284397c019240c4cd2ee79adb5b6ec0 Reviewed-on: https://gerrit.libreoffice.org/64960 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-03-20 14:56:31 +0000