<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 - After removing few lines in XLSX, some formula became #REF, though formula did not referenced into deleted lines"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131065">131065</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>After removing few lines in XLSX, some formula became #REF, though formula did not referenced into deleted lines
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.0.3 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>opensuse.lietuviu.kalba@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=158302" name="attach_158302" title="XLSX document for testing: after removing 9-40 lines, H9 cell will be REF">attachment 158302</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158302&action=edit" title="XLSX document for testing: after removing 9-40 lines, H9 cell will be REF">[details]</a></span>
XLSX document for testing: after removing 9-40 lines, H9 cell will be REF
After removing few lines in XLSX created in Microsoft Excel, some formula
became #REF.
How to reproduce:
1. Open attached document
2. Remove 9-40 lines
Result:
H9 cell contains formula =+#REF!*#REF!
Expected:
H9 cell contains formula =+G9*F9
Note, that before removing lines, this cell was H41 and it contained formula
=+G41*F41
Thus formula did not referred into removed cell.
Besides, after removing lines, doing Undo and Redo fixed formula.
I have LibreOffice 6.4.0.3 in openSUSE Linux, LibreOffice installed from RPMs
from LibreOffice site.
Versija: 6.4.0.3
Darinio identifikatorius: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
Procesoriaus gijos: 4; OS:Linux 4.12; Sąsajos pateikimas: numatytasis; VCL:
kf5;
Lokalė: lt-LT (lt_LT.UTF-8); Sąsajos kalba: lt-LT
Calc: threaded</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>