[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-2029) (needs discussion)5.10.21 WEEKNUM - not well defined
[ http://tools.oasis-open.org/issues/browse/OFFICE-2029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eike Rathke updated OFFICE-2029:
--------------------------------
Summary: (needs discussion) 5.10.21 WEEKNUM - not well defined (was: (needs discussion) 6.9.20 Weeknum - not well defined)
Proposal:
Syntax:
WEEKNUM( DateParam Date [ ; Integer StartOfWeek = 1 [ ; Integer MinimumDaysInFirstWeek = 4 ] ] )
Constraints: 1 ≤ StartOfWeek ≤ 7, 1 ≤ MinimumDaysInFirstWeek ≤ 7
Semantics:
StartOfWeek: The day a week starts with, from 1=Sunday to 7=Saturday.
MinimumDaysInFirstWeek: The minimum number of days of a week required to be counted as the first week of a year.
Returns the number of the week in the year for the given date.
Description:
Originally issue was opened to cover missing results in test cases, but the description of Weeknum says:
"Summary: Determines the conventional non-ISO week number of the year for a given date." and "Note that this is not the ISO week number." but does not say what conventional is or what Not ISO means.
Draft25 says:
Returns the number of the week in the year for the given date. Note that this is not the ISO week number. If Type is 1, Sunday is the first day of the week; if 2, Monday is the first day of the week.
was:
Originally issue was opened to cover missing results in test cases, but the description of Weeknum says:
"Summary: Determines the conventional non-ISO week number of the year for a given date." and "Note that this is not the ISO week number." but does not say what conventional is or what Not ISO means.
"Conventional" is meaningless without context. Actually this function depends on the locale in use to determine what conventional means. The locale describes how many days of a week there must be in the first week of the year. Additionally it also describes the first day of a week. Given this, WEEKNUM should have three parameters, the DateParam and two optional parameters for days in fist week and week start.
Note: adapted Summary to 5.10.21 WEEKNUM to reflect reality in draft25.
> (needs discussion) 5.10.21 WEEKNUM - not well defined
> -----------------------------------------------------
>
> Key: OFFICE-2029
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2029
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Affects Versions: ODF 1.2 Part 2 CD 1
> Reporter: Eric Patterson
> Assignee: Eric Patterson
> Fix For: ODF 1.2 Part 2 CD 3
>
>
> Originally issue was opened to cover missing results in test cases, but the description of Weeknum says:
> "Summary: Determines the conventional non-ISO week number of the year for a given date." and "Note that this is not the ISO week number." but does not say what conventional is or what Not ISO means.
> Draft25 says:
> Returns the number of the week in the year for the given date. Note that this is not the ISO week number. If Type is 1, Sunday is the first day of the week; if 2, Monday is the first day of the week.
--
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]