OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


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



    [ http://tools.oasis-open.org/issues/browse/OFFICE-2343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17677#action_17677 ] 

Patrick Durusau commented on OFFICE-2343:
-----------------------------------------

OK, in part 1, we have <table:null-date> that specifies the null date. Or rather, the value of its table:date-value attribute does. Currently defaults to 1899-12-30. There are no other restrictions.

So, the "shall" part of the statement is *inconsistent* with part 1.

As far as multiple epoch starting dates, actually part 1 only allows one <table:null-date> element per instance of the syntax so it could be the case that an evaluator supported more than one but one is all you will get with any instance of OpenDocument syntax.  

Can you comment on how you would incorporate "allow-negative-dates" into the other calculations settings for tables in part 1? For example, as an attribute of <table:calculation-settings>? As a Boolean? If so, default to false?

Also, can you say a bit more about the semantics of your proposed "skip-after-feb-1900?" 

BTW, since our discussion revealed an apparent conflict between part 1 and 2, I will upgrade the status of this issue to critical. 

> 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

        


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]