Xlsx export issue

[Mattia]

Hi,

I used your example to improve my export (http://docs.telerik.com/devtools/wpf/controls/radgridview/export/export-xlsx)

It works perfecty excepted when I try to export some strings with quotation mark (').

How can I fix it?

Thank you

in Telerik.Windows.Documents.Spreadsheet.Model.CellValueFactory.CreateFormulaCellValue(String value, Worksheet worksheet, Int32 rowIndex, Int32 columnIndex)
   in Telerik.Windows.Documents.Spreadsheet.Model.CellValueFactory.ToFormulaCellValue(String value, Worksheet worksheet, Int32 rowIndex, Int32 columnIndex)
   in Telerik.Windows.Controls.GridView.ExportHelper.GetICellValue(Int32 rowIndex, Int32 columnIndex, Object content, Type type)
   in Telerik.Windows.Controls.GridView.ExportHelper.SetWorksheetCellValue(Object cellContent, ExportingTransferData data, GridViewElementExportingToDocumentEventArgs exportingArgs, Int32 rowIndex, Int32 columnIndex)
   in Telerik.Windows.Controls.GridView.ExportHelper.AddCells(Int32 rowIndex, Int32 startColumnIndex, Object dataItem)
   in Telerik.Windows.Controls.GridView.ExportHelper.AddDataRows(IEnumerable items, Int32 startRowIndex, Int32 startColumnIndex)
   in Telerik.Windows.Controls.GridView.ExportHelper.CreateWorkbook(GridViewDocumentExportOptions options)
   in Telerik.Windows.Controls.GridView.ExportHelper.CreateWorkbookForXslxFormat(GridViewDataControl grid, GridViewDocumentExportOptions exportOptions)
   in Telerik.Windows.Controls.GridViewDataControlExportExtensions.ExportToXlsx(GridViewDataControl gridViewDataControl, Stream stream, GridViewDocumentExportOptions options)
   in Test.GridViewExportExcelCommand.Execute(Object parameter) in d:\J_Jobs\Test\Commands\GridViewExportExcelCommand.cs:row 44

[Dimitrina]

Hi,

As it turns out, we are not able to reproduce such a problem with the latest version (lib). We recently resolved a similar problem and the fix is included in the latest internal build.

Would you please try it and let me know how does it work for you?

Regards,
Dimitrina
Telerik

[Mattia]

Hi,

I just tried to use the internal build Telerik_UI_for_WPF_2015_1_0608_Dev_Hotfix but it still not working

 

Thank you

[Dimitrina]

Hello,

After performing some further tests, we managed to reproduce the issue when there is "-" presented in the input content. It is logged as a bug and you can follow its progress in the Feedback Portal:
InvalidOperationException in Telerik.Windows.Documents.Spreadsheet.Model.CellValueFactory.CreateFormulaCellValue()

We apologize for this inconvenience.

Regards,
Dimitrina
Telerik