Paste Special ability

Paste Special ability

Posted by: kim.dok on 27 May 2023, 9:59 pm EST

• 

  kim.dok

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 May 2023, 9:59 pm EST - Updated 27 May 2023, 11:11 pm EST

  Hi, we want to implement Paste Special Dialog (like in the attached screenshot) to allow our users to have more paste capabilities, same as Excel
  
  we haven’t managed to find a way to implement it.
  
  can we have some guidance on how to achieve the required outcome?

  Thanks.
  
  

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 29 May 2023, 4:59 pm EST - Updated 29 May 2023, 5:04 pm EST

  Hello,

  The requested feature is already present in the product backlog. The internal tracking id for the issue is: SJS-11820. Currently, it is planned for the SpreadJS V16.2.0 which will be released by August 2023. It might be delayed or moved to further releases. I will let you know when this feature will be available.

  However, you can create a paste special dialog box like MS Excel in SpreadJS Designer. For this, you would need to create a dialog template and register the dialog template using GC.Spread.Sheets.Designer.registerTemplate() method. This dialog template shows different options for pasting values.

  To open the paste special dialog template, you need to create a command(option) in the context menu of the designer. Inside the execute() method of the command(option), you can use GC.Spread.Sheets.Designer.showDialog() method to open the paste special dialog. In this method, you can also specify the success callback which will be executed when some values are selected from the dialog box of special paste. In the success callback, you can perform the paste operation as per selected option in the paste special dialog.

  Please refer to the attached sample and gif for further understanding.

  sample:https://jscodemine.grapecity.com/share/2-vYmAm5SE2NnBKUF3L5Cw

  Please let us know if you still face any issues.

  Doc references:

  custom dialog demo: https://www.grapecity.com/spreadjs/docs/spreadjs_designer_component/customizations/add_new_dialog

  GC.Spread.Sheets.Designer.registerTemplate(): https://www.grapecity.com/spreadjs/api/designer/modules/GC.Spread.Sheets.Designer#registertemplate

  GC.Spread.Sheets.Designer.showDialog():https://www.grapecity.com/spreadjs/api/designer/modules/GC.Spread.Sheets.Designer#showdialog

  ICommand interface:https://www.grapecity.com/spreadjs/api/designer/interfaces/GC.Spread.Sheets.Designer.ICommand

  ICommand.execute(): https://www.grapecity.com/spreadjs/api/designer/interfaces/GC.Spread.Sheets.Designer.ICommand#execute

  IDialogTemplate interface: https://www.grapecity.com/spreadjs/api/v16/designer/interfaces/GC.Spread.Sheets.Designer.IDialogTemplate#interface-idialogtemplate

  Regards,

  Ankit

  

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 25 December 2023, 4:50 pm EST

  Hi,

  The Paste Special Ability Feature has been added in the latest version of the SpreadJS v17.0.0. Kindly upgrade to the latest version of the SpreadJS.

  You may also download the latest version using the following link: http://cdn.mescius.com/spreadjs/17.0.0/Files/SpreadJS.Release.17.0.0.zip

  Let us know if you still face the issue with the latest version.

  Regards,

  Ankit

• 

  lior.sharabi

  • Post Options:
  • Link
    Copy

  Posted 12 March 2024, 2:42 am EST

  HI

  can we open the Paste Special dialog from our side?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 12 March 2024, 5:31 pm EST

  Hi,

  As per my understanding, you want to open the Paste Special Dialog using code. If this is the use case, you could execute the “openPasteSpecialDialog”. Kindly refer to the following code snippet and the sample:

  spread.commandManager().execute({ cmd: "openPasteSpecialDialog", sheetName: spread.getActiveSheet().name() });

  Sample: https://jscodemine.mescius.io/share/N3DZPmuRL0aISBrBs664XQ/?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"}

  openPasteSpecialDialog command: https://developer.mescius.com/spreadjs/api/v17/modules/GC.Spread.Sheets.Commands#openpastespecialdialog

  Let me know if you have another requirement or if you face any issues.

  Regards,

  Ankit