[Libreoffice-bugs] [Bug 138646] The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name

[bugzilla-daemon at bugs.documentfoundation.org]

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

himajin100000 at gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #3 from himajin100000 at gmail.com ---
Confirmed.

RuntimeException is thrown when I use either of "Excel A1" or "Excel R1C1"

I put some SAL_INFO macros to see what's happening. Though I haven't looked the
source closer,

https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd&fi=ConvertSingleRef#1149

SAL_INFO("sc.core", OUString(p)); showed $Sheet1.$A$1 for "Calc A1", 
SAL_INFO("sc.core", OUString(p)); showed Sheet1!$A$1 for both "Excel A1" and
"Excel R1C1".

This can be problematic here, I guess.
https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd&fi=ConvertSingleRef#1185

-- 
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/20210220/261f04e7/attachment-0001.htm>