ReoGrid icon indicating copy to clipboard operation
ReoGrid copied to clipboard

Unable to implement custom function IFERROR

Open ShamnaHussain opened this issue 4 years ago • 0 comments

Description

We tried to implement custom function IFERROR

unvell.ReoGrid.Formula.FormulaExtension.CustomFunctions["IFERROR"] = (cell, args) => { }

For example: IFERROR(1/C8:C8 <> "") "C8 is blank", since 1/true or false is not handled in reogrid, the formula status will not be set to Normal and the control will not come back to IFERROR custom function.

In Total, if internal calculations of a formula is not returning normal -- custom functions will not get a control and hence its not getting executed.

Thank you for your cooperation! ``

To Reproduce

add a custom function IFERROR unvell.ReoGrid.Formula.FormulaExtension.CustomFunctions["IFERROR"] = (cell, args) => { } and try the formula: =IFERROR(1/true <> "", "return error value")

Edition

Which edition of ReoGrid do you using?

  • WPF

Environment

  • OS: [e.g. Windows 10]
  • Language of OS: English

ShamnaHussain avatar Jun 17 '21 14:06 ShamnaHussain