Barcode128 Encoded is a macro function for LibreOffice Calc or Excel to encode texts for use with a barcode 128 font.
To create a barcode that can be read by a handscanner, it is not enough to just change the font to a barcode font. See the screenshot above; the texts or product codes (column A) must first be encoded (column B), and then the barcode 128 font is applied to the encoded texts (column C).
This results in a compact barcode, using as little space as possible, especially when the text contains just digits. For more information see Wikipedia.
- Open LibreOffice Calc
- Go to Tools > Macros > Edit macros
- Go to File > Import Basic and import the .bas file
- Go to sheet cell A1, paste a product code
- In cell B1 type the formula
=BARCODE128_ENCODED(A1) - Set font of cell B1 to Barcode 128 font and increase text size
Use the Libre Barcode 128 font on the encoded texts to print scannable barcodes.
2020-mar-30 upload to github
Questions, comments -- Bas de Reuver (bdr1976@gmail.com)