Issue 66930 - ODFF: Make INDEX return an entire vector of a 2D array
Summary: ODFF: Make INDEX return an entire vector of a 2D array
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2006-07-02 12:33 UTC by mark_e
Modified: 2013-08-07 15:15 UTC (History)
3 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Error in nested INDEX- / LINEST (or LOGEST)-functions (71.50 KB, application/vnd.ms-excel)
2006-07-02 12:36 UTC, mark_e 		no flags Details
patch 1. (2.93 KB, text/plain)
2008-03-20 04:53 UTC, lvyue 		no flags Details
TestCaseSpecification (26.54 KB, text/html)
2008-06-09 09:55 UTC, oc 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description mark_e 2006-07-02 12:33:57 UTC 
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
Comment 1 mark_e 2006-07-02 12:36:38 UTC 
Created attachment 37454 [details]
Error in nested INDEX- / LINEST (or LOGEST)-functions
Comment 2 gercokees 2006-07-04 09:24:08 UTC 
I can confirm this error
Gerco-Kees
oooqa
Comment 3 frank 2006-07-11 14:55:56 UTC 
Looks like a double to Issue 62850 .

*** This issue has been marked as a duplicate of 62850 ***
Comment 4 frank 2006-07-11 14:56:28 UTC 
closed double
Comment 5 ooo 2006-10-16 18:17:22 UTC 
This is not a duplicate of issue 62850. This is about returning a vector (emtire
row or column) of a 2D array.
Comment 6 ooo 2006-10-16 18:18:23 UTC 
Grabbing issue.
Comment 7 ooo 2006-10-16 18:22:19 UTC 
Accepted.
Comment 8 Martin Hollmichel 2007-11-09 16:52:41 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 9 ooo 2007-11-14 14:03:24 UTC 
ODFF relevant.
Comment 10 lvyue 2008-03-20 04:53:38 UTC 
Created attachment 52226 [details]
patch 1.
Comment 11 ooo 2008-04-11 17:57:16 UTC 
In cws odff03:

sc/source/core/tool/interpr1.cxx  1.56.20.5
Comment 12 ooo 2008-05-09 17:01:06 UTC 
Reassigning to QA for verification.
Comment 13 oc 2008-05-16 12:18:24 UTC 
*** Issue 89550 has been marked as a duplicate of this issue. ***
Comment 14 oc 2008-05-16 12:20:02 UTC 
*** Issue 89550 has been marked as a duplicate of this issue. ***
Comment 15 oc 2008-06-09 09:55:51 UTC 
Created attachment 54333 [details]
TestCaseSpecification
Comment 16 oc 2008-06-09 09:57:32 UTC 
verified in internal build cws_odff3
Comment 17 oc 2008-10-17 10:21:08 UTC 
closed because fix available in builds OOO300_m9 and DEV300_m33