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
it gets truncated to
How can I solve this?
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?
1 Answer, 1 is accepted
0
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
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.