1. Feedback
  2. WinForms
  3. 21851

Welcome to the WinForms feedback portal. We’re happy you’re here! If you have feedback on how to improve the WinForms, 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!

2
Votes

Export to Excel - Apostroph are not exported in front of each value

Export to Excel - Apostroph are not exported in front of each value.

I use code from :

https://help.syncfusion.com/file-formats/xlsio/working-with-data


I export that way a datatable into excel. My datatable contains columns which datatype is always string.

The content of the strings in these DataColumns may be numbers or dates or whatever.

In the excel file, there is no apostrophe exported in front of the values. So when a user open excel, values are formatted in the wrong way. If for example, Excel decimal separator in a comma, then values containing numbers (with a dot as decimal separator) will be formated as date..

An apostrophe in front of the value solve of course the issue.

How is it possible to export an apostrophe in a good manner, without adding it manualy ??