jQuery UI Widgets Forums Grid clipboard function to nested grid

This topic contains 4 replies, has 2 voices, and was last updated by  Stanislav 6 years, 2 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • clipboard function to nested grid #98787

    atomic
    Participant

    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?
    Thanks

    clipboard function to nested grid #98843

    Stanislav
    Participant

    Hello 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,
    Stanislav

    jQWidgets Team
    http://www.jqwidgets.com/

    clipboard function to nested grid #98916

    atomic
    Participant

    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?
    Thanks

    clipboard function to nested grid #98942

    atomic
    Participant

    Solution.
    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..

    clipboard function to nested grid #98946

    Stanislav
    Participant

    Hello atomic,

    Thanks for the update!

    Best Regards,
    Stanislav

    jQWidgets Team
    http://www.jqwidgets.com/

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.