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] Updated: (OFFICE-2245) ISOWEEKNUM definitionand second parameter

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

Eike Rathke updated OFFICE-2245:

Replace Syntax
ISOWEEKNUM( DateParam Date [ ; Integer Mode = 2 ] )
ISOWEEKNUM( DateParam Date )

Replace the entire Semantics text, including the mode table, with
Returns the ordinal number of the ISO 8601 calendar week in the year for the given date. ISO 8601 defines the calendar week as a time interval of seven calendar days starting with a Monday, and the first calendar week of a year as the one that includes the first Thursday of that year.

Remove the first two test cases.

As per agreement during conference call on 2010-10-19, remove the second parameter and change semantics details accordingly.

> ISOWEEKNUM definition and second parameter
> ------------------------------------------
>                 Key: OFFICE-2245
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2245
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Patrick Durusau
>            Assignee: Eike Rathke
>            Priority: Minor
>             Fix For: ODF 1.2 CD 06
> ISOWEEKNUM reads (under semantics):
> "Returns the number of the ISO 8601 week in the year for the given date. Note that this is not the "conventional" week number used by some applications (for that, see WEEKNUM). In this system, week number 1 of any year is the week that contains January 4, because (1) Monday is considered the first day of the week, and (2) a week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie."
> First, what is the reference "In this system..." ISO I assume? 
> Second, "conventional" week is defined only by not being the ISO 8601 week. That seems weak to me. 
> Under both definitions, there are options to start weeks on Monday or Sunday. Was that intentional? I say that because of the table under ISOWEEKNUM and the prose under WEEKNUM. How does that interact with considering Monday to be the first day of the week?
> I am looking at ways to calculate the ISO week number, not sure if that will be helpful or not. 

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]