Barcode Generator for Google Docs Sheets Manual
- Product Overview
- Integration Tutorial
- Technical Support
- Google Docs Barcode Implementation Guide
- Barcode Scanners and Verifiers
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.
If 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 - Script editor and paste the script code into the script editor.
- Select the Save icon to save the script.
In the cell to create the barcode, type the equal sign followed by the
function and parameters.
- 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.
The following functions are available:
- 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.
- IncludeCheckDigit - 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
|Code-128 Auto||IDAutomationGoogleDocsBarcodeC128(DataToEncode, ApplyTilde, BarHeight)|
|Code 128 A||IDAutomationGoogleDocsBarcodeC128a(DataToEncode, BarHeight)|
|Code 128 B||IDAutomationGoogleDocsBarcodeC128b(DataToEncode, BarHeight)|
|Code 128 C||IDAutomationGoogleDocsBarcodeC128c(DataToEncode, BarHeight)|
|Code-39||IDAutomationGoogleDocsBarcodeC39(DataToEncode, IncludeCheckDigit, N_Dimension, BarHeight)|
|Codabar||IDAutomationGoogleDocsBarcodeCodabar(DataToEncode, N_Dimension, StartChar, StopChar, BarHeight)|
|Interleaved 2-of-5||IDAutomationGoogleDocsBarcodeI2of5(DataToEncode, IncludeCheckDigit, N_Dimension, BarHeight)|
|MSI||IDAutomationGoogleDocsBarcodeMSI(DataToEncode, IncludeCheckDigit, N_Dimension, BarHeight)|
Additional solutions may be searched for in the public forum threads. Priority phone, email and forum support is provided up to 30 days after purchase. Additional priority phone, email and forum support may be obtained if the Priority Support and Upgrade Subscription is active.
Barcodes do not Appear in the correctly in the spreadsheet: Certain
browsers may not display the barcode correctly. Firefox for example may 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. 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.
This issue may also appear in the 2010 version of the product because of a later requirement of how returns are handled. To fix this version, locate and change the following line of code:
BarcodeImage = BarcodeImage + PrintableString + String.fromCharCode(13);
And change it to:
BarcodeImage = BarcodeImage + PrintableString + String.fromCharCode(13)+ String.fromCharCode(10);
- 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.