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

C++

BOOL CSpreadSheet::GetRestrictRows( );
void CSpreadSheet::SetRestrictRows(BOOL value);

Visual Basic

[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)

DLL Correspondence

SSGetBool (SSB_RESTRICTROWS), SSSetBool (SSB_RESTRICTROWS) functions