To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=73380
User vreid47362 changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |REOPENED
--------------------------------------------------------------------------------
Resolution|WONTFIX |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Jan 12 04:28:54 -0800
2007 -------
The behavior that I described in this issue did not exist in previous versions
of OpenOffice. I think that it needs to be fixed for two reasons: 1.it is
totally unexpected behavior. Basic mathematics says that something multiplied
by nothing is either undefined or zero. In this case zero makes the most sense.
2. It breaks templates and documents from previous versions of Openoffice
without warning. 3. Excel users migrating to Openoffice will not be expecting
this behavior because in Excel (and every other spreadsheet that I've ever used
in the past 15 years) the product of two cells, when one cell is blank is zero.
and 4. In the current version of Calc, the formula "=sum(Cell*Cell)" yields
the expected value of zero when one of the cells is blank. It seems seems
reasonable that the product function would behave the same way.
---------------------------------------------------------------------
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]
