spreadsheet is not working,taking too longer for 1000 rows and above which has data validation as list for that column

[Goutham]

Hi,

i am using spread sheet component to edit data,which is over 1000 rows of data.and i am adding validation for columns (list validation which is count of 10)
but it got strucked even for 2 columns
Ple

this.spreadsheetObj.addDataValidation({ type: 'List', inCellDropDown: true, value1: val1.data.join(',') }, `${alpha[ind]}2:${alpha[ind]}${this.mappedExcelData.length + 1}`);

[Sangeetha Priya Murugan]

Hi Goutham,

We have checked your reported issue by adding the list validation for 2 columns with 1000 rows and the delay doesn’t occurs in our end. For your convenience, we have prepared the sample that apply list validation for 1000 rows in E and F column in created event. Please find the link below.

Sample Link: https://stackblitz.com/edit/angular-mnrmh9?file=app.component.ts

Could you please check & replicate your issue in the above sample and send back to us with more information such as, if you did any other customization, Version details. so that we could be able to sort out the cause of this issue and provide you a better solution quickly? The information provided would be great help for us to proceed further

Regards,

Sangeetha M

[Goutham]

Hi,
thanks for quick response.
I think above specified issue arises when we add highlight for invalid

this.spreadsheetObj.addInvalidHighlight();
here is example
https://stackblitz.com/edit/angular-mnrmh9-gxfz6x?file=app.component.ts,app.component.html,data.ts

Thanks you.

[Sangeetha Priya Murugan]

Hi Goutham,

We have checked the sample that you have shared, but we haven’t encountered any performance issue in our end. For your convenience, we have prepared the video demonstration of this in our machine. Please find the link below.

Video Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/datavalidation-193533823

Could you please check the above video and get back to us with the exact issue replicable sample and video with version details? Based on that we will check and provide you a better solution quickly.

Regards,

Sangeetha M

[Goutham]

Hi,
Could Please try to change the value of cell by selecting the value from  drop down for that particular column
you will able to see the issue.
Thanks you.

[Sangeetha Priya Murugan]

Hi Goutham,

We have checked your provided sample by changing the list validation values and we are not encountered any performance issue in our end. For your convenience, we have prepared the video demonstration of this in our machine. Please find the link below.

Video Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/li-validation-1844296888

Could you please check the above video and get back to us with the exact issue replicable sample and video with version details? Based on that we will check and provide you a better solution quickly.

Regards,

Sangeetha M

[Goutham]

Hi ,
i think you can observe the same issue here
Please check below example
https://stackblitz.com/edit/angular-mnrmh9-gxfz6x?file=app.component.ts,app.component.html,data.ts

[Sangeetha Priya Murugan]

Hi Goutham,

We have checked the sample once again and we are not faced any performance issue with list validation actions. And we have already shared the video demonstration of initial rendering and data change actions for list validation. Could you please share the video demonstration of this issue in your end, based on that we will get a clear view regarding this issue and provide you a better solution quickly.

Regards,

Sangeetha M