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]

Reply via email to