[Libreoffice-bugs] [Bug 137617] Incorrect operation Sheet -> Named Ranges and Expressions -> Create

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
            Version|6.4.6.2 release             |5.3 all versions

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Apparently the formula syntax is set to ExcelA1, in this case and with
ExcelR1C1 the Create range names generates wrong references using the CalcA1
syntax (note sheet separator '.' instead of '!').

Workaround: to (re)create names from a selection temporarily switch Tools ->
Options -> Calc -> Formula, Formula Options, Formula syntax to Calc A1.

-- 
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/20201020/94d9a5d1/attachment.htm>