Description: I have various ods files that have been created in previous versions of Libreoffice but after upgrading to 7.2.0.4 today the images no longer appear. If I open the file in Google Sheets the images appear as they did previously. There is also an issue when exporting to PDF where the images no longer export Steps to Reproduce: 1. Open a file where you have previously inserted images Actual Results: The object appears but you will not see the image and have to remove it and add it back in Expected Results: the image should load Reproducible: Always User Profile Reset: Yes Additional Info: Worked in previous versions, ods files still open correctly in gSheet if you upload them
Please attach a sample file. What file format do you use to save?
Created attachment 174822 [details] Sample ODS File This is a sample file with the image I will attach how it looks through Google Sheet shortly as well as through the latest LibeOffice Calc release. Previous versions appeared as per the google sheet as I create the files locally and edit via Libre and only put onto G-Drive as a backup
Created attachment 174823 [details] preview Here is a preview of the same file
I've attached a sample ods file. Files are created via Libre Office calc and saved as "ODF Spreadsheet (.ods)". I then use the export to PDF to create PDFs. Everything has worked fine for this since I started in 2012 until the latest v7.2.0.4. I install via snap so was on the last general release until it updated and today was the first time I opened calc since. The preview file shows gSheet vs Calc. File uploaded to Google Drive just now. The image there is how it was appearing within Calc until the update.
No issue for me Version: 7.2.0.4 (x64) / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Please verify Menu/Tools/Options/LibreOffice calc/View - Objects - Objects/Images - Show
Created attachment 174825 [details] Libre Office Calc Options I have that set. If I right click the image and choose replace and select another file then that appears but it still disappears when exporting to PDF. Here's the output of ```snap info libreoffice``` snap info libreoffice name: libreoffice summary: LibreOffice is a free and open source office suite publisher: Canonical✓ store-url: https://snapcraft.io/libreoffice contact: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bugs?field.tag=snap license: unset description: | LibreOffice is a free and open source office suite, developed by The Document Foundation. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. commands: - libreoffice.base - libreoffice.calc - libreoffice.draw - libreoffice.filebug - libreoffice.impress - libreoffice - libreoffice.math - libreoffice.writer snap-id: CpUkI0qPIIBVRsjy49adNq4D6Ra72y4v tracking: latest/stable refresh-date: today at 11:24 BST channels: latest/stable: 7.2.0.4 2021-09-03 (227) 732MB - latest/candidate: 7.2.0.4 2021-09-03 (227) 732MB - latest/beta: ↑ latest/edge: 7.2.0.4 2021-08-27 (227) 732MB - installed: 7.2.0.4 (227) 732MB -
Created attachment 174826 [details] Screenshot with calc and pdf No issue exporting to pdf either.
Is there anything else you would like me to try? I can't downgrade via snap as that leaves calc in a state where it crashes on launch. Writer works fine too. I'm in the middle of some development myself but I'll also restart my laptop soon to test in case there's some phantom process causing an issue
maybe it's an only Linux issue.
On pc Debian x86-64 with master sources updated today, I don't reproduce this with gtk3, gen or kf5 renderings. Could you give a try at https://wiki.documentfoundation.org/QA/FirstSteps ?
This seems to be an issue of the "snap" version. Repro in (snap version on Ubuntu 20.04) Version: 7.2.0.4 / LibreOffice Community Build ID: fa0a9af5681a0acc7909a705f92c1ada8a658552 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded No repro (using ppa:libreoffice/ppa on Ubuntu 20.04) Version: 7.1.6.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Ubuntu package version: 1:7.1.6~rc2-0ubuntu0.20.04.1~lo1 Calc: threaded No repro (TDF packages on OpenSUSE Leap 15.3) Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 174854 [details] error message Error message when trying to open the samples file from SAL_USE_VCLPLUGIN=gen libreoffice
So I tried running SAL_USE_VCLPLUGIN=gen libreoffice and then opening the file. That produced the error I just attached which appears to be pointing at a previous version of libreoffice. I've checked and I don't have a version installed from apt but /usr/bin/libreoffice is running version LibreOffice 7.1.6.2 10(Build:2) I can see its installed in the software centre so I'm going to look to clean out every installation I can find including the snap package and then try installing it again as I'm guessing it's got conflicts somewhere by having multiple versions installed
I remove all installed copies then installed from APT using sudo add-apt-repository ppa:libreoffice/ppa sudo apt-get update && sudo apt-get install libreoffice -y && sudo updatedb This gave me version 7.1.6.2 which worked as before :) I then remove it again using sudo apt-get remove --purge libreoffice* sudo apt-get clean sudo apt-get autoremove Then installed the snap package which installs 7.2.0.4 and that has the bug again. So it certainly looks like it's something in that version on snap. I'll stick with the older version for now as I need a stable version both for myself but also for clients who use it for automated processing of documents and then PDF generation all of which have embedded images
Marking as notourbug in light of comment 14