To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109264 Issue #|109264 Summary|Unexpected #VALUE! error in LINEST Component|Spreadsheet Version|OOo 3.2 RC5 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|pescetti
------- Additional comments from pesce...@openoffice.org Sun Feb 14 22:08:26 +0000 2010 ------- The Calc file I will attach shortly contains a 5x2 matrix, with red background, showing wrong results (actually, #VALUE! errors) given by LINEST(). Reportedly, if you save the file in XLS format and open it with Microsoft Excel, you are given sensible results and no errors. Maybe a numerical stability problem? [Reported by Antonio Ricci during Italian QA tests] --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org