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.
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.
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.
Kind Regards,
Albert
Not sure why the Images I included aren't showing up in the previous post...
Attempting to re-post with pictures...
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 in the collapsed state.