Next
Update
Prev
Change History
Change History (XML)

You can paste a TSV-formatted data into an entire row using the Crtl-V key. Select the row into which you want to paste and press the Crtl-V key. You have to enter the data for the entire row, each column of which is separated by TAB. The pasteEnabled property must be set to true.

...
<DataGrid ... editable="true" doubleClickEnabled="true" pasteEnabled="true" pasteEditEndJsFunction="pasteEditEndFunction" ... >
...

function pasteEditEndFunction(rowIndex, columnIndex, item, dataField, oldValue, newValue) {
  if (columnIndex == 2) {
    if (newValue == "Arizona") {
      alert(dataField+" cannot insert Arizona.");
      return false;
    }
  } else if (columnIndex == 5) {
    if (isNaN(newValue) || newValue < 1000) {
      alert(dataField+" must have 1000 (or larger values).");
      return false;
    }
  }
  
  return true;
}

© 2017 KoolChart. All rights reserved.