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

Public Comment: Comment on ODF 1.2 OpenFormula (6.17 Rounding Functions)

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      #1:
      From 6.17.1 General remove the sentence
      "
      Rounding functions convert an arbitrary Number into an Integer.
      "
      The resulting section 6.17.1 General would then be empty, so completely remove it.

      #2:
      In 6.17.2 CEILING replace
      "
      the amount of N is rounded away from zero to a multiple of significance and then the sign applied
      "
      with
      "
      the absolute value of N is rounded away from zero to a multiple of the absolute value of significance and then the sign applied
      "

      #3:
      In 6.17.4 FLOOR replace
      "
      the amount of N is rounded toward zero to a multiple of significance and then the sign applied
      "
      with
      "
      the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied
      "

      #4:
      In 6.17.7 ROUNDDOWN replace
      "
      If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X.
      "
      If Digits is zero, or absent, round to the largest decimal integer whose absolute value is smaller or equal to the absolute value of X.

      #5:
      In 6.17.8 ROUNDUP replace
      "
      If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X.
      "
      with
      "
      If Digits is zero, or absent, round to the smallest decimal integer whose absolute value is larger or equal to the absolute value of X.
      "

      #6:
      In 6.17.9 TRUNC replace
      "
      Syntax: TRUNC( Number a ; Number b )
      "
      with
      "
      Syntax: TRUNC( Number a ; Integer b )
      "

      Remove
      "
      If b is not an integer, it is truncated.
      "
      as the conversion from Number to Integer is defined.

      Show
      #1: From 6.17.1 General remove the sentence " Rounding functions convert an arbitrary Number into an Integer. " The resulting section 6.17.1 General would then be empty, so completely remove it. #2: In 6.17.2 CEILING replace " the amount of N is rounded away from zero to a multiple of significance and then the sign applied " with " the absolute value of N is rounded away from zero to a multiple of the absolute value of significance and then the sign applied " #3: In 6.17.4 FLOOR replace " the amount of N is rounded toward zero to a multiple of significance and then the sign applied " with " the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied " #4: In 6.17.7 ROUNDDOWN replace " If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X. " If Digits is zero, or absent, round to the largest decimal integer whose absolute value is smaller or equal to the absolute value of X. #5: In 6.17.8 ROUNDUP replace " If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X. " with " If Digits is zero, or absent, round to the smallest decimal integer whose absolute value is larger or equal to the absolute value of X. " #6: In 6.17.9 TRUNC replace " Syntax: TRUNC( Number a ; Number b ) " with " Syntax: TRUNC( Number a ; Integer b ) " Remove " If b is not an integer, it is truncated. " as the conversion from Number to Integer is defined.

      Description

      Copied from office-comment list

      Original author: Andrea Pescetti <pescetti@openoffice.org>
      Original date: 3 Aug 2010 21:26:33 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/201008/msg00002.html

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: