Apache OpenOffice (AOO) Bugzilla – Issue 22410
OO changes date field value from "2003-11-13" to "11/13/03"
Last modified: 2013-08-07 14:38:26 UTC
OO changes date field value from "2003-11-13" to "11/13/03". This seriuos problem, because in Lithuania second variant means: year - 2001, month - 13, day - 03. "11/13/03" you can read and understand. But next year, if i write "Important meeting - 2004-03-04", OO will convert it to "Important meeting - 04/02/04". For lithuanians it means, that meaating will be in 4th of February. Steps to reproduce: 1. Open OO text document 2. menu : "Insert->Fields->Other" 3. select "type: date", "Select:date", "Format:1999-12-31" 4. OO inserts date in selected fomat ("2003-11-13") 5. save and close document 6. open the same document 7. BUG: wrong date format "11/13/03"
*** This issue has been confirmed by popular vote. ***
Reassigned to ES
I cannot reproduce it. Please describe the language you choose in the format dialog, the OOo localization language, the document language (i.e provide a sample document) Notice: this is a P3 not a P1.
Win2000 pro locale: lithuanian OO Language settings: - Locale setting - default - Default lannguage for documents : Western - English (USA) I used "YYYY-MM-DD" date format in document where default language was English (USA). My question, i have choosen date format, why OO it reformats using default format? From another side, If OO reformats date field, why OO allows to me to choose different date format? Note to Steps to reproduce: 3rd. step. I selected 12th row in format column.
Created attachment 11365 [details] OO 1.1; Win2000; locale:lithuanian; Default document language: English(USA);
I can reproduce this bug with OOo 1.1 on Linux
ES->DVO: - system locales: Lithuanian - Document language: English US - insert a date field with format YYYY-MM-DD -> is correct displayed - save - reload -> the field has the format MM/DD/YY Resetting the format to YYYY-MM-DD does not work directly The content.xml shows the correct format YYYY-MM-DD. Please check with OS/ER what's wrong. ES->Community: This problem knows 2 work arounds: 1. Insert - Fields - Date 2. in the "Format" liste choose "Additional formats" 3. set the language to Lithuanian 4. choose YYYY-MM-DD as format -> format will be correctly displayed after reload OR 1. Insert - Fields - Date 2. choose YYYY-MM-DD as format 3. close the Fields dialog 4. select the field 5. Format - Character - Language - Lithuanian -> format will be correctly displayed after reload
Cannot be fixed in time for OO 2.0.
Cannot reproduce in OOo3.2 - system locales: French - Document language: English US - insert a date field with format YYYY-MM-DD -> is correct displayed - save - reload -> the field has the format YYYY-MM-DD
Reset assignee on issues not touched by assignee in more than 2000 days.