Barcode Generator for Google Docs Sheets Manual

Buy License Support Download Demo Release Log

Product Overview

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.

Integration Tutorial for Google Sheets

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.

  1. Extract the files from the Native Barcode Google Docs Generator package.
  2. Open the IDAutomation Google Docs Script.js file.
  3. Select all and copy the script code in the file to the clipboard.
  4. Open the spreadsheet.
  5. Choose Tools - Script editor and paste the script code into the script editor.
  6. Select the Save icon to save the script.
  7. In the cell to create the barcode, type the equal sign followed by the barcode function and parameters.
    For example:
    Set the barcode function in the formula bar
  8. 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.
  9. Press enter and a barcode should appear.
  10. 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.
  11. Once the left button is released the functions should calculate and multiple barcodes will appear.
    Create multiple barcodes

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 Symbols

IDAutomation includes the capability in this product to create barcodes and text for GS1-128 with the Apply Tilde feature in the IDAutomationGoogleDocsBarcodeC128 function.

Functions of the Google Docs Barcode Generator

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
Symbology Barcode Functions
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)

Technical Support & Troubleshooting

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.

Common Problems and Solutions:

  • 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.
    Spaces between bars appear on screen.
    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.
    When printed to pdf, the barcode will display 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.
    Barcode appears jumbledThis 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);
    Recalculate functions should fix the barcode.
  • 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.
    Barcodes wrapping in cell.