Hi, On Tue, May 19, 2015 at 1:24 PM, Winfried Donkers <w.donk...@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@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
