<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 - [EDITING] Named range gives an ERR result when deleting a row/column of their range, range remains fine, but needs save/reload to recover their correct state."
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=108671">108671</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>[EDITING] Named range gives an ERR result when deleting a row/column of their range, range remains fine, but needs save/reload to recover their correct state.
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>5.0.5.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>miguelangelrv@libreoffice.org
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
Regresion between
Version: 4.4.7.2
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
and
Versión: 5.0.5.2
Id. de compilación: 55b006a02d247b5f7215fc6ea0fde844b30035b3
TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-0, Time:
2016-03-07_09:00:12
Configuración regional: es-ES (es_ES)

Steps to Reproduce:
1.Open attached file
2.Delete column A in Sheet1
3.Go to Sheet2
4.A1 shows #REF!
5.Hard recalc doesn't resolve.
6.Save/Reload, solves the issue.

Actual Results:  
#REF!

Expected Results:
No error


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
Firefox/52.0</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>