<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: Data validity fails after copying sheet and deleting original sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135482">135482</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Data validity fails after copying sheet and deleting original sheet
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>rmkelly314@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
After defining a "cell range" data validity in a sheet and then copying that
sheet, the data validity is RIGHT in the new sheet. If you then delete the
original sheet, the data validity is WRONG in the new sheet. Instead of
containing valid entries, the selection list contains only "#REF!".
Steps to Reproduce:
1. Load the attached spreadsheet.
2. On Sheet2, observe that D1’s selection list works correctly.
3. Delete Sheet1.
4. On Sheet2, observe that D1’s selection list now works incorrectly.
Actual Results:
After deleting Sheet1, Sheet2.D1's selection list contains only "#REF!".
Expected Results:
After deleting Sheet1, Sheet2.D1's selection list should still contain "aaa",
"bbb", and "ccc".
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
>From "Help / About LibreOffice":
Version: 6.3.6.2 (x64)
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
OS: Microsoft Windows 10 Home, Version 10.0.19041 Build 19041</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>