To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109721





------- Additional comments from [email protected] Sat Mar  6 13:18:48 
+0000 2010 -------
The workaround works !!!
The SUM function does ignore cells containing text.

For coherence, using + and SUM() should work the same.
Even though one could use only SUM, logically they have the same function and
users would expect them to work the same.
(As well, often + and SUM are used together.)

In summary, although there is less urgence with the existance of the workaround,
cells containing (at least non-numeric) text should be ignored in all
calculations, and not be treated as errors.


---------------------------------------------------------------------
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]

Reply via email to