[Libreoffice-bugs] [Bug 34938] New: INDEX function gives error:511 for cell range from other spreadsheets

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=34938

           Summary: INDEX function gives error:511 for cell range from
                    other spreadsheets
           Product: LibreOffice
           Version: LibO 3.3.1 release
          Platform: All
        OS/Version: Windows (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: geza at kzsdabas.hu


We have a quite complex spreadsheet which uses data from other xls and ods
files.
It contains some INDEX functions, which operates on those data (as a side-note,
the MATCH functions, which also works from the same files are working as
expected).
The spreadsheet was created originally with an ancient version of Openoffice
(the Hungarian version, based on go-ooo sources) and later used without
problems with each version of Openoffice up until 3.2.1. The problem appeared
at upgrading to LibreOffice 3.3.0, and later 3.3.1. At the same time, if I try
to reproduce the problem creating a new spreadsheet with only one INDEX
function in it, with the cell range from an other spreadsheet, after closing
the function wizard, the reference to the other file ('file://....) disappears
and Calc errors about a wrong formula.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.