problem with interpreting OpenFormula format in ODF1.2

[Wols Lists]

On 19/05/15 12:24, Winfried Donkers 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 modeis given and not equal to zero, the absolute value of Nis
> rounded __away from zero__ to a multiple of the absolute value of
> significanceand then the sign applied ."
> 
>  
> 
> That sounds to me as CEILING behaviour, not FLOOR.
> 
Can N be negative? The reference to absolute values says yes, so
negative numbers are rounded DOWN, ie FLOOR behaviour, while positive
values are rounded UP ie CEILING behaviour.
>  
> 
> Is my interpretation wrong, is there an error in the standard?
> 
> What should the behaviour be to have FLOOR comply with ODFF1.2?
> 
>  
> 
> Winfried
> 
Cheers,
Wol