Issue 46648 - WW8: Locale date format lost on fields when exported
Summary: WW8: Locale date format lost on fields when exported
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: 680m88
Hardware: All All
: P3 Trivial with 10 votes (vote)
Target Milestone: 3.4.0
Assignee: michael.ruess
QA Contact: issues@sw
Keywords: ms_interoperability, oooqa, regression
: 61627 (view as issue list)
Depends on:
Reported: 2005-04-04 21:04 UTC by andreschnabel
Modified: 2017-05-20 10:31 UTC (History)
11 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample with correct date format (6.20 KB, application/vnd.oasis.opendocument.text)
2005-04-04 21:06 UTC, andreschnabel
no flags Details
Sample with broken date format (8.00 KB, application/msword)
2005-04-04 21:07 UTC, andreschnabel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description andreschnabel 2005-04-04 21:04:08 UTC
The localized date format gets lost for date text fields, when saving as Word

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)
Comment 1 andreschnabel 2005-04-04 21:06:43 UTC
Created attachment 24646 [details]
Sample with correct date format
Comment 2 andreschnabel 2005-04-04 21:07:28 UTC
Created attachment 24647 [details]
Sample with broken date format
Comment 3 michael.ruess 2005-04-05 07:41:56 UTC
MRU->FLR: We should fix this for OO 2.0.1. 
Comment 4 michael.ruess 2005-04-21 12:49:04 UTC
...forgot to reassign.
Comment 5 andreas.martens 2005-05-26 07:59:08 UTC
Considering the effort, the priority, the risk and our resource planning I've to
retarget this issue to OOo Later.
Comment 6 andreschnabel 2005-11-07 19:30:15 UTC
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).

Comment 7 pplwong 2005-11-08 17:17:44 UTC
This bug is invalid if Traditional Chinese formating is used.
Comment 8 morganolsson 2005-11-08 18:04:35 UTC
confirmed on 2.0RC3 swedish MSWindows:

Opened the given date_sample.odt, saved as Word 97/2000 "date_sample-1.odt", 

Opened and compared my "date_sample-1.odt" with the given date_sample.doc: same 
problem exactly.

Comment 9 Andrea Pescetti 2005-11-08 18:37:16 UTC
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.
Comment 10 yury_t 2005-11-09 09:22:11 UTC
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.

Comment 11 rail_ooo 2005-11-09 10:14:27 UTC
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.

Comment 12 michael.ruess 2006-02-06 10:12:49 UTC
*** Issue 61627 has been marked as a duplicate of this issue. ***
Comment 13 andreschnabel 2006-03-28 14:36:13 UTC
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

Comment 14 Mathias_Bauer 2006-08-30 14:56:26 UTC
assigned to hbrinkm
Comment 15 openoffice 2006-10-12 11:54:27 UTC
Comment 16 Mathias_Bauer 2007-12-04 13:30:40 UTC
target 3.0
Comment 17 Mathias_Bauer 2008-04-25 17:25:32 UTC
The docx import filter consumed most of our resources in the "interop" area. Due
to that we must retarget this issue. -> 3.x
Comment 18 thackert 2010-05-12 16:07:16 UTC
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 ... :(
Comment 19 openoffice 2011-03-09 14:04:44 UTC
fixed in CWS sw34bf04
changeset: 0a67df6dda78

@mst: Please confirm review.
Comment 20 michael.ruess 2011-03-14 14:30:33 UTC
Verified fix in CWS sw34bf04.