IDAutomation.com, Inc., Computers Hardware, Software & Services, Tampa, FL Contact IDAutomationView your cart in the IDAutomation Store  
Loading

IDAutomation will be closed November 27th & 28th for Thanksgiving.

Home > Barcode Component > Native Barcode Generator for Google Docs > User Manual:

Barcode Generator for Google Docs Manual

Order Barcode Generator for Google Docs Native Generator Download Demo of Barcode Generator for Google Docs Native Generator

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.

Barcode Integration Tutorial

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 - Scripts - Script editor and paste the script code into the script editor.
  6. 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
  7. 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.
  8. Press enter and a barcode should appear.
  9. 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.
  10. 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 (UCC/EAN-128) Symbols

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

Functions of the Google Docs Barcode Generator

The following functions are available:

Barcode Functions
IDAutomationGoogleDocsBarcodeC128(DataToEncode, ApplyTilde, Bar Height)
IDAutomationGoogleDocsBarcodeC128a(DataToEncode, Bar Height)
IDAutomationGoogleDocsBarcodeC128b(DataToEncode, Bar Height)
IDAutomationGoogleDocsBarcodeC128c(DataToEncode, Bar Height)
IDAutomationGoogleDocsBarcodeC39(DataToEncode, N_Dimension, IncludeCheckDigit, Bar Height)
IDAutomationGoogleDocsBarcodeCodabar(DataToEncode, N_Dimension, StartChar, StopChar, Bar Height)
IDAutomationGoogleDocsBarcodeI2of5(DataToEncode, N_Dimension, IncludeCheckDigit, Bar Height)
IDAutomationGoogleDocsBarcodeMSI(DataToEncode, N_Dimension, IncludeCheckDigit, Bar Height)

Function Properties Definitions:

  • 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

Technical Support & Troubleshooting

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 will 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. Recalculation occurs automatically when a PDF is generated or the print command is issued, therefore, this is rarely an issue.
    Barcode appears jumbled
    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.
    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.

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.

Back to Top

 © Copyright 2014 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.