Excel download: NaN downloaded as zero

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

    Posted 22 May 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?





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

  2. Georgi Krustev
    Georgi Krustev avatar
    3707 posts

    Posted 24 May 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:
    Georgi Krustev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
  3. Kendo UI is VS 2017 Ready
Back to Top