The QRCODE function allows users to generate a QR code image directly in a spreadsheet cell Excel (LibreOffice Calc).
Users can also control the image size and alignment within the cell for a clearer and more customized layout.
This function uses the online service "QuickChart" and can be used both independently and in combination with other standard spreadsheet functions.
=QRCODE(text, destination, [type], [sizing])
The QRCODE() function is easy to use. You just need to enter the image URL path and the cell where the image should be placed, and Excel (Calc) will automatically insert the required image:
=QRCODE(text; destination; type)
We will get the following result:
In this example, the following values are used:
The complete list of available QR code types can be found on the "QuickChart" page:
You can use the function QRCODE() by installing the extension YLC Utilities.
After this, this function will be available in all files opened in Excel (LibreOffice Calc).