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.