[ http://tools.oasis-open.org/issues/browse/OFFICE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=22259#action_22259 ]
Andreas Guelzow commented on OFFICE-2913:
------------------------------------------
These definitions predate Excel's invention of WORKDAY.INTL & NETWORKDAYS.INTL and the original functions are implemented like that in at at least two distinct implementations. The order of arguments given ( DateParam Date1 ; DateParam Date2 [ ; [ DateSequence holidays ] [ ;NumberSequence workdays ] ] ) allows the original NETWORKDAYS and WORKDAY from Excel to be read in a compatible way.
> 6.10.14 NETWORKDAYS and 6.10.22 WORKDAY inconsistency
> -----------------------------------------------------
>
> Key: OFFICE-2913
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2913
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: Needs Discussion, OpenFormula
> Affects Versions: ODF 1.2 CD 05
> Reporter: Andreas Guelzow
> Assignee: Andreas Guelzow
> Fix For: ODF 1.2 CD 06
>
>
> In 6.10.14 NETWORKDAYS and 6.10.22 WORKDAY the last argument is specified as [ ;LogicalSequence workdays ] .
> In 6.10.14 it states that {1;0;0;0;0;0;1} is the default and an explanatory example gives {0;0;0;0;0;1;1}. The same is stated in 6.10.22 in a Note.
> {1;0;0;0;0;0;1} and {0;0;0;0;0;1;1} are not LogicalSequences. We should give Logical sequences here, ie. {TRUE();FALSE();FALSE();FALSE();FALSE();FALSE();TRUE()} and {FALSE();FALSE();FALSE();FALSE();FALSE();TRUE();TRUE()}.
--
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
