Update Value in SpreadJS using Selenium

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

  • 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
  • Replied 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.

  • Replied 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.
  • Replied 25 June 2019, 9:37 pm EST

    SpreadJS_SetText Issue.zip
  • Replied 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
  • Replied 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).


  • Marked as Answer

    Replied 27 June 2019, 4:32 pm EST


    We have posted the response on support case, please refer to the following case:

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels