https://bugs.documentfoundation.org/show_bug.cgi?id=164614
nutka <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from nutka <[email protected]> --- Note that the _internal_ file "settings.xml" contains the entry: <config:config-item config:name="SyntaxStringRef" config:type="short">2</config:config-item> The value 2 signifies using "Excel A1" as the reference syntax for string reference. If I open "createdin24-8-3.ods" (with 24.8.3.2 or 24.8.4.2), I see it in the "Detailed Calculation Settings" dialog. According to Help [1]: --------- Reference syntax for string reference Formula syntax to use when parsing references given in string parameters. This affects built-in functions such as INDIRECT that takes a reference as a string value. --------- It might be that CELL function belongs to the functions mentioned above, hence with the "Excel A1" syntax choosen it returns the file name in square brackets. Anyway, if in the said dialog I change "Excel A1" to "Calc A1", save the file and open it again, the brackets are no longer there. Refs: [1] topic "Detailed Calculation Settings" https://help.libreoffice.org/24.8/en-US/text/shared/optionen/detailedcalculation.html?DbPAR=CALC#par_id3859675 -- You are receiving this mail because: You are the assignee for the bug.
