I upgraded to the latest telerik version yesterday to change my pivot grid excel exporting to use xlsx. Now I’m getting auto formatting of data when it is exported. An example is I have column headers by fiscal year. So a value in the header that is “2006-07” ends up being “7/1/2006“ when it gets to excel. This happens for all my fiscal year column headers. And when I check the cell type in excel its set to Date even though the datatype in the DataTable and PivotGrid is a String. I tried to use the PivotGridCellExporting to possible change this but during that process the values are all correct.
If I change it back to export to xls the column header formats are correct. Is there some setting I can change to fix this issue?