Hi e-letter,
e-letter schrieb:
Readers,
According to the specification for openformula (see:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html),
the syntax for the function 'sum' is:
SUM( { NumberSequenceList N }+ )
e.g. SUM(a1+b2)
No. it would be SUM(a1;b2)
However in calc the function:
=a1+b2
+ is an operator no function. For operators see ODF1.2. part2, section 5
and 6.
You have to be aware of the conversion rules in addition.
still produces a correct result. Isn't the logical behaviour for the
second function to return an error, for non-compliance with the
standard. This is being asked for learning if it is better to use the
official syntax or accept that these "short-cuts" exist.
In LibreOffice the behavior of the operator + and the function is not
the same in regard of cells with no numerical content.
Your question is to general. Please give a more concrete example, what
you try to calculate, what your result is and what you expect the result
should be.
Kind regards
Regina
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
