Home: Products: Font Tools: Star Office Barcode Tutorial:

Star Office Barcode Add-in and Tutorial

Add barcodes to your StarOffice Calc spreadsheet or Adabas database with this bar code add-in. Our add-in contains functions for POSTNET, Code 39, Interleaved 2 of 5, Code 128, UPC, EAN, UCC-128, MSI and others. NOTICE: The Star Office Add-in is still available; however, it is no longer supported. IDAutomation recommends using IDAutomation's OpenOffice & StarOffice barcode font VB macros instead which will be supported for the foreseeable future.

Add barcodes to StarOffice Calc spreadsheet or Adabas database with this bar code add-in. IDAutomation's add-in contains functions for POSTNET, Code 39, Interleaved 2 of 5, Code 128, UPC, EAN, UCC-128, MSI and others.

Installing the StarOffice Add-In
Using the StarOffice Add-In in Calc

Want the easiest method of implementing barcodes in Microsoft Office? Then visit IDAutomation's OfficeBarcode.com site, it is dedicated to bar-coding in Microsoft Office.

Additional Font Tools: ActiveX DLL | Barcode Printing Application | Crystal Reports UFL | LotusScript | Font Tools

Overview::

StarOffice uses a feature called Add-Ins, which allows the use of custom functions within the StarOffice applications. These Add-In functions are defined in a Dynamic Link Library (DLL). When this DLL is placed in the correct StarOffice directory, the functions can be called from within the StarOffice Calc spreadsheet or Adabas database. IDAutomation.com provides such a DLL for encoding data that needs to be bar-coded; the DLL contains functions for most standard symbology. The DLL may be downloaded here. The following is an explanation of each function that is included in the DLL:

Download the StarOffice Add-In Library Now

Function	Notes
Code128(Data)	If there is a doubt about which Code 128 set is for the application, then use this one. This is a "Code 128 Auto" function that will automatically encode any data from ASCII 0 to ASCII 127. It will automatically switch to character set C for numbers also. To encode alpha-numeric UCC/EAN-128, ASCII 202 or character Ê is entered as the FNC1 before each AI. For example, the UCC number of (8100)712345(21)12WH5678 should be entered as: Ê8100712345Ê2112WH5678. More information about AI's and UCC/EAN-128 is located here.
Code128a(Data)	Use the characters from set B to print characters not on the keyboard; the scanner will scan characters from set A. Formats output to the Code 128 barcode fonts.
Code128b(Data)	Returns codes formatted to the Code 128 character set B. Formats output to the Code 128 barcode fonts.
Code128c(Data)	This code128 function "interleaves" numbers into pairs for high density.
I2of5()	This function "interleaves" numbers into pairs for high density without check digits and formats the return string to the Interleaved 2 of 5 fonts.
I2of5Mod10(Data)	Performs the mod10 checksum calculation for increased accuracy and formats the return string to the Interleaved 2 of 5 fonts. MOD 10 checksums are required by USPS for special services and for SSC-14 when using Interleaved 2 of 5 for that purpose.
Code39((Data)	Formats the output to print using Code 39 fonts.
Code39Mod43(Data)	Performs the mod43 checksum calculation for increased accuracy and then formats the output to print using Code 39 fonts. The mod43 checksum is usually required for LOGMARS and HIBC applications.
Codabar()	Formats the output to print using Codabar fonts.
Postnet(Data)	Enter a single string of Zip, Zip + 4 or Zip + 4 + Delivery Point. The input for Data must be a number and can include dashes and spaces.
MSI(Data)	Formats output to the MSI barcode fonts.
UPCa()	Enter UPC-A with or without a check digit, add-ons are supported. Formats output to the UPC/EAN barcode font.
EAN13()	Enter EAN-13 with or without a check digit, add-ons are supported. Formats output to the UPC/EAN barcode font.
EAN8()	Enter exactly 7 characters (EAN-8 without the check digit). Formats output to the UPC/EAN barcode font.

Installing the StarOffice Add-In

After the StarOfficeBarcodeAddin.zip has been downloaded and extracted IDAutomationAddIn.dll, the DLL file will need to be placed in the StarOffice Add-In directory. To find the location of the StarOffice Add-In directory, follow these steps within StarOffice:

Click the Tools menu item.
Click Options...
Expand the General item and select Paths from the tree-view of options.

AddIns

Copy the IDAutomation.dll file to the path specified by AddIns in the StarOffice environment
Restart StarOffice

Using the StarOffice Add-In in Calc

Now that the Add-In has been installed, the functions are ready to use within the spreadsheet. The following example will discuss using the Code128B Add-In function to create a bar code in cell B1 for a value that is in cell A1:

Open the spreadsheet to barcode data using StarOffice Calc.
Enter test data into cell A1.
Move the cursor to cell B1.
Select Insert | Function from the Calc menu or press Ctrl + F2 to access the function screen.
Select Add-In from the Category drop-down menu and highlight CODE128B in the Function list.
Click the Next button. At this point, the screen should look similar to the following:
Enter A1 in the Input Data field.
Click the OK button.
Cell B1 will look similar to the following:
Select the appropriate IDAutomation.com font to turn the formatted text into a bar code.
NOTE: When selecting the font from the pull down menu, please do not use the fonts that begin with the "@" Symbol. Instead, scroll down in the list and select the ones that begin with "IDAutomation".
The barcode should be able to scan when printing.
If there problems scanning the barcode after these steps are performed: Make sure the correct barcode font is selected for the formula function. Make sure the barcode is not truncated, there needs to be some white space to the left and right of it for scanning.
For other problems, please refer to Font Problems and Solutions.

Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.