Hi,
I am using the NetAdvantage 11 and I also use UltraGridExcelExporter to export my data from the grid to excel file. On my grid, there are many headers and when I export them into the excel file. From that excel file, I want to do sorting/filtering, however when I do that, the Microsoft excel show me an error message: To do this, all the merge cells need to be the same size.
What should I do for this situation?
Thank you?
Phong Vo
Hello Phong,
Thank you for posting in our forum.
UltraGridExcelExporter is working in WYSIWYG way. So whatever merged cells you have in the grid the same merged cell you should have in exported excel file. If you need to change the merged cells in the resulting document you may handle BeginExport event of UltraGridExcelExporter. In this event the event argument contains Layout property. This layout is a clone of the grid layout. You can change this layout as you wish and it will affect only the exported document and not the grid’s layout itself. More about BeginExport event you may find by following the next link http://help.infragistics.com/Help/Doc/WinForms/2015.2/CLR4.0/html/Infragistics4.Win.UltraWinGrid.ExcelExport.v15.2~Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter~BeginExport_EV.html.
Please let me know if you need any additional information.
Thank you for using Infragistics Components.