Apache OpenOffice (AOO) Bugzilla – Issue 46648
WW8: Locale date format lost on fields when exported
Last modified: 2017-05-20 10:31:01 UTC
The localized date format gets lost for date text fields, when saving as Word 97-2000. to reproduce - create a writer document in a localized environment (I'm using de_DE). - insert some date textfields with a typical locale format - save as .doc (Word97-2k) and close - open the .doc file -> former loclized fields are now in english (or mixed) format At least the german "." becomes a "/" (04.04.2005 -> 04/04/2005)
Created attachment 24646 [details] Sample with correct date format
Created attachment 24647 [details] Sample with broken date format
MRU->FLR: We should fix this for OO 2.0.1.
...forgot to reassign.
Considering the effort, the priority, the risk and our resource planning I've to retarget this issue to OOo Later.
set keywords and reset target. As I had requests from users about this issue, pleas reconsider the target milestone. This will completely break the date as text fields feature when trying to exchange files with word users (some format cannot be read by word).
This bug is invalid if Traditional Chinese formating is used.
confirmed on 2.0RC3 swedish MSWindows: Opened the given date_sample.odt, saved as Word 97/2000 "date_sample-1.odt", closed. Opened and compared my "date_sample-1.odt" with the given date_sample.doc: same problem exactly.
I can partially reproduce it on OOo 2.0 Italian. If I open the provided (German) file, the date appears in German and the .DOC export is broken as described. But if I repeat the test from scratch with Italian locale (open a new Writer document, insert Italian-formatted dates, export as .DOC and reopen), everything works fine. So this doesn't appear to affect Italian-formatted dates.
What's really happening here is that .DOC file contains "correct" (dotted) field contents, but "incorrect " (slashed) formats of date fields. The .ODT seems to have correct formats of fields and fields contents. So, it'd be error of export filter.
Tested on localized Russian build with ru_RU.UTF-8 locale. I can confirm this bug. Note: if you create document from scratch you need edit date field after insertion and choose not fixed date (second in middle table, not default). Fixed date exported as plain text and there is no problem.
*** Issue 61627 has been marked as a duplicate of this issue. ***
possible workaround, as long as the issue is not fixed: escape the "." in the format string by using following steps: - doubleclick on the date field - choose "more formats" from the list of date formats - change TT.MM.JJ to TT\.MM\.JJ
assigned to hbrinkm
retarget
target 3.0
The docx import filter consumed most of our resources in the "interop" area. Due to that we must retarget this issue. -> 3.x
Hello André, *, I have tested it with the Germanophone version of OOO320m17 under Debian SID AMD64 and I can confirm your issue so far with the ODT file you provided here. But if you create an ODT file from scratch - like pescetti - it works somehow. The date format is exported correctly, but they are now clear text instead of date fields ... :( HTH Thomas.
fixed in CWS sw34bf04 changeset: 0a67df6dda78 @mst: Please confirm review.
Verified fix in CWS sw34bf04.