Posted 8 September 2017, 2:06 pm EST
In Farpoint Spread for Winforms, is there a way to trap/catch an invalid formula? The CalcError codes for #NAME?, #REF!, #VALUE! and #DIV/0 are generated and loaded as values, but these are not displayed to the cell. The currency/number cell's filter appears to hide all of the non numeric characters from displaying. The FpSpread_EditError and FpSpread_Error events do not appear to get raised when these occur (breakpoints not being hit).
Is there another event or code that I should look for to be able to catch these and display a popup to the user that they have entered in an invalid formula?
Version of Farpoint used: