[sc-issues] [Issue 84934] Bug in DAYS360 Algo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84934 User kpalagin changed the following: What|Old value |New value CC|'er' |'er,kpalagin' --- Additional comments from [EMAIL PROTECTED] Thu Jan 3 12:12:21 + 2008 --- terrye, could you, please, specify two dates where we differ from Excel? Thanks. - 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]
[sc-issues] [Issue 84934] Bug in DAYS360 Algo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84934 --- Additional comments from [EMAIL PROTECTED] Wed Jan 2 15:27:10 + 2008 --- Having read the documentation and looked at the test data again, I feel that Calc does provide a sensible implementation of the 30US/360 aka SIA variant algorithm. It's only Excel that is wrong. If we are intending to maintain correctness and therefore Excel incompatibility, then this should at least be reflected in the online help and documented under MSOffice-Excel incompatibilities. - 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]
[sc-issues] [Issue 84934] Bug in DAYS360 Algo
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 + 2008 --- Mail Reader Message Refers: http://www.openoffice.org/servlets/ReadMsg?list=devmsgNo=21247 User Forum Message Refers: http://user.services.openoffice.org/en/forum/viewtopic.php?f=5t=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]
[sc-issues] [Issue 84934] Bug in DAYS360 Algo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84934 --- Additional comments from [EMAIL PROTECTED] Wed Jan 2 01:18:19 + 2008 --- Created an attachment (id=50619) Spreadsheet showing bug and Basic for correct Algo - 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]