SpreadJS15 getCell

SpreadJS15 getCell

Posted by: petri.rasanen on 11 March 2022, 5:00 am EST

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy

  Posted 11 March 2022, 5:00 am EST

  Hi,

  We were using this method in our program to get the value from cell:
  
  var cellValue = activeSheet.getCell(37, 0).text();
  
  Now when updating from SpreadJS 14 to version 15 this method returns null.
  
  Anyway getting value from cell 36,0 with same method returns correct value.
  
  See attached excel file to check issue.

  Br,
  
  Petri
  
  TestFile.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 14 March 2022, 5:54 am EST

  Hi,

  We were able to replicate the issue at our end with SpreadJS V15.0.0 . However, this issue has been already fixed in our latest version 15.0.4

  Please refer to the attached sample. Steps to follow:

  1. Open the index.html file.
  2. Import your Excel file.
  3. Click on GetValue Button.
  4. Open the Developers’ Console(by pressing F12) to see the values.

  Please let us know if you face any further issues.

  Regards
  
  Ankit.

  purejsV15.0.4.zip