<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:himajin100000@gmail.com" title="himajin100000@gmail.com">himajin100000@gmail.com</a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138646">bug 138646</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138646#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138646">bug 138646</a>
from <span class="vcard"><a class="email" href="mailto:himajin100000@gmail.com" title="himajin100000@gmail.com">himajin100000@gmail.com</a>
</span></b>
<pre>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,
<a href="https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd&fi=ConvertSingleRef#1149">https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd&fi=ConvertSingleRef#1149</a>
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.
<a href="https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd&fi=ConvertSingleRef#1185">https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/address.cxx?r=1250aecd&fi=ConvertSingleRef#1185</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>