office message

Subject: [OASIS Issue Tracker] Issue Comment Edited: (OFFICE-1505)<table:null-date> definition

From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
To: office@lists.oasis-open.org
Date: Mon, 7 Dec 2009 06:57:15 -0500 (EST)


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

Eike Rathke edited comment on OFFICE-1505 at 12/7/09 6:56 AM:
--------------------------------------------------------------

When 1900-02-29 is included, there will always be contradiction somewhere. The null date is only used by formulas, so the description in the current  OpenFormula draft should be enough.

      was (Author: erack):
    When 1900-02-29 is included, there will always be contradiction somewhere. The null date is only used by formulas, so the description in the current  draft should be enough.
  
> <table:null-date> definition
> ----------------------------
>
>                 Key: OFFICE-1505
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1505
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Andreas Guelzow 
>            Assignee: Eike Rathke
>            Priority: Minor
>             Fix For: ODF 1.2
>
>
> The <table:null-date> element by itself may not uniquely identify the "date->numerical number" conversion for dates after 1900/3/1. This is due to the fact that some applications have an extra step from 1900/2/28 to 1900/3/1. The OpenFormula draft suggests that documents misrepresent the <table:null-date> so that calculations  after 1900/3/1 are correct. This is an unnecessary contradiction between the definition of <table:null-date> and the OpenFormula date description.
> A close related omission is that hte standard does not specify how the numerical values change as the date changes. (It is assumed in general that this is linear with slope 1 but the standard fails to specify this.)

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