To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66930 Issue #|66930 Summary|Error in nested INDEX- / LINEST (or LOGEST)-functions Component|Spreadsheet Version|OOo 2.0.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|mark_e
------- Additional comments from [EMAIL PROTECTED] Sun Jul 2 04:33:57 -0700 2006 ------- Hi, There is obviously an error in OpenOffice 2.0.3 (and earlier versions) using nested INDEX- / LINEST (or LOGEST)-functions (see attachment). The used array formula provides the entire row of the regression statistics with a single function call. I am aware that this array function can be replaced by multiple independant function calls, but since the original regression function is of higher order than this example and it is used several hundred times in a workbook, calculation time will increase significantly. All tested Excel versions provide the correct results. The used operating system is Windows XP. Best regards, Mark --------------------------------------------------------------------- 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]