Column Headers add space in front of capital letters?

[Joel]

This is the first I have run into this.  Is there a way to turn the behavior off?  Grid is populated with needdatasource event.

If a column name in my datatable is "SuperMan", the column header in the grid is displayed as "Super Man" (note the space in front of "M").  If the column name in my database is  "superman" then the column header in the grid is "superman".  Is there some option where I can turn off renaming my column headers?  We capitalize for readability, but need the names to stay in tact so users can do excel lookups.

This particular page returns a variety of different datatables with different formats, most approx 50 columns wide so my preference is to not build lots of pages with predefined column headers to work around this.

Thanks!

-Joel

<telerik:RadGrid ID="rgExport" runat="server" Skin="WebBlue" AllowPaging="true" PageSize="20">
</telerik:RadGrid>

[Princy]

Hello Joel,

Try the following code snippet in ColumnCreated event and check if it resolves the issue.

C#:

protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
    {
        string name = e.Column.HeaderText;
        e.Column.HeaderText=name.Replace(" ", string.Empty);
    }

Thanks,
Princy.

[Joel]

Thanks Princy.  I had thought about something like that, but some column headers should have spaces in them and unless I hardcode a library of headers to remap, it wouldn't work in my situation.  This is definitely new behavior as the client's existing site does not  do this, but they are about a year out of date on their radcontrols.

I need "District Manager" and "RoiQ1" to be able to be in the same grid like it used to be without defining each column manually.  Being a new feature (and an odd one), there has to be a way to turn this off in the grid or mastertableview definitions I would think?

[Marin]

Hello Joel,

Indeed since Q3 2010 we introduced a new property EnableSplitHeaderText of MasterTableView that controls the automatic splitting of the header text for autogenerated columns. Its default value is true, to disable splitting set it to false.

Regards,
Marin
the Telerik team