fixedColumns

Type: Integer

Availability: Read or write at any time

The fixedColumns property of the Table class contains the number of fixed columns in a table.

The default value for the fixedColumns property is 1.

The Table control has two types of columns: fixed and non-fixed. Fixed columns are most often used for row headings. Non-fixed columns are most often used for data display. A fixed column is always displayed on the sheet, while non-fixed columns can be scrolled out of view.

Clicking a cell in a fixed column selects all non-fixed cells in the row. Clicking on a cell selects only that cell.

Positioning the mouse over a boundary between columns in the fixed area enables the boundary line to be dragged by clicking and dragging. This changes the height and width of a column. (See also the allowResize property.)

The default value of the backColor property of a fixed cell is gray.

Setting the fixedColumns property to a value greater than the defined number of columns causes the number of columns to be increased to the new number of fixed columns.