problem with interpreting OpenFormula format in ODF1.2

Winfried Donkers <W.Donkers -AT- dci-electronics.nl>
Tue, 19 May 2015 13:24:06 +0200

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?

Winfried

Context

problem with interpreting OpenFormula format in ODF1.2 · Winfried Donkers
- Re: problem with interpreting OpenFormula format in ODF1.2 · Wols Lists
  - RE: problem with interpreting OpenFormula format in ODF1.2 · Winfried Donkers
- Re: problem with interpreting OpenFormula format in ODF1.2 · Andras Timar
  - Re: problem with interpreting OpenFormula format in ODF1.2 · Regina Henschel
    - Re: problem with interpreting OpenFormula format in ODF1.2 · Andras Timar
    - RE: problem with interpreting OpenFormula format in ODF1.2 · Winfried Donkers

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.