Re: [office-formula] Conflict between Part 1 and Part 2

[Patrick Durusau <patrick@durusau.net>]

Eric,

Eric Patterson wrote:
> robert_weir@us.ibm.com [mailto:robert_weir@us.ibm.com] Wrote:
> ------------------------------------------------------
> I've tested this, and of the implementations represented on the TC:
>
> Gnumeric, OpenOffice, Symphony, Google and KSpread do it correctly.
>
> Excel does not.
>
> I don't think number of existing documents in non-ODF formats is extremely 
> relevant.
> ------------------------------------------------------
>
>
> The number of existing documents with this bug should have some relevance.  There are billions if not trillions of documents out there with this bug.  The days between 1-Jan-1900 and 28-FEB-1900 are less important than being able to transfer documents between applications in a way that insures that Dates, Serial Dates and all calculations involving them for dates after 1-Mar-1900 are correct.  
>
> Having a flag to indicate whether 29-Feb-1900 should be allowed as a date is fine, but there needs to be a definitive way of defining what serial number represents 1-Mar-1900 such that date calculations can occur.  Note that since dates can be serial numbers they are often included in formulas as such and cannot be identified as dates or converted during a save operation.
>
>   
Interesting point and different than simply allowing 29-Feb-1900 as a date.

Suggestions for how to define what serial number represents 1-Mar-1900? 
Particularly in light of your comment that if included in a formula, the 
origin of the value cannot be identified?

But aren't dates past 1900-3-1 at issue as well? That is to say that if 
serial numbers diverge at 1900-3-1, due to counting differently, don't 
they remain different? For any dates after that?

Interested to hear what you would suggest as a solution.

Hope you are having a great day!

Patrick
> -Eric
>
> ---------------------------------------------------------------------
> To unsubscribe from this mail list, you must leave the OASIS TC that
> generates this mail.  Follow this link to all your TCs in OASIS at:
> https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php 
>
>
>   

-- 
Patrick Durusau
patrick@durusau.net
Chair, V1 - US TAG to JTC 1/SC 34
Convener, JTC 1/SC 34/WG 3 (Topic Maps)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)