To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98336 Issue #|98336 Summary|Date format changes when editing MM/DD/YYYY HH:MM: |SS date format Component|Spreadsheet Version|DEV300m37 Platform|PC URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|amy2008
------- Additional comments from amy2...@openoffice.org Thu Jan 22 06:47:16 +0000 2009 ------- 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 do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org