To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87855
------- Additional comments from [EMAIL PROTECTED] Wed Apr 9 08:33:19 +0000
2008 -------
@drking: don't know where you got the "text representations of numbers" from,
Excel 2007 help says:
[...] arguments that contain text [...] evaluate as 0 (zero).
Arguments that are error values or text that cannot be translated into
numbers cause errors.
Excel here seems to differentiate between "arguments that contain" (reference to
cell containing) and "arguments that are" (direct arguments). STDEVA(A1:A3) with
a cell containing text is different from STDEVA("red",1,2) (#VALUE! error) which
again is different from STDEVA("23",1,2) where the text is interpreted as a
number. We don't want to follow that.
---------------------------------------------------------------------
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]
