Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-3973

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: New
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: ODF 1.2
    • Fix Version/s: ODF 1.2 Errata 01
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      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 ."
    • Resolution:
      Hide

      [see proposal]

      Show
      [see proposal]

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              regina.henschel Regina Henschel
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: