To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67355
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Jul 28 05:30:45 -0700
2006 -------
Hi,
you are comparing apples and pears. SUM() just adds the numbers in a cell range,
so a zero is just a zero and have no influence on the result. BTW SUM() really
does not sum an empty cell as the value zero it ignores this cell.
On the other hand you have 1, 2, 3, empty cell, 4 in a cell range and start a
mina() function on it, you will get zero as MINIMUM which is in fact false. You
do not have a zero in the range, just an empty cell and empty is not equal to
zero.
Frank
---------------------------------------------------------------------
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]
