To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84934 Issue #|84934 Summary|Bug in DAYS360 Algo Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|terrye
------- Additional comments from [EMAIL PROTECTED] Wed Jan 2 01:17:00 +0000 2008 ------- Mail Reader Message Refers: http://www.openoffice.org/servlets/ReadMsg?list=dev&msgNo=21247 User Forum Message Refers: http://user.services.openoffice.org/en/forum/viewtopic.php?f=5&t=1289 In your dialogue you mentions that Excel has a bug in its implementation of 30U/360, and states that Calc MUST be compatible with Excel. Yes Excel has a bug, and NO CALC is NOT compatible with Excel. I have attached a spreadsheet * which compares Excel and Calc against 3OU/360 against a reasonable test cover showing how Excel deviates from 3OU/360 and Calc from Excel * Provides Basic functions which implements * The 3OU/360 Algo * The Excel Algo showing the bug and why it gets the wrong answer * The Calc Algo showing its bug and why it disagrees with Excel. The code in sc/source/core/tool/interpr2.cxx would be trivial to make compatible with Excel, so it seems a shame for this incompatibility to remain. Do you want me to propose a patch? --------------------------------------------------------------------- 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]
