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 18:10:39 +0000 2008 ------- philhibbs said: "What should =A1+0 do, if A1 is text? What should =MID(A1;1;LEN(A1))+0 do, if A1 is text? Why does the former need to be =VALUE(A1)+0 but the latter does not need to be =VALUE(MID(A1;1;LEN(A1)))+0?" The answer is so easy in the context of OO calc opening an Excel document. The answer is it should do the exact same as Excel. --------------------------------------------------------------------- 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]