i am trying print barcode, in my sheet is working:
But when i trying print in my printer, show me the numbers:
3 Answers
You inserted your barcode as a font, this causes formatting problems when printing
As a workaround, take an approach that insert your barcode as an image instead of a font.
There are plenty third party websites that offer free bar code generation.
Try for example to insert into column B the formula
=image("http://berrywing.com/barcode/Code128.aspx?bc=" & A2)
This will generate an image from the barcode returned from the specified URL with the content of cell A2.
After i search for long time, i find some solution.
i am using the following command to produce barcode EAN13:
IMAGE("https://barcode.tec-it.com/barcode.ashx?data="&G2&"&code=EAN13&dpi=360&dataseparator="
thanks for all
Use this link to create an image. You have but to keep in mind, that the EAN13 demands exactly 12 digits (or 13 for the last digit to be the checksum), otherwise you'll get an error.
https://barcode.tec-it.com/barcode.ashx?code=EAN13&data=123456789012
to use it in sheets or excel, use this:
=image('https://barcode.tec-it.com/barcode.ashx?code=EAN13&data='&A2)
Related