Summary: | FORMATTING Incorrect number and date format for South Africa (en_ZA) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Gert van den Berg <documentfoundation> |
Component: | Localization | Assignee: | Eike Rathke <erack> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | erack |
Priority: | medium | ||
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=123122 https://bugs.documentfoundation.org/show_bug.cgi?id=127602 https://bugs.documentfoundation.org/show_bug.cgi?id=134897 https://bugs.documentfoundation.org/show_bug.cgi?id=159829 |
||
Whiteboard: | target:6.2.0 | ||
Crash report or crash signature: | Regression By: |
Description
Gert van den Berg
2018-08-30 19:47:50 UTC
Thanks for the pointers and references. Comma as decimal separator and space as group separator seem to be a clear case. But, for the ISO 8601 date being used I find no normative references. Also the ICU Locale Explorer https://ssl.icu-project.org/icu-bin/locexp?d_=en&_=en_ZA lists the y/MM/dd date format. SABS is the national standards body and have adopted ISO 8601 as SANS 8601. I'm not completely sure if it is meant for use everywhere though. A version of the current one with 4-digit years as the default format would also be acceptable. I have not seen a 2-digit year used anywhere since Y2k. (dd-mm-yyyy is also in common use). (mm/dd/yyyy is completely unacceptable as a result.) The current default two digit years make it very hard to tell whether the day or year is at the start / end. (I'm ok with the ICU format for dates - It matches the Windows defaults) (Another note: I haven't seen the long date format ever be yyyy mmmmmm d, which Wikipedia lists) (Adopting the entered format if it is available and still formatted as "General" might also make sense, but that is a separate feature request) (I was considering Localisation as the component, but the description seemed to imply that it applies to translations) Purchasing SABS's SANS M33a seems to be the best method for figuring it out (if it contains date formats...). This has a nice summary of non-date, non-currency things: http://www.sun.ac.za/english/faculty/eng/mechanical-mechatronic/Documents/Undergraduate/Current%20UG/MM%20Procedures%20for%20Final%20Year%20Projects/siguide.pdf (And some history on SANS M33a) (Changing the decimal dot to commas WILL result in several more bugs being logged... The comma is official, but due to wrong Windows defaults for several decades systems were build around decimal dots, and commas tend to break third party applications (and many people assume that commas are wrong), especially if the CSV export depend on the regional settings, as in Excel) (Any one of those two as acceptable to me as long as the digit grouping symbol is set to as space and not the other one) (Using the underlying OS's locale settings might be ideal and end up with the least bugs - if someone changed their defaults in the OS to use dots instead of commas, Calc should normally respect that) Adopting a standard doesn't necessarily mean it's actually used in the wild. Many countries "adopted" ISO 8601 but the actual date format used is still locale dependent. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5c10c448b299faf43d9df28bdb9dc4fbb00540aa tdf#119613 [*-ZA] decimal separator is comma, group separator is space It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=464154aa26ae77883dd59fcbaab9e084aa035c9d Related: tdf#119613 inherit af_ZA separators from identical en_ZA It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. The number formats are correct on the daily 6.2 alpha builds. The date format still has 2 digit years. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fbc6415b85a855d3658be758efe4684cfd49faa3 Resolves: tdf#119613 [*-ZA] default to ISO 8601 date format It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e85966450b770e1169f113183ce1a9a9f4dcc507 Related: tdf#119613 tdf#118127 suppress duplicated builtins, rework All cat It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |