Hi,
I am using XamDataGrid and DataPresenterExcelExporter which is exporting my fields to Excel fine except for my unbound field which is coming up with blank values. Can you please advise?
This is my code snippet:
<ipdg:Field BindingType="Unbound" Label="Cust All-In Price" Visibility="Collapsed"> <ipdg:Field.Settings> <ipdg:FieldSettings Width="Auto" CellValuePresenterStyle="{StaticResource BidAskCell}" AllowRecordFiltering="False" LabelClickAction="Nothing"/> </ipdg:Field.Settings> </ipdg:Field>
Thanks.
Hello,
Thank you for your feedback. I am glad to know that I was able help you achieve the functionality you were looking for. I believe this thread can help other people looking for a similar solution.
If you require any further assistance on this matter, please do not hesitate to ask.
Would be great to have a CSV Exporter in the future but for now the Excel Exporter will do. Thanks a lot for your help.
Currently, the Workbook class does not support saving and loading to and from CSV files. For more information in regards to this behavior, you can take a look at the following thread:
http://es.infragistics.com/community/forums/t/104677.aspx
If you require any further assistance on the matter, please let me know.
Thanks. Do you have a CSV exporter by any chance?
Thank you for your feedback.
The behavior you have described is expected because the Excel itself recognizes the values with their editing type which is a string. In order to avoid the message produced by Excel you can always use the first approach and use explicitly defined numbers or change the type of the cells directly in Excel.