How to copy above line into next line

How to copy above line into next line

Posted by: gagandeep.singh on 28 September 2023, 2:17 am EST

• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 September 2023, 2:17 am EST - Updated 28 September 2023, 2:22 am EST

  Hi there,
  
  Please refer to the attached pic
  
  I have one requirement when user click on Adjustment (my own command) it should create new line and copy data from above line.

  For eg in this case line number 8 copy and change the data from Return to Supplier Misc to
  
  Return to Supplier Misc (updated)

  and paste this data into new line between 8 and 9 without changing other data.

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 28 September 2023, 6:40 pm EST

  Hi,

  You can bind a function or command to the “Adjustment” option of the context menu. This function would be invoked when the “Adjustment” option is clicked. Inside this function, you can find the selections (or active cells) in the sheet and accordingly insert the new row with the sheet.addRows() method.

  To copy the data of the above to the inserted row, you can use sheet.copyTo() method.

  Please refer to the attached sample for more understanding.

  sample:https://jscodemine.grapecity.com/share/VH5qNvlN90a7zvXXb3W7Uw/?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:

  sheet.addRows(): https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#addrows
  
  sheet.copyTo(): https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#copyto

  Regards,
  
  Chandan