Spread 8.0 Documentation
Customizing Virtual Mode
Support Options
User's Guide > Setting Up the Control > Working with Sheets > Using Virtual Mode > Customizing Virtual Mode

Glossary Item Box

Customizing Virtual Mode


Overview

You can specify how many rows are read into the virtual buffer at a time and whether some of the previously displayed rows are kept in the buffer when additional rows are read.

In addition, you can customize the vertical scroll bar to work more smoothly with virtual mode. For example, you can specify that the scroll box reflects only the number of records in the virtual buffer, rather than the entire number of records.

Alternatively, you can provide the number of rows in the sheet. Providing the number of rows helps the vertical scroll bar more accurately reflect the current position in the sheet and permits the row headers to accurately number the rows. For more information about specifying the number of rows in the sheet, see Specifying the Maximum Number of Rows.

Note: If you set the VirtualMaxRows property, be sure the number of records in the database matches the maximum number of rows in virtual mode, otherwise the results will be unpredictable.

If you prefer, the control can display a special vertical scroll bar as described in Displaying the Special Vertical Scroll Bar.

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