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

CEILING and FLOOR: allow 2nd parameter to be missing

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Change syntax of CEILING and FLOOR to

      CEILING( Number N [ ; [ Number significance ] [ ; Number mode ] ] )
      respectively
      FLOOR( Number N [ ; [ Number significance ] [ ; Number mode ] ] )

      In the definition texts, change

      If significance is omitted it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function.

      to

      If significance is omitted or an empty parameter (two consecutive ;; semicolons) it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function if mode is not given or zero.

      Replace 'ceiling' with 'floor' for the FLOOR function.

      Show
      Change syntax of CEILING and FLOOR to CEILING( Number N [ ; [ Number significance ] [ ; Number mode ] ] ) respectively FLOOR( Number N [ ; [ Number significance ] [ ; Number mode ] ] ) In the definition texts, change If significance is omitted it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function. to If significance is omitted or an empty parameter (two consecutive ;; semicolons) it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function if mode is not given or zero. Replace 'ceiling' with 'floor' for the FLOOR function.
    • Resolution:
      Hide

      Change syntax of CEILING and FLOOR to

      CEILING( Number N [ ; [ Number significance ] [ ; Number mode ] ] )
      respectively
      FLOOR( Number N [ ; [ Number significance ] [ ; Number mode ] ] )

      In the definition texts, change

      If significance is omitted it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function.

      to

      If significance is omitted or an empty parameter (two consecutive ;; semicolons) it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function if mode is not given or zero.

      Replace 'ceiling' with 'floor' for the FLOOR function.

      Show
      Change syntax of CEILING and FLOOR to CEILING( Number N [ ; [ Number significance ] [ ; Number mode ] ] ) respectively FLOOR( Number N [ ; [ Number significance ] [ ; Number mode ] ] ) In the definition texts, change If significance is omitted it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function. to If significance is omitted or an empty parameter (two consecutive ;; semicolons) it is assumed to be -1 if N is negative and +1 if N is non-negative, making the function act like the normal mathematical ceiling function if mode is not given or zero. Replace 'ceiling' with 'floor' for the FLOOR function.

      Description

      The current definitions of CEILING and FLOOR have the syntax (here using only FLOOR for illustration)

      FLOOR( Number N [ ; Number significance [ ; Number mode ] ] )

      Documents imported from alien file formats may encounter the forms FLOOR(N) or FLOOR(N and when saving to ODFF have to append the 3rd parameter to indicate the proper calculation mode. As the default value of 'significance' depends on the value of N, it is not possible to write a fixed value for 'significance'. We thus have to allow 'significance' as an empty (two consecutive ;; semicolons) parameter.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: