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