1. Feedback
  2. JavaScript
  3. 8361

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Excel export of Pivot Table with 0 columns and 2+ values results in collapsed last column

When you export a Pivot Table with N rows, 0 columns and 2+ values, the last column has its width set to NaN which results in the row being collapsed when opened in excel.

In 

@syncfusion/ej2-excel-export/src/workbook.js > parsetColumns you can see why this is at this code section:

if (json[column].width !== null && json[column].width !== undefined) {
    col.width = json[column].width;
}

For the above configuration json[column].width is NaN, which does not satisfy the checks against null or undefined and so col.width gets set to NaN

I've attached an image of what it looks like in Excel