In Help, e.g. [1], we have date strings that use non-ISO date formats. Unless there is a strong reason to use such format (like when various formats are described/discussed explicitly), it's best to always use ISO 8601 unambiguous date strings, to promote use of international standards helping people understand each other. The task is to find and replace non-ISO dates in Help with their ISO 8601 counterparts - where applicable. Regular expressions like "\d\d?/\d\d?/\d{2,4}" (including double quotes) might be useful when searching them in help repo. [1] https://help.libreoffice.org/6.4/en-US/text/sbasic/shared/03030110.html
+1
*** Bug 161377 has been marked as a duplicate of this bug. ***
the example page (sbasic/shared/03030110) has been changed, which raises the question to clarify the wording at top (conceptual) level : * ISO = preferred ? * non ISO = ?? e.g. https://help.libreoffice.org/latest/en-US/text/sbasic/shared/01020100.html#DateLiterals https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03030102.html#par_id841643046880968
Mike, no result here bogdan@bogdan:~/Documente/help/help$ git grep "\d\d?/\d\d?/\d{2,4}" bogdan@bogdan:~/Documente/help/help$
(In reply to BogdanB from comment #4) `git grep` doesn't use regular expressions by default. Since the \d is not in grep's basic/extended metacharachers, your command should specify to Perl syntax: > git grep -P "\d\d?/\d\d?/\d{2,4}"
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/6977846f119905354c5b449612e1e0b64fdf0722 tdf#131332: Replace custom date formats with ISO 8601
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/ce42a420ae28518aae72e72e06a8d3d8a3f33cc8 tdf#131332: Replace custom date formats with ISO 8601
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/0ecc00617e7b93d3869ea7d77c777ebe47db9896 tdf#131332: Replace custom date formats with ISO 8601
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/c73747f8fb95caee2f4bd5095b886e305bd7d684 tdf#131332: Replace custom date formats with ISO 8601
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/9b423c924ba73aab8b885304822fd92b00ee562d tdf#131332: Replace custom date formats with ISO 8601
Mike, can you make a search to see if is something else still left?
Created attachment 197839 [details] screenshot of LO option dlalog Options for LO Calc - Calculate - Date
Following changes in optionen/01060500.xhp on patch https://git.libreoffice.org/help/+/0ecc00617e7b93d3869ea7d77c777ebe47db9896%5E%21/ The same change in date display should go to the Tools - Options - LibreOffice Calc - Calculate - Dates dialog page for consistency. See image attached
(In reply to Olivier Hallot from comment #12) > Created attachment 197839 [details] > screenshot of LO option dlalog > > Options for LO Calc - Calculate - Date The change is in gerrit https://gerrit.libreoffice.org/c/core/+/177496
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a1b8b44bf99b331f6cd4b4583d08b6a01d5c4f03 tdf#131332: Replace custom date formats with ISO 8601 It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike, can you check if there are dates remaining to be changed?
Yes; besides dates separated by slash /, there are dates separated by dot . - so the command would be > git grep -P "\d\d?\.\d\d?\.\d{2,4}"
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/22c587639a5c06e9a61a390b4ea18da0cb0c0b68 tdf#131332: Replace custom date formats with ISO 8601
Bogdan Buzea committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/help/commit/fc527bd75b13dff6c78f6103723f05fd3eaea75b tdf#131332: Replace custom date formats with ISO 8601
Mike, can you check again?
Thanks Bogdan, looks done! I suppose, this can be marked completed. If any leftover is found, nothing prevents fixing it for a closed bug :-)
Bogdan Buzea committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/433fd1579949216906e931c1d331a5fa8023b117 tdf#131332: Replace custom date formats with ISO 8601 It will be available in 25.2.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.