[sc-issues] [Issue 85387] when assigning a specific valid date, the system change the day with the month and month with day
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85387 User regina changed the following: What|Old value |New value CC|''|'regina' Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords|needmoreinfo, oooqa |oooqa --- Additional comments from [EMAIL PROTECTED] Sat Jan 19 21:17:33 + 2008 --- You can solve this input problem and force an unambiguous meaning, if you set the number language in your format, in your case to en-uk. Or you use ISO notation 2007-01-04 for your input. I see an inconsistent behavior of OOo too, and therefore confirm the issue. Please compare this situations: (A) Set your local to German(Germany). - Format a cell to date tt/mm/, number language default - Enter 04/01/2007, so the day should be 4. - You see 04/01/2007 in the cell. - Use DAY(),MONTH(),YEAR() to determine, what date it is. You will see that it is (in ISO-notation) 2007-01-04. - Format a cell to date mm/tt/, number language default - Enter 04/01/2007 in the cell, so the day should be 1. - You see 04/01/2007 in the cell. - Use DAY(),MONTH(),YEAR() to determine, what date it is. You will see that it is (in ISO notation) 2007-04-01. OOo has calculated the order of day and month from the given format of the cell in both cases. (B) Set your local to English(USA). - Format a cell to date dd/mm/, number language default - Enter 04/01/2007, so the day should be 4 as in the German case. - You see 01/04/2007 in the cell. - Use DAY(),MONTH(),YEAR() to determine, what date it is. You will see that it is (in ISO-notation) 2007-04-01. OOo does not calculated the order of day and month from the given format but from the local. Proposal: Use always the order of day, month, and year from the given cell format. Do not silently change order, if number of month not in 1..12, but set to text format in those cases. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85387] when assigning a specific valid date, the system change the day with the month and month with day
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85387 --- Additional comments from [EMAIL PROTECTED] Sat Jan 19 18:04:04 + 2008 --- After I wrote the date : 01/04/2007 in the cell. The value change and then I can see : 04/01/2007. If I select the cell, in the formula textfield, I can see the correct date : 01/04/2007. The OpenOffice default language is : English (USA) What language do you set in Format cells > Numbers ? : Default What language do you set in Format cells > Font ? : English (USA) The format cells is Date : DD/MM/ - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85387] when assigning a specific valid date, the system change the day with the month and month with day
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85387 User regina changed the following: What|Old value |New value Keywords| |needmoreinfo, oooqa --- Additional comments from [EMAIL PROTECTED] Sat Jan 19 15:29:37 + 2008 --- What do you see in the cell itself? What do you see afterwards in the input line? What locale do you use? What is your default language for spreadsheets? What language do you set in Format cells > Numbers ? What language do you set in Format cells > Font ? - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85387] when assigning a specific valid date, the system change the day with the month and month with day
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85387 Issue #|85387 Summary|when assigning a specific valid date, the system chang |e the day with the month and month with day Component|Spreadsheet Version|OOo 2.3.1 Platform|Other URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|weeb0tikris --- Additional comments from [EMAIL PROTECTED] Sat Jan 19 14:46:34 + 2008 --- When formatting a cell as : DD/MM/ if I enter the date 04/01/2007 the system change the text to : 01/04/2007 if I enter the date 01/04/2007 the system change it to : 04/01/2007 It's seem to be general with all date less than 13. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]