problem with interpreting OpenFormula format in ODF1.2

[Andras Timar]

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