Welcome to the WPF feedback portal. We’re happy you’re here! If you have feedback on how to improve the WPF, we’d love to hear it!>
Thanks for joining our community and helping improve Syncfusion products!
PivotGrid control is having the native support to export the grid values into Excel, PDF, Word and CSV documents. This could be achieved by various methods available in exporting helper class available in PivotGrid. While exporting the control into various formats, current view of grid control should be exported. As per default, we need to maintain the collapsed state of pivot fields in exported documents properly. But when exporting the PivotGrid control into Excel document as cell mode, collapsed fields are hidden in exported document. At the same time, while exporting our control into Excel document as PivotTable mode, collapsed fields are maintained properly in exported document. Hence we need to maintain the expanded/collapsed stated of pivot fields also for exporting the control to Excel document in cell mode.