Customizing Virtual Mode

---

• Spread Designer Instructions
• ActiveX Instructions
• DLL Instructions

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.