Excel download: NaN downloaded as zero

2 posts, 0 answers
  1. Labhesh
    Labhesh avatar
    23 posts
    Member since:
    Sep 2015

    Posted 22 May 2016 Link to this post

    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();
    };

  2. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3718 posts

    Posted 24 May 2016 Link to this post

    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:
    Regards,
    Georgi Krustev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top