CellFormatting on RunExportAsync

[Dominik]

I ma using Telerik.WinControls.Export.GridViewSpreadExport to export data to XLSX.

The CellFormatting event is not called when using RunExportAsync().

It is only called when using RunExport();

Why is that?

[Dess | Tech Support Engineer, Principal]

Hello, Dominik,  

As it is noted in the online documentation, due to performance considerations and in order to decrease the consumed memory the visual settings and view definitions in RadGridView are not exported when the operation is run async. If you need to export visual settings feel free to run the export synchronously by using the RunExport method.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess
Progress Telerik

[Dominik]

Fair enough. Thanks for help!

[Alejandro]

I need export with visual settings and Asynchronous, or there a way to export with "RunExport" and show progress bar?

Thanks

[Dess | Tech Support Engineer, Principal]

 

Hello, Alejandro,

As it was previously noted, due to performance considerations and in order to decrease the consumed memory the visual settings in RadGridView are not exported when the export operation is run async.

Please refer to the "Exporting Data Asynchronously" section in the following help article which demonstrates how the async spread export feature can be combined with a RadProgressBar control to deliver better user experience: https://docs.telerik.com/devtools/winforms/controls/gridview/exporting-data/spread-export

The progress is not reported when using the RunExport method since it doesn't use a BackgroundWorker which actually reports the progress of the executed work.  
Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik