Replied 8 September 2017, 2:05 pm EST
Here is the sample code to prevent the value from being adding in a cell which are greater than maximum value or lesser than the minimum value set in the number cell type.
fpSpread1.ActiveSheet.Cells[0, 0].Value = 22.2;
FarPoint.Win.Spread.CellType.NumberCellType numCellType = new FarPoint.Win.Spread.CellType.NumberCellType();
fpSpread1.ActiveSheet.Cells[0, 2].CellType = numCellType;
numCellType.MinimumValue = 10;
numCellType.MaximumValue = 100;
numCellType.DecimalPlaces = 0;
fpSpread1.ActiveSheet.Cells[0, 2].Formula = "PRODUCT(A1,4)";
Here if the calculated value obtained by applying the formula is greater than the maximum value or less than the minimum value specified, then no result is shown in that cell & neither the value which is not an integer can be added.
The version of the spread used is 4.0.2012. Which version is installed on your machine? Can you please modify the above code and post it back to us for review.