Replied 8 September 2017, 2:47 pm EST

lastday1225,

In Excel, numbers are stored using the double data type. The double data type provides about 15 decimal digits of precision. Excel's number format allows up to 30 digits to the right of the decimal point.

In Spread, the GeneralCellType is designed to work similar to Excel. Numbers are stored using the double data type just like Excel. You can format numbers with 30 digits to the right of the decimal point using either the NumberFormat property...

GeneralCellType ct = new GeneralCellType();

ct.NumberFormat = new System.Globalization.NumberFormatInfo();

ct.NumberFormat.NumberDecimalDigits = 30;

fpSpread1.Sheets[0].Cells[0, 0].CellType = ct;

or the FormatString property...

GeneralCellType ct = new GeneralCellType();

ct.FormatString = "0.000000000000000000000000000000";

fpSpread1.Sheets[0].Cells[0, 0].CellType = ct;

In Spread, the NumberCellType is designed for working with number values that are stored using the double data type. The DecimalPlaces property is limited to 16 places (which is about the same as the precision of the double data type).

In Spread, the CurrencyCellType is designed for working with number values that are stored using the decimal data type. The decimal data type provides about 28 decimal digits of precision. The DecimalPlaces property is limited to 29 places (which is about the same as the precision of the decimal data type).