You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2019/01/27 23:48:20 UTC
[Issue 128021] New: Indirect Addressing in Array Formula
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: issues@openoffice.apache.org
Reporter: scified@gmail.com
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.
[Issue 128021] Indirect Addressing in Array Formula
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128021
--- Comment #1 from scified@gmail.com ---
*** Issue 128020 has been marked as a duplicate of this issue. ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128021] Indirect Addressing in Array Formula
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128021
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|FIXED |FIXED_WITHOUT_CODE
--- Comment #4 from Marcus <ma...@apache.org> ---
Thanks for your feedback. I'm changing the status as there was no fix in the
OpenOffice code.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128021] Indirect Addressing in Array Formula
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128021
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128021] Indirect Addressing in Array Formula
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128021
--- Comment #2 from scified@gmail.com ---
Created attachment 86624
--> https://bz.apache.org/ooo/attachment.cgi?id=86624&action=edit
Sample File showing working and non-working examples
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128021] Indirect Addressing in Array Formula
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128021
scified@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|UNCONFIRMED |RESOLVED
--- Comment #3 from scified@gmail.com ---
This was a formula error. The Forum did not see it. But after submission
another respondent found the error.
--
You are receiving this mail because:
You are the assignee for the issue.