how to get auto size on dbl click header seperator same as excel?

[Administrator]

does anyone know how to get auto size on dbl click header seperator same as in excel?

[Administrator]

just to be clear at the mo it resizes to the default width...

[Administrator]

Hi Peterainbow, This can be acheived by using the ResizeToFit method in the ResizingColumns event. Refer to the forum thread for more details. Let us know if you need further assistance. Best regards, Madhan.

[Adam K.]

Madhan, This doesn''t seem to work for a Virtual Grid. It only autofits the column header. If a cell in one of the data rows is wider, it doesn''t seem to autofit around that. Any ideas. Thks, ak >Hi Peterainbow, > >This can be acheived by using the ResizeToFit method in the ResizingColumns event. Refer to the forum thread for more details. > >Let us know if you need further assistance. > >Best regards, >Madhan.

[Administrator]

Hi Adam,

In case of a Virtual grid, the column width will be requested and saved by using the QueryColWidth and SaveColWidth event. To resize to the longest text in the column, you can follow the code snippet given below.

private void gridControl1_ResizingColumns(object sender, GridResizingColumnsEventArgs e)
{
if (e.Reason == GridResizeCellsReason.DoubleClick)
{
GridRangeInfo columns = this.gridControl1.Selections.Ranges.GetRangesContaining(e.Columns).ActiveRange.UnionRange(e.Columns);
this.gridControl1.Model.ColWidths.ResizeToFit(columns, GridResizeToFitOptions.IncludeHeaders);
e.Cancel = true;
}
}

Thanks for being patience.

Best regards,
Madhan

[Administrator]

thks . .worked like a charm !!

>Hi Adam,
>
>In case of a Virtual grid, the column width will be requested and saved by using the QueryColWidth and SaveColWidth event. To resize to the longest text in the column, you can follow the code snippet given below.
>
>private void gridControl1_ResizingColumns(object sender, GridResizingColumnsEventArgs e)
>{
> if (e.Reason == GridResizeCellsReason.DoubleClick)
> {
> GridRangeInfo columns = this.gridControl1.Selections.Ranges.GetRangesContaining(e.Columns).ActiveRange.UnionRange(e.Columns);
> this.gridControl1.Model.ColWidths.ResizeToFit(columns, GridResizeToFitOptions.IncludeHeaders);
> e.Cancel = true;
> }
>}
>
>Thanks for being patience.
>
>Best regards,
>Madhan
>