This project has moved and is read-only. For the latest updates, please go here.

Column AutoFit with non-standard DPI settings

Nov 3, 2016 at 6:24 AM
When using the ExcelColumn.AutoFit method with non-standard DPI settings, the width calculated is incorrect. With a setting of 150% (144dpi), the width is 50% more than it needs to be.

It's easy enough to calculate the scaling factor by looking at the system DPI settings and comparing with the default 96dpi, but would be nice to perform this inside EPPlus. This will likely affect row height also but I haven't checked.