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-1874

Description of Roundup is confusing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 2
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      5.17.7 ROUNDDOWN
      Summary: Rounds the value X towards zero to the number of digits specified by Digits
      Syntax: ROUNDDOWN( Number X [ ; Integer Digits = 0 ] )
      Returns: Number
      Constraints: None
      Semantics: Round X towards zero, to the precision specified by Digits. The number returned is a multiple of 10^-Digits. If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X. If Digits is positive, round towards zero to the specified number of decimal places. If Digits is negative, round towards zero to the left of the decimal point by -Digits places.

      5.17.8 ROUNDUP
      Summary: Rounds the value X away from zero to the number of digits specified by Digits
      Syntax: ROUNDUP( Number X [ ; Integer Digits = 0 ] )
      Returns: Number
      Constraints: None
      Semantics: Round X away from zero, to the precision specified by Digits. The number returned is a multiple of 10^-Digits. If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X. If Digits is positive, round away from zero to the specified number of decimal places. If Digits is negative, round away from zero to the left of the decimal point by -Digits places.

      Show
      5.17.7 ROUNDDOWN Summary: Rounds the value X towards zero to the number of digits specified by Digits Syntax: ROUNDDOWN( Number X [ ; Integer Digits = 0 ] ) Returns: Number Constraints: None Semantics: Round X towards zero, to the precision specified by Digits. The number returned is a multiple of 10^-Digits. If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X. If Digits is positive, round towards zero to the specified number of decimal places. If Digits is negative, round towards zero to the left of the decimal point by -Digits places. 5.17.8 ROUNDUP Summary: Rounds the value X away from zero to the number of digits specified by Digits Syntax: ROUNDUP( Number X [ ; Integer Digits = 0 ] ) Returns: Number Constraints: None Semantics: Round X away from zero, to the precision specified by Digits. The number returned is a multiple of 10^-Digits. If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X. If Digits is positive, round away from zero to the specified number of decimal places. If Digits is negative, round away from zero to the left of the decimal point by -Digits places.

      Description

      According to the description
      If Digits is positive, round to the specified number of decimal places. If Digits is negative, round to the left of the decimal point by -Digits places.
      So
      =ROUNDUP(1.45673; -2)
      should round to he left of the decimal point and yield 100.

      Similarly
      =ROUNDUP(9;1)
      should be 9 but this seems to be inconsistent with:
      The number returned is the smallest number that is not less than X and is a multiple of 10^Digits.

      Tha sentence should probably be:
      The number returned is the smallest number that is not less than X and is a multiple of 10^-Digits.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              aguelzow Andreas Guelzow (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: