preventing columnreordering after removing groupin

Hi ,

I don't want columns to be reordered, I have made the property AllowColumnReordering = false,
But when I group the records on clicking columns , and again for removing it when I place column somewhere else from dragged position ,It does allow column reordering.

How can i prevent that , the problem is I wanted to export record list to excel sheet. but when columns reordered , reportcontrol has its rows not reordered by column, bec'z of which . In excel sheet I get different values in different columns

 worksheet.Cells[i , j ] = ReportControl.Rows.Record[j].Value;
here Report control does not have reordered value

...... I would rather like column reordered list to export to excel sheet ....... but if not that I would at least need to prevent column reordering
 Any suggestion will be appreciated.

Hi,

maybe it is a workaround to handle ColumnOrderChanged event: iterate through all columns and compare properties ItemIndex and Index. If there is a difference, use Move method to move the column to the original position.

I agree, it would be better if AllowColumnReordering works as expected, even after removing a column from the grouping area...

Maybe we can expect a fixing with one of the next releases?

Peter

It sounded to me like he would rather allow column reordering.

I read the last line  He only wanted to prevent it because it wasn't exporting to his excel sheet the way he wanted.

Yes, add it to your list.  I'll make sure they are fixed in 12.1.0.