Created attachment 191654 [details] Libreoffice calc spreadsheet demonstrating bug when exporting password protected PDF _____________ 1. Overview On Libre office Calc, under linux Ubuntu 23.10, when exporting a document as a PDF and specifying a password, the content of cells are erased when those cells have a colored background. This bug does not exist under Libre office calc on windows (tried). _______________________________________ 2. Steps required to reproduce the bug: 2.1 On linux, Open the attached spreadsheet PDF_Export_test.ods 2.2 File> Export as PDF... 2.3 In PDF Options>Security, click on [Set Passwords...] 2.4 Enter the password 'bug' in set open password "Password:" and "Confirm:" text boxes. 2.5 Click [OK] 2.6 Click [Export] 2.7 Set a name for the document and click [Export] 2.8 Open the document 2.8.1 click on the document 2.8.2 type password bug 3. review the document: the 4 first background colored rows are now empty. The only non empty rows are the last two. __________________________ 3. Contextual information This bug affects Libre Office Calc on Linux only. Tried on versions: 7.5.9.2 (Manual debian package install) and 7.6.3.2 (Snap) === LIBRE OFFICE CALC VERSION INFORMATION == Version: 7.6.3.2 (X86_64) / LibreOffice Community Build ID: 4fe86607b5ac922e55f140471fda9b60bdaa980d CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded === OPERATING SYSTEM INFORMATION === - **OS Name:** Ubuntu 23.10 - **OS Build:** (null) - **OS Type:** 64-bit - **GNOME Version:** Not Available - **Windowing System:** Wayland - **Kernel Version:** Linux 6.5.0-14-generic
Created attachment 191655 [details] Screenshot of the output pdf, which is connect when no password is entered This a screenshot of the PDF generated when using the PDF export without specifying a password.
Created attachment 191656 [details] Screenshot of the output pdf, which is INCORRECT when a password is entered
No repro with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 71c28942fbc7f36e5bcd46c5a6cdfbb3fcbcd6a0 CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
+++ Happy new year !!! +++ ______________________ 1. Update overview: The bug seems restricted to Ubuntu 23.10. In effect, in addition to the test done by raal (thank you raal), I did two other tests on a different Linux distribution on two different versions of Libreoffice which worked correctly. ______________________________________________________________ 2. Details of the additional tests 2.1. Linux distribution: Linux Mint 21.2 Xfce Edition 2.2. Tested successfully (meaning no bug) with this version: Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Flatpak Calc: threaded 2.3. Tested successfully (meaning no bug) with this version: Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4 Calc: threaded _______________________________ 3. Summary For the moment,the bug reveals itself only on Ubuntu 23.10. Under windows, Linux Mint, as well as the Linux distro used by raal, the functionality works without bug. I used this functionality successfuly in the past on Ubuntu 22.04 and 22.10.
It is possible to report bugs to Ubuntu as well: https://bugs.launchpad.net/ubuntu/+source/libreoffice/
Thank you Buovjaga I do confirm that the bug is *NOT* in Ubuntu 22.04. The bug reveals itself only on Ubuntu 23.10, whichever the version. In effect, I did test this version successfully on Ubuntu 22.04 Version: 7.6.3.2 (X86_64) / LibreOffice Community Build ID: 4fe86607b5ac922e55f140471fda9b60bdaa980d CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded I will seek to report it to https://bugs.launchpad.net/ubuntu/+source/libreoffice/ as per your suggestion.