Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Fri Dec 31, 2010 2:20 am

Hello,
Will the hidden value be considered when we use autofit adjust the column width of cells?
Thanks!

rose
 
Posts: 3
Joined: Tue Dec 21, 2010 8:29 am

Fri Dec 31, 2010 9:47 am

No, it won’t. The hidden value is just the data value. The value is hidden because the data has been converted to text format when it is recorded in the cell. And Excel just considers text format but the data value. So the hidden value won’t be considered when we use autofit adjust the column width of cell.
Thank you for your inquiry.
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS

cron