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] Fri Aug 8 21:39:01 +0000 2008 ------- > What I don't understand is, why refering to a cell containing "" > (empty string) in formulas evaluates to Err:529 This is definitely an error. Empty cells should not be evaluated as either text or number. They are just empty. Silly, but this is how it should have been handled. Actually, empty has a special value, it is called Not Available, or NaN, or NA. Calc should implement such a special type, as described in one of my previous posts. R does it (the S+ language) and all professional statistical applications. Also, R has a very powerful way to handle NA values. Default is to ignore these values, but the user can specify a different action, e.g. remove or fail. This is also the sensible way how to handle string-numbers: default would be *fail*, while other options are: *ignore* (Current Calc implementation) and *convert* to number (Excel's way). These option parameters should be passed to every function/formula/cell. --------------------------------------------------------------------- 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]
