To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=38759





------- Additional comments from [EMAIL PROTECTED] Sun Feb 10 15:53:14 +0000 
2008 -------
This is actually an issue that nullifies compatibility between Excel and OOo.
Fancy IF statements are required at present to ensure backwards compatibility. 
The argument against a fix remains academic, but the solution ensures that a
formulae remains "error" free and can provide a solution even before all values
are populated.
The main frustration is compound MIN/MAX as the error is carried through.
viz: =MIN(MIN(A1:A4),MIN(A10:A14)); will error if A10:A14 is empty even if A1:A4
has a valid solution.
It seems to be an issue that can and has been resolved with Patches. Surely it
doesn't have to wait until version 3.0?
This bug and 71776 both confirm the need for a "Fix".

---------------------------------------------------------------------
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]

Reply via email to