Last Updated: 12 Feb 2018 12:37 by ADMIN
Created on: 08 Feb 2018 16:19
Category: PivotGrid
Type: Bug Report
FIX. RadPivotGrid - the data cells of aggregate descriptions with an applied format are exported by the PivotGridSpreadExport class as unformatted text cells
The best solution would be to have cells in Excel with the correct data type and formatted values. This can be achieved with an additional property similar to RadGridView. At the moment data cells which are created from aggregate descriptions with an applied StringFormat property are exported as text and they do not persist the formatting which is not correct.

 A possible workaround is to set the ExportVisualSettings property of the PivotGridSpreadExport object to true so that the formatting event to fire. Then in the CellFormatting event one can set the FormatString this way:
        private void SpreadExport_CellFormatting(object sender, PivotGridSpreadExportCellFormattingEventArgs e)
            if (e.Cell.Text.StartsWith("$"))
                e.Cell.FormatString = "$ #.00";
            else if (e.Cell.Text.Contains("€"))
                e.Cell.FormatString = "#.00 €";

PivotGridSpreadExportCellFormattingEventArgs, however, does not provide information about the actual aggregate of the data cell, so the applied number format on the aggregate cannot be obtained in the formatting event.