How do I control Column reordering

[Administrator]

Hi,

I want to let the end user reorder columns.
But I don't want the user change the first column.
E.g.: A, B, C, D, E columns are there.
New order: A, C, E, D, B.
A is fixed column.

I tried to set the first column as Frozen. It just stops it from scrolling.

Is there any way I can catch some kind of event while the column header is being dragged and stop it, if it is col# 1? Is there any way stop if column B, C, D or E being dropped before A?

thanks,
- Reddy

[Administrator]

You can catch the ColsMoving event, and cancel it if the args point to columns or a target location you do not want moved.

[Administrator]

Clay,

Thanks for the quick response. That is exactly what I am looking for. I tried it and it works.

thanks,
- Reddy