TOP

QrCode Function

QRCODE() Description

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:

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:

Example of using the QRCODE() function
Example of using the QRCODE() function

In this example, the following values are used:

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"

Download extension

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).


This function is also available in the following extensions: YLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel