preventing the autogenerate columns from reordering themselves

[Sayle]

I have a very wide RadGrid (the latest public release version) that I'm using as an export into Excel. I have the root query ordering the columns a certian way - the way the customers want the Excel output in... However, when I databind my RadGrid on the webpage, the columns are automatically reordered into alphabetical order!

How do I preventing the autogenerated columns from reordering themselvesinto alphabetical order?

Thanks

<telerik:RadGrid ID="gridSellerData" runat="server" Width="100%" CellSpacing="0" CellPadding="0"
    PageSize="5000" EnableLinqExpressions="False" HeaderStyle-Wrap="false" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" Skin="Hay"
    OnItemDataBound="grid_ItemDataBound" OnNeedDataSource="grid_NeedDataSource"
    OnPreRender="gridContractData_PreRender" OnGridExporting="gridSellerData_GridExporting"
    >
    <ClientSettings AllowColumnsReorder="false">
        <Selecting EnableDragToSelectRows="false" UseClientSelectColumnOnly="false" />
        <Scrolling AllowScroll="true" UseStaticHeaders="true" FrozenColumnsCount="0" />
    </ClientSettings>
    <ExportSettings IgnorePaging="true" ExportOnlyData="true" Excel-Format="ExcelML" OpenInNewWindow="true" HideStructureColumns="true" />
    <MasterTableView CommandItemDisplay="Top" DataKeyNames="LoanImportID" ClientDataKeyNames="LoanImportID" GridLines="Both">
        <CommandItemSettings ExportToExcelText="Export To Excel" ShowExportToExcelButton="true" ShowAddNewRecordButton="false" ShowRefreshButton="false" />
        <ItemStyle CssClass="Row0" />
        <AlternatingItemStyle CssClass="Row1" />
    </MasterTableView>
    <HeaderStyle Wrap="False" />
    <FilterMenu EnableImageSprites="False">
    </FilterMenu>
    <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Hay">
    </HeaderContextMenu>
</telerik:RadGrid>

[Antonio Stoilkov]

Hello Miles,

The RadGrid does not provide methods and properties for customizing order of auto generated columns. You could achieve your scenario by using manually declared columns which you could order depending on your needs. Note that RadGrid auto generated columns are for basic scenarios and in case when more advanced functionality is needed a manual approach is recommended.

Kind regards,
Antonio Stoilkov
the Telerik team