Re: [office-formula] Date resources (YEARFRAC)

[Eike Rathke <erack@sun.com>]

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
http://sc.openoffice.org/source/browse/sc/scaddins/source/analysis/analysishelper.cxx?view=markup

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
http://sc.openoffice.org/source/browse/sc/sc/source/core/tool/interpr2.cxx?view=markup
method ScInterpreter::ScGetDiffDate360() and just recently got slightly
modified to produce identical results to Excel. As that's not integrated
to HEAD yet see
http://sc.openoffice.org/source/browse/sc/sc/source/core/tool/interpr2.cxx?rev=1.35.20.1&view=markup
and for reasoning and test cases see
http://qa.openoffice.org/issues/show_bug.cgi?id=84934

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.

  Eike

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

PGP signature