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.
An internet connection is required for this function to work.
Key Features of the QRCODE Function
Syntax:
=QRCODE(text, destination, [type], [sizing])
Parameters:
text: The text to be converted into a QR code.
destination: A reference to the cell where the image should be placed.
[type]: (Optional) Type of QR code ("qrcode" (default), "datamatrix", "azteccode", "hanxin", "dotcode" etc.).
[sizing]: (Optional) Defines the image dimensions. There are several possible values:
Insert the image into the cell and preserve its aspect ratio. Selected by default.
Fill the cell with the image and ignore its aspect ratio.
Preserve the original image size, which may exceed cell boundaries.
Example of Use
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:
text:A2 - The text to be converted into a QR code ("This is a QR Code by YLC").
destination:D2 - The cell where the image will be located ("D2").
type:B2 - Type of QR code ("qrcode").
Where to Get the Full List of QR Code Types?
The complete list of available QR code types can be found on the "QuickChart" page: "Supported Barcode Types"
