6.15.16 COMBINA incorrect argument type

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • 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
    • 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.

      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.

            Assignee:
            Eike Rathke (Inactive)
            Reporter:
            Andreas Guelzow (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: