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

*Subject*: **Re: [office-formula] Calculation Settings**

*From*:**robert_weir@us.ibm.com***To*: "office-formula@lists.oasis-open.org" <office-formula@lists.oasis-open.org>*Date*: Fri, 15 May 2009 18:25:04 -0400

Here's what I'm thinking: We have an abstract machine that does operations on dates. Dates, when stored, are stored as ISO 8601 strings. We also define explicit and implicit ways of converting numeric data into dates. The implict coercion method has one or more parameters, one of which is the date basis. I think we want to avoid talking about doing date calculations on numeric data. Someone should be able to implement OpenFormula on a library that does date arithmetic using any date representation, whether integer serial numbers, floating points, Y/M/D/H/M/S records, or whatever. I don't think we should care. What we really need to define is the type conversion. If we state it along those lines (conceptually -- obviously the text would need to be more fully articulated) would that do the job? -Rob "Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca> wrote on 05/15/2009 06:04:50 PM: > > I think what one really should want is a specification of the serial > number matching 1904-1-1 and a statement how days and changes in serial > numbers are related.

**Follow-Ups**:**Re: [office-formula] Calculation Settings***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**References**:**[office-formula] Calculation Settings***From:*Eric Patterson <ericpa@exchange.microsoft.com>

**Re: [office-formula] Calculation Settings***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**RE: [office-formula] Calculation Settings***From:*Eric Patterson <ericpa@exchange.microsoft.com>

**RE: [office-formula] Calculation Settings***From:*"Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>

**Re: [office-formula] Calculation Settings***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**Re: [office-formula] Calculation Settings***From:*"Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>

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