Spreadsheet - Copy and paste function using API

[Brian]

Hi,

How do i trigger a copy and paste function in kendo ui jquery spreadsheet via API? I am trying to copy a selected range of records and paste it over but it does not work with the below codes.

var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
var sheet = spreadsheet.activeSheet();

sheet.range(1, 0, 1, 100).select();
spreadsheet.trigger("copy");
sheet.range(0, 0, 1, 100).select();
spreadsheet.trigger("paste");

Thanks in advance.

[Neli]

Hi Brian,

If you need to get the values in a specific range in Spreadsheet and set them as values in another range I would suggest you use the Range values() method.

function pasteValues(){
  var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
  var sheet = spreadsheet.activeSheet();
  var current = sheet.range("A1:B2").select();
  var values = current.values()    
  sheet.range("D1:E2").values(values);
}

Here is a Dojo example where this si demonstrated.

The trigger() method is supposed to be used to execute all attached event handlers. However, it will not invoke any methods, i.e.  it will not copy or paste data. 

Let me know in case you have additional questions on the matter.

Regards,
Neli
Progress Telerik

[Brian]

Hi,

Besides copy of values, i would like to copy the formula and format if any. Will your above solutions fulfil my requirements as well?

[Neli]

Hi Brian,

The formula configured in a single cell can be retrieved and then set in another cell using the Range formula method:

- https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/formula

However, you will need to iterate over each cell in the copied range and get its formula.

Regards,

Neli