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

    Hello
    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

    IIF(S_FELIQ<{01/09/2010},15,IIF(S_FELIQ<{01/12/2010},23.05,29.2025))


    it gets truncated to

    IIF(S_FELIQ


    How can I solve this? 

  2. Mira
    Admin
    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.

    Regards,
    Mira
    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.

  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top