Issue 87268 - labels doesn't work in array formulas
Summary: labels doesn't work in array formulas
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-03-19 22:00 UTC by mroe
Modified: 2017-05-20 11:11 UTC (History)
2 users (show)

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

Attachments
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 mroe 2008-03-19 22:00:25 UTC 
E. g. having a column labelled 'Result'.

=SUM('Result')
works. But

{=SUM('Result'>0)}
doesn't work.
The results (error or 0) differs, if one insert label ranges
(Insert\Names\Labels...) or not.


Greetings
	Mathias
Comment 1 ooo 2008-03-20 12:14:46 UTC 
In array context using a label should not generate a position dependent
reference. Probably correct would be to generate an array instead, similar to
{=A1:A3} as opposed to =A1:A3. However, "the other spreadsheet application"
generates a #N/A error in that case. Not sure if there is a reason other than
implementation details, will have to investigate.
Comment 2 drking 2008-03-20 18:15:56 UTC 
With a column headed Result containing {9|4|16}:
{=SQRT('Result')}
will return an array {3|2|4}

The trouble is that if you then add a number onto the end of the column, Result 
is a different size, but the output array size of course remains unchanged.

It's horribly messy from a user's viewpoint - are you really *really* sure you 
want to attack this? ;)

You might consider simply not allowing labels in array formulae - is that what 
Excel does? The whole concept of arrays seems to me to be inelegant and messy 
(yes, we can blame 'the other spreadsheet'), so there has to be a realistic 
limit on what the user can expect from them.
David
Comment 3 Marcus 2017-05-20 11:11:15 UTC 
Reset assigne to the default "issues@openoffice.apache.org".