Barcode Generator for Google Docs Manual
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 - Scripts - Script editor and paste the script code into the script editor.
-
In the cell to create the barcode, type the equal sign followed by the
barcode
function and parameters. For example:
-
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.
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.
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
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
|
