Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
845
Excel Export Shows Summary Rows Of Collapsed Child Tables Of Hierarchical Data
posted

I think this is a bug, but wanted to check to see if there are any work arounds or settings I missed.

The picture below shows a collapsed hierarchical grid as it appears in a XamDataGrid control. The child tables have summary rows.

XamDataGrid_CollapsedHierarchical.png

I use the DataPresenterExcelExporter with default settings to export the grid to Excel2007 format. The problem is that the export shows the summary rows for child tables even though all parent rows are not in the collapsed state.

ExportToExcel_Hierarchical_ShowsChildSummaryRows.png

In Excel, when I double-click the [1] all the parent rows are collapsed and the child summary rows disappear. This is the initial state I was expecting to see after exporting the collapsed grid to Excel.

ExportToExcel_Hierarchical_CollapseParentRows.png

Kind Regards,

Albert

Parents Reply Children