[Libreoffice-bugs] [Bug 132519] New: INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: tnetter at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200429/ae84e12c/attachment.htm>