when I manually resize columns on PivotGrid and then run Export to Excel (or PDF) - row descriptor columns (Day, Aggregates) are same size in Excel, but aggregates columns somehow resized. Is it by design or there is a way to export row descriptor columns width as well?
2 Answers, 1 is accepted
answered on 07 Mar 2018, 09:42 AM
By default the custom width is not exported, however, you can set the width after the workbook is created. The following code shows how you can get the width from the pivot as well:
void button_Click(object sender, EventArgs e)
PivotGridSpreadExport spreadExport = new PivotGridSpreadExport(this.radPivotGrid1);