Example

The following example sets the maximum number of rows to 1000 and the number of rows in the virtual buffer to 100. The number of virtual rows is 10 and special scroll bars are displayed.

C++

// Set the number of rows or records in the data source
// Use -1 when the number of records is unknown
fpSpread1.VirtualMaxRows(1000);
// Set the max number of rows or records to keep in memory
fpSpread1.VirtualOverlap(100);
// Set the number of rows or records to read when additional data is requested
fpSpread1.VirtualRows(10);
// Enable virtual mode
fpSpread1.VirtualMode(TRUE);
// Reflect the number of rows in the virtual buffer and not the max number of rows or records
fpSpread1.VirtualScrollBuffer(TRUE);
// Enable special virtual scroll bars
fpSpread1.VScrollSpecial(TRUE);
fpSpread1.VScrollSpecialType(VScrollSpecialNoPageUpDown);

Visual Basic

' Set the number of rows or records in the data source
' Use -1 when the number of records is unknown
fpSpread1.VirtualMaxRows = 1000
' Set the max number of rows or records to keep in memory
fpSpread1.VirtualOverlap = 100
' Set the number of rows or records to read when additional data is requested
fpSpread1.VirtualRows = 10
' Enable virtual mode
fpSpread1.VirtualMode = True
' Reflect the number of rows in the virtual buffer and not the max number of rows or records
fpSpread1.VirtualScrollBuffer = True
' Enable special virtual scroll bars
fpSpread1.VScrollSpecial = True
fpSpread1.VScrollSpecialType=VScrollSpecialNoPageUpDown