Spread V11: evaluateFormula() API is not evaluating culture specific formulas

Spread V11: evaluateFormula() API is not evaluating culture specific formulas

Posted by: viswanath.malepati on 27 June 2018, 11:47 pm EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 June 2018, 11:47 pm EST

  Hi,

  in Spread V11: evaluateFormula() is not evaluating culture specific formulas, throwing an error. On the other hand in V9, evaluateFormula() was able to evaluate culture specific formulas.

  Please find the attachment with spread V9 and V11 html files. after opening files in the browser, execute following in console to see the difference.

  in V9 console execute: GcSpread.Sheets.Calc.evaluateFormula(spread.getActiveSheet(), “=IF(TRUE;1;2)”)

  RESULT: 1

  in V11 console execute: GcSpread.Sheets.Calc.evaluateFormula(spread.getActiveSheet(), “=IF(TRUE;1;2)”)

  RESULT: Uncaught Invalid Formula

  Let us know how to evaluate formulas like =IF(TRUE;1;2) using an API???

  Thanks,
  
  Viswanath.

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 27 June 2018, 11:47 pm EST

  formula evaluation.zip

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 28 June 2018, 3:05 pm EST

  Hello,

  We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix.

  We will update you as soon as we hear anything from them.

  Tracking id for your issue is #260086.

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 9 September 2018, 5:41 pm EST

  Hello,

  Your issue is working fine with the latest build and you can download the same from this link:-
  
  https://www.grapecity.com/en/download/spreadjs

  Hope it helps.

  Thanks,
  
  Reeva