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-2343

3.3.3 Date and DateTime - 1900 as leap year

    XMLWordPrintable

    Details

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

      Rephrase the two portable notes in 3.3.3 Date and DateTime to:

      Note: Expression authors should consider that the epoch date may vary
      between implementations. Expressions that assume a particular epoch
      date may have different results depending on the implementation

      and

      Conforming evaluators shall support positive serial numbers. They may
      support negative serial numbers to represent dates before the epoch.

      Note: Expression authors should consider that it is evaluator
      specific whether 1900 is considered to be a leap year.

      Note: It is recommended that evaluators that consider 1900 to be a
      non leap year use the epoch date 1899-12-30 to compensate
      for serial numbers originating from evaluators that consider 1900
      to be a leap year and use the 1899-12-31 epoch date.

      Reject the change that added " Office-2343"

      Show
      Rephrase the two portable notes in 3.3.3 Date and DateTime to: Note: Expression authors should consider that the epoch date may vary between implementations. Expressions that assume a particular epoch date may have different results depending on the implementation and Conforming evaluators shall support positive serial numbers. They may support negative serial numbers to represent dates before the epoch. Note: Expression authors should consider that it is evaluator specific whether 1900 is considered to be a leap year. Note: It is recommended that evaluators that consider 1900 to be a non leap year use the epoch date 1899-12-30 to compensate for serial numbers originating from evaluators that consider 1900 to be a leap year and use the 1899-12-31 epoch date. Reject the change that added " Office-2343"

      Description

      Currently we say:

      ***
      Many applications cannot handle Date values before January 1, 1900. Some applications can handle dates for the years 1900 and on, but include a known defect: they incorrectly presume that 1900 was a leap year (1900 was not a leap year). Applications may reproduce the 1900-as-leap-year bug for compatibility purposes, but should not.
      ***

      Rob Weir suggests that we should not make editorial comments about bugs, compatibility, etc. I think that is a good point.

        Attachments

          Activity

            People

            • Assignee:
              michael.brauer Michael Brauer (Inactive)
              Reporter:
              patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: