In v11, what is alternate for triggering events like sheet.triggerCellClick

In v11, what is alternate for triggering events like sheet.triggerCellClick

Posted by: viswanath.malepati on 11 February 2018, 9:58 pm EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 11 February 2018, 9:58 pm EST

  Hi,

  We dont find ways to trigger various events on sheet programtically in V11. In V9 we used to call:

  sheet.triggerSelectionChanged()
  
  sheet.triggerCellClick()
  
  sheet.triggerCellDoubleClick()
  
  and so on.

  How to achieve the same in V11?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 12 February 2018, 8:45 am EST

  Hello,

  There are no methods like the above associated with sheet object. Could you please provide me the complete code to test with SpreadJS v11.0.

  Thanks,
  
  Deepak Sharma

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 13 February 2018, 7:01 am EST

  Hi Deepak,

  You are right, these APIs that I mentioned are not part of sheet object in V11.

  All these APIs that I have mentioned above were part of sheet object in V9. So, my question was how do we achieve the same behavior in V11?

  please let me know if I am not clear, i can share a HTML file with V9 and a sample usage of any of the API mentioned above.

  Thansk,
  
  Viswanath

  Thanks,
  
  Viswanath.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 February 2018, 5:36 am EST

  Hi Viswanath,

  It will be really helpful, if you could provide me the sample application.

  Thanks,
  
  Deepak Sharma

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 15 February 2018, 6:53 am EST

  Hi Deepak,

  please find the attached html file.

  When you run this in a browser, you will notice a button under the spread. Click that button and you will notice that it will select a particular cell, trigger EditStarting, set cell value and trigger EditEnded. And you will also see edit starting and ended handlers being triggered and alert is show on the browser.

  Thanks,
  
  Viswanath

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 15 February 2018, 6:53 am EST

  trigger edit cell- spread9.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 16 February 2018, 11:50 am EST

  Hello,

  Thanks for sharing the sample, I could not find anything related to triggerEditStarting method in SpreadJS v11.0 documentation. I have asked the concerned team for information on this. The tracking id for this issue is 254566, I will let you know as soon as I get an update on this.

  Thanks,
  
  Deepak Sharma

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 19 February 2018, 4:46 am EST

  Thanks Deepak, looking forward to hear form you on this.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2018, 2:48 am EST

  Hi Viswanath,

  All these methods are internal methods of SpreadJS. Our development would like to understand your use case in detail. Please let us know where exactly you need to fire these events in code?

  Thanks,
  
  Deepak Sharma