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 Feb 20 17:25:22 +0000 2008 ------- Could we could have a "strict" mode, where the following both throw errors? = "3" + 4 = A1 + 4 where A1 contains "'9" (text number) That would give Calc a huge advantage in mission-critical applications, where Excel (and currently Calc) simply can't be used because of sometimes evaluating text to zero, sometimes to its numeric value, and sometimes throwing an error. Incidentally, see also issue 58903 and http://ca.geocities.com/jrkrideau/OpenOffice/spreadsheet_problems.pdf --------------------------------------------------------------------- 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]