problem with interpreting OpenFormula format in ODF1.2

Regina Henschel rb.henschel at t-online.de
Tue May 19 05:55:47 PDT 2015


Hi Andras,

I think we have already resolved it as OFFICE-3879 for ODF1.2 Errata 01 
and ODF 1.3.

Kind regards
Regina

Andras Timar schrieb:
> Hi,
>
> On Tue, May 19, 2015 at 1:24 PM, Winfried Donkers
> <W.Donkers at dci-electronics.nl> wrote:
>> Hi,
>>
>>
>>
>> I'm currently working on the various FLOOR functions (all Calc and Excel
>> variations) and I struggle with this phrase in
>> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018610_715980110
>> :
>>
>>
>>
>> "If mode is given and not equal to zero, the absolute value of N is rounded
>> __away from zero__ to a multiple of the absolute value of significance and
>> then the sign applied ."
>>
>>
>>
>> That sounds to me as CEILING behaviour, not FLOOR.
>>
>>
>>
>> Is my interpretation wrong, is there an error in the standard?
>>
>> What should the behaviour be to have FLOOR comply with ODFF1.2?
>>
>
> It can be a copy&paste error. I filed a bug:
> https://issues.oasis-open.org/browse/OFFICE-3885
> We'll discuss this on the next OASIS ODF TC meeting (1st of June),
> unless until then someone proves that the current text is correct.
>
> Thanks,
> Andras
> _______________________________________________
> LibreOffice mailing list
> LibreOffice at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/libreoffice
>



More information about the LibreOffice mailing list