To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106118 Issue #|106118 Summary|LINEST uses incorrect default parameter Component|Spreadsheet Version|OOO310m19 Platform|PC URL|http://www.rrts.us/openoffice/LINEST default parameter | problem demo.ods OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|robert_rossi
------- Additional comments from [email protected] Wed Oct 21 02:42:57 +0000 2009 ------- The OOo implementation of LINEST works correctly if the optional third and fourth parameters are omitted, however the third parameter incorrectly defaults to FALSE if the fourth parameter is specified but not the third. That is, LINEST(range;range;;1) incorrectly returns the results for LINEST(range;range;0;1) rather than the expected LINEST(range;range;1;1) (per LINEST helpfile) This is demonstrated in the document linked through the URL above. (I prepared it thinking I could send an attachment, but don't see a way to do so here.) --------------------------------------------------------------------- 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]
