This article explains how to display very long numbers without rounding off in XlsIO.
Microsoft Excel displays all digits of a numeric value in the cell if its digit count does not exceed the maximum count, with respect to system resolution. Otherwise it is displayed in exponential format and displayed. This is same in XlsIO and is not possible to retrieve the entire cell value as entered, through DisplayText. Therefore, the cell’s number format should be set to text to retrieve the number as entered.
The following C#/VB complete code snippet explains how to display very long numbers without rounding off using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|