Grid hangs on pasting large data 2974 rows X 24 columns

Tags: #<Tag:0x00007efc606c7038>
#1

I am using HandsOnTablePRO 1.14.2.

The business req is paste the data on grid and import the same to server. While pasting, it is taking 3.5 - 5 min for the grid to refresh. Until then focus stays on first cell and hangs.

Any pointer on tuning this?
<hot-table
[hotId]=“instance”
[colHeaders]=“gridHeader”
[rowHeaders]=“false”
[dropdownMenu]=“dropdownMenu”
[filters]=“true”
[data]=“gridData”
(beforeCopy)=“beforeCopy($event)”
(beforePaste)=“beforePaste($event)”
(afterChange)=“afterChange($event)”
[contextMenu]=“contextMenu”
[sortIndicator]=“true”
[columnSorting]=“true”
[autoColumnSize]=“true”
[manualColumnMove]=“false”
[allowInsertColumn]=“true”
[manualRowMove] =“true”
[columns]=“columns”
[copyPaste]=“true”
(afterInit)=“showLoader($event)”
(afterLoadData)=“hideLoader($event)”

#2

Hi @sumathi.vellaisamy

Can you share a full demo (can be .zip)? I’ll test it and let you know my thoughts.

#3

Provided the Grid Component in drop box and shared to support mail-id . please take a look.

#4

Thanks @sumathi.vellaisamy

Can you tell me what you would like to achieve in the beforePaste hook?

#5

The grid has a column header. When I paste data, the first row of data is just a header. Hence I am trying to take that first row of data and fix as “header”, then rest alone should go as “Data”

#6

I wasn’t able to speed the process up. Maybe it’s related to the abilities of the Angular wrapper or the 3rd party libraries.

#7

But pasting on ur Vanilla versions were very fast !!! I tried with some fiddles…

#8

Sorry I do not have an ability to check the code now, but have you tried to use vanilla CE/PRO to check that is the difference? To find the bug I need to reject all information that doesn’t relate to the subject.

#9