To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61329
------- Additional comments from [EMAIL PROTECTED] Thu Feb 9 19:18:41 -0800 2006 ------- Lars, I notice in the issue activity you comment that the error should be 502 rather than 503. >From the OO 2.0 Help File: Error 502 Invalid argument Function argument is not valid, for example, a negative number for the root function. Notice that =IF(A1<100,"2") has perfectly valid arguments for an IF formula and is not the direct problem with the example Excel file. The problem does not arise until the resulting text 2 is referenced in a formula in another cell and treated like it was a number. Therefore, Error 502 would not be appropriate in this case. >From the OO 2.0 Help File: Error 519 No result (#VALUE is in the cell rather than Err:519!) Formula yields a value that does not corresponds to the definition, or a cell that is referenced in the formula contains text instead of a number. This is more appropriate error since this is the exact problem with the example spreadsheet. I definitely agree with you that Error 503 is completely inappropriate. The results of the simplified example in my last comment were from Excel 2002, so there will still be conversion problems from documents for Excel 2002 and possibly older formats even if the formula results in a more descriptive error. --------------------------------------------------------------------- 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]
