Freeze columns / Rows in GridGroupingControl

[Albert Gao]

In GridControl, I can use Cols.FreezeRange to freeze some columns. I didn''t find correspondent Cols property in GridGroupingControl. Is there way to freeze columns?

thanks,
Albert

[Albert Gao]

I am able to freeze the column by this:

gridGroupingControl.TableModel.Cols.FreezeRange(col1, col1);

But it looks like first column is frozen, no matter what col1 is. And it didn''t move columns.

>In GridControl, I can use Cols.FreezeRange to freeze some columns. I didn''t find correspondent Cols property in GridGroupingControl. Is there way to freeze columns?
>
>thanks,
>Albert

[Administrator]

Hi Albert.

you need to manually move columns by rearringing the Columns or VisibleColums collection.

If you set TableModel.FrozenCount = 0 I think also the row header will scroll.

Be aware also that when you have GroupedColumns you need to increase the FrozenCount.

Stefan

[Albert Gao]

Thank you, Stefan. I found that MoveRange of Table.Model.Cols is not working. I am going to use VisibleColumns according to your suggestion.

Albert

>Hi Albert.
>
>you need to manually move columns by rearringing the Columns or VisibleColums collection.
>
>If you set TableModel.FrozenCount = 0 I think also the row header will scroll.
>
>Be aware also that when you have GroupedColumns you need to increase the FrozenCount.
>
>Stefan
>

[Albert Gao]

I want to disable column moving for the columns which are frozen. The handler of ColsMoving from TableModel is only invoked from MoveRange function call. How can I disable moving forzen columns by mouse?

Thanks,
Albert

>Thank you, Stefan. I found that MoveRange of Table.Model.Cols is not working. I am going to use VisibleColumns according to your suggestion.
>
>Albert
>
>>Hi Albert.
>>
>>you need to manually move columns by rearringing the Columns or VisibleColums collection.
>>
>>If you set TableModel.FrozenCount = 0 I think also the row header will scroll.
>>
>>Be aware also that when you have GroupedColumns you need to increase the FrozenCount.
>>
>>Stefan
>>

[Albert Gao]

After the following code, I found that even valid moving operation is not working:
GridVisibleColumnDescriptor col =
ctrl.TableDescriptor.VisibleColumns[colname];

ctrl.TableDescriptor.VisibleColumns.Remove(colname);

ctrl.TableDescriptor.VisibleColumns.Insert(
ctrl.TableModel.Cols.FrozenCount-1, col);

Please help.
thanks,
Albert

>I want to disable column moving for the columns which are frozen. The handler of ColsMoving from TableModel is only invoked from MoveRange function call. How can I disable moving forzen columns by mouse?
>
>Thanks,
>Albert
>
>>Thank you, Stefan. I found that MoveRange of Table.Model.Cols is not working. I am going to use VisibleColumns according to your suggestion.
>>
>>Albert
>>
>>>Hi Albert.
>>>
>>>you need to manually move columns by rearringing the Columns or VisibleColums collection.
>>>
>>>If you set TableModel.FrozenCount = 0 I think also the row header will scroll.
>>>
>>>Be aware also that when you have GroupedColumns you need to increase the FrozenCount.
>>>
>>>Stefan
>>>

[Administrator]

Hi Albert,

the problem that dragging does not work when you modify VisibleColumns has been addressed in more recent private builds.

But you can work-around it for now by rearranging the columns within the Columns collection.

Stefan

[Albert Gao]

Thank you very much Stefan. The workaround works.

Another goal I want to achieve is that disabling draging on frozen column. I added Cols_Moving handler. It didn''t help.

>Hi Albert,
>
>the problem that dragging does not work when you modify VisibleColumns has been addressed in more recent private builds.
>
>But you can work-around it for now by rearranging the columns within the Columns collection.
>
>Stefan
>

[Administrator]

We added a QueryAllowDragColumn event for that - I think that was after 2.1.0.9.

You can submit a dtrac incident. Then we can give you access to later version that has that event.

Stefan

[Administrator]

I have the lastest version 2.1.0.50. I added the following handler:
int col=-1, row = -1;
Debug.WriteLine(e.Column, "QueryAllowDragColumn - ");
if (this.TableDescriptor.ColumnToRowColIndex(e.Column.Name, out row, out col))
{
Debug.WriteLine("out row - " + row + ", out col " + col);
if (col +1 <= this.TableModel.Cols.FrozenCount)
{
Debug.WriteLine("FrozenCount is " + this.TableModel.Cols.FrozenCount + " Disabling column dragging ");
e.AllowDrag = false;
}
}

I can see in the debug window, it was saying the dragging is disabled. But I am still able to drag the frozen column.

I don''t know if .50 is the build you mentioned earlier. When I switched back to VisibleColumns, I still saw the same problem.
I have problem with the workaround with Columns. When I am dragging the frozen column, the dragging image shows initial column, not the one frozen.

Thanks,
albert

>We added a QueryAllowDragColumn event for that - I think that was after 2.1.0.9.
>
>You can submit a dtrac incident. Then we can give you access to later version that has that event.
>
>Stefan

[Albert Gao]

Sorry - I found the project still associated with 2.1.0.9.
It works.
Should I blame the installer? :-)