Xlsx export issue

4 posts, 1 answers
  1. Stefania
    Stefania avatar
    154 posts
    Member since:
    May 2013

    Posted 11 Jun 2015 Link to this post

    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     

  2. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 12 Jun 2015 Link to this post

    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
  3. Stefania
    Stefania avatar
    154 posts
    Member since:
    May 2013

    Posted 12 Jun 2015 in reply to Dimitrina Link to this post

    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

  4. Answer
    Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 15 Jun 2015 Link to this post

    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
Back to Top