Suppressing #DIV/0! error message in cell

Suppressing #DIV/0! error message in cell

Posted by: ed on 15 April 2022, 4:47 pm EST

• 

  ed

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 15 April 2022, 4:47 pm EST

  In flexgrid is there any way to suppress the #DIV/0! error message and have the cell contents be blank when this error occurs? The cell is computing a value based on user inputs and we can’t avoid situations where the denominator could be a zero value.

  In spread for Windows there is an “IFERROR” function that handles this but I can’t find it in Wijmo.

  Thanks, Ed

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 18 April 2022, 3:53 am EST

  Hi Ed,

  It seems that you are using FlexSheet but have mistakenly written flexGrid. Can you please confirm which control are you using?

  Also, in Wijmo, there is an iferror function that you can use. Please refer to the sample for understanding:

  https://stackblitz.com/edit/js-lklzwg

  Regards,
  
  Ashwin

• 

  ed

  • Post Options:
  • Link
    Copy

  Posted 18 April 2022, 7:57 pm EST

  Hi Ashwin,
  
  Yes you are correct we are using FlexSheet not FlexGrid.
  
  Thanks for your help.
  
  Ed