Next
Update
Prev
Change History
Change History (XML)

You can change the TSV-formatted data to be pasted from Excel using the pasteParseJsFunction attribute. The JavaScript function, pasteParseFunction in this sample adds "-1" to the data if the column to be pasted is "Territory".

...
<DataGrid ... editable="true" doubleClickEnabled="true" pasteEnabled="true" pasteParseJsFunction="pasteParseFunction" ... >
...

function pasteParseFunction(parsedValue, parsedObj, item, column) {
  if (column.getDataField() == "Territory")
    return parsedValue + "-1";
  else
    return parsedValue;
}
pasteParseJsFunction This attribute is to set the JavaScript function to be applied to each row when data is pasted.

© 2017 KoolChart. All rights reserved.