[Libreoffice-bugs] [Bug 127200] New: Anchored images mess up in an .ods calc document after a FILESAVE reload

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127200

            Bug ID: 127200
           Summary: Anchored images mess up in an .ods calc document after
                    a FILESAVE reload
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: floris.do at laposte.net

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190828/02786656/attachment.html>