Spread V11: CalcEngine.evaluateFormula is not evaluating formula properly

Spread V11: CalcEngine.evaluateFormula is not evaluating formula properly

Posted by: viswanath.malepati on 30 January 2018, 10:36 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 January 2018, 10:36 am EST

  Hi,

  I tried to do following steps:

  1. open https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  2. execute following line in developer console:
     
     GC.Spread.Sheets.CalcEngine.evaluateFormula(spread.getActiveSheet(), “ROW(AR25)”)

  3. observe that you will get correct value. i.e. 10

  4. Now, click on any random cell in the sheet. and repeat step step 2.

  5. Observe that the value it returns is not 10.

  I think it is working good in spread v9.

  How to fix it?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 11:36 am EST

  Hello,

  I am able to replicate this issue with online demo and reported it to the development team. I will let you know as soon as I get an update on this.
  
  The bug id for this issue is #253869

  Thanks,
  
  Deepak Sharma

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 12:23 pm EST

  Thanks. we will be waiting and a quick response would be great help for us.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2018, 5:46 am EST

  Hello,

  I will update you once I get a response from the concerned team.

  Thanks,
  
  Deepak Sharma

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 5 February 2018, 5:53 am EST

  I found an alternative for the same, correct me if there are any corner cases where it might fail:

  GC.Spread.Sheets.CalcEngine.evaluateFormula(spread.getActiveSheet(), “ROW(AR25)”, 0 ,0);

  Note: Adding baseRow and baseColumn as 0, it gives me right answer always irrespective of my active cell.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 February 2018, 3:26 am EST

  Hello,

  The workaround looks fine. However I am waiting for the development team’s comment on the behaviour displayed. I will let you know as soon as I get an update on this.

  Thanks,
  
  Deepak Sharma

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 13 June 2018, 5:53 am EST

  Hello,

  Your issue has been fixed in latest bi-weekly build which can be downloaded from this link:-
  
  http://cdn.grapecity.com/spreadjs/11.1.2/Files/SpreadJS.Release.11.1.2.zip

  Thanks,
  
  Reeva