Posted 8 September 2017, 12:38 pm EST
I am using latest version of Spread (v.2.5.2011.2005) and decided to try Regular Expression CellType instead of handling entries on the LeaveCell event. However when I assign this cell type to the column or to the range of cells [I tried it via setting CellType in Spread Designer or via code] I am not able to type in any values into the cell. Any idea?
Here is sample code:
FarPoint.Win.Spread.CellType.RegularExpressionCellType regexcell = new FarPoint.Win.Spread.CellType.RegularExpressionCellType();
this.sprBooking.ActiveSheet.Columns.CellType = regexcell;
this.sprBooking.ActiveSheet.Cells[0, 9, sprBooking.ActiveSheet.Rows.Count - 1, 9].CellType = regexcell;//just in case column's celltype doesn't take...