<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 - Anchored images mess up in an .ods calc document after a FILESAVE reload"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127200">127200</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Anchored images mess up in an .ods calc document after a FILESAVE reload
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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>floris.do@laposte.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
After I saved a calc spreadsheet with anchored images after being sorted, they
loaded all wrong at file reopening
Steps to Reproduce:
1.Create a spreadsheet with images anchored to cell in one column, and any data
key in another colum
(for example: "Image" in A1, "Key" in B1, Pic1 anchored to A2 with "1" in B2,
Pic2 anchored to A3 with "2" in B3, Pic3 anchored to A4 with "3" in B4, Pic 4
anchored to A5 with "4" in B5)
2.sort them in a different order that the one they initially were in, so images
got anchored to different cells
(You should have, if you reverse the order in the example, "Image" in A1, "Key"
in B1, Pic1 anchored to A5 with "1" in B5, Pic2 anchored to A4 with "2" in B4,
Pic3 anchored to A3 with "3" in B3, Pic 4 anchored to A2 with "4" in B2)
3.save your file in .ods format
4.Open your file
Actual Results:
Pic1 was in A3 instead of A5, thus A3 got 2 pics stacked on top of each-other,
and A5 having none. If you add more images, you should have even more problems.
On my 198 entry database, around half were affected, depending on the sorting I
would use, and, weirder even, some being stretched from their key number to
their cell number, like starting on A133 to end up in cell A67, where "133" is
stored in B67, which is used as the key for sorting. stretching still occurs
when using alphabetical sorting, though, so I'm not sure it really is relevant
Expected Results:
The file should be exactly the same way as when I saved it
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: fr
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes</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>