<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 ranges become corrupt during deletion of sheet"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=123724">123724</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>EDITING: Named ranges become corrupt during deletion of sheet
          </td>
        </tr>

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

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

        <tr>
          <th>Hardware</th>
          <td>x86-64 (AMD64)
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>Linux (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>tldr+acc@posteo.net
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
Sheet contains sheet-local references to named ranges. If that sheet is copied
and placed at the very beginning *and* deleted again, the references in
original sheet become corrupt.

The same happens if the copied sheet is placed at the end and the original
sheet is deleted. In that case the references in copied sheet become corrupt.

I will upload a minimal example spreadsheet.

The bug seems to be related to #87153 (already fixed). At least I am able to
reproduce the very same issue with the example contained in that bug report.

Let me know if you need more information.

Steps to Reproduce:
1. Copy current sheet and insert it at the very beginning.
2. Delete the newly created sheet again.
3. The yellow cell (containing a sheet-local named range) will become corrupt.

Actual Results:
Reference to named range become corrupt.

Expected Results:
Reference is still valid.


Reproducible: Always


User Profile Reset: No



Additional Info:</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>