jQuery UI Widgets › Forums › Grid › clipboard function to nested grid
Tagged: clipboard, grid, jqxGrid ;, nested grid
This topic contains 4 replies, has 2 voices, and was last updated by Stanislav 6 years, 11 months ago.
-
Author
-
Hi guys,
I have nested jqx grid with clipboard function. Everything works well except that copy data from excel and pasting it into NESTED grid takes about 12 seconds to take effect after pressing ctr+V (table 11×9 11 columns and 9 rows).
Master grid with same data is rather fast but pasting it into nested grid takes time.
` grid.jqxGrid({
source: nestedAdapter,
theme: theme,
width: ‘100%’,
autoheight: true,
columnsheight: 25,
editable: true,
selectionmode: ‘multiplecellsadvanced’,
showstatusbar: true,
showaggregates: true,
altrows: true,
handlekeyboardnavigation: function (event) {
event.stopImmediatePropagation();
},
columns: columnsYrs,
});I have just updated to jqx 5.6.0 and it is still slow.
Any ideas?
ThanksHello atomic,
Maybe there is something in the dataAdapter that is slowing down the process.
If you can share your DataAdapter inside some kind of an example for us to test, that would be great.Best Regards,
StanislavjQWidgets Team
http://www.jqwidgets.com/Hi Stanislav,
Thanks for the reply.
Acctually I figured out what is slowing down the process.
If I set these two properties to false:showstatusbar: false, showaggregates: false,
pasting is very fast. It seems that aggregates[‘sum’] is delaying the process of pasting data to grid.
I even tried to invoke aggregates on click event, after pasting values, but still showing aggregates on this grid (11×50) is rather slow.
$("#invokeAggregates").on('click', function () { $("#jqxgrid").jqxGrid({ showstatusbar: true, showaggregates: true }); });
Any ideas how to deal with this one?
ThanksSolution.
Correct way to invoke aggregates on click event would be:$("#invokeAggregates").on('click', function () { $("#jqxgrid").jqxGrid({ showaggregates: true, showstatusbar: true }); $('#jqxgrid').jqxGrid('refreshaggregates'); $('#jqxgrid').jqxGrid('renderaggregates'); });
and everything is fine…
Hope this helps someone..Hello atomic,
Thanks for the update!
Best Regards,
StanislavjQWidgets Team
http://www.jqwidgets.com/ -
AuthorPosts
You must be logged in to reply to this topic.