White Lines Appear in a 2D or Stacked Barcode Symbol
Many applications, including Microsoft Word and OpenOffice Writer, add extra line spacing between each line of text, which creates white lines in 2D and stacked symbols.
To resolve this issue the line spacing must be set to “1” or “Single” without any additional spacing before or after. If white lines still appear, set the spacing to less than 1, such as 0.98 as shown in the Crystal and FileMaker examples.
OpenOffice Writer Example:
SAP Crystal Reports Example:
FileMaker Pro Example:
The line spacing property is not adjustable within Excel. A special 2D XLS Font for Excel is available to overcome the line spacing issue and it is compatible with many 2D fonts including QR-Code, Data Matrix and PDF417.
When using DataBar, or if the 2D XLS Font for Excel is not an option, the following solutions are available:
- Use Microsoft Word to perform a mail-merge using the barcode column as the source.
- Use IDAutomation Barcode Label Software and connect to Excel as the data source.
- Stream a barcode image into Excel; this is the most complex option and requires knowledge of VBA scripting.
If this issue occurs with PCL fonts, reduce the VMI setting and refer to the pclinfo.html file in the appropriate font package for more information.