This Native Barcode Generator is intended for Google Docs Spreadsheet users that
wish to easily integrate barcode capability into their spreadsheets without any external dependencies. This product is implemented as a single
script module with complete source code, which allows the developer greater
flexibility with implementation and design. Once imported in a spreadsheet, no other components
or fonts need to be installed to create barcodes; it is the complete barcode
generator that stays embedded in the spreadsheet.
Barcode Integration Tutorial
problems are encountered with this tutorial, IDAutomation recommends referring
to the sample included in the package. The demo version of this
product will only produce a static barcode which can not be changed.
Extract the files from the Native Barcode Google Docs Generator package.
Open the IDAutomation Google Docs Script.js file.
Select all and copy the script code in the file to the clipboard.
Open the spreadsheet.
Choose Tools - Scripts - Script editor and paste the script code into the script editor.
Choose Format - Font - Courier New and reduce the point size as much as
possible. The smaller the point size, the smaller the barcode will be.
Press enter and a barcode should appear.
To create barcodes in additional columns, move the mouse to the bottom right
of the cell and the arrow should turn into a plus sign (+); left click and drag down to the end of the column.
Once the left button is released the functions should calculate and multiple
barcodes will appear.
Legal Notice: The technology used in this product is
Patented. Reports containing this object may only be distributed outside
the licensed organization with the purchase of a Developer License to the
Native Barcode Generator for Google Docs.
Creating GS1-128 (UCC/EAN-128) Symbols
IDAutomation includes the capability in this product to create barcodes
and text for
(UCC/EAN128) with the
Apply Tilde feature
in the IDAutomationGoogleDocsBarcodeC128
DataToEncode - This string value represents
the data being encoded.
N_Dimension - Determines the width
of the wide bars, which is a multiple of the
X dimension. Valid values are 2 and 3.
The default is 2.
A Boolean value that determines whether a check digit should be automatically
calculated and included for the DataToEncode.
BarHeight - The height of the bars in the symbol;
default = 8, which is about .3 inches or 1 CM. The approximate height is
determined with the following formula: Height in Inches = (Font Size) * (BarHeight) * 0.015
Height in CM = (Font Size) * (BarHeight) * 0.04
Barcodes do not Appear in the correctly in the spreadsheet: Certain
browsers may not display the barcode correctly. Firefox for example will
produce barcodes with small gaps.
This is a limitation of the browser, or the inability of the browser to properly
represent line spaces. When a PDF is generated or the spreadsheet is printed,
the barcodes will be produced correctly.
Barcodes appear jumbled: if the spreadsheet is closed and reopened within
five minutes the barcodes may appear jumbled; this occurs because they need to
be recalculated. Recalculation occurs automatically when a PDF is generated or
the print command is issued, therefore, this is rarely an issue.
Forcing the functions to recalculate will also display the barcodes correctly.
This can be done by selecting the cells containing the barcodes and changing the
formatting in the "More Formats" drop down list. For example, if Plain Text is the current format, select Normal. This should
update the cells and the barcodes should appear normally.
Barcodes are wrapping: After the function is entered if the cell is
not wide enough the barcode may not appear as expected. Increase the width of
column to correct this issue.