Re: [libreoffice-users] calc compliance with openformula

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: users+help@global.libreoffice.org
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