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
-
iceblue support
-
- Posts: 240
- Joined: Tue Dec 21, 2010 2:56 am