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
(In reply to Floris Dô from comment #0) > 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) Can you attach a minimal example file for this and then testers can proceed to step 2 immediately? Thanks. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 164416 [details] File before sorting and saving This is the original file, before sorting by "points" decreasing.
Created attachment 164417 [details] Example after sorting and saving
Hello, I experienced the same issue
(In reply to Camillo M from comment #3) > Created attachment 164417 [details] > Example after sorting and saving I don't reproduce the problem. Camillo: Please copy and paste here the contents of your Help - About. This allows us to know more about your system. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information. Arch Linux 64-bit Version: 6.4.5.2 Build ID: 6.4.5-2 CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: kf5; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded
Dear Floris Dô, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Floris Dô, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp