summaryrefslogtreecommitdiff
path: root/source/text/scalc/guide
AgeCommit message (Collapse)Author
2020-06-23Fix 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> (cherry picked from commit d2fe8fae9d249659c389e374a253072ae92506ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96870 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
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>
2018-11-19update menu command to protect spreadsheet structureStanislav Horacek
Change-Id: I14e424aea344ffeab47bc68d99b98dd56492dcbc Reviewed-on: https://gerrit.libreoffice.org/63521 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-12Fix contents, after translators review.Olivier Hallot
Change-Id: I142b6ec74d06d1153675c50079ebda6273e44414 Reviewed-on: https://gerrit.libreoffice.org/63305 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-07-23Fix a typo found by Andrea GelminiSophia Schröder
-reformatting part Change-Id: If12a0361a9b47878b7df0f562154931437e59fc6 Reviewed-on: https://gerrit.libreoffice.org/57827 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-05-20More punctuation fixesSophia Schröder
Change-Id: Ia38e862e5a1dc2f225f8c6f8928f35aeba440683 Reviewed-on: https://gerrit.libreoffice.org/54549 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-05-15Fix external reference to blog post on pivot chartsOlivier Hallot
Change-Id: Icabfdcce2ae18848793bd467fd606e20afa97f5f Reviewed-on: https://gerrit.libreoffice.org/54347 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-12Grammar: subject–verb agreementAdolfo Jayme Barrientos
We don’t suffix “-s/-es” to verbs that refer to a subject in the third-person plural. Change-Id: I6fd90814bd63d618c8af4e625d38c6ee9895f919
2018-05-08Refactor help files with sample files embeddedOlivier Hallot
Change-Id: I46d1147b2a6db931914d332ba6004d1b23b4ea65 Reviewed-on: https://gerrit.libreoffice.org/53954 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-01Add more links between pivot tables and chartsOlivier Hallot
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>
2018-05-01Refactor inter-page linksOlivier Hallot
+ 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>
2018-05-01tdf#106623 Write help page for PIVOT CHARTOlivier Hallot
+ 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>
2018-04-23More punctuation fixesSophia Schröder
Change-Id: I02ffc730b03d696a70c192b5824534fde81f64a1 Reviewed-on: https://gerrit.libreoffice.org/53256 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-16replace http links with https equivalentsdennisroczek
* 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>
2018-04-02Removed commentsAndrea Gelmini
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>
2018-02-22tdf#115831 Review of rename sheet help pageOlivier Hallot
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>
2018-02-22tdf#115831 Renaming of sheetLaurent BP
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>
2017-08-15tdf#111777 correct help page for named rangesOlivier Hallot
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>
2017-08-15tdf#111651 'Styles and Formatting' -> 'Styles'Olivier Hallot
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>
2017-08-12tdf#109213 - Changed hotkey for switching between absolute and relative ↵liongold
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>
2017-07-23Fix some DTD issues in Help PagesOlivier Hallot
<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>
2017-06-28Fixes for help pages after translation review.Olivier Hallot
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>
2017-05-30Mass remove excess spaces from inside tagsGabor Kelemen
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>
2017-05-12adjust image paths after moving helpimg into more appropriate folderKatarina Behrens
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>
2017-05-09remove obsolete oldref attribute (removes one context line in pot)Christian Lohmaier
also remove obsolete l10n attribute (doesn't affect translations/pot) Change-Id: I809866ea7b16cb1cacad9efacb6fdeebae38ea9f
2017-03-30tdf#106861 - fix Autoinput entry in menu, plusOlivier Hallot
- 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>
2017-03-15Remove useless tagOlivier
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>
2016-12-23tdf#60873 Link Protect Sheet dialog to its own help pageGabor Kelemen
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>
2016-12-22drop imglstCaolán McNamara
Change-Id: I6a9caacfb23c7610bf531e7a8b2719d6ebae3bf0
2016-12-07tdf#104410 'Insert - Names' moved and renamedGabor Kelemen
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>
2016-11-26type: missing spaceAndras Timar
Change-Id: Ia0a6e032611b8c76c6b7c55adf0b5307c63dc8e9
2016-11-26tdf#103968 'Link to External Data' is now in the Sheet menuGabor Kelemen
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>
2016-11-06tdf#103244 adjust menu path to Tools - Protect Sheet/SpreadsheetStanislav Horacek
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>
generated by cgit (git 2.34.1) at 2025-03-11 16:41:51 +0000