Completed
Last Updated: 17 Jul 2017 13:51 by ADMIN
ADMIN
Dimitar
Created on: 26 Jun 2017 06:25
Category: GridView
Type: Bug Report
1
FIX. RadGridView - the ColumnGroupsViewDefinition is not exported when the FreezeHeaderRow property is true
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);
}
0 comments