Spread 8.0 Documentation
SSGetMaxRows, SSSetMaxRows Functions
Support Options
DLL Reference > DLL Functions > SSGetMaxRows, SSSetMaxRows Functions

Glossary Item Box

SSGetMaxRows, SSSetMaxRows Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Set or return the maximum number of usable rows in the sheet.

Syntax

C

SS_COORD SSGetMaxRows(HWND hWnd);

void SSSetMaxRows(HWND hWnd, SS_COORD MaxRows);

C++

SS_COORD TSpread::GetMaxRows( );

void TSpread::SetMaxRows(SS_COORD MaxRows);

Parameters

The SSGetMaxRows function has the following parameter:

Parameter Description
hWnd Window handle of the fpSpread control

The SSSetMaxRows function has the following parameters:

Parameter Description
hWnd Window handle of the fpSpread control
MaxRows Number of rows allowed in sheet

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

The maximum value can be any value from zero through two billion. You can change the maximum number of rows at any time.

Caution: If you decrease the maximum number of rows, any data or formats in the rows beyond the new setting are lost.

To increase the maximum number of rows when a row is inserted, first use the SSSetMaxRows function to increment the maximum number of rows by one, then use the SSInsRow function to insert the row.

Return Value

SSGetMaxRows: Maximum number of rows in the sheet.

See Also

Specifying the Maximum Number of Rows
Setting the Maximum Number of Columns and Rows

SSGetMaxCols, SSInsRow, SSSetMaxCols, SSSetSheet functions

ActiveX Correspondence

MaxRows property

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.