To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723
------- Additional comments from and...@openoffice.org Fri May 8 12:13:08 +0000 2009 ------- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is yyyy-mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) ------- Additional comments from and...@openoffice.org Fri May 8 12:14:36 +0000 2009 ------- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is yyyy-mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) --------------------------------------------------------------------- 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
