To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93527
Issue #|93527
Summary|INTRATE and RECEIVED functions different to Excel
Component|Spreadsheet
Version|OOo 2.4.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P4
Subcomponent|programming
Assigned to|spreadsheet
Reported by|drking
------- Additional comments from [EMAIL PROTECTED] Fri Sep 5 16:40:03 +0000
2008 -------
Both these functions involve deciding how many days are in a year (and more
particularly, *which* year); Calc and Excel do it slightly differently in basis
1.
Calc uses the year containing the settlement date.
Excel is more subtle - I think it is documented in OOXML, but I'm not sure if
Excel actually follows that exactly. David Wheeler has done some work on this
for ODFF. It's something like "366 only if Feb29 is included, otherwise 365".
Examples:
INTRATE("2008-09-02"; "2009-03-02"; 1000; 1080;1)
RECEIVED("2008-09-01"; "2009-03-31"; 10000; 5%; 1)
This is not of great importance - but worth making a note of I hope.
---------------------------------------------------------------------
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]
