ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: Sunny on April 24, 2015, 11:45:09 pm

Title: Copy/Paste taking 4 to 7 seconds in IE8
Post by: Sunny on April 24, 2015, 11:45:09 pm: Hi,

I am using the Evaluation version, noticed that copy/paste is taking 4 to 7 seconds while using IE8 browser, not sure if thats because of evaluation version or not. Also noticed same behaviour happening in one of your PRO demos at: Grouping Summary-->ArraySummary/JSONSummary.

Can you please advice why and how to resolve it.

Also, looking for a feature of 'AutoSum' in Excel. If we change value in one grid, the total in other grid should reflect it. Is it possible ?

Thanks.
Title: Re: Copy/Paste taking 4 to 7 seconds in IE8
Post by: paramvir on April 27, 2015, 08:53:40 pm: 1) Please use virtual mode (virtualX: true, virtualY: true ) for faster copy / paste. Both the mentioned demos use non virtual mode.

2) Use cellSave event in first grid to update the value by invoking updateRow on second grid.
Title: Re: Copy/Paste taking 4 to 7 seconds in IE8
Post by: Sunny on April 27, 2015, 09:38:04 pm: Hi,

Thanks for the reply.

I was already using the virtual mode (virtualX: true, virtualY: true ) property, as my grid contains large data with around 500 rows and 50 columns. Copy/Paste is still slow in IE8, I tried virtual mode in your demo as well which it didn't help either there as well in IE8.

Also here are my properties list on the grid:
var obj = {
   width: 1300, //width of grid
   height: 450, //height of grid
   colModel: columns,
   dataModel: {data: rows},
   sortable: true,
   freezeCols:7,
   collapsible:{on:false,collapsed:false},
   selectionModel: { type: 'cell' },
   editModel: { clicksToEdit: 2 },
bottomVisible:false,
   filterModel: { header: true, type: 'local' },
   virtualX:true,
   virtualY:true,
   showTitle:false,
   showTop:true,
   showBottom:false,
   roundCorners:true,
scrollModel:{pace: 'consistent', flexContent:true }
};

Please suggest.
Title: Re: Copy/Paste taking 4 to 7 seconds in IE8
Post by: Sunny on April 28, 2015, 08:36:00 pm: Hi Admin/Paramquery,

We liked all the features of the Pro version, except the slow performance of Copy/Paste functionality in IE8 which has been as a ShowStopper for us to buy the licensed version.

Can you please provide workaround for this in IE8 ?

Thanks in advance.
Title: Re: Copy/Paste taking 4 to 7 seconds in IE8
Post by: paramvir on April 28, 2015, 09:00:54 pm: Please do use <!DOCTYPE html> at the top of your web page and double check the virtual mode in demos. Also you haven't mentioned how many cells you tried to copy / paste.

I checked this demo http://paramquery.com/pro/demos/infinite (which is in virtual mode) by copy / paste 10,000 cells (10 rows x 1000 columns).

10,000 cells is good enough benchmark and it didn't take more than a second in IE8 for me.

Please note that copy paste beyond a few thousand cells is bound to be slow as copy/paste functionality in PQ Pro is implemented in pure javascript which has certain clipboard memory constraints.
Title: Re: Copy/Paste taking 4 to 7 seconds in IE8
Post by: Sunny on May 01, 2015, 11:54:01 pm: Thank you admin. I tested in my colleagues machine who has Windows 7 with IE8. Its relatively better over there compared to mine, having windows XP with IE8.