Detect action create PivotTable in new sheet

Detect action create PivotTable in new sheet

Posted by: trankhanhngan00 on 22 August 2024, 5:32 am EST

• 

  trankhanhngan00

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 August 2024, 5:32 am EST

  Hi team,
  
  I am trying to detect when user creates PivotTable in a new sheet. I am using event SheetChanged but it doesn’t work, nothing happens even when it switches to a new sheet

  spread.bind(GC.Spread.Sheets.Events.SheetChanged, function (sender, args) {
        console.log("SheetChanged:::", args);
  });

  Can you suggest me another solution?
  
  Thank you!

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 23 August 2024, 2:20 am EST - Updated 23 August 2024, 2:25 am EST

  Hi,

  You can use the addListener method to detect when a pivot table is created in a new sheet. The addListener method tracks every command that operates through the UI. Please refer to the attached snippet, the “Steps.gif” file, and the sample.

  Gif:

  Here’s the relevant code:

  spread.commandManager().addListener("app", (args) => {
      if (args.command.cmd === "Designer.createDefaultPivotTable") {
          setTimeout(() => {
              if (spread.sheets.length > args.command.sheetNames.length) {
                  console.log("Pivot table created in a new sheet");
              }
          });
      }
  });

  Please note that the addListener method is not a public API and is used internally. However, for your use case, you can utilize this approach.

  Sample: https://jscodemine.mescius.io/share/9odogCe0IEqjJqBNJJ1HsA/?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"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Best regards,
  
  Priyam

• 

  trankhanhngan00

  • Post Options:
  • Link
    Copy

  Posted 23 August 2024, 7:08 am EST

  Thanks for the help, that solved our problem!

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 23 August 2024, 8:24 am EST

  Hi,

  We are happy that your query has been resolved. You could always create new tickets for new queries/issues.

  Regards,
  
  Priyam