RE: [office-formula] serial number? Don't we mean serial date?

["Dennis E. Hamilton" <dennis.hamilton@acm.org>]

Rob, that's a nice breakdown of the cases.

My vote is on the lines of #4 to support the spreadsheet ecumenicalism that
seems to be part of the OpenFormula thrust and also to give the
OpenFormula-hosting specifications and their implementations the discretion
that might be required for them to embrace OpenFormula.

 - Dennis 

-----Original Message-----
From: robert_weir@us.ibm.com [mailto:robert_weir@us.ibm.com] 
http://lists.oasis-open.org/archives/office-formula/201001/msg00104.html
Sent: Thursday, January 28, 2010 07:25
To: dennis.hamilton@acm.org
Cc: office-formula@lists.oasis-open.org
Subject: RE: [office-formula] serial number? Don't we mean serial date?

I think we have four choices here:

[ ... ]

4) Set a default canonical conversion between Numbers and Dates, i.e., 
base 1900, with correct Gregorian leap year calculations, but allow this 
to be overridden by sheet-level attributes in Part 1 that allow an 
implementation to set a different date original, and a leap year 
compatibility flag.  That way, implementation can continue doing what they 
do today, but declare their behavior via these attributes, and those 
implementations that wish to adapt can do so.


-Rob



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