To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84934
User terrye changed the following:
What |Old value |New value
================================================================================
Assigned to|er |spreadsheet
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Jan 3 13:59:37 +0000
2008 -------
kpalagin, I have updated the ODS to V2 to do the extra comparison, This
includes the following sheets which evaluate this function for a 36x36 test
vector:
Excel Evaluated on Excel 2003
Calc Evaluated on Calc 2.3.1
USDays360 Basic implementation of 30/360 (SIA) algo
ExDays360 Basic implementation of the Excel algo
CalcAlgo360 Basic implementation of the Calc algo
DiffExcelCalc Excel-Calc Delta
DiffExcelUSDays360 Excel-30/360 Delta
DiffCalcUSDays360 Calc-30/360 Delta
DiffExcelExDays360 Excel-Its Basic Implementation Delta(==0)
DiffCalcCalcAlgo360 Calc-Its Basic Implementation Delta(==0)
Ignore my last post of Wed Jan 2 15:27:10. I had a mind fart.
The algorithm is for two dates A,B where A<B. Excel gets dates wrong when
comparing last days of leap-years. In the defined range Calc and Excel agree, so
calc also gets it wrong. Also Microsoft has preserve this same bug since Excel
97 to ensure calculation compatibility.
Where they DO differ is in the case where A>B, in that neither error but
instead adopt different conventions: Calc flips the algo about the origin
so DAYS360(A,B)=-DAYS360(B,A) and Excel just extrapolates (meaninglessly)
backwards so that the two randomly differ by up to 2 days.
The point is that users may use DAYS360 outside of its strict use in actuarial
calcs and win such cases we might get A>B. In such cases loading a "working"
(that is doing what the user thinks is OK) spreadsheet into Calc will give
different results.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
