To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109721
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P2 |P3
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
Summary|In calc, calculations no l|Calculations no longer tre
|onger treat non-numeric te|at non-numeric text as zer
|xt as zero |o
--------------------------------------------------------------------------------
------- Additional comments from rainerbielef...@openoffice.org Tue Mar 2
06:09:26 +0000 2010 -------
Reproducible with "Ooo-Dev 3.3.0 multilingual version German UI WIN XP:
[DEV300m71 (Build 9481)]"!
Pls see my "sample.ods", what contains 3 cells 'A1:A3' with text formatting and
text contents and 3 formulas (add 1 to value of A-cell) in 'B1:B3'
With 3.1 all 'A' cells are calculated with value "0"
In 3.3. Formatting for a-Cells still is shown as "text", but
- Text content looking as numbers is used as number.
That looks like a feature, but i dislike it. My opinion: You can't
calulate with text, and so error message "#VALUE!" should be shown.
- In 3.3. a text like "SSS" will no longer be calculated with value "0", but
it will be indicated as an illegal "impurity" for a numeric calculation.
That's consequent, it was a bug in former versions not to show the error
message.
If a user had text strings in his calculations and trusted to use as "0" he did
it on his own risk.
Of course, a "3.1 compatibility mode" that calculates test strings as "0" would
have been great, but I don't believe that an enhancement request wolud be useful
- a solution would come too late.
Pls see comments and links in Issue 109165 !
*** This issue has been marked as a duplicate of 109165 ***
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
