Search code examples
epplusepplus-4

EPPlus AutoFit() different column width on different machines

I am using EPPlus Version 4.1.0 I know this issue seems extremely weird but I have already wasted 2 days on this and any input is very very welcome!

I run the following code:

using (var package = new ExcelPackage())
{
    ExcelWorksheet ws = package.Workbook.Worksheets.Add("Sheet1");
    ...
    for (int i = ws.Dimension.Start.Column; i <= ws.Dimension.End.Column; i++)
    {
        ws.Column(i).AutoFit(0, 100);
        ws.Column(i).Style.WrapText = ws.Column(i).Width > 60;
    }
...

I run this code on several machines and the AutFit() function always returns the same value for the column width.

But on one machine the (unfortunately my new laptop) the width is completely off (i.e. 33 instead of expected 11).

Any clues how my machine setup can possibly effect this?

Solution

  • I hope somebody else can benefit from this, but as stated in the comments, it was actually the DPI settings of my new machine that caused this.

    I have yet to find out if this actually affects the reports itself.