1. Feedback
  2. JavaScript
  3. 26703

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

"Substitute character" (character code 26) in DataGrid crashes Excel export

To replicate the issue, see this example: https://stackblitz.com/edit/mtehnv?file=index.ts. When creating the Excel export file and opening it, Excel complains "We found a problem with some content 'Export.xlsx'. Do you want us to try and recover as much as we can?". Nothing from the file can be recovered by Excel.

The problem appears when the data contains a character called "Substitute character" (character code 26) (https://en.wikipedia.org/wiki/Substitute_character). That is a control character which is not a written symbol, but it's still a valid character for example in the Unicode. Excel files can also contain that character, so it seems doable to generate a valid Excel file containing it.

(It seems that Chrome shows that character is a box, but Firefox doesn't show it at all.)