To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108479
User regina changed the following:
What |Old value |New value
================================================================================
CC|'blueeon' |'blueeon,regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
Summary|Enhancement |Enhancement
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Jan 20 13:13:16
+0000 2010 -------
This is neither a bug report nor does it tell what enhancement is wished, but it
only shows the current way of calculation.
The current way of calculation is correct according to the ODF spec, chapter 2.3
Part 1) 1.2
http://www.oasis-open.org/committees/download.php/35695/OpenDocument-formula-20091222.odt
Without array context the + operator results that element, which is on the same
row as the formula. So the result of the + operator is 2 in row 1 and 4 in row 2
and undefined in row 3. Building the sum over this single value, gives of cause
2 in line 1, 4 in line 2 and #VALUE! in line 3.
To get the result 6, which you might expect, you have to enter the formula as
array formula.
---------------------------------------------------------------------
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]
