This is a migrated thread and some comments may be shown as answers.

Xlsx export issue

3 Answers 94 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Stefania
Top achievements
Rank 2
Stefania asked on 11 Jun 2015, 03:42 PM

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     

3 Answers, 1 is accepted

Sort by
0
Dimitrina
Telerik team
answered on 12 Jun 2015, 07:41 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Stefania
Top achievements
Rank 2
answered on 12 Jun 2015, 08:56 AM

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

0
Accepted
Dimitrina
Telerik team
answered on 15 Jun 2015, 06:54 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
GridView
Asked by
Stefania
Top achievements
Rank 2
Answers by
Dimitrina
Telerik team
Stefania
Top achievements
Rank 2
Share this question
or