Spread V11: Is there any API to validate formula?

Spread V11: Is there any API to validate formula?

Posted by: viswanath.malepati on 8 July 2018, 10:27 pm EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 July 2018, 10:27 pm 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 9 July 2018, 10:13 pm 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