To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5556
------- Additional comments from [email protected] Mon May 3 13:08:14 +0000 2010 ------- I don't see this as any different than having a numeric value such as 1.23456789 in a cell, formatted to display as 1.235. When you edit it, you will see 1.23456789; to edit it as it was formatted, you may lose data (in this case, 5 decimal places). Likewise, to pj's original comment so long ago, if you had formatted the date as "QQ YYYY", and edited it according to the format, you would only be able to change the quarter or the year, not the actual date in the cell. This is why editing and display should remain separate. That said, the problem seems to really be that the date editor, whether by double-click or in the entry line, defaults to US date format, regardless of anything else. It seems that Issue 72229 really is the answer - for all date cells, let the user pick the format that should be used for editing. --------------------------------------------------------------------- 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]
