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
BOOL CSpreadSheet::GetRestrictCols( );
void CSpreadSheet::SetRestrictCols(BOOL value);
[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)
See Also
DataColCnt, DataRowCnt, NoBeep, RestrictRows, Sheet properties
EditError event
DLL Correspondence
SSGetBool (SSB_RESTRICTCOLS), SSSetBool (SSB_RESTRICTCOLS) functions