Description: Used the function Insert -> Object -> QR-Code. Saved the file as .xls. Reopened the file and got a completely blurry image of the QR-code. Looks like it gets converted to PNG while saving, and either either something goes horrible wrong when it gets converted from vector based to pixel based or the PNG compression messes up. This does not happen when saving to .ods. However, the object properties get lost and the QR-Code is handled as an ordinary, vector based image Steps to Reproduce: 1. Open a new sheet in calc 2. create a random content QR-Code (Insert -> Object -> QR-Code) 3. save the file as .xls 4. reopen the file Actual Results: QR-Code gets converted to a blurry png Expected Results: Perfect result: QR-Code stays a vector based object with all its properties (I assume the .xls file format does not allow that, but for .ods I would expect that) Good result: QR-Code stays a vector based image (again I am not sure if the .xls file format allows that, but for .ods I would expect that) Acceptable result: QR-Code gets converted in a loss less pixel based image Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Sorry, forgot the info: Version: 7.0.4.2 (x64) Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Thanks for reporting. It is known that exporting SVG images (and QR code is an SVG image) to MS formats is problematic, see bug #51510. There is also bug #127234 that is about saving QR code as PNG format with poor result. This bug is likely a DUPLICATE of either of them, as the code for generating and converting QR code is the same for Writer and Calc. I don't know enough to make a decision though, and will just mention them and leave this bug to others.
As Mike Kaganski writes on bug #127234, saving into an MS Office file is just causung this bug to show up. The problem is the progress, where a tiny bitmap is created out of the vectors and scaled to the size shown in the document. This is more or less described in bug #51510, but hell, this bug was created 9 years ago!
Thanks for reporting. Known - old - bug :-( Adding it too it, more duplicates & more people in CC increases changes of a fix *** This bug has been marked as a duplicate of bug 51510 ***