Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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