summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2019-02-02Bug 107930 - Help needs to be corrected and amended for RecalculationMark
add 'recalculate' bookmark_value to 06080000.xhp and 06070000.xhp, created 'exnbr' section in 00000406.xhp for 'Tools -> Options -> LibreOffice Calc -> Formula' and added 'embed' tag to 01060900.xhp changed 00000406.xhp LibreOffice text to %PRODUCTNAME Change-Id: Id3c6dffd31b1b72a854a5bd11902d2c22109900a Reviewed-on: https://gerrit.libreoffice.org/67237 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-01-28A couple of articles and tag vomit cleanupAdolfo Jayme Barrientos
Change-Id: I5e3d9c7f9ce78807d1acfa190a740f41ddd8a378
2019-01-25Fix typoAndrea Gelmini
Change-Id: I7603a2f8eb144bf243cbf5b5d4812e7aa3a1649a Reviewed-on: https://gerrit.libreoffice.org/66907 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-01-25Related: tdf#121173 double spaces in sentencesSophia Schröder
Change-Id: I4cdde42510bdf0cf50a91caf208133666a412b27 Reviewed-on: https://gerrit.libreoffice.org/64893 Tested-by: Jenkins Reviewed-by: Sophie Gautier <gautier.sophie@gmail.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-01-18tdf#121781 Clarify TZ info in Calc functionsOlivier Hallot
Notify user that TZ are not considered in date & time functions and in date & time formatted cells. Change-Id: I684039ebcc095fe4eefc2bf573df18679dd7f9f3 Reviewed-on: https://gerrit.libreoffice.org/66468 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-19http -> httpsEike Rathke
Turns out the https://www.oasis-open.org/standards#opendocumentv1.2 page has linked them badly with http ... Change-Id: I64d26f79f4503a6b795c4990cf92327d20fbb08a Reviewed-on: https://gerrit.libreoffice.org/65459 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2018-12-19Point to the correct ODFF 1.2 specification download linkEike Rathke
The previously pointed to office-formula page is the collection of working drafts. Change-Id: Id8bc75e2192ce8da26ca1af1d8779560ace14b6b Reviewed-on: https://gerrit.libreoffice.org/65454 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2018-12-13Help files: http -> httpsSophia Schröder
+ some more conservative changes Change-Id: I328505b05838c3f3ce40759096ca77d30c874c57 Reviewed-on: https://gerrit.libreoffice.org/63196 Tested-by: Jenkins Reviewed-by: Sophie Gautier <gautier.sophie@gmail.com> 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-12-08Fixes in Help page after translators reviewOlivier Hallot
Change-Id: I8ad08be0881d10bbe3ca8eac4647118cf5d4fa18 Reviewed-on: https://gerrit.libreoffice.org/64806 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-01REGEX: correct ICU URL to use http, not https (which seems unavailable)Mike Kaganski
Change-Id: Iaeed0d81dc88418c2bffab730fd682ca8cb3b101 Reviewed-on: https://gerrit.libreoffice.org/64313 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-11-29Occurrence number as REGEX() 4th argument, tdf#113977 tdf#121084Eike Rathke
Change-Id: I42be8bbc4e7c11e09cb66bf12f164c4fc565b54b Reviewed-on: https://gerrit.libreoffice.org/64276 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2018-11-26tdf#120927 Webservice functions needs linking toOlivier Hallot
Change-Id: I8d96025238fc2005dab37c1050a0c7915210d73a Reviewed-on: https://gerrit.libreoffice.org/64055 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-19update commands to insert column before/after active columnStanislav Horacek
Change-Id: Ie633d63e70103f2eda88a677e72c7e91482e5ac0 Reviewed-on: https://gerrit.libreoffice.org/63523 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-16tdf#121084 Help page for Calc REGEX functionOlivier Hallot
* honor DTD * follow erAck advise Change-Id: Ib911888fbc5aae9c4a749c9343218081df9f6783 Reviewed-on: https://gerrit.libreoffice.org/63430 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-11-12Fix Contents, after translators review (2)Olivier Hallot
Change-Id: Ia1038fbfc054efa457fae5d28d1a2e737dba1d45 Reviewed-on: https://gerrit.libreoffice.org/63308 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-11-06related: tdf#121173: double space cleanupsSophia Schröder
..and some more improvements (hopefully) Change-Id: I17e6656ff0f0274c342b62e72405d396437c8964 Reviewed-on: https://gerrit.libreoffice.org/62923 Tested-by: Jenkins Reviewed-by: Bartosz Kosiorek <gang65@poczta.onet.pl>
2018-10-28GrammarAdolfo Jayme Barrientos
Change-Id: I3d3bc317afd35bce5c941144417b7222e9063ae8
2018-10-25tdf#120221 Add experimental noteIlmari Lauhakangas
Change-Id: I591c7ef34a84059060a7eeeff15ad2f7b6cc58ae Reviewed-on: https://gerrit.libreoffice.org/62365 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-10-15Related: tdf#102257 adjust Help, RANDBETWEEN() volatile like RAND()Eike Rathke
Change-Id: Id200bd4886ccc6e5f932d2872d5969f0196b7332
2018-10-05Update help on Help in module pagesOlivier Hallot
fix DTD issue Change-Id: I178683b7352e2eff3de111bbb726d2ab60a31063 Reviewed-on: https://gerrit.libreoffice.org/61429 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-10-05Uppercase function MUNITOlivier Hallot
Change-Id: Ife835065f29789785d5382081c2ebecb576e34dd Reviewed-on: https://gerrit.libreoffice.org/61407 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-10-02Fix typosAndrea Gelmini
Change-Id: Ic23908f65b62064ae99fa337a4f269d1b1ea1c09 Reviewed-on: https://gerrit.libreoffice.org/61254 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2018-10-02Reduce L10N workload for repetitive stringsOlivier Hallot
Change 'Syntax' and 'Examples' heading into an embedded string translated only once. Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d Reviewed-on: https://gerrit.libreoffice.org/61143 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-22SEARCH spreadsheet function returns error when text not foundMike Kaganski
... as per OASIS ODF OpenFormula specification: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018874_715980110 Change-Id: I16b81de40dcc4b103e44cc1e3784eea830bf8ffa Reviewed-on: https://gerrit.libreoffice.org/60891 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-15tdf#115254 Some branch bookmarks are'nt working 26Olivier Hallot
Module formula Change-Id: I938d27a30497e3f9cc1880e3eb3cff82dedec2e4 Reviewed-on: https://gerrit.libreoffice.org/60512 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-12tdf#115254 Some branch bookmarks are'nt working 23Olivier Hallot
module sc a - e Change-Id: I179ea686cf83f31ebc645c2310fca52b222eb66f Reviewed-on: https://gerrit.libreoffice.org/60365 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-12tdf#115254 Some branch bookmarks are'nt working 22Olivier Hallot
module sc d-m Change-Id: I067b880ab4db50704acfd52a6ee6edb4aa277560 Reviewed-on: https://gerrit.libreoffice.org/60364 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-12tdf#115254 Some branch bookmarks are'nt working 21Olivier Hallot
Module sc m-r Change-Id: I6619733467aadf2a5bec5ffbfee523f4a55705a0 Reviewed-on: https://gerrit.libreoffice.org/60363 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-12tdf#115254 Some branch bookmarks are'nt working 20Olivier Hallot
Module sc r-z Change-Id: Ib8ee034cdbaf2f42280fac787cc31279cab3dc8e Reviewed-on: https://gerrit.libreoffice.org/60362 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-07Mark XML Source as experimental featureMike Kaganski
... since commit 65722772f00a40b8ca8adf21e31c22295ef7d215 Change-Id: I80d97004a9cd4dc9e6600e6bab64a43c5be91633 Reviewed-on: https://gerrit.libreoffice.org/59706 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-09-07Mention custom format codes for Calc's TEXT() functionMike Kaganski
Change-Id: I29271e2f555cbc231b616e75b43b37775143feae Reviewed-on: https://gerrit.libreoffice.org/59984 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-09-04TypoOlivier Hallot
Change-Id: I0943c9a67f45d5bcebc79278166c9ff0256eb209 Reviewed-on: https://gerrit.libreoffice.org/59972 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-09-04Refactor pages for string <-> numbers/refs/datesOlivier Hallot
Change-Id: I988850bd09ed2877bc98a3fda7ddff4b3ffbcff6 Reviewed-on: https://gerrit.libreoffice.org/59595 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-08-27Refactor help page on empty cellsOlivier Hallot
Change-Id: I8bff8e56804fae90a71fb35c0a67b015356c2138 Reviewed-on: https://gerrit.libreoffice.org/59585 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-27Review date and time functions help pagesOlivier Hallot
fix some formatting issues Add note and warning on date parsing Mute l10n in some tables with constants Change-Id: I86b4e7651ac89e2d2c8e2e658a8bdfd8f185ab60 Reviewed-on: https://gerrit.libreoffice.org/59582 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-08-23tdf#119009 Clarify DATEDIF date parsingOlivier Hallot
Change-Id: Ia0fa5110beb5914f7acb70046ef09e337f2fb30d Reviewed-on: https://gerrit.libreoffice.org/59406 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-08-17Add MACOSX for =INFO("system")Olivier Hallot
Change-Id: I23bd4706bf7f0eba4334e15c21e750b2f2cf2883 Reviewed-on: https://gerrit.libreoffice.org/59266 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-17Mute l10n in numeric table and InfoType stringsOlivier Hallot
Numeric cell are not to be translated InfoType either. Change-Id: I320b78c2c84212ece5c080e47c78cef2550ae066 Reviewed-on: https://gerrit.libreoffice.org/59263 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-16Fix excel syntax descriptionMike Kaganski
Change-Id: Iaaf38a33373eb910785a4a5d1fc45649523726e9 Reviewed-on: https://gerrit.libreoffice.org/57897 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-01Revert "tdf#118187 Text for INDIRECT() in wrong place"Mike Kaganski
... and clarify the context in the example instead. This reverts commit 184324625ea1e803007b9c41ce625ae6014573f1. Change-Id: Ie51c3b960a2262e5751bdecf86ba4e174f369fff Reviewed-on: https://gerrit.libreoffice.org/57899 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-07-11tdf#118314 Delete help content related to obsolete “Input Method Status” ↵Adolfo Jayme Barrientos
feature Change-Id: Ie80279915e3ee9a123204a729325ca9e119ab6bb Reviewed-on: https://gerrit.libreoffice.org/57224 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2018-06-23Improve 'IFS documentationOlivier Hallot
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS Improve collateral file Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7 Reviewed-on: https://gerrit.libreoffice.org/56310 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-06-17tdf#118187 Text for INDIRECT() in wrong placeOlivier Hallot
Change-Id: Ia6b37858c79940ce95467345bd96d22c8fe4737c Reviewed-on: https://gerrit.libreoffice.org/55945 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-06-11tdf#116642 Fix COUNTIFS page + help makefilesOlivier Hallot
+ Add callateral file for COUNTIFS + Adjust makefiles + some tweaks in XSLT + adjust languages to gb_HELP_LANGS. Change-Id: I9d2684d20804b93fd0671621d28a8d786a101fdf Reviewed-on: https://gerrit.libreoffice.org/55493 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-02-11 12:47:13 +0000