RestrictCols Property

Applies To

fpSpread control

Description

Sets or returns whether users can type data in a column that is more than one column beyond the last column containing data.

Syntax

C++

BOOL CSpreadSheet::GetRestrictCols( );
void CSpreadSheet::SetRestrictCols(BOOL value);

Visual Basic

[form.]fpSpread.RestrictCols[ = boolean%]

Remarks

The default value for the RestrictCols property is False, which means that the user can type data in any column in the sheet.

When the RestrictCols property is set to True, the user can type data in all columns up to one column beyond the last column containing data. This ensures that the user types data one column at a time. If the user attempts to type data beyond that point, the control beeps (unless the NoBeep property is set to True), the EditError event occurs, and the sheet does not allow the user to type data in that column.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

To ensure that users type data one row at a time, set the RestrictRows property to True.

Spread Designer

Choose the Sheet menu, then the Headers menu, and then the General menu, select the Columns tab, and then select the Restrict Columns check box in the Header Settings dialog box.

Data Type

Integer (Boolean)

DLL Correspondence

SSGetBool (SSB_RESTRICTCOLS), SSSetBool (SSB_RESTRICTCOLS) functions