Issue 87268

Summary: labels doesn't work in array formulas
Product: Calc Reporter: mroe <mroe.nospam>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, openoffice
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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".