<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - 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">138646</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>The "Excel R1C1" formula syntax does not allow you to refer to a named range (single cell or cell range) by name
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>7.0.2.2 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>eeigor@inbox.ru
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
When I tried to access the named range when the formula syntax was "Excel R1C1"
an exception was thrown. The example file is attached.
Here is the problem:

    getCellRangeByName("NamedRange1")

Steps to Reproduce:
1. Go to Tools, Options, LibreOffice Calc, Formula and select "Calc R1C1" in
the Formula syntax dropdown menu.
2. Run the macro "Main" in the attached file.
3. Referring to a named range throws an error.

Actual Results:
Error #1 intercepted.

Expected Results:
No errors occured.
The error disappears when you select "Calc A1" in the Formula syntax dropdown
menu.


Reproducible: Always


User Profile Reset: No



Additional Info:
The same thing happens on Windows 10 and Linux Ubuntu 18.04 LTS.</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>