To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Wed Mar 5 16:24:36 +0000 2008 ------- Adding locale information to text cells isn't viable. It wouldn't only bloat the information to be stored, it would also require other applications loading the document to have the same locales implemented. I guess as soon as one used Indic or Chinese digits or Arabic separators or the like you'd be lost. Function VALUE() is of course equally error prone if it comes to portability across locales. To overcome this situation, the ODFF specification added the function NUMBERVALUE() that takes an additional parameter for the decimal separator used. For calculation with literal strings and single referred cells of textual content there's only one correct solution: generate an error. Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list. --------------------------------------------------------------------- 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]
