Issue 50000 - Allow reference results in array formulas
Summary: Allow reference results in array formulas
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://www.kantjils.nl/Competitieboek...
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-29 13:27 UTC by dbdejonge
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Attachments
Dutch Excel2003-document with arrayformulas (44.50 KB, application/vnd.ms-excel)
2005-05-29 13:35 UTC, dbdejonge 		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 dbdejonge 2005-05-29 13:27:53 UTC 
I created a Excel 2003 document with the Dutch version. The formulas in Excel
working fine, but when i opened it in Calc 1.9.104 (of 13
 may 2005).
I got errors with the transpose-formula and the array-function. The
array-function only reports the first value in the cells. I had 8 different values.

At the Url is this document available.
Comment 1 dbdejonge 2005-05-29 13:35:22 UTC 
Created attachment 26653 [details]
Dutch Excel2003-document with arrayformulas
Comment 2 dbdejonge 2005-05-29 13:36:50 UTC 
The Enter-value (alt (10)) in a cell doesn't work either.
Comment 3 dbdejonge 2005-05-29 13:41:08 UTC 
The Enter-value (alt (10)) in a cell doesn't work either.
Comment 4 thomas.lange 2005-05-30 07:28:28 UTC 
TL->NN: CLac related issue.
Comment 5 niklas.nebel 2005-06-02 15:32:34 UTC 
In fact, the errors in the attached document are caused by three different problems:

1. There are intermittent errors in string concatenation within arrays, seen in
C22:J22. This is now issue 50145, target 2.0.1.

2. The "Err:508" as well as the repeated values in column A are caused by the
use of the "range operator", which we don't have. This is issue 4904 and will be
one of the next things we add to the calculation engine (but nor for 2.0.x).
If, in the Excel file, you had used "Blad2!$A$23:$A$30" instead of
"Blad2!$A$23:Blad2!$A$30", it would be a single range reference instead, which
works fine in Calc.

3. The cells with the long formula have "Err:504" because they rely on having
cell reference results in an array formula (the combination of INDIRECT and
OFFSET). We don't support that.

Line feeds in formula results aren't supported, see issue 18302.

We'll keep this issue open as an enhancement issue for for reference results in
array formulas (point 3 above, the only thing that's not covered by other
issues), I'm adjusting the title. Other formula improvements seem more important
at the moment, so don't expect it very soon.

Summary: We need to be able to have cell range references as elements of a
matrix, so they can be used in array formulas.
Comment 6 daniel.rentz 2005-06-02 18:31:16 UTC 
Note for point 2): See also issue 48496 which is about converting a construct 
<address><range-op><address>  into a single range token on import time.
Comment 7 ooo 2005-06-02 19:20:58 UTC 
Accepted.

Removing senseless dependency on issue 27656.
Comment 8 wsfulton 2008-08-11 09:38:59 UTC 
Issue 35913 has a patch to fix the line feed aspects, ie char(10) in the formulas.
Comment 9 Marcus 2017-05-20 11:13:27 UTC 
Reset assigne to the default "issues@openoffice.apache.org".