
Type: Bug

Status: Closed

Priority: Major

Resolution: Fixed

Affects Version/s: None

Fix Version/s: ODF 1.2

Component/s: OpenFormula

Labels:None

Proposal:

Resolution:
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, noninteger arguments should be truncated. It would be cleaner to use make the argumetns integer.