Specifying the Maximum Number of Rows

• Spread Designer Instructions
• ActiveX Instructions
• DLL Instructions

Overview

When using virtual mode, the maximum number of rows in the sheet, which is set using the MaxRows property or the SSSetMaxRows function, is no longer valid. You can specify the maximum number of rows for virtual mode using the VirtualMaxRows property or SSVSetMax function.

If you add rows to a sheet that is using virtual mode after all the rows have been read, the VirtualMaxRows property or the SSVSetMax function will still be set to the original number of rows and the fpSpread control will not be able to read all the rows in the sheet. You must set the VirtualMaxRows property or the Max parameter of the SSVSetMax function to –1 to have it reset the number of rows, or you must provide the new number of rows.

If you are using a bound fpSpread control, once the database has been read and a value assigned to the VirtualMaxRows property or the SSVSetMax function, that value will not change until either you assign a new value to the VirtualMaxRows property or to the SSVSetMax function or a new database is bound to the fpSpread control and read. However, if you bind a database after first binding and reading a smaller database, the VirtualMaxRows property or the SSVSetMax function will be set to the number of records in the smaller database and the fpSpread control will not be able to read all the records in the larger database.

If you exit the Spread Designer without changing the VirtualMaxRows or MaxRows property, the control will verify 1 million rows. The control appears to be hung when in reality it is checking the 1 million rows. To avoid this problem, when you exit Spread Designer, a message box appears asking whether or not you would like to reset the MaxRows property to its default value of 500 rows.