New: TFORMer Designer V9.2 — easily design and print labels and forms. Explore the product →

TEC-IT

FAQ: TBarCode Office Excel Add-In

Barcode Size Changes on a Different PC

Barcode Size Changes on a Different PC

General Scaling Issues

We have seen scaling issues

  • If a user has adjusted enlarged display fonts or enlarged DPI (often used with 4K screens or screens, where the font is small) ➔ How to Change the Font Size on Your Screen (lifewire.com)
  • If DOC format is used instead of DOCX
  • If the printer driver does not provide correct DPI
  • If the user changes the screen resolution while login (e.g. Remote Desktop or Docking Station) – see FAQ above.
  • After a Windows update (sometimes a reboot helps or an Office repair or disabling Fast Startup).
  • If the embedded bar code is of type ActiveX and not EMF

Issues with ActiveX Controls

The following problem applies to TBarCode Office V10.5.2 and earlier (concerns embedded ActiveX Controls). As of TBarCode Office 10.9.0, bar codes are embedded as EMF images - there the problem only occurs in a few cases (like with Remote Desktop - see other FAQ).

There are two possible reasons why this size changing happens:

1. Enlarged Screen Fonts

User A is using standard font sizes (100%). User B has adjusted enlarged screen fonts (e.g. 125%). User A saves the Excel sheet with the bar codes in normal (correct) size. User B opens the sheet and discovers the bar code object with a different size (scaled according to the difference in screen font sizes).

Excel scales the bar code objects independently from TBarCode Office. The ideal solution would be to use the same readability options (screen font enlargement) on all involved PCs.

2. Different Screen Resolution

User A has a screen resolution of 1280x1024 Pixels. User B has a screen resolution of 1600 x 1200 Pixels. User A saves the Excel sheet with a bar code in normal (correct) size. User B opens the sheet and discovers the bar code object with a different size (scaled according to the difference in screen resolution between A and B).

Excel scales the bar code objects independently from TBarCode Office. The ideal solution would be to use the same screen resolution on all involved PCs.

Workaround

TBarCode Office V10.5.3 introduced the option "Redraw on document open" as a workaround for this problem. For instructions on adjusting control sizes, see Microsoft’s documentation: Resize or format a control on a worksheet.

Make every label, code and scan work the first time.

Try it free in the browser, download a full trial, or talk to sales about your systems, standards and volume.

Get started Contact Sales →

Online Inquiry

Write an e-mail instead

For support or sales: edit your message and send it yourself. Sales enquiries are forwarded internally. Recipient: support@tec-it.com

Incomplete transfer: only first name, last name and e-mail can currently be copied. Other answers, full trial licence keys and files are not copied. Add your question below, omit full licence keys and attach files manually in your mail app.