Copy and paste programmatically

Copy and paste programmatically

Posted by: devadmin on 15 November 2021, 8:50 am EST

• 

  devadmin

  • Post Options:
  • Link
    Copy

  Posted 15 November 2021, 8:50 am EST

  Hi!

  I want to programmatically copy and paste the following from one cell to another :
  
  cell type
  
  cell style
  
  data validation
  
  cell states
  
  cell dropdown
  
  conditional format
  
  I found these:
  
  https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands~copy.html
  
  https://www.grapecity.com/spreadjs/docs/v14/online/clipboard.html
  
  But I can’t figure out how to use them.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 17 November 2021, 3:33 am EST

  Hey,

  You can copy and paste programmatically by executing copy and clipboardPaste commands.

  Use activeSheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.all to paste all data objects, including values, formatting, and formulas.

  Here is a sample: https://jscodemine.grapecity.com/sample/LQn5o7hhjky5a5PdmsF1Vg/

  clipboardPaste type:
  
  https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands.clipboardPaste.html

  copy Field: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands~copy.html

  ClipboardPasteOptions Enumeration: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.ClipboardPasteOptions.html

  Thanks

• 

  devadmin

  • Post Options:
  • Link
    Copy

  Posted 17 November 2021, 6:13 am EST - Updated 3 October 2022, 9:32 am EST

  Hi!
  
  Thank you for your help!
  
  However it’s still not clear what are the options of the copy operation because its type is just Object.
  
  Can you help me with that?
  
  

  

  706×198 6.55 KB

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 22 November 2021, 2:31 am EST

  Hi,

  The options argument list is listd in the docs. Please refer to the following link and let me know fit is good enough for your requirement.

  https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands~autoFitColumn.html

  Regards
  
  Avinash

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 22 November 2021, 2:32 am EST

  Hi,

  SpreadJS definition file actually contains information about the argument list for commands, found in the SJS download in the “definition” folder. you may also refer to the attached file.

  Further, We have made enhancement requests for our docs. The internal ID for this issue will be SJS-6807.

  Regards
  
  Avinash

  commands.zip