Goto event triggered?

Goto event triggered?

Posted by: datnguyen4326 on 17 May 2023, 6:29 am EST

• 

  datnguyen4326

  • Post Options:
  • Link
    Copy

  Posted 17 May 2023, 6:29 am EST

  Is there an event in GrapeCity SpreadJS that is triggered when using the “Find & Goto” feature, or is there a workaround to detect when a cell is highlighted?
  
  Many thanks

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 May 2023, 5:24 am EST - Updated 18 May 2023, 5:29 am EST

  Hi,

  Currently, there is no direct Event that is triggered when using the “Find & GoTo” feature.
  
  However, you could override the “goto” command, get the SpreadJS Designer’s Dialog and add the click handler to the “OK” button. You can get the getSelections() method to get the selections.

  Kindly refer to the following code snippet and the sample:

  let config = GC.Spread.Sheets.Designer.DefaultConfig;
  var oldGoToCommand = GC.Spread.Sheets.Designer.getCommand(GC.Spread.Sheets.Designer.CommandNames.FindDialogGoto).execute;
  config.commandMap = {
      "goto": {
          execute: function () {
              let result = oldGoToCommand.apply(this, arguments);
              let gotoDialogEl = document.querySelector("div.gc-sjs-designer-dialog");
              if (gotoDialogEl) {
                  let okButtonEl = gotoDialogEl.querySelectorAll("button.gc-ui-button")[1];
                  if (okButtonEl) {
                      okButtonEl.addEventListener("click", function () {
                          setTimeout(() => {
                              if (!document.querySelector("div.gc-sjs-designer-dialog")) {
                                  console.log("Go to Event");
                                  let selections = spread.getActiveSheet().getSelections()[0];
                                  console.log("Sheet Name: " + spread.getActiveSheet().name());
                                  console.log("Range: " + GC.Spread.Sheets.CalcEngine.rangeToFormula(
                                      new GC.Spread.Sheets.Range(selections.row, selections.col, selections.rowCount, selections.colCount))
                                  );
                                  console.log("Selections: ");
                                  console.log(selections);
                              }
                          }, 100)
                      }, true);
                  }
              }
              return result;
          }
      }
  }
  
  designer.setConfig(config);
  

  Sample: https://jscodemine.grapecity.com/share/xOiDyhH1QEu0KQkExXNFyw/?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["%2Findex.html"%2C"%2Fsrc%2Fapp.js"%2C"%2Fpackage.json"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  References:

  FindDialogGoTo Command: https://www.grapecity.com/spreadjs/api/v15/designer/classes/GC.Spread.Sheets.Designer.CommandNames#finddialoggoto

  getSelections method: https://www.grapecity.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Worksheet#getselections

  rangeToFormula method: https://www.grapecity.com/spreadjs/api/modules/GC.Spread.Sheets.CalcEngine#rangetoformula

  Regards,

  Ankit