https://bz.apache.org/ooo/show_bug.cgi?id=128021
Issue ID: 128021
Issue Type: DEFECT
Summary: Indirect Addressing in Array Formula
Product: Calc
Version: 4.1.6
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: editing
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I have a working array formula. I added a column F to a sheet to make this
work.
{=MAX( ISNUMBER( INDIRECT(FirstRow) : INDIRECT($F29) ) * ROW(INDIRECT(FirstRow)
: INDIRECT($F29))) }
I have working Address() Functions for the start and end addresses of the range
using named ranges
Start
=ADDRESS(ROW(LdgrAnnuityBal);COLUMN(LdgrAnnuityBal))
End
=ADDRESS(ROW()-1;COLUMN(LdgrAnnuityBal))
When I substitute these addresses into the above formula I get one of a couple
invalid argument errors
{ =MAX( ISNUMBER( INDIRECT(ADDRESS(ROW(LdgrAnnuityBal);COLUMN(LdgrAnnuityBal)))
: INDIRECT(ADDRESS(ROW()-1;COLUMN(LdgrAnnuityBal))) ) *
ROW(INDIRECT(ADDRESS(ROW(LdgrAnnuityBal);COLUMN(LdgrAnnuityBal))) :
INDIRECT(ADDRESS(ROW()-1;COLUMN(LdgrAnnuityBal))))) }
It is possible that I copied and pasted incorrectly but I have now tried it at
least 10 times giving myself blank space.
A sample spreadsheet is attached.
Note that I first tried this with the Offset function with similar results.
Either fix would be acceptable. " * OFFSET has limited behaviour within an
array formula. " from the page
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_Arrays
The only Bugs I found related were Calc ID 50000 and Calc ID 86658 neither of
which seems to apply.
This could be my missing something basic. It could be a bug. It could be a
much needed enhancement.
--
You are receiving this mail because:
You are the assignee for the issue.
