Bug 141751 - QR-Codes are blurry after saving to .xls
Summary: QR-Codes are blurry after saving to .xls
Status: RESOLVED DUPLICATE of bug 51510
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-04-19 01:44 UTC by Martin Rienesl
Modified: 2021-04-19 17:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Martin Rienesl 2021-04-19 01:44:11 UTC
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
Comment 1 Martin Rienesl 2021-04-19 01:45:31 UTC
Sorry, forgot the info:
Version: (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
Comment 2 Ming Hua 2021-04-19 06:48:06 UTC
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.
Comment 3 Martin Rienesl 2021-04-19 07:19:15 UTC
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!
Comment 4 Telesto 2021-04-19 17:27:26 UTC
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 ***