RestrictRows Property
Applies To
fpSpread control
Description
Sets or returns whether users can type data in a row that is more than one row beyond the last row containing data.
Syntax
BOOL CSpreadSheet::GetRestrictRows( );
void CSpreadSheet::SetRestrictRows(BOOL value);
[form.]fpSpread.RestrictRows[ = boolean%]
Remarks
The default value for the RestrictRows property is False, which means that the user can type data in any row in the sheet.
When the RestrictRows property is set to True, the user can type data in all rows up to one row beyond the last row containing data. This ensures that the user types data one row 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 row.
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 column at a time, set the RestrictCols property to True.
Spread Designer
Choose the Sheet menu, then the Headers menu, and then the General menu, select the Rows tab, and then select the Restrict Rows check box in the Header Settings dialog box.
Data Type
Integer (Boolean)
See Also
DataColCnt, DataRowCnt, NoBeep, RestrictCols, Sheet properties
EditError event
DLL Correspondence
SSGetBool (SSB_RESTRICTROWS), SSSetBool (SSB_RESTRICTROWS) functions