BarCode Function

BARCODE() Description

The BARCODE function allows users to generate a barcode 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 "TEC-IT" online service and can be applied both independently and in combination with other standard table functions.

Main Characteristics of the BARCODE Function

Syntax:

=BARCODE(text, destination, [type], [sizing], [lock])

Parameters:

• text: Text to be converted into a barcode.
• destination: Reference to the cell where the image should be placed.
• [type]: (Optional) Barcode type ("code128" (default), "code39", "ean13", "ean8", "upca", "upce" etc.).
• [sizing]: (Optional) Defines the image dimensions. There are several possible values:
  0. Insert the image into the cell and preserve its aspect ratio. Selected by default.
  1. Fill the cell with the image and ignore its aspect ratio.
  2. Preserve the original image size, which may exceed the cell boundaries.
• [lock]: (Optional) Whether to fix the position and size of the image: 0-No, 1-Yes.

Example of Use

The BARCODE() function is easy to use. You just need to enter the URL path to the image and the cell where the image should be placed, and Excel (Calc) will automatically insert the required image:

=BARCODE(text; destination; type)

We will have the following result:

This example uses the following values:

• text: A2 - the text to be converted into a barcode ("ABC-abc-1234").
• destination: D2 - the cell where the image will be located ("D2").
• type: B2 - Barcode type ("code128").

Where to Get a Full List of Barcode Types?

A complete list of available barcode types can be found on the following page: "Supported Barcode Types"

Download extension

You can use the BARCODE() function by installing the YLC Utilities extension.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).