AddComment() Performance

[Delmer Johnson]

When I call AddComment() worksheet creation slows dramatically. I can create a worksheet with a thousand rows in a second, but when I call AddComment on a cell more than a few dozen times it takes several minutes. I tried it with a MigrantRange and performance was still very slow. Can you provide a sample where you call AddComment for at least 20% of the rows, more than 200 times, that doesn't slow dramatically compared with when the AddComment() line is commented out? For example, with this code? http://mvc.syncfusion.com/demos/reporting/xlsio/DataManagement/Performance

Thanks,

Delmer Johnson

[Abirami Varadharajan]

Hi Delmer, 

 

Thank you for contacting Syncfusion support. 

 

We are able to reproduce the performance issue. We have prepared sample as per your scenario. The sample can be downloaded from following location. 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-161945416.zip  

 

Kindly refer and confirm us whether this is your scenario. If not, kindly modify and share us the issue reproducing sample which will be helpful for us to provide prompt solution at the earliest. 

 

Regards, 

Abirami. 

[Delmer Johnson]

Yes, it does.

[Abirami Varadharajan]

Hi Delmer, 

 

Thank you for updating us. 

  

We are able to reproduce “Performance issue while adding comments”. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates.  

   

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents   

   

Regards, 

Abirami.