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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

concatenation in a formula

Thread ID:





71733 Feb 11,2008 11:39 PM UTC Feb 12,2008 12:10 PM UTC WinForms 1
Tags: GridControl
Brian R
Asked On February 11, 2008 11:39 PM UTC

Hey there,

I have a grid with three cells. The first has a baseline numeric value, say 1000. The second one has an manual override value, say 1500. I need the third to display the difference between the two values both as a percentage and a difference, seperated by a '/'. I've nearly managed this using formulas with the following.

"=(ROUND(((1500-1000)/1000), 2) * 100) & \"% /\" & ROUND((1500-1000), 0)"

The problem is that the result is displayed contained within a pair of double quotes, ie.

'"50% / 500"'

What I would like to see is '50% / 500', no "s.

Any advice would be grealy appreciated.


Jeba S [Syncfusion]
Replied On February 12, 2008 12:10 PM UTC

Hi Brian,

You can handle the DrawCellDisplayText event and control the display of the formula result. Below is the code snippets:

private void gridControl1_DrawCellDisplayText(object sender, GridDrawCellDisplayTextEventArgs e)
if( e.RowIndex>0 && e.ColIndex>0)
e.DisplayText = e.DisplayText.Replace("\"","'");

Please refer the sample which implements the above said feature:

Kindly let us know if you need any further assistance.

Best Regards,


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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