Excel download: NaN downloaded as zero

[Labhesh]

Hi , 

 

I am using pivotgrid's angular version. 

 

When I download using excel (saveAsExcel()) functionality, all NaNs in my pivotgrid download as 0s in the excel. I'd like them to be kept as NaNs...

How can I do this?

 

Thanks, 

 

Labhesh

$scope.exportToExcel = function() {
    var pivotGrid = $("#pivotgrid").data("kendoPivotGrid");
    pivotGrid.saveAsExcel();
};

[Georgi Krustev]

Hello Labhesh,

The PivotGrid Excel export functionality is designed to export the data values without any modifications. If you would like to modify the representation of the exported data then you will need to modify the generated OOXML document. Check this help topic for more details:

• http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/export#excel-customization

Regards,
Georgi Krustev
Telerik