https://bugs.documentfoundation.org/show_bug.cgi?id=132519
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|REOPENED |RESOLVED
--- Comment #5 from m.a.riosv <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
