OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

    [ 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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]