https://bugs.documentfoundation.org/show_bug.cgi?id=132519

            Bug ID: 132519
           Summary: INDIRECT() to other sheet from Workbook imported from
                    Excel fails with Ref!
           Product: LibreOffice
           Version: 7.0.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

If one creates an Excel workbook, e.g. in Excel 2010, and then imports it into
LibreOffice, then create INDIRECT() to reference a cell in another sheet of the
workbook, this causes a #REF! error. If one starts with a fresh LibreOffice
sheet then this bug does not occur. 
See also:
https://ask.libreoffice.org/en/question/215844/syntax-for-indirect-to-access-another-sheet/?answer=241395#post-id-241395

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to