AutoFitColumns does not consider Numberformat when adjusting column width, such as time and date types, and only detects the original double value

[zhuangState]

EPPlus usage

Personal use

Environment

win11

Epplus version

7.7.3

Spreadsheet application

Excel365

Description

AutoFitColumns does not consider Numberformat when adjusting column width, such as time and date types, and only detects the original double value

May I ask what I should do to make AutoFitColumns consider Numberformat? Thank you

[AdrianEPPlus]

I've tested using autofit on a couple of date format and it autofits just fine using EPPlus 8.2. My suggestion for you would be to update EPPlus.