summaryrefslogtreecommitdiffstats
path: root/source/text/scalc/guide
Commit message (Collapse)AuthorAgeFilesLines
* Some more copyediting…Adolfo Jayme Barrientos2020-04-271-3/+3
| | | | | | | Change-Id: I43d4535b5c0ea659fd19177775ad00db71a2d7b3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91001 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
* Highlight dialog objects in textOlivier Hallot2020-04-261-5/+5
| | | | | | | Change-Id: I9a0a65988a79602bf1e43006f2266bb8ab1471ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92778 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#126923 Add guide for subtotals toolOlivier Hallot2020-03-261-0/+66
| | | | | | | Change-Id: I941214be272d6e959c1129b074891bb6f229ba26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Review, refactor Calc Data Menu Help pagesOlivier Hallot2020-03-201-3/+2
| | | | | | | | | | | - 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>
* Apply correct style for table head in pageOlivier Hallot2020-03-191-46/+41
| | | | | | | Change-Id: I042e1ee043a9dc2034f9fa9c77100286cad02770 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90726 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix image size in pageOlivier Hallot2020-02-171-11/+9
| | | | | | | Change-Id: I8b3c885bb98d59880dfce42339344e6119fbf1c8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88893 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Correct string "has value 0" to "is ignored" for the SUM functionEike Rathke2020-02-041-1/+1
| | | | | | | | | | 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
* Fix typosOlivier Hallot2020-01-111-1/+1
| | | | | | | Change-Id: I7cb128508b827261e82fa6ca90d4c13d97b6e825 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/86556 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Clarify some unmentioned disallowed naming casesMike Kaganski2019-11-251-1/+1
| | | | | | | Change-Id: Idaf82835d571500d62a8a7cf5ad0d7f5335be524 Reviewed-on: https://gerrit.libreoffice.org/83269 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
* tdf#128503 Clarify numeric x regex conversionOlivier Hallot2019-11-081-3/+4
| | | | | | | | | | | | | | | | | | | | + 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>
* Housekeeping page on Calc custom functionsOlivier Hallot2019-11-071-15/+18
| | | | | | | | | | | + 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>
* Fix wrong/obsolete embedsOlivier Hallot2019-10-291-11/+11
| | | | | | | Change-Id: I59e5a18c403caef79b1f08a8575c310faa724f08 Reviewed-on: https://gerrit.libreoffice.org/81659 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Improve "Referencing Other Sheets" documentationMike Kaganski2019-10-261-2/+5
| | | | | | | Change-Id: Iceb396337a189958919811206dfcfdf8510a24a7 Reviewed-on: https://gerrit.libreoffice.org/79482 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
* tdf#42990 Different handling of Text Cells in CalcOlivier Hallot2019-09-061-9/+15
| | | | | | | Change-Id: I96d54394fc4191ae80f593040b2b870e8a6e9e39 Reviewed-on: https://gerrit.libreoffice.org/78612 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
* tdf#122753 Calc AutoFormat Styles updateOlivier Hallot2019-06-261-12/+12
| | | | | | | Change-Id: I7b099f3b94f901af1885b942ce71c5815c1a4918 Reviewed-on: https://gerrit.libreoffice.org/74711 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix code formatting in validity help pagesOlivier Hallot2018-12-191-3/+2
| | | | | | | Change-Id: I9b0558bb805512c98223eaf2305d37861e10c82c Reviewed-on: https://gerrit.libreoffice.org/65458 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Correct some Format - Row/Column/Cell pathsSabri Unal2018-12-112-2/+2
| | | | | | | | | | 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>
* Fix contents after translators reviewOlivier Hallot2018-12-111-4/+4
| | | | | | | Change-Id: I674796639284397c019240c4cd2ee79adb5b6ec0 Reviewed-on: https://gerrit.libreoffice.org/64960 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* update menu command to protect spreadsheet structureStanislav Horacek2018-11-192-2/+2
| | | | | | | Change-Id: I14e424aea344ffeab47bc68d99b98dd56492dcbc Reviewed-on: https://gerrit.libreoffice.org/63521 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix contents, after translators review.Olivier Hallot2018-11-121-3/+3
| | | | | | | Change-Id: I142b6ec74d06d1153675c50079ebda6273e44414 Reviewed-on: https://gerrit.libreoffice.org/63305 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix a typo found by Andrea GelminiSophia Schröder2018-07-231-32/+24
| | | | | | | | | -reformatting part Change-Id: If12a0361a9b47878b7df0f562154931437e59fc6 Reviewed-on: https://gerrit.libreoffice.org/57827 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
* More punctuation fixesSophia Schröder2018-05-201-4/+2
| | | | | | | Change-Id: Ia38e862e5a1dc2f225f8c6f8928f35aeba440683 Reviewed-on: https://gerrit.libreoffice.org/54549 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
* Fix external reference to blog post on pivot chartsOlivier Hallot2018-05-151-1/+1
| | | | | | | Change-Id: Icabfdcce2ae18848793bd467fd606e20afa97f5f Reviewed-on: https://gerrit.libreoffice.org/54347 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Grammar: subject–verb agreementAdolfo Jayme Barrientos2018-05-121-1/+1
| | | | | | | We don’t suffix “-s/-es” to verbs that refer to a subject in the third-person plural. Change-Id: I6fd90814bd63d618c8af4e625d38c6ee9895f919
* Refactor help files with sample files embeddedOlivier Hallot2018-05-0814-14/+14
| | | | | | | Change-Id: I46d1147b2a6db931914d332ba6004d1b23b4ea65 Reviewed-on: https://gerrit.libreoffice.org/53954 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Add more links between pivot tables and chartsOlivier Hallot2018-05-018-4/+28
| | | | | | | | | Fix id duplicity Change-Id: I72520764bcf68f25299a05be619b8624d5ca5d1c Reviewed-on: https://gerrit.libreoffice.org/53697 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Refactor inter-page linksOlivier Hallot2018-05-016-36/+36
| | | | | | | | | + reduce translation work Change-Id: I9d6025186f2769981ccac9bd9ec8cfcd00c83f07 Reviewed-on: https://gerrit.libreoffice.org/53694 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#106623 Write help page for PIVOT CHARTOlivier Hallot2018-05-017-1/+266
| | | | | | | | | | | | + Added example file + with inputs from Tomasz Vajngerl + remove a spurious character slipped in set 1 + fix DTD issue 01 Change-Id: I13ebce0241a2ae1e7dcac29945403607da0d1dfa Reviewed-on: https://gerrit.libreoffice.org/53692 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* More punctuation fixesSophia Schröder2018-04-231-1/+1
| | | | | | | Change-Id: I02ffc730b03d696a70c192b5824534fde81f64a1 Reviewed-on: https://gerrit.libreoffice.org/53256 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* replace http links with https equivalentsdennisroczek2018-04-162-8/+6
| | | | | | | | | | | | * mainly http://wiki.documentfoundation.org * http://en.wikipedia.org * http://api.libreoffice.org Change-Id: I3587d8d5e6a6de4a7c7013920b9e135e4adc977c Reviewed-on: https://gerrit.libreoffice.org/52354 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Removed commentsAndrea Gelmini2018-04-021-1/+1
| | | | | | | Change-Id: I5917f9c4b49a06937f5d7ab5ecf1551953dc7875 Reviewed-on: https://gerrit.libreoffice.org/52229 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
* tdf#115831 Review of rename sheet help pageOlivier Hallot2018-02-221-72/+72
| | | | | | | Change-Id: Ibe2db947cd6a1ef52231013a6ecdb9efbf2e99a2 Reviewed-on: https://gerrit.libreoffice.org/50192 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#115831 Renaming of sheetLaurent BP2018-02-221-69/+73
| | | | | | | | | | | | | | Renaming of sheets have the same constraints whatever the file format used. Max number of sheets is 10,000. See tdf#44443 File modified with HelpAuthoring Change-Id: Iff4ecdea6cdfede9844475eaac31c27c9d903a3d Reviewed-on: https://gerrit.libreoffice.org/49949 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#111777 correct help page for named rangesOlivier Hallot2017-08-151-1/+1
| | | | | | | | | Scrolling suggested named ranges is done with Crtl+Tab keys Change-Id: If57beb17528a291e7b08f768378d15c67f1149d9 Reviewed-on: https://gerrit.libreoffice.org/41125 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* tdf#111651 'Styles and Formatting' -> 'Styles'Olivier Hallot2017-08-152-4/+4
| | | | | | | Change-Id: Ic4db58aa04d21c514987cdbeaed5d11292d79b85 Reviewed-on: https://gerrit.libreoffice.org/41103 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* tdf#109213 - Changed hotkey for switching between absolute and relative ↵liongold2017-08-121-3/+3
| | | | | | | | | | | referencing In this commit, some small changes to the English is also done. Change-Id: I5abd3d9d7dc278202cf87228fbb8395b06f89126 Reviewed-on: https://gerrit.libreoffice.org/40976 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* Fix some DTD issues in Help PagesOlivier Hallot2017-07-231-1/+1
| | | | | | | | | <item> does not have child nodes Change-Id: Ieac002b65cfc54c66af92e1a7cb80a1fc7ce31f4 Reviewed-on: https://gerrit.libreoffice.org/40313 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* Fixes for help pages after translation review.Olivier Hallot2017-06-281-2/+2
| | | | | | | | | Thanks to all translators for pinpointing these mistakes. Change-Id: I3746d3d81ded2af1e012cb38cdd20e9e529c2667 Reviewed-on: https://gerrit.libreoffice.org/39330 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* Mass remove excess spaces from inside tagsGabor Kelemen2017-05-3018-29/+29
| | | | | | | | | | | | | | | | This is fallout from the l10n and oldref attribute removal. Some tags were broken into two rows and the second was indented with spaces. The line break was removed along the tags, but those spaces were not. Command I used to catch these: find source/text/ -name "*xhp" | xargs sed -i -e 's#\" *>#\">#g' Change-Id: I6f9bad46cbfb7416950bee8230e358a3dd851def Reviewed-on: https://gerrit.libreoffice.org/37791 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
* adjust image paths after moving helpimg into more appropriate folderKatarina Behrens2017-05-125-18/+18
| | | | | | | Change-Id: Idcfa3700bfd53d38ddeda484828f00bf36cf3b57 Reviewed-on: https://gerrit.libreoffice.org/32104 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
* remove obsolete oldref attribute (removes one context line in pot)Christian Lohmaier2017-05-0978-1174/+1144
| | | | | | also remove obsolete l10n attribute (doesn't affect translations/pot) Change-Id: I809866ea7b16cb1cacad9efacb6fdeebae38ea9f
* tdf#106861 - fix Autoinput entry in menu, plusOlivier Hallot2017-03-301-49/+55
| | | | | | | | | | | - Reorder Calc tools menu help page - Remove ref to "Cell contents" - Move Recalculate to Data menu Change-Id: Id6165db40a99316eae9768955b6cdbb9d5f05afb Reviewed-on: https://gerrit.libreoffice.org/35922 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* Remove useless tagOlivier2017-03-151-1/+1
| | | | | | | Change-Id: I3ba1ea5632401645682955ecfc7ba8b740099746 Reviewed-on: https://gerrit.libreoffice.org/35195 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
* tdf#60873 Link Protect Sheet dialog to its own help pageGabor Kelemen2016-12-231-1/+1
| | | | | | | | | | | Instead of Protecting Cells from Changes. Create a link to the Password page too. TODO: Update formatting of all those tips, they look terrible Change-Id: I345bcfd315680b5ad4fdf71dcc04085ef438ad13 Reviewed-on: https://gerrit.libreoffice.org/32360 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
* drop imglstCaolán McNamara2016-12-222-2/+2
| | | | Change-Id: I6a9caacfb23c7610bf531e7a8b2719d6ebae3bf0
* tdf#104410 'Insert - Names' moved and renamedGabor Kelemen2016-12-072-5/+5
| | | | | | | | | Now this menu item is 'Sheet - Named Ranges and Expressions' Change-Id: I82113ef2e969cd2409fe114a51789e030752cdc0 Reviewed-on: https://gerrit.libreoffice.org/31700 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
* type: missing spaceAndras Timar2016-11-261-2/+2
| | | | Change-Id: Ia0a6e032611b8c76c6b7c55adf0b5307c63dc8e9
* tdf#103968 'Link to External Data' is now in the Sheet menuGabor Kelemen2016-11-262-3/+3
| | | | | | | Change-Id: If8b69923ff8e6e9ed2ab03c72330665c6ef788d5 Reviewed-on: https://gerrit.libreoffice.org/31189 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com>
* tdf#103244 adjust menu path to Tools - Protect Sheet/SpreadsheetStanislav Horacek2016-11-062-3/+3
| | | | | | | Change-Id: I5993052af55e681c19b15f8e08f22b36d15e1e65 Reviewed-on: https://gerrit.libreoffice.org/30614 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
* update description of Find and Replace dialogStanislav Horacek2016-10-313-7/+7
| | | | | | | Change-Id: I40af15d57e568eebdb5fe145e6a8bc9c8d6845b0 Reviewed-on: https://gerrit.libreoffice.org/30396 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
generated by cgit (git 2.34.1) at 2024-06-04 13:48:25 +0000