[Libreoffice-bugs] [Bug 138994] Incorrect work =FORMULA()

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138994

Mike Kaganski <mikekaganski at hotmail.com> changed:

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

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201217/9886d6c7/attachment.htm>