End 2 end testing

End 2 end testing

Posted by: alenstojanovic on 25 October 2019, 6:31 am EST

• 

  alenstojanovic

  • Post Options:
  • Link
    Copy

  Posted 25 October 2019, 6:31 am EST

  Hello community!

  Is there any good practice to test the Spread JS integration in the web application? We’re using Cypress for our end 2 end tests, and now I want to see what’s the best approach to test Spread JS formulas with automated tests.

  Any suggestion is warmly welcomed!

  Cheers!
  
  Alen

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 October 2019, 2:57 am EST

  Hi Alen,

  SpreadJS is not opinionated about the testing framework so you may use any framework of your choice or according to the needs of your application.
  
  It is quite easy to write automated test cases for SpreadJS using Cypress, please refer to the following post which discusses the same:
  
  https://www.grapecity.com/forums/spread-views/cypress-automation-testing
  
  For testing formulas, you could use the evaluateFormula() method to compute the formula and then compare the result with the expected result.
  
  API reference: http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.CalcEngine~evaluateFormula.html

  Please feel free to reach out if you face any issues.

  Regards
  
  Sharad