Apache OpenOffice (AOO) Bugzilla – Issue 98336
Date format changes when editing MMï¼DDï¼YYYY HH:MM:SS date format
Last modified: 2013-01-29 21:52:47 UTC
Can reproduce it with DEV300m39 on WinXP-ZH and DEV300m37 on Fedora-ZH How to reproduce it 1 Open a new Calc document 2 Select any cell like B2 and right_click - Format Cells, "Format Cells" dialog opens, switch to Numbers Tab, Category:Date, Format:MMï¼DDï¼YYYY HH:MM:SS(the last one), OK 3 Input 2009/1/22 in B2 and press ENTER 4 Double_click B2, date show as "08å¹´1月22æ—¥00æ—¶00分", edit date as "08å¹´2月22æ—¥ 00æ—¶00分", then press ENTER, check date format in B2 Result Date in B2 shows as "08å¹´2月22æ—¥00æ—¶00分" with aligning left Expectation Date in B2 shows as "2009/2/22" with aligning right Regards Li Meiying
Please have a look at issue 5556 and issue 72229. This issue seems to be a duplicate of those.