Link Search Menu Expand Document

Spread.LockColumns Property


Specifies the number of columns to fix. Columns that are fixed are not subject to horizontal scrolling.

You can specify a value from 0 to 32767 for the LockColumn property. 0 will unlock the column, and 1 will lock the leftmost column.

Note that the value you specify is the number of columns on the display, not the column position of the SpreadColumn object.

Column-fixed columns behave similarly to row headers.

  1. The StartEdit event does not occur

  2. When pasting an editor object with the StartEdit method, the SetEditor event is immediately fired.

  3. The column width cannot be changed with the mouse.

  4. Even if the column is fixed to a column position that exceeds the Spread display range, the fixed column cannot be scrolled horizontally.