Retrieve the events

Retrieve the events

Posted by: vincent.delachaux on 20 February 2024, 12:26 pm EST

• 

  vincent.delachaux

  • Post Options:
  • Link
    Copy

  Posted 20 February 2024, 12:26 pm EST

  Hello,
  
  Is there a way to retrieve the events linked to a sheet?
  
  Thank you for your reply.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2024, 1:03 am EST

  Hi,

  There is no direct API to get all the events linked to a sheet or workbook. However, event binding support namespaces. You could give different namespace for the same event and then unbind the events accordingly.

  Kindly refer to the following code snippet and the attached sample:

      sheet.bind('ValueChanged.ns1', function () {
          alert("value changed");
      });
  
      sheet.bind('ValueChanged.ns2', function () {
          alert("value changed1");
      });
  
      sheet.bind('RangeChanged.ns2', function () {
          alert("Range Changed");
      })
  
      document.getElementById('btn').addEventListener('click', function () {
          spread.unbind('ValueChanged.ns2');
      })
  
      document.getElementById('btn2').addEventListener('click', function () {
          spread.unbind('.ns2');
      })

  Sample: https://jscodemine.grapecity.com/share/fFDfuNqgLUOxkykeDC6ucA/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  If this still doesn’t fulfill your requirement, kindly do share your use case with an example so that we could have a better understanding of your use case and could assist you accordingly.

  Regards,

  Ankit