How to implement custom CalcError

How to implement custom CalcError

Posted by: jk on 27 August 2019, 12:03 pm EST

• 

  jk

  • Post Options:
  • Link
    Copy

  Posted 27 August 2019, 12:03 pm EST

  Hi,

  I am using custom functions, and now I’d like to define custom CalcError(s). Can you please suggest how to do that.

  Also, is there a way that a custom function returns more than one CalcError, basically passing a number of errors from other custom functions used as parameters.

  =CustFn(CustParamFn1(), CustParamFn2(), CustParamFn2())
  
  I’d like to be able to notify user that all three CustParamFn throw a CalcError.

  Can you suggest how to approach it, please?

  Thanks!!!

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2019, 2:53 am EST

  Hi,

  You may override the “acceptsError” method in your custom function. If the acceptsError method returns true then error will be passed to evaluate the method of your customFunction and you may return custom error messages as required.
  
  Please refer to the following sample which demonstrates the same:
  
  https://codesandbox.io/s/spread-js-starter-5jihy

  Regards

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2019, 2:54 am EST

  API Reference:
  
  http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.CalcEngine.Functions.Function.html