[OASIS Issue Tracker] Updated: (OFFICE-2343) 3.3.3 Date andDateTime - 1900 as leap year

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

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

Dennis Hamilton updated OFFICE-2343:
------------------------------------

    Fix Version/s: ODF 1.2 Part 2 CD 2
         Assignee: Dennis Hamilton

Assigned this and set the fix version target.

1. The statement that this issue is about should be deleted.

2. The language of the section needs to be cleaned up to talk about serial days (the only Number type cases) and not confuse them with the text representation of calendar dates and times.

3. With that change made, we can be clear that time within a day is as a fraction of 1 day.  An hour is 1/24 day, a minute is 1/(24*60) of a day, etc.

4. With regard to the range of dates supported, that needs to be in terms of what the range of allowed serial days is, the date that serial day 1 (or 0) corresponds to -- we need to choose, and what calendar mapping is used to correspond all other allowed serial days to allowed calendar dates.   These are all ambient properties.

5. We can probably define an understood range based on DATE(year, month, day) that establishes the portable case for a Gregorian calendar mapping without much difficulty, and we might do that.  

[I set CD2 as the fix target because this may take a while to hammer out.]

> 3.3.3 Date and DateTime - 1900 as leap year 
> --------------------------------------------
>
>                 Key: OFFICE-2343
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2343
>             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: Patrick Durusau
>            Assignee: Dennis Hamilton
>             Fix For: ODF 1.2 Part 2 CD 2
>
>
> 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. 

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