1. Feedback
  2. JavaScript
  3. 26157

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

Exporting pivot table with zero values produces corrupted Excel file

To replicate the issue, create a pivot table with the following configuration:

{

  dataSourceSettings: {

    values: [{ name: 'data' }],

    formatSettings: [{ name: 'data', format: 'N1' }],

    dataSource: [{ data: 0 }]

  },

  allowExcelExport: true,

  toolbar: ['Export'],

  showToolbar: true

}


The exported Excel file from this pivot table is invalid, and Excel gives the following error message (attached) when trying to open the file: "We found a problem with some content in 'Export.xslx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."