Events of move Shapes from sheet to another

Events of move Shapes from sheet to another

Posted by: ricardo.aleixo on 13 June 2024, 2:58 pm EST

• 

  ricardo.aleixo

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 June 2024, 2:58 pm EST - Updated 13 June 2024, 3:03 pm EST

  Hi.

  I’ve been working with charts and i’m trying capture the event of move the Shape beetwen Sheets, i try use

  ShapeChanged

  but it only return a value when Axies X or Y move.

  

  959×869 40.9 KB

  

  1029×621 28 KB

  And when i move the chart to another sheet it plot the shape in coordinate 0x0.

  

  1029×621 22.3 KB

  The problem is.

  I only can get the move of Shapes when the Shape move the X ou Y.
  
  But if when i change, it go to another Sheet to coordinate 0x0.
  
  And if i move again with origin 0x0 and got to another to 0x0, my event do not shoot.

  There is another way to capture this type of event?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 14 June 2024, 5:51 am EST - Updated 14 June 2024, 5:56 am EST

  Hi,

  As per my understanding, you are looking to monitor whenever a chart is moved between sheets in the SpreadJS designer.

  To achieve this, you can utilize the “addListener” method of the command manager in SpreadJS. This method tracks all commands executed within SpreadJS, allowing you to monitor the movements of charts between sheets. Please refer to the attached snippet, GIF “Steps.gif”, and sample for more details.

  spread.commandManager().addListener("app", (e) => {
          if(e.command.cmd == "Designer.moveChart"){
              console.log("sheet moved between sheets:", e);
          }
      })

  GIF:

  Sample: https://jscodemine.mescius.io/share/PLqpHdveSU_g8eOqwbr4Hw/?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"ActiveFile"%3A"%2Findex.html"}

  Regards,
  
  Priyam