1. Feedback
  2. JavaScript
  3. 41177

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

2
Votes

DataGrid's Excel Export's "hierarchyExportMode" differs from documentation

Hello! I've got an issue with the way Grid's Excel Export feature works in recent versions.

The ExcelExportProperties.hierarchyExportMode property is supposed to determine which childGrids are expanded in the exported Excel spreadsheet, according to the documentation, and i

t had this behavior in 19.2.44.

Changing this setting shouldn't affect whether the childGrids are exported at all. 

Here's the documentation for hierarchyExportMode for convenience, alongside its current behavior.

ModeBehaviorCurrent behavior
ExpandedExports the visible child grids in expanded state.Only exports visible child grids. Expands them in the spreadsheet.
AllExports the all the child grids in expanded state.Same behavior
NoneExports all child grids in collapse state.Doesn't export any child grids.

Demo in 

20.4.49, with convenient export buttons with each setting.

https://stackblitz.com/edit/xevgov?file=index.js


The same demo running 19.2.44 has the behavior defined in documentation.

https://stackblitz.com/edit/98qfrz?file=index.js


Thanks,

Ashley