https://bugs.documentfoundation.org/show_bug.cgi?id=138994
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |NOTABUG
--- Comment #2 from Mike Kaganski <[email protected]> ---
This is not a bug.
Your spreadsheet uses a mix of settings:
* Formula syntax is set to Calc A1 at Options|Calc|Formula [1];
* Reference syntax for string reference is set to Excel A1 at
Options|Calc|Formula|Detailed Calculation Settings [2].
The former setting makes all formulas (including those in A2) to be in Calc
syntax (with references like "$Sheet.A1"), which is correctly converted to
string by FORMULA function; but then you try to use part of that string in
INDIRECT, which is affected by the latter setting (and is expecting references
like "Sheet!A1").
It works as intended. FORMULA is expected to return the formula as it is shown
in formula bar, without any additional transformations. If you rely on Excel
syntax like that, then you need to change the former setting to Excel A1.
[1] https://help.libreoffice.org/7.0/en-US/text/shared/optionen/01060900.html
[2]
https://help.libreoffice.org/7.0/en-US/text/shared/optionen/detailedcalculation.html
--
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
