[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

--- Comment #4 from ThomasU <tnetter at gmail.com> ---
Hi Miguel,
I don't understand your reply.
What I highlighted is the incompatibility between CELL() and INDIRECT().
In a sheet imported from Excel into LibreOffice,
CELL() returns a $Sheet.A1 reference format
but
INDIRECT() wants a $Sheet!A1 reference format
This is incompatible.

Note also that Google Sheets uses the ! notation so one should be warned about
further possible incompatibilities.

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