DO NOT REPLY [Bug 118653] New: Cannot retrieve Named Range values in Basic when named ranges are defined with OFFSET

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=118653

             Bug #: 118653
        Issue Type: DEFECT
           Summary: Cannot retrieve Named Range values in Basic when named
                    ranges are defined with OFFSET
    Classification: Code
           Product: scripting
           Version: OOo 3.4 Beta
          Platform: PC
        OS/Version: Windows 7
            Status: NEW
          Severity: normal
          Priority: P5
         Component: code
        AssignedTo: kr@openoffice.org
        ReportedBy: truk@openoffice.org
                CC: ooo-issues@incubator.apache.org


I have named range defined using an OFFSET function (see attached) and one
using a conventional address.

When I refer to these named ranges in a cell of the spreadsheet the behaviour
is as expected. However, I cannot retrieve the referenced cells for the OFFSET
named range in BASIC using .getReferredCells() as it returns a null object.

Any assistance would be appreciated.

truk

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

DO NOT REPLY [Bug 118653] Cannot retrieve Named Range values in Basic when named ranges are defined with OFFSET

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=118653

--- Comment #1 from truk <tr...@openoffice.org> 2011-11-28 13:35:35 UTC ---
Created attachment 77053
  --> https://issues.apache.org/ooo/attachment.cgi?id=77053
file demonstrating the correct functioning of the named range in sheet but
failing in Basic

OFFSET in named range prevents the retrieval of values in BASIC

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.