Specifying Significant Digits to be Stored in Excel file
Contents
[
Hide
]
Possible Usage Scenarios
By default, Aspose.Cells stores 17 significant digits of double values in spreadsheets unlike Excel application which stores only 15 significant digits. You can change the default behavior of Aspose.Cells for this case, that is; you can change the number of significant digits from 17 to 15 while using the CellsHelper.SignificantDigits property.
Specifying Significant Digits to be Stored in Excel file
The following sample code enforces Aspose.Cells to use 15 significant digits while storing double values inside the excel file. Please check the output excel file. Change its extension to .zip and unzip it and you will see, only 15 significant digits are stored inside the excel file. The following screenshot explains the effect of CellsHelper.SignificantDigits property on the output excel file.
Sample Code