VSFlexGrid Control > VSFlexGrid Properties, Events, and Methods > VSFlexGrid Properties > FixedCols Property |
Returns or sets the number of fixed (non-scrollable) columns.
[form!]VSFlexGrid.FixedCols[ = value As Long ]
Fixed columns remain visible when the user scrolls the contents of the grid. They are not selectable or editable by the user (but you can select them with code and even allow the user to edit their contents by selecting them and invoking the EditCell method). You can set FixedCols to any value between zero and the total number of columns.
The following line of code places 3 fixed columns at the left edge of the grid.
fg.FixedCols = 3
Fixed columns are typically used in spreadsheet applications to display row numbers or other types of labels.
To format the fixed cells, use the BackColorFixed, ForeColorFixed, GridLinesFixed, and FixedAlignment properties.
You can create non-scrollable columns that can be selected and edited using the FrozenCols property.
If the AllowUserResizing property is set to a non-zero value, the fixed cells allow the user to resize row heights and column widths at run time.
Long