Grid LazyLoading and export to Excel

[Paul]

Hi,

I using SfGrid v19.2.0.51.

I have found that with LazyLoading = true, only the top level caption rows are exported to Excel, even if the rows have been expanded.

Is there a way of exporting all rows to Excel, top level and children, regardless of whether the top level has been expanded or not?  That is, perhaps the export could load all rows during its process?

(It would be important though that if the export could load all rows then it would not necessarily populate the grid with those rows, as I have found that a grid without paging that has a tens of thousands of child rows is extremely slow and memory hungry when it loads all of them - in my testing I have waited 10+ minutes for a grid to populate and memory usage on the server and in the browser can go up to 4GB!!)

Thanks.

Paul

[Vignesh Natarajan]

Hi Paul,  

 

Thanks for contacting Syncfusion support.  

 

Query: “only the top level caption rows are exported to Excel, even if the rows have been expanded.” 

 

We have analyzed the reported query and we are able to reproduce the reported issue at our end also. The reported issue has occurred due to ForeignKey column defined in Area page Grid.  We have confirmed the reported query as a bug and logged the defect report “Exporting is not working properly with LazyLoadGrouping” for the same. Thank you for taking the time to report this issue and helping us improve our product. Fix for the defect will be included in our weekly release which is expected to be rolled out by mid of September 2021. We will update you once the release is rolled out.     

        

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.        

    

https://www.syncfusion.com/feedback/27716/exporting-is-not-working-properly-with-lazyloadgrouping  

 

Till then we appreciate your patience.                                                                                                                                         

 

Regards, 

Vignesh Natarajan 

[Vignesh Natarajan]

Hi Paul,  

Sorry for the inconvenience caused.  

Due to unforeseen circumstances, we are unable to include the fix for the reported issue “Exporting is not working properly with LazyLoadGrouping”  in our weekly patch release as promised. Fix for issue will be included in our weekly patch release which is excepted to be rolled out by end of October 2021 

Feedback: https://www.syncfusion.com/feedback/27716/exporting-is-not-working-properly-with-lazyloadgrouping  

Till then we appreciate your patience.   

Regards, 

Vignesh Natarajan 

[Vignesh Natarajan]

Hi Paul,

 

We are glad to announce that our latest release(19.3.0.47) has been successfully rolled out. We have included the fix for this issue “Exporting is not working properly with LazyLoadGrouping” in our latest version release. So please upgrade to our latest release for the latest fixes and features. 

Nuget: https://www.nuget.org/packages/Syncfusion.Blazor/

 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.   

    

Regards,              

Vignesh Natarajan