[OASIS Issue Tracker] Commented: (OFFICE-2017) 6.15.16 COMBINAincorrect argument type

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15264#action_15264 ] 

Andreas Guelzow  commented on OFFICE-2017:
------------------------------------------

Note that this is related tot he TODO in 6.2.5:
TODO: Walk through functions, and change all "Number" in input or result types to Integer where
appropriate. Document which integer conversion function is used (usually INT), and include test
cases to check that.


> 6.15.16 COMBINA incorrect argument type
> ---------------------------------------
>
>                 Key: OFFICE-2017
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2017
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Andreas Guelzow 
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira