Spread Designer

To customize virtual mode

In the Spread Designer,

1. From the Book menu, choose Virtual Mode or press the Virtual Mode button ( ) on the Book toolbar.
2. Type the number of rows read into the virtual buffer at a time in the Rows Per Read box under Settings.
   If the sheet can display more rows at a time than the number of rows specified, the value in the Rows Per Read box changes to the number of rows the sheet can display.
3. Type the total number of previously retrieved rows that are retained in a buffer in the Memory Max Rows box under Settings.
4. Under Virtual Scrollbar, select the Thumb Reflects Row in Buffer check box to have the vertical scroll box reflect only the number of rows in the virtual buffer rather than the total number of rows.
5. If you do not select the Thumb Reflects Row in Buffer check box or if the control displays the row headers with numbers, type a number in the Virtual Max Rows box to provide the sheet with the number of rows in the sheet or bound database.
6. Choose the OK or Apply button.
7. If your sheet is not bound to a database, you must indicate the number of rows loaded in the QueryData event. After each data request, set the RowsLoaded parameter to the number of rows that have been loaded.