copy paste from excel is slow/not working

[mraj]

Hi,
I tried to copy rows from excel . ( Around 15 columns , char, float( decimal 4 digits, int )

For 12000 rows . out of memory exception came.
also in the debugging. getting warnings as


So, i removed all of the column validations.  After that, copied and tried,

For 1000 rows it took 6-7 secs.
For 2000 rows it took around 20secs.
For 4000 rows it took around 1 min.

Getting warnings:
[Violation] 'setTimeout' handler took 6246ms   - pqgrid.min.js
[Violation] Forced reflow while executing JavaScript took 1879ms  pqgrid.min.css:!

[Violation] 'setTimeout' handler took 22034ms
[Violation] Forced reflow while executing JavaScript took 4033ms

Is there any way to avoid /deferred ( DOM painting ) event in the pq grid. Event i commented all the code in cell paste event.


For simple copy paste to notepad. there no issue.


thanks in advance

[paramvir]

use virtual rendering: virtualX: true, virtualY: true,

Paste of 10,000 rows or 1,00.000 cells takes around 1 second in pqgrid.

Example: https://paramquery.com/demos/copy_paste

[mraj]

Thanks,

It worked. for paste of 12,000 rows trial. But freeze cols, columns in the grid gets affected/size getting changed. will check further.