Hello Mike,

Thanks for the reply...Its my mistake i did not remove the lines like Activation and style for the code, i agree it has to be in InitializeRow...

Many of the article says we can achieve highlighting the Text using simple FormattedText., so i was experimenting using FormattedText,

For instance i have a ID columns with values

ID

123

1235

1234556

say i want to format the text in the column to change the appearance of the digit 55 to bold using Formatted Text..

if you can please provide the sample for highlighting the text for the integer column it would be really helpful..

Thanks

Manoj

Hi Manoj,

If you wanted the grid cell to display "1234556", which the "55" in bold, then you would have to use a String column in the grid. You can't do this with an integer column. So like I said, what I would do is use an unbound column. The code might look something like this:

        private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
        {
            // Hide the "real" data column
            e.Layout.Bands[0].Columns["Int32 1"].Hidden = true;
            
            // Add an unbound column 
            UltraGridColumn formattedColumn = e.Layout.Bands[0].Columns.Add("Formatted Int32 1");
            formattedColumn.DataType = typeof(string);
            formattedColumn.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.FormattedText;
            formattedColumn.Header.Caption = "Int32 1";
        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            // Make sure the unbound column exists. 
            if (e.Row.Band.Columns.Exists("Formatted Int32 1"))
            {
                // Get hte int value from the Int32 1 column. 
                int realValue = (int)e.Row.Cells["Int32 1"].Value;

                // Build a formatted string for the text and apply it to the unbound column. 
                string formattedText = realValue.ToString().Replace("55", "<b>55</b>");
                e.Row.Cells["Formatted Int32 1"].Value = formattedText;
            }
        }

Hi Mike,

Thanks for the reply...

Following is my concern on implementing this (highlight of test) using the unbound columns

1. There might be a scenatio where the number columns may be more (say 5, 10....) so for each column of type integer we have to create a unbound column then hide the original columns making the new unbound column visible, and this will not be dynamic.....

2. And in future when ever there will be changes to remove or add a new column then all the time we need to change this piece of code which is not a good idea....

So what i have done is (nothing gr8 though) but slightly tweaked

i am creating the new dataset  with the columns similar to a original dataset and importing the rows to the newly created dataset, so when i add a columns to the new dataset all the columns will be of type string..

and then i am formatting the column in the similar way as mentioned above (FYR: the below code)

// Build a formatted string for the text and apply it to the unbound column.
                string formattedText = realValue.ToString().Replace("55", "<b>55</b>");

e.Row.Cells["Formatted Int32 1"].Value = formattedText;

And this works fine..!!! Which is finally what is needed...and it solves my above two concerns... :)

Please let me know ur thoughts....

Thanks

Manoj

Hi Manoj,

The down side of doing it that way is the when you sort, filter, or use a summary in the grid, the values will all be treating as strings. So numbers won't sort properly, you won't be able to perform mathematical calculations without converting from the string first, and you won't get any built-in validation of the values in any editable cells.

Of course, all of these issues would exist with unbound columns, as well, but they would be easier to work around with things like SortComparers.

Hi Mike,

Thanks..

Yeah correct, things like sort, filter might not behave correctly on the numbers columns which

is treated as strings...

Regards

Manoj

Hi,

As far as I know, there's no superscript or subscript functionality in the FormattedText support. I assume <sup> is an html tag? We don't actually use html, although our custom format is similar. So that tag probably isn't supported if it's not working.

Hi,

Is there any way to add a superscript in Ultragrid cell. My need is to add a alphabet superscript in ultragrid cell. I have tried the ^text tag as we have used <b>text</b> tag in above example.

<b></b> tag is working fine. But  tag is not working. Is there any other tags present to achieve this. Please help.

eg. Sample Text^M

Thanks in advance.

Hi Manoj,

I don't see any easy way to handle so complex a case. You probably have to string out the escape codes first, then applying your formatting, and then put them back in. Or write your own Replace method that skips over the appropriate codes.

Here's a list of codes that are escaped by the EscapeXML method.

& = &amp;

< = &lt;

> = &gt;

" = &quot;

Hi Mike,

Tried with the above code..It works fine... :)

Thanks a ton.... :)

Thanks

Manoj