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

6.15.16 COMBINA incorrect argument type

    XMLWordPrintable

    Details

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

      6.15.16 COMBINA
      Summary: Returns the number of combinations with repetitions.
      Syntax: COMBINA( Integer N ; Integer M )
      Returns: Number
      Constraints: N >= 0, M >= 0
      Portable Constraints: N >= M
      Semantics: Returns the number of possible combinations of M objects out of N possible ones,
      with repetitions allowed. The parameters that are not integers are truncated (using INT) before use. The result is

      Show
      6.15.16 COMBINA Summary: Returns the number of combinations with repetitions. Syntax: COMBINA( Integer N ; Integer M ) Returns: Number Constraints: N >= 0, M >= 0 Portable Constraints: N >= M Semantics: Returns the number of possible combinations of M objects out of N possible ones, with repetitions allowed. The parameters that are not integers are truncated (using INT) before use. The result is
    • Resolution:
      Hide

      Applied proposal.
      Changed
      "The parameters that are not integers"
      to
      "Actual arguments that are not integers ..."
      because the parameter definitions are Integer, but the actual argument may be not.

      Show
      Applied proposal. Changed "The parameters that are not integers" to "Actual arguments that are not integers ..." because the parameter definitions are Integer, but the actual argument may be not.

      Description

      We currently have:
      ---------------------------------------------------------------
      6.15.16 COMBINA
      Summary: Returns the number of combinations with repetitions.
      Syntax: COMBINA( Number N ; Number M )
      Returns: Number
      Constraints: N >= 0, M >= 0, INT(N)=N, INT(M)=M
      Portable Constraints: N >= M
      Semantics: Returns the number of possible combinations of M objects out of N possible ones,
      with repetitions allowed. The parameters are truncated (using INT) before use. The result is
      ---------------------------------------------------------------
      The problem I see is that the specification of the argument as a number together with e constraint INT(N)=N should cause the function to return an error, but according to the semantics, non-integer arguments should be truncated. It would be cleaner to use make the argumetns integer.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: