This question is locked. New answers and comments are not allowed.
I'm using DataFormatString to format an integer and noticed the column is exported as a String. This value needs to remain as an integer\number so that users are able to work with it in Excel.
What is the best way to format a column yet maintain it's original type when exporting to excel (ExportFormat.ExcelML)?
XAML
ExampleExport.xml
<Cell ss:Index="2"><Data ss:Type="String">9281</Data></Cell>
Note: I noticed the same behaviour when using an IValueConverter to format the integer rather than DataFormatString.
Thanks for your help!
What is the best way to format a column yet maintain it's original type when exporting to excel (ExportFormat.ExcelML)?
XAML
<grid:GridViewDataColumn Header="Example Count" DataMemberBinding="{Binding ExampleCount}" DataFormatString="{0:N0}">
ExampleExport.xml
<Cell ss:Index="2"><Data ss:Type="String">9281</Data></Cell>
Note: I noticed the same behaviour when using an IValueConverter to format the integer rather than DataFormatString.
Thanks for your help!