[Libreoffice-bugs] [Bug 132519] 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

ThomasU <tnetter at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
     Ever confirmed|0                           |1
         Resolution|NOTABUG                     |---

--- Comment #2 from ThomasU <tnetter at gmail.com> ---
Hi Miguel,
Many thanks for your quick response and useful input. I think there maybe is
still a bug.
Say I use in Sheet1 the CELL() function to generate the string to reference
another sheet. Then CELL will return a string in the form $Sheet2.A1
However, if I use INDIRECT($Sheet2.A1) I get an error.
If I use INDIRECT($Sheet2!A1) then it works (note the exclamation mark).
So this is very very confusing! The function used to generate the needed string
outputs in LibreOffice format with a dot separator but, in the context of this
Excel import, the function to use the string wants Excel format with an
exclamation mark separator.
So there is a kind of bug somehow. There could at least be a warning telling
the user to set Options/LibreOffice Calc/Formula - Detailed calculation
settings - Custom  to CalcA1. The error is really obscure to the user.

-- 
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/bea7b595/attachment.htm>