To reproduce:
- Create ColumnGroupsViewDefinition and export it with the following code:
SpreadExportRenderer renderer = new SpreadExportRenderer();
GridViewSpreadExport spreadExporter = new GridViewSpreadExport(radGridView1);
spreadExporter.FreezeHeaderRow = true;
spreadExporter.ExportViewDefinition = true;
spreadExporter.ExportVisualSettings = true;
spreadExporter.ExportGroupedColumns = true;
spreadExporter.ExportHierarchy = true;
spreadExporter.SheetMaxRows = ExcelMaxRows._1048576;
spreadExporter.ExportFormat = SpreadExportFormat.Xlsx;
spreadExporter.FileExportMode = FileExportMode.CreateOrOverrideFile;
spreadExporter.RunExport(dialog.FileName, renderer);
Workaround:
- Set FreezeHeaderRow to false.
You can manually freeze the rows as well:
private void Renderer_WorkbookCreated(object sender, WorkbookCreatedEventArgs e)
{
e.Workbook.ActiveWorksheet.ViewState.FreezePanes(2, 0);
}