Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2029

5.10.21 WEEKNUM - not well defined

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Replace Summary with:
      Determines the week number of the year for a given date.

      In Syntax rename Type to Mode.

      Add Constraints: 1 ≤ Mode ≤ 2, or 11 ≤ Mode ≤ 17, or Mode = 21, or Mode = 150

      Replace Semantics with:
      Returns the number of the week in the year for the given date.
      For Mode=

      {1, 2, 11, 12, ..., 17}

      the week containing January 1 is the first week of the year, and is numbered week 1. The week starts on

      {Sunday, Monday, Monday, Tuesday, ..., Sunday}

      .
      Mode 21 or 150 are both ISO 8601, the week starts on Monday and the week containing the first Thursday of the year is the first week of the year, and is numbered week 1.

      Show
      Replace Summary with: Determines the week number of the year for a given date. In Syntax rename Type to Mode. Add Constraints: 1 ≤ Mode ≤ 2, or 11 ≤ Mode ≤ 17, or Mode = 21, or Mode = 150 Replace Semantics with: Returns the number of the week in the year for the given date. For Mode= {1, 2, 11, 12, ..., 17} the week containing January 1 is the first week of the year, and is numbered week 1. The week starts on {Sunday, Monday, Monday, Tuesday, ..., Sunday} . Mode 21 or 150 are both ISO 8601, the week starts on Monday and the week containing the first Thursday of the year is the first week of the year, and is numbered week 1.

      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.

        Attachments

          Activity

            People

            • Assignee:
              ericpa Eric Patterson (Inactive)
              Reporter:
              ericpa Eric Patterson (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: