Spread V11: Is there any API to validate formula?

Spread V11: Is there any API to validate formula?

Posted by: viswanath.malepati on 9 July 2018, 7:27 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 July 2018, 7:27 am EST

  Hi,

  Is there any API to validate formula?

  for example: “=Max()” should be recognized as invalid formula or throw an error and “=Max(1,3)” should return 3.

  Thanks,
  
  Viswanath

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 10 July 2018, 7:13 am EST

  Hello,

  We couldn’t find any API to validate formula in Spread.Sheets. However, invalid formula strings raise the InvalidOperation error by design.

  Thanks,
  
  Reeva