Divide by zero error

Divide by zero error

Posted by: adisa.craig on 25 November 2024, 11:18 am EST

• 

  adisa.craig

  • Post Options:
  • Link
    Copy

  Posted 25 November 2024, 11:18 am EST

  There are two formulas that I have seen this with the FLOOR function, when it is added as such FLOOR(215.6, 0) the value returned is 0 in SpreadJS, however in both Google Sheets and Excel it throws a #DIV/0! error. Is there a setting in spread that needs to be set for the function to be evaluated similarly to Excel?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 26 November 2024, 4:58 am EST

  Hi,

  I have been able to replicate the issue on our end. The case has been escalated to the concerned team with the internal track ID: SJS-27507. I will provide updates as soon as more information becomes available.

  As a workaround, you can redefine the FLOOR function to handle cases where 0 is used as the second argument, displaying the required error. You can refer to the attached sample for implementation: https://jscodemine.mescius.io/share/X1psjzmF7kaDpfseREnxFA/?defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Regards,
  
  Priyam