To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109721
User andr55 changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|DUPLICATE |
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Tue Mar 2 20:49:03
+0000 2010 -------
Any non-numeric text in the range of cells used in of numeric formula should be
taken as zero, as is the past practice of OpenOffice.org Calc (up to and
including OOo 3.1.x.)
This practice has been followed by other spreadsheet programs as well.
A typical use is entering "n/a" in fields of a table where a non-zero value is
not appropriate, but other text could be entered as well.
(For example, the equivalent in french would be "s/o".)
Changing this breaks the functionality of OOo.
Having seen the attachment, the change interpreting text-formated cells as
numbers is reasonable -- as it does look the same.
(This removes errors resulting only from unintended text format.)
That isn't the problem.
The problem is treating non-numeric text as an error, instead of the traditional
treatment as zero.
By the way, in many programming languages, numeric conversion functions treat a
non-numeric string as zero -- not an error.
It is an entirely reasonable result.
Changing the function in OOo should be done for some compelling reason, not on a
whim.
Think about it for a moment.
What is the point of producing an error message ?
All that does is cancel all the calculations of any formulas directly or
indirectly using the cell containing non-numeric text.
Entering such text in a cell would most probably be deliberate.
Entering an incorrect number would produce invalid results, but NOT give an
error message. A much more likely occurance.
Reopening this issue as the other issue was not clearly explained (only by the
contents of an attachment), and has been subsequently closed.
---------------------------------------------------------------------
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]
