Apache OpenOffice (AOO) Bugzilla – Issue 26092
Hebrew: month placed out of order
Last modified: 2013-08-07 15:15:02 UTC
I opened an excel file from Windows. If the format for the date had the month written in Hebrew, instead of Day month Year, I'd get Day Year Month. If I changed the format to display the month as a number, I got the right order. The example date, displayed where the formats were set, displayed the date in the right order. Using Lucina Sans Regular as the font for the system.
Created attachment 13563 [details] File giving wrong date format
I reproduced this problem with the Accounts2004.xls spreadsheet attached by the original submitor. The dates in the leftmost column as viewed in MS Excel appear as "04-aaaa-XX", where 04 is the year, aaaa is a variable length Gregorian month name in Hebrew transliteration and XX is the day of the month. See attached Accounts2004.prn The dates in the leftmost column as viewed in Calc appear as "XX 04 ,aaa", where XX is the day of the month, 04 is the year and aaa is a three-letter abbreviation of the Hebrew transliteration of the Gregorian month name. See attached Accounts2004.pdf This looks like a bug that we want to fix. - yba
Created attachment 13635 [details] Calc generated PDF of Accounts2004.xls
Created attachment 13636 [details] MS Excel generated PRN file of first page of Accounts2004.xls
Hi Eike, I think it's part of your construction site. Frank
The number format used is an Excel internal built-in format, which for different locales maps to different format codes. To be able to import this correctly we'd need a mapping table for all locales. Currently, in OOo1.1 for this example, the locale's DMMMYY format code is chosen (com.sun.star.i18n.NumberFormatIndex.DATE_SYS_DMMMYY:=22), which in this case was specified to be >D MMM, YY<, see formatindex="22" in i18npool/source/localedata/data/he_IL.xml (the fact that this currently is displayed in a different order >D YY ,MMM< for the Hebrew script type is a different story). For OOo1.1.1 a mapping table for en_US (e.g. D-MMM-YY in this case) and de_DE was specified, other locales still use the locale data's default. For future versions that table should be extended for other locales. => OOoLater, reassign to Daniel.
accepted
DR->Submitter: please attach a readable screenshot. I cannot read the *.prn filr... Or even better, if you want to help me fixing this issue completely: If you have a real Hebrew MS Excel, please load the file I will attach to this issue there, and attach a screenshot or PDF showing how Excel displays all the formats (I need a screenshot from an Hebrew Excel in a Windows set to Hebrew). Raising target to OOo 2.0. Issue 29949 remains for other unsupported locales.
target
Created attachment 15720 [details] built-in number formats test sheet
DR: Fixed in src680/dr19 @submitter: I found a way to see all built-in formats in Excel, I don't need a screenshot anymore. Added locales: LANGUAGE_HEBREW LANGUAGE_FRENCH (France) LANGUAGE_FRENCH_CANADIAN LANGUAGE_FRENCH_SWISS LANGUAGE_FRENCH_BELGIAN LANGUAGE_FRENCH_LUXEMBOURG LANGUAGE_FRENCH_MONACO LANGUAGE_ITALIAN (Italy) LANGUAGE_ITALIAN_SWISS
reopened
back to QA
fixed
verified in internal build cws_dr19
Found integrated in master src680m54 using Linux and Windows build