Team,

We have some issue while reading hierarchical data from xamDataGrid for export to excel. Without expanding child grid rows if we try to read xamDataGrid hierarchical data then the ActualPosition.Column for all child fields returning 0 (Step1).

Once if grid child expanded then data will read as expected (Step2).  

Please find the attached POC(ZIP) for your kind reference.

We are following the same on across the suite, please help to resolve this issue ASAP.

Observation Ex:

//Hierarchical child rows fields actualPosition problem : if grid is not expanded then ActualPosition.Column for all child fields shows 0                       

excelWorkSheetRow.Cells[record.FieldLayout.Fields[i].ActualPosition.Column + level].Value = record.FieldLayout.Fields[i].Label.ToString();

Please find the screenshot(ZIP):

XamDataGridExportData POC:

Step1:

1. On the log window select ‘Export’ option on ribbon
2. Observe the child row

Actual Result:

‘Field Name – Class’ is not displayed in the child row

‘Field Name – Line of business’ is not displayed in the child row

See attached excl screenshot “ImgStep1”

Expected Result:

‘Field Name – Class’ should be displayed in the child row

‘Field Name – – Line of business’ should be displayed in the child row

Step2:

1. On the log window expand clients
2. select ‘Export’ option on ribbon
3. Observe the child row 

Working as expected, See attached excl screenshot “ ImgStep2”

Please let me know if you need more information.

Thanks,

Guruprasad Gowda