Pasting from Excel into DataTable with editor enabled

Webix JS
1

Hi,

I have a editable DataTable. I want to give the user an option of either directly editing the table or copy and paste directly from excel using Clipboard.

editable:true,
columns:[
         { id:'Sno',  header:['S.No.'],width:40,css:{'text-align':'right'}},
         { id:'sDataValue', header:['Data'],width:85,css:{'text-align':'right'},editor:'text'}
],
select:"cell",
multiselect: true,
clipboard: "selection",

Thanks in advance

Ashok

2

Your code is correct. Still you need to change the edit-start action to dblclick or some other trigger. As with single click, you can’t just select the cell.

Check the next sample, you can edit any cell by dbl-clicking, and in same time you can select cell and use ctrl-v to paste some value.

http://webix.com/snippet/79693dba

3

Thank you.

4

btw, where can i get a comprehensive list of keycodes like “dblclick”, “up” etc

5

http://docs.webix.com/api__link__ui.datatable_editaction_config.html

6

I was actually looking for key mapping like function key F2 for the custom editaction

7

You can use something like next

	webix.UIManager.addHotKey("enter", function(view){
		var pos = view.getSelectedId();
		view.edit(pos);
	}, gridc);

Check the third table here

http://docs.webix.com/samples/15_datatable/04_editing/01_basic.html

8

Thank you