Issue 62850 - Array context of INDEX function if vector
Summary: Array context of INDEX function if vector
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, oooqa
Depends on:
Blocks:
 
Reported: 2006-03-07 07:07 UTC by ahung
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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

Attachments
poc (13.50 KB, application/vnd.ms-excel)
2006-03-08 02:14 UTC, ahung 		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 ahung 2006-03-07 07:07:21 UTC 
The function LINEST calculates parameters of the linear regression as an array 
but there is no corresponding function to return the individual elements in the 
array.  (I have looked under the arry category of the function list.)

Under Microsoft Excel, the index function is used but not supported by 
Openoffice resulting in errors when opening excel files containing index 
functions.
Comment 1 Joost Andrae 2006-03-07 17:27:00 UTC 
ja->ahung: could you please add an example to this issue where the index
function is used in that way ?
Comment 2 ahung 2006-03-08 02:14:39 UTC 
Created attachment 34659 [details]
poc
Comment 3 ahung 2006-03-08 02:15:28 UTC 
Attached is an example that works fine in excel but results in an error when 
reading the second element of the array.
Comment 4 ahung 2006-03-08 02:16:55 UTC 
And the version number for this issue should be OO2.0.1 stable
Comment 5 hwoarang 2006-03-15 03:03:11 UTC 
Confirmed with OOo-dev m158 WinXP SP2.
Changing Version due reporter comments and added 'ms_interoperability' keywork

Hwoarang
Comment 6 frank 2006-04-05 11:34:53 UTC 
Hi Eike,

could this be a double to Issue 4904 ?

Frank
Comment 7 ooo 2006-04-07 15:15:57 UTC 
Not related to the range operator (why should it be?). The INDEX() function
doesn't support the array context yet. An array is returned by the LINEST()
function.
Comment 8 frank 2006-07-11 14:55:55 UTC 
*** Issue 66930 has been marked as a duplicate of this issue. ***
Comment 9 ooo 2006-07-25 20:42:13 UTC 
In CWS calc38:
sc/source/core/tool/interpr1.cxx  1.38.80.2

In fact this was a special case of array support (general array handling btw was
already implemented) accessing one element of a vector independent of the
col/row orientation of the array parameter. The semantics of the INDEX function
here are the same as if a corresponding col/row parameter was 0, so effectively
=INDEX(array;element) for an array consisting of one row and several columns is
the same as =INDEX(array;0;element), and for an array consisting of one column
and several rows it is the same as =INDEX(array;element;0)
Comment 10 ooo 2006-07-27 14:21:04 UTC 
Reassigning to QA.
Comment 11 oc 2006-08-01 13:05:08 UTC 
verified in internal build cws_calc38
Comment 12 oc 2006-08-15 14:13:47 UTC 
closed because fix available in OOo2.0.4 (680m1)