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-formula] Date resources (YEARFRAC)

Hi David,

On Monday, 2008-04-14 18:47:02 -0400, David A. Wheeler wrote:

> Other sources are, of course, open source implementations' code.  Here is KOffice's:
> http://api.kde.org/koffice-api/koffice-apidocs/kspread/html/helper_8cpp-source.html#l00194
> I'm sure our friends from OpenOffice.org and others can point to similar files for their code,
> in those cases where it's publicly accessible.

Sure, for OOo it's

in GetDiffParam(). Note that implementation is known to produce some few
results different from Excel. The GetDiffDate360() function for the
basis 0/4 cases may have to be aligned to the internal DAYS360
spreadsheet function that is implemented in
method ScInterpreter::ScGetDiffDate360() and just recently got slightly
modified to produce identical results to Excel. As that's not integrated
to HEAD yet see
and for reasoning and test cases see

I'll add some details about DAYS360 to my working copy of our draft,
which btw I plan to upload to the OASIS repository by the end of this
week or next week.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

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