Apache OpenOffice (AOO) Bugzilla – Issue 43751
Polish locale: align date formats to ISO 8601
Last modified: 2013-08-07 15:03:05 UTC
We rather using ISO standards in Poland. I propose this setings: change of DateSeparator to '-' default date format medium - DateFormatskey20 add DateTimeFormatskey3 as default.
Created attachment 23159 [details] proposed changes
SBA: reassigned to ER.
Daniel, Seems reasonable, also http://www-950.ibm.com/software/globalization/icu/demo/locales?d_=en&_=pl_PL lists the yyyy-mm-dd format now. However, changing the date separator only in this case isn't really sufficient. The date formats of the D.M.Y forms using the dot should be adapted too. Btw: I didn't find your name in the list of copyright approvals, http://www.openoffice.org/copyright/copyrightapproved.html Please sign the JCA before we can integrate your contribution, see http://www.openoffice.org/contributing/programming.html But please, never attach entire files as updates, only diffs produced by the "diff -u" command, otherwise a file would overwrite changes done in the mean time when blindly copied. Thanks Eike
Daniel, By browsing through the copyright approvals document I saw that in the mean time you signed the JCA. A short notice in this issue could have speeded up things.. Please carry out the changes in the remaining date formats I mentioned above, before doing so please cvs update your pl_PL.xml file to the then recent revision and finally attach the output of cvs diff -u pl_PL.xml instead of an entire file. Thanks Eike
Long time no hear, nevertheless retargeting this issue to OOo2.0.1, would do the necessary changes myself.
On branch cws_src680_locales201: i18npool/source/localedata/data/pl_PL.xml 1.10.20.1
Reassigning to QA. re-open issue and reassign to oc@openoffice.org
reassign to oc@openoffice.org
reset resolution to FIXED
verified in internal build cws_locales201
closed because fix available in OOo2.0m142
I think this is wrong. An office package should help people to write texts in their language, so number formats should conform to spelling rules, not to technical standards. And the spelling rules read as follows: "Dates written with arabic numbers are to be separated with dots e.g. [...] 6.9.1994 [...] Except for special cases, as requirements of computer information processing or official business rules, or law rules, no other symbols should be used to separate the elements of a date (e.g. hyphens: 1-1-1995)." There are no such "requirements" here because if only the date is spelled according to spelling rules, and the locale is conforming to spelling rules, OO will interpret the date correctly. And there are no "law rules" that would force people not to use dots. "Also, no other order should be used than: day, month, year." This is even more unambiguous. The citations come from the "Nowy słownik ortograficzny PWN" ("PWN New Dictionary of Orthography") which certainly is the most renowned and up-to-date source for Polish spelling rules. See http://slowniki.pwn.pl/zasady/629747_1.html (in Polish). The statement that "We [are?] rather using ISO standards in Poland" is true but not applicable here. In Germany, Austria, Czech Rep., Slovakia, Slovenia ISO standards are used too, however their locales are conforming to spelling rules not to ISO, so it's M.D.YYYY there and this is correct. For some unknown reason YYYY-MM-DD is in Microsoft's Polish locale--which is totally opposite to Polish customs and rules--but I can see no reason to follow this poor language practice in OO. OO shouldn't be contributing to spoiling Polish language by computer engineers who unfortunately have forgotten what they had been taught in school. Please change the locale back! I'm sorry I didn't react earlier but I came upon this issue only after upgrading to version 2.0.1 last week.
It seems the situation is not that clear for the pl_PL locale. According to the CLDR http://www.unicode.org/cldr/data/diff/main/pl_PL.html#416 for a medium date format the following platforms have yyyy-MM-dd: Common, SUNJDK, IBMJDK, Solaris, AIX http://www.unicode.org/cldr/data/diff/main/pl_PL.html#427 for a short date format the following platforms have yy-MM-dd or yyyy-MM-dd: Windows, IBMJDK, AIX, Linux, HP Common has dd.MM.yy though. Daniel, you as the original submitter of this issue, could you please comment on this? Thanks Eike
1. DateSeparator - I was wrong, and agree with luke89. 2. Date format "yyyy-MM-dd" - I don't change my word. I always use this format. I'm technician and We rather likes standards. All tools are for people, and people make e decision.
Daniel, You must be joking. So we did this change only because YOU are a technician and YOU like to use ISO standard and this is nothing about the standard used in Poland?!? I'll bring this topic up on the dev@l10n mailing list. Eike
Yes, in Poland date SHOULD be written in ISO format, but practically most people use DD-MM-YYYY or DD.MM.YYYY. Question is: should OO.o follow unpopular standards, or rather common used practice? IMHO standards are for people, not people for standards.
gkocur> Yes, in Poland date SHOULD be written in ISO format Who says so? Is there any official statement/reference/document demanding this?
Yes, there is official standard PN-90/N-01204. This document is not available on-line for free, but it is equivalent to ISO 8601. See for ex. http://www.ie.iwi.unibe.ch/services/initiativen/iso8601.php. But: this standard is not often used. So, IMO OO.o polish default format should be DD-MM-YYYY.
gkocur> DD-MM-YYYY That's again something different and would be the third variant then. It uses hyphen '-' instead of dot '.' as a separator, in contrary to what 'luke89' said and Daniel lately agreed with.
After reading again what luke89 wrote I agree, "." is better choice.