export to excel problem

2 posts, 0 answers
  1. Oscar
    Oscar avatar
    21 posts
    Member since:
    Sep 2008

    Posted 31 May 2011 Link to this post

    Using the mastertableview.exportto excel() method. If the grid has a cell that contains certain characters, the export is truncated.

    Example: if text inside a cell is


    it gets truncated to


    How can I solve this? 

  2. Mira
    Mira avatar
    1124 posts

    Posted 01 Jun 2011 Link to this post

    Hello Oscar,

    There are two ways the desired functionality to be implemented.
    The first one is to wrap the text in single quotes when exporting. The second is to set the
    mso-number-format attribute of the cell in the ExcelExportCellFormatting event handler.
    Please refer to the Word/Excel export (HTML-based) help topic for additional information.

    I hope this helps.

    the Telerik team

    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Back to Top