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 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=22.214.171.124&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.