HGrid: Excel Export is not working properly when there are collapsible column groups in the child grid

[MarielaTihova]

Description

When we use collapsible column groups in a child grid, downloading the hgrid data in Excel does not work properly. The header of the column that is marked as [visibleWhenCollapsed]="true" is skipped in the excel data, but the data itself is there. Which leads to shift in the data for each of the next columns.

• igniteui-angular version:
• browser:

Steps to reproduce

1. Create hgrid that has rowisland with at least one column group like this

<igx-column-group header="Delivery" [collapsible]="true">
     <igx-column field="delivery.dateOrdered" header="Date Ordered" [dataType]="'string'" [width]="'180px'" [sortable]="true" [resizable]="true" [visibleWhenCollapsed]="true"></igx-column>
     <igx-column field="delivery.dateOrdered" header="Date Ordered" [dataType]="'string'" [width]="'180px'" [sortable]="true" [resizable]="true" [visibleWhenCollapsed]="false"></igx-column>
     <igx-column field="delivery.dateShipped" header="Date Shipped" [dataType]="'string'" [width]="'180px'" [sortable]="true" [resizable]="true" [visibleWhenCollapsed]="false"></igx-column>
</igx-column-group>

2. Try to export in excel format

Result

Result includes only the non-collapsed columns headers.

Expected result

Result should include the collapsed columns content (if collapsed) or the non-collapsed (otherwise).

Attachments

1. We have this child grid so we expect to see all 3 columns in the excel downloaded

2. Instead we see this

3. We see the above result regardless whether we have column collapsed or not