<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, fileopen, filesave; A wrong sheet reference breaks the cell content"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107850">107850</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>editing, fileopen, filesave; A wrong sheet reference breaks the cell content
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.6.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>dumblob@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>1. Create a new Calc document.
2. Write into cell A1: "Sheet1.A5 + Sheet1.$A$6".
3. Write into A5: "2".
4. Write into A6: "3".
5. Save document as "test00.ods".
6. Close all running LO instances and open Calc and then the file "test00.ods".
7. Change content of cell A1 to: "Sheet1X.A5 + Sheet1.$A$6" and press Enter.
#REF! appears instead of the number "5".
8. Click on the cell A1 and look at the content - "Sheet1X.A5" changed to
"#REF!.A5". This is the first bug (the correct behavior would be to leave the
cell content as it was).
9. Save the document (again to "test00.ods").
10. Close all running LO instances and open Calc and then the file
"test00.ods".
11. Click on the cell A1 and look at the content - "#REF!.A5" changed to
"#REF!". This is the second bug (the correct behavior would be to leave the
cell content as it was).
Few months ago I was working with a simple .ods spreadsheet referencing other
sheets from the same document and after writing one reference incorrectly
(similar to above), it changed itself to a weird reference to a file (but this
reference was incorrect and not functional). Back then I didn't have time to
report bugs in this Bugzilla and right now I can't reliably reproduce it, so
I'm just mentioning it for the person who'll dive into the referencing code to
check if there is not any visible bug with sheet references changing to file
references.</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>