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] Sat Aug 9 07:43:27 +0000
2008 -------
Which only goes to show how inconsistent the current treatment is.
The treatment of a blank ("") cell introduced from a formula is especially
irritating, both Excel and OO treat the resulting content of the cell as "" ie.
not as blank, and there is no other way of leaving a cell blank after evaluation
that I know of.
Excel does have the "transition" option which evaluates text/blank as zero,
similar to discoleo's suggestion, but OO does not include this option. I filed a
bug report on this but it seems to have been deleted.
The work around is to use the sum() formula in all complex calculation, which
should evaluate "correctly". BUT beware, adding a sign in the formula will cause
the dreaded ERR:529 again, so, =SUM(A1;-A2;A3) can still give ERR:529 but
=+SUM(A1;A3)-SUM(A2) will evaluate "correctly"
---------------------------------------------------------------------
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]
