Grouped rows information is lost when the grid has only multi-column headers and is exported to excel #12787
Description
Description
When we have a grid with only multi-column headers without single columns (that is, we only have igx-column-group with igx-column in it), a grouping feature and an export to excel feature and we group a given column, what happens is that we have grouped rows that show information about the grouped columns and their values. After exporting the grid to Excel, these information from the grouped rows are lost and they remain empty. In addition, this does not happen when we have a single column at the beginning of the grid before the multi-column headers.
- igniteui-angular version: 14.2.x 15.0.x
- browser: all
Steps to reproduce
- Go to this sample.
- Оbserve that we have a grid with multi-column headers.
- We don't have a single column in front of the column groups and the grid columns start directly with multi-column headers.
- Notice that there is already a grouped column.
- There are grouped rows showing the information which is the column and what is the value.
- Press the export button and open the downloaded excel file.
Result
Notice that the downloaded еxcel file is missing these grouped rows with the grouping information, instead they are blank.
Expected result
Instead of empty lines, the grouping information about the column and value should be displayed there.
Additional information
Before the column groups, there is a single column, when you uncomment it, that is, when we have a grid, that start with a single column and continue with multi-column headers, the described behavior does not appear. Also when we have a single column at the end after the multi-column headers then the grouping information in the grouped rows is shown at the end again under that single column.