[OASIS Issue Tracker] (OFFICE-3973) CLONE - In function floor, mode<>0 rounds toward zero, not away from zero

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ https://issues.oasis-open.org/browse/OFFICE-3973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=70428#comment-70428 ] 

Patrick Durusau commented on OFFICE-3973:
-----------------------------------------

Clone of https://issues.oasis-open.org/browse/OFFICE-3879 for ODF 1.2 Errata 01)

> CLONE - In function floor, mode<>0 rounds toward zero, not  away from zero
> --------------------------------------------------------------------------
>
>                 Key: OFFICE-3973
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3973
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Regina Henschel
>            Priority: Major
>             Fix For: ODF 1.2 Errata 01
>
>
> This issue has been reported in https://lists.oasis-open.org/archives/office-comment/201502/msg00000.html
> Example floor(6.4;2;1) results in 6 in LibreOffice and OpenOffice. Following the description in "6.17.3 FLOOR" it would result in 8.
> A mode-value<>zero is used to get a function which is compatible to Excel's function "floor", which rounds toward zero. Therefore Gnumeric exports it's Excel compatible function "floor" to floor(number; significance;1) when exporting to ODF.
> I guess, that it is a forgotten adaption, when copying the description of "ceiling" and adapt it to "floor". Therefore I suggest to fix it in the errata.
> The suggestion of the reporter to find a better wording in general, can be handled in an issue for ODF 1.3.



--
This message was sent by Atlassian JIRA
(v7.7.2#77003)