FAQ: TBarCode Office Excel Add-In
Wrong Aspect Ratio with 2D Matrix Codes
Wrong Aspect Ratio with 2D Matrix Codes
Problem
In the preview and on the print out the 2D matrix codes are printed with distorted aspect ratio (the printed symbol is not square!).
Reason for that behavior is a scaling applied by Excel to the whole page. It also depends on the default font of the sheet if you see this problem or not.
Workaround
If you have 10.9.0 or later installed, you can use the following workaround:
- Open the TBarCode Panel and go into the Add-In options
- Enable the option Scale Picture (correct print size)
- Insert a 2D Code and print it.
When you print the 2D Code, the scaling from Excel should be compensated by our own scaling (activated by option). We use a standard compensation which works in most cases. If needed, there would be the possibility to further fine-tune the scaling ratio / compensation with a registry key.
Existing bar codes are not changed by this option! You need to insert the bar code again from scratch (at least the ones, which do not print correctly).