[OASIS Issue Tracker] Updated: (OFFICE-2913) 6.10.14 NETWORKDAYSand 6.10.22 WORKDAY inconsistency

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

     [ http://tools.oasis-open.org/issues/browse/OFFICE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andreas Guelzow  updated OFFICE-2913:
-------------------------------------

      Proposal: 
Rewrite:
6.10.14 NETWORKDAYS
Summary: Returns the whole number of work days between two dates.
Syntax: NETWORKDAYS( DateParam Date1 ; DateParam Date2 [ ; [ DateSequence holidays ] [ ;
NumberSequence workdays ] ] )
Returns: Number
Constraints: the numbers in workdays are 0 or 1
Semantics: Returns the whole number of days between two dates, ignoring weekends.
Work days are defined as non-weekend, non-holiday days. By default, weekends are Saturdays
and Sundays and there are no holidays.
The optional 3rd parameter Holidays can be used to specify a list of dates to be treated as
holidays. Note that this parameter can be omitted as an empty parameter (two consecutive ;;
semicolons) to be able to pass the set of Workdays without Holidays.
The optional 4th parameter Workdays can be used to specify a different definition for the standard
work week by passing in a list of 0-1 values which define which days of the week are
workdays (indicated by 0) in order Sunday, Monday,...,Saturday. So, the default definition of the work week excludes Saturday and Sunday and is:
{1;0;0;0;0;0;1}. To define the workweek as excluding Friday and Saturday, the third parameter
would be: {0;0;0;0;0;1;1}.

    Resolution:   (was: In 6.10.14 NETWORKDAYS and 6.10.22 WORKDAY replace
{1;0;0;0;0;0;1} with {TRUE();FALSE();FALSE();FALSE();FALSE();FALSE();TRUE()} 
and  
{0;0;0;0;0;1;1} with  {FALSE();FALSE();FALSE();FALSE();FALSE();TRUE();TRUE()}.)

leted my resolution and added a proposal to reflect what I think we agreed on.

> 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: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Andreas Guelzow 
>            Assignee: Robert Weir 
>
> 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