[ http://tools.oasis-open.org/issues/browse/OFFICE-2343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676#action_17676 ]
Andreas Guelzow commented on OFFICE-2343:
------------------------------------------
Re my first comment: I think that in addition to an epoch starting date we should simply have two additional characteristics "skip-after-feb-1900" and "allow-negative-dates". I believe that would characterize all date->number mappings currently in use.
The reformulation suggestion regarding my second comment sounds good to me, but as far as I know there is no evaluator in place that supports more than two different epoch starting date (or am I mistaken there)?
regarding the third comment please see the first paragraph of this comment.
> 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
