Posted 8 September 2017, 12:38 pm EST
I want to implement a custom cell type that only accepts boolean values but the question I am going to pose is irrelevant to the value type that the cell type accepts. I inherit my custom cell type class from the GeneralCellType class. If I want to validate user input, I override the IsValid method and act accordingly. The problem occurs if I have enabled user formulas on the spread control. In that case, if the user enters a formula in a cell whose cell type is my custom cell type, the IsValid method receives as (string) argument the formula that was entered. So, how can I evaluate the formula entered and check if the result is of the type I want?
Thanks in advance.