To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109557 Issue #|109557 Summary|Selecting ISO 8601 format for dates breaks date input Component|Spreadsheet Version|OOo 3.2 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|poorboywilly
------- Additional comments from poorboywi...@openoffice.org Wed Feb 24 00:54:20 +0000 2010 ------- In a spreadsheet with dates, formatting the date cells to display in ISO 8601 (2010-02-22) format causes the cells to not accept input in ISO 8601 form. Trying to input a date in this format will cause the cell to take on the date value 1899-12-30. With the cells displayed in other date formats I've tried (such as US standard "11/30/2000" or long formats like "Tue, October 23, 2001"), I can still input a date in ISO format as usual. Note that I am not talking about issue 5556, I don't particularly care how the date is displayed on the input line. I am talking about putting the cursor over the cell and typing in a whole new date, or selecting all the text in the input line and writing over it with a new date. This is a regression from 3.1.1. I've also tried this on a Windows XP system but it did not affect that setup. Steps to reproduce: 1) Open a new Calc document. 2) Input a date into a cell as an ISO 8601 string, e.g. 2010-02-23. The date should default to display as 02/23/10, at least on en-US installations. 3) Select the cell with the date in it and "Format Cells". Choose the "Date" category and then the ISO 8601 format (displayed as "1999-12-31" in the dialog). 4) Place the bold cell-outline cursor over the cell with the date in it and type a new date as an ISO 8601 string, say 2001-10-30. Alternatively, select the cell with the date in it and then select all text in the input line and type the new date. 5) The cell will now display 1899-12-30. Looking at the input line, you can verify that the value for the date is indeed 12/30/1899. --------------------------------------------------------------------- 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