To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65221
------- Additional comments from [email protected] Tue Jan 6 09:36:59 +0000 2009 ------- In the other issues consolidated here there is considerable confusion about what constitutes an empty cell and whether OOo should be 'compatible' with XL. There is a further issue: in the help it clearly uses the phrase 'empty cell' to mean one with no value set, and furthermore to DEFINE equality comparison with "" and 0 to succeed against such cells. Try, for example, using A1="" and A1<>"" as cell formulae against the empty (unset) cell A1, and you will discover the semantics of comparison. Independent of the question of compatibility with XL is the necessity for compatibility with OOo. SUMIF, COUNTIF and the like, should apply the same comparison rules as simple comparison formulae -- and they don't. This note is to request of the developer looking at this to provide some sort of specification, and to ensure that self-consistency is preserved. Is there a place to discuss this? --------------------------------------------------------------------- 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]
