We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to export the formula cells with formatted text only and cell style to excel from grid?

By default, in the GridControl, when a formula cell is exported to Excel, both the result of formula and formula text will be exported. To export the result with format and cell styles applied to the formula cell of the grid, create a custom GridExcelConverterControl class; override the ExportCellToExcel() method; set the result to the Excel cell. The result of the formula cell will be displayed by the GridStyleInfo.FormattedText property of that cell.

Code Snippet

CS

 

VB

 

Screenshot

 

Sample Link:

CS: Export formula cell with format_CS

VB: Export formula cell with format_VB

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8746 05/11/2018 05/15/2018 Windows Forms GridControl
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon