Posted 8 September 2017, 3:04 pm EST
We are seeing NumberCellType columns that are set to DecimalPlaces of 4 display a value of 0.0591000000 as 0.0600.
I'm not sure what to look for.
We are doing the following to set the column to 4 decimal places
Dim nc4 As FarPoint.Win.Spread.CellType.NumberCellType = New FarPoint.Win.Spread.CellType.NumberCellType
nc4.DecimalPlaces = 4
nc4.SetCurrentCulture(System.Globalization.CultureInfo.CurrentCulture) 'culture setting must occur after any customization of celltype
.Columns(columnIndex).CellType = nc4