The hidden value in Excel cell

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

The hidden value in Excel cell

Postby rose » 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

Re: The hidden value in Excel cell

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


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests