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|RESOLVED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|DUPLICATE |
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Mar 3 22:11:04
+0000 2010 -------
@rainerbielefeld
My issue is not well defined by "Behavior of calculation with text cell.",
whatever that is supposed to mean.
Your argument about filing a new issue because one doesn't agree with the result
of this other issue is incomprehensible. The other issue is extremely poorly
defined.
What specific version of what other spreadsheet is unimportant to the
discussion.
(One could start with OOo 1.x, 2,x, 3.0, and 3.1, as well as Quattro Pro, among
others.)
The point is that if a user chooses to put text, such as "n/a", in the place of
zero, for cells to be excluded from calculation in a range used in a formula,
that is perfectly legitimate.
The intent of course, is not to calculate with text, but to ignore the cell for
purposes of calculation, and use the text entered for clarification.
(Also used in at least some examples for OOo.)
The change from OOo 3.1 to OOo 3.2 was to make cells which appeared to be
numbers, but were formated as text, to be calculated as numbers.
Unfortunately included was the additional change to make non-numeric text in a
calculation range an error.
That is my issue.
(Note that there is an anomoly common to many spreadsheets, including OOo. The
value entered is normally dynamically typed, but if a cell has a non-default
format, and there is no current value in the cell, the new value entered is
stored, if possible, in the pre-existing format.)
Examples where one would reasonably put text in the place of zero :
1) Spreadsheet which calculates income tax returns.
Fields which do not apply to the individual are entered as "n/a" for clarity.
Fields awaiting more info could have an appropriate comment.
Meanwhile, a result would be shown based on the other entries, which could
indicate that the missing entries are not necessary.
2) A table where the columns used for a line vary according to the type of info.
On a particular line, it is appropriate to enter something like "n/a" in unused
cells. (This could be done automatically, according to the value of another
field.)
3) I'm sure that you can think of something.
Programming languages that convert non-numeric text to zero in conversion
functions :
This is the case in most versions of Basic, in whatever operating environnement.
(Such as OOo Basic, where also
print 1+"text"+3
prints 4).
(Until this issue is corrected, forced to return to OOo 3.1.1)
---------------------------------------------------------------------
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]
