While performing copy and paste functionality we are facing the following problems. Please let us know how to resolve these issues.
a. When pasting the data from EXCEL to the grid, it is allowing us to paste into the disabled (read-only) cells. Ideally, paste should not be allowed in the read-only cells.
b. Also, it is not allowing us to paste the data in to read-only combo box (Select Box). If we use editable combo box, we are able to paste the data which is not present in the dropdowns. Ideally user should be able to paste only the data which is present in the combo box.
>>a. When pasting the data from EXCEL to the grid
Can be done by small modification of existing js file, in dhtmlxGrid_selection.js, function pasterBlockFromClipboard, line 275
var ed = this.cells3(row, j);
if (!ed.isDisabled())
ed[ ed.setImage ? “setLabel” : “setValue” ]( serialized[ k ][ l++ ] );
by adding colored line, you will allow pasting to editable cell only
>>we are able to paste the data which is not present in the dropdowns
combobox allows entering any data while edit, so they correctly mimic behavior while pasting operation