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: Re: [office] YEARFRAC, basis==0

Hi David,

On Thursday, 2008-04-17 12:09:19 -0400, David A. Wheeler wrote:

> In my previous post, I noted that YEARFRAC with basis==0 was radically
> different between Excel 2007 and the Ecma spec.  Any difference is bad,
> but this is the DEFAULT basis for many functions.
> For completeness, I will document the differences here for basis==0.

Could you please check if your findings now produce identical results
with the data attached to

If so, this would mean that the algorithms for DAYS360() US-method and
YEARFRAC(...;basis=0) would be identical. If not, it would raise the
question why not ...


 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS

PGP signature

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