Update Value in SpreadJS using Selenium

Update Value in SpreadJS using Selenium

Posted by: jothivignesh.c on 25 June 2019, 2:03 am EST

• 

  jothivignesh.c

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 June 2019, 2:03 am EST

  Hi Team,

  I am using the below code

  js.executeScript("return window.testSpread.getActiveSheet().setValue(" + ri + "," + ci + ",\"22,00\");");
  
  

  to set values in SpreadJS using Selenium. I am able to set the values. But it is not saved. After saving the old value remains. Could any one help me on this.

  Thanks in Advance

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 25 June 2019, 3:22 pm EST

  Hi Joothi,

  We are sorry but we are unable to replicate the issue at our end. Could you please share a small sample replicating the issue so that we could investigate the issue.

  Regards

• 

  jothivignesh.c

  • Post Options:
  • Link
    Copy

  Posted 25 June 2019, 9:36 pm EST

  Before Editing:

  Manual Editing:
  
  • Click on the Cell to make it editable
  
  • Change the value

  • Click on Save button.

  During Automation:
  
  getValue  Returning the cell value
  
  setValue / setText  Entering the new Value.

  I am able to retrive the data and set new value using selenium. I could able to see that new value that update in displayed. But if I click on Save Button  Go back  Come again, I could see the old value is present. Not the new one.

  Please find the Screenshots in the attached document

  Kindly help us with the same.
  
  Thanks,
  
  Jothi

• 

  jothivignesh.c

  • Post Options:
  • Link
    Copy

  Posted 25 June 2019, 9:37 pm EST

  SpreadJS_SetText Issue.zip

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 26 June 2019, 4:04 pm EST

  Could you please confirm what you mean by “going back and come again”? Does it mean going back to the previous URL?
  
  Also please let us know how you have implemented save functionality? Also please share a sample replicating the issue that would be really helpful in the investigation of the issue.

  Thank you

• 

  jothivignesh.c

  • Post Options:
  • Link
    Copy

  Posted 26 June 2019, 4:44 pm EST

  Hi @sharad.tomer,

  going back and come again - Once we click on save button we will be navigated to the home page. And if we redirect to the same page, I could see the old value, not new one.

  Also please let us know how you have implemented save functionality? - Our Vendor is Board(https://www.board.com/en) and they have implemented those. I am not sure.

  Is it possible for us to have a screen sharing session. I am will be available on IST (GMT +5.30).

  Thanks,
  
  Joothi.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 June 2019, 4:32 pm EST

  Hi,

  We have posted the response on support case, please refer to the following case:
  
  http://supportone.componentone.com/casedetail/385981

  Regards