Apache OpenOffice (AOO) Bugzilla – Issue 85969
Not existing native Polish formatting instruction "rrrr-mm-dd" causes EXCEL export problems
Last modified: 2017-05-20 11:13:18 UTC
I am using Polish version of OO and Polish version of Excel. The date is formated in OO as "yyyy-mm-dd" but in Polish Excel as "rrrr-mm-dd", where r means "rok", in Polish "year". I created many spreadsheets in OO and formulas like: ="the profit reached the level of "&A5&" USD on the day "&TEXT(A6;"yyyy-mm-dd") are being destroyed when I send them to someone using only Excel. I know this might be a problem with a standard, but there should be a way to solve it somehow. Maybe when I save a file as .xls in OO the date format should change into "rrrr-mm-dd"... I think this problem is not just about the Polish language, but many others. Greg
@grzechu: Did you check whether EXCEL can handle formulas as you use in your spreadsheet? Can you please comment your summary? dew that work with EN version of OOo? Test results available? Please - contribute information concerning - your OS and Platform - your OS settings concerning Region / Date - Your OOo settings Language Please contribute a sample document - Original.odt - Export.xls - screenshots showeing view in "Original.odt" and "Export.xls"
Created attachment 51474 [details] date not converted correctly
Created attachment 51475 [details] date not converted correctly 2
Pls see attachements. I created the under WinXP, but as I remember the same problem exists when I use Linux and open it in OO or MS Office (through Crossover). Generally I don't think this problem is operating system dependent.
Small correction, in my .pdf attachements I wrote: "Now I write in the A8 the following formula" I meant: "Now I write in the A13 the following formula"
Seems to be not a general problem, but may be a Problem with the Polish localization. I can't confirm that problem directly, but I believe I found out the reason for that problem I tried with "2.3.1 Multilingual German version WIN XP: [680m9(Build9238)]", no problem wiht German MS EXCEL VIEWER for ="the profit reached the level of "&A5&" USD on the day "&TEXT(A6;"yyyy-mm-dd") and ="the profit reached the level of "&A5&" USD on the day "&TEXT(A6;"jjjj-mm-tt") Problems like visible in "I start from Calc and then go to Excel.pdf" / excel view I see when I mix English and German formattin instructon like ="the profit reached the level of "&A5&" USD on the day "&TEXT(A6;"jjjj-mm-dd"), 'dd' will not be recognized as formatting instruction by OOo. My Polish UI dos not allow native Polish formatting instruction "rrrr-mm-dd". Instead, some English way for date formatting is used. @grzechu, can you confirm that? I believe the problem is that "no native polish formatting instruction". I tested French UI, where (as with German interface) an native language formatting instruction (AAAA-MM-JJ) is possible and required. My resume: a correct Polish language formatting instruction set would eliminate that problem. This issue might be related to Issue 43751 (pls see " Additional comments from luke89 Mon Feb 20"!) @grzechu: Do you agree with my results?
@rainerbielefeld, "I believe the problem is that "no native polish formatting instruction". I tested French UI, where (as with German interface) an native language formatting instruction (AAAA-MM-JJ) is possible and required." Your conclusion might be right, if you have tested it in a German version and you code the date in OO as "jjjj-mm-tt" and also in Ex "jjjj-mm-tt", similarily in French one so it seems that the Polish one does not work properly and it is something that should be fixed. I have no access however to OO of other languages, I haven't tested on other versions. When I can be useful, I am ready to help. I will post this bug issue also on Polish OO distribution.
We will try it with l10n due to "comments from rainerbielefeld Tue Feb 12"
Changed sub component from "UI" to "code". SBA->ER: Please proceed, thx.
Reset assigne to the default "issues@openoffice.apache.org".