Returns or sets whether the user is allowed to freeze rows and columns with the mouse.
Syntax
[form!]VSFlexGrid.AllowUserFreezing[ = AllowUserFreezeSettings ]
Remarks
Frozen cells can be selected and edited, but they remain visible when the user scrolls the contents of the control. The AllowUserFreezing property determines whether the user can change the number of frozen rows and columns by dragging the solid line between the frozen and scrollable areas of the grid.
The settings for the AllowUserFreezing property are described below:
|
Constant |
Value |
Description |
|
flexFreezeNone |
0 |
The user cannot change the number of frozen rows or columns. |
|
flexFreezeColumns |
1 |
The user can change the number of frozen columns. |
|
flexFreezeRows |
2 |
The user can change the number of frozen rows. |
|
flexFreezeBoth |
3 |
The user can change the number of frozen rows and columns. |
This property is especially useful when the grid is used as a data browser. It allows users to freeze the leftmost columns of the data while they scroll the control to view the remaining columns.
The number of frozen rows and columns can be set or retrieved through the FrozenRows property and FrozenCols properties. You may customize the appearance of the frozen areas of the grid using the BackColorFrozen and ForeColorFrozen properties. The solid line between the frozen and scrollable areas of the grid is drawn using the color specified by the SheetBorder property.
Data Type
AllowUserFreezeSettings (Enumeration)
Default Value
flexFreezeNone (0)