Description: I have a sheet with many strings that occupy more rows and relative images near them. That images are biger than row and they are anchor to the cell. They are also fixed in position and dimension. If I filter the rows with the strings the result is ok. Images are ok. Problems come when I save the file (.ods) with filter activated. The images are not anymore well placed when I open again the file. I should save the file with the filter not applied. There is a mistake or I'm wrong? Steps to Reproduce: 1.fill more rows with the same data and put one image big as the total hight of that rows 2. repeat step 1. for other data and image 3. try to filter the rows by autofilter option 4. if you save the file with filter not applied images come corrected when you reopen the file itself 5. if you save the file with filter applied, images are messed up when you reopen the file itself Actual Results: if I save the file with filter applied, images are messed up when I reopen the file itself Expected Results: if I save the file with filter applied, I expected images in order as they were originally when I reopen the file Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: CL
Created attachment 173098 [details] This is a correct file (not filtered). Make a copy with filtered version also. try filter by column A
No repro Version: 7.1.4.2 / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded see also https://ask.libreoffice.org/en/question/314950/calc-problems-with-filter-of-rows-with-images/
Yes, i can confirm this bug. it doesn't work when i reopened the file after autofilter was applied. I applied autofilter to options: "a";"b";"c";"d";"a,c";"a,b";"a,d" repro in Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded also repro in Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 0d4cbdbc9cd4ab06056cec66cffd292b41615b6e CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 173783 [details] autofilter for a&c this is the result of my actions: 1. click autofilter, select "a,c" 2.close file before saving it. 3. open file. autofilter save "a,c" option. 4.click autofilter, select "all" somthing went wrong- images are messed up.
Created attachment 187346 [details] Original file with all images before save with filter
Created attachment 187347 [details] Final file with lost image after save with filter
Hi, i have opened this on ask.libreoffice.org https://ask.libreoffice.org/t/libreoffice-auto-filter-remove-images-from-filtered-row-after-save-close-reopen-file/91566 Some user give me the hint that my problem is the same described here the only difference is that, save with filter active, make all the filtered image disapper (or moved in some inaccessible part of the sheet..i don't know) ---------------------------------------------------------------------------------- This is the content i put in ask.libreoffice.org, is alwasy reproducible: ---------------------------------------------------------------------------------- Hi, sorry for my english…is not my primary language im using LibreOffice 7.4.2.3 but the same problem is in portable 7.5.2 and in an old 5.3.3.2 and different company computers (we have deployed libreoffice instead of office in the company) for example i have spreadsheet with 3 column and a few rows, one of this column has images anchored to the current cell (the problem arise with every file, new old, in ods, xlsx, xls format) the steps to reproduce the error are these: enable an auto-filter (or standard filter.) and select some value the sheet correctly show the filtered rows with the right images if i save with filter active, close, reopen and remove the filter…all the images are lost the only images that survive are the one filtered in step 2 if in the step 3…i remove the filter before save, the images are preserved i have tried various libreoffice version, save formats, image format, the behaviour is always the same…images lost:( for what i see the images are in the file because the file has the right filesize and if i use f5 and go to the images list…i see all the references to the images… …but i can’t drag and drop the images in the sheet i have attached two files: the original file with all images present and the file with images lost is in xls file…but format is not important, i have done all the test with a new ods and xlsx format I really hope someone know how to fix this problem…we really appreciate LibreOffice and we have done the bet to use it instead od office for the majority of our user…but sometime there is those strange things that create a lot of trouble for the normal users
I get the error only if I open the xls file, which is attached to the mentioned Ask, and save it back as xls. When I save to ods, the images are all present. Tested with Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 32; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded
Thanks for the info Regina:) also on my version 7.6.2.1 saving in ods solve the trouble, i hope in the future this issue will be fixed at least for xlsx