Using Virtual Mode
- Turning on Virtual Mode
- Specifying the Maximum Number of Rows
- Customizing Virtual Mode
- Displaying the Special Vertical Scroll Bar
Overview
Use virtual mode to increase fpSpread control responsiveness when working with large amounts of data. You can use virtual mode for a sheet with a large number of rows or for a sheet bound to a large database.
If you do not use virtual mode, the sheet can take a long time to display data. The diminished responsiveness occurs because the sheet must read through all the rows before displaying the data. In virtual mode, the sheet reads ahead only when needed to display additional rows and retrieves records from a buffer area for faster response.
You can specify characteristics of virtual mode, such as how many rows are read into the buffer area at a time. In addition, you can display a special vertical scroll bar to use with virtual mode. Set the sheet before setting virtual mode if there are multiple sheets.
Notes:
|