To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85362
------- Additional comments from [email protected] Thu Feb 11 12:54:20 +0000 2010 ------- > This is more of a UI bug. When selecting "default" format for cells, the > term "default" is taken by users to mean "default for the type I > specified" (i.e. if the cell is a date, it should be "default date > format for my country). Unfortunately, in a spreadsheet, "default" > simply means "number, integer". So the "Default formatting" option > should be called "Reset to default spreadsheet format : integer number". > While I agree that that "bug" is a UI issue, the fix in my opinion is not to change the text of the UI but rather to bring the application's behaviour in line with what the UI suggests. > There is no silver bullet. Date operations are made on integers. Not 2 > individuals will agree on what is a default format for a date depending > on what type of use for that date they want. > No two individuals have to agree! Calc should use the format used when entering the data. For instance, if the user entered "2010-02-11" then Calc should use yyyy-mm-dd and if the user entered "27.10.2010" then Calc should use dd.mm.yyyy. Of course there is the problem of ambiguity when the user enters "10-12" but that problem is currently assumed in Calc anyway, so Calcs current behaviour (barring any open issues) should be preserved in these cases. That is, if Calc currently recognizes "10/12" as dd/mm/yy then that behaviour should remain. But currently, if the user enters "10-12" and pressed Enter, he sees "10/12/10" in the cell. If he then chooses "Default Formatting" the cell should display "10-12", not "40463" as it currently does. --------------------------------------------------------------------- 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]
