CLONE - In function floor, mode<>0 rounds toward zero, not away from zero

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major
    • ODF 1.2 Errata 01
    • Affects Version/s: ODF 1.2
    • Component/s: OpenFormula
    • None
    • Hide

      Change the wording
      " 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 ."
      to
      "If mode is given and not equal to zero, the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied ."

      Show
      Change the wording " 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 ." to "If mode is given and not equal to zero, the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied ."
    • Hide

      [see proposal]

      Show
      [see proposal]

      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.

            Assignee:
            Unassigned
            Reporter:
            Regina Henschel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: