[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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|REOPENED                    |RESOLVED

--- Comment #5 from m.a.riosv <miguelangelrv at libreoffice.org> ---
INDIRECT($Sheet2!A1) the function gets the value in $Sheet2!A1 and tries to
interpreter their vallues as an address string.
For this the option is Menu/Tools/Options/LibreOffice Calc/Formula - Formula
options - Formula syntax

INDIRECT("$Sheet2!A1") gets the value in $Sheet2!A1
for this one it's the already mentioned Menu/Tools/Options/LibreOffice
Calc/Formula - Detailed calculation settings - Custrom .... - Refence syntax
for string reference

Indirect help
https://help.libreoffice.org/6.4/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153181

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