Spread 8.0 Documentation
VirtualRows Property
Support Options
ActiveX Reference > ActiveX Properties > VirtualRows Property

Glossary Item Box

VirtualRows Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number of virtual rows the sheet requests at a time.

Syntax

C++

long CSpreadSheet::GetVirtualRows( );
void CSpreadSheet::SetVirtualRows(long value);

Visual Basic

[form.]fpSpread.VirtualRows[ = value&]

Remarks

The default value for the VirtualRows property is 0.

The minimum number of virtual rows the sheet can request is one screen of data. The QueryData event occurs when more data is needed.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

The VirtualRows property does not have an effect unless the VirtualMode property is set to True.

Use the VirtualMode property to turn virtual mode on or off.

Spread Designer

Choose the Book menu, then the Virtual Mode menu, and then type a number in the Rows Per Read edit box in the Settings group box in the Virtual Mode dialog box.

Data Type

Long Integer

See Also

Customizing Virtual Mode

Sheet, VirtualCurRowCount, VirtualCurTop, VirtualMaxRows, VirtualMode, VirtualOverlap properties

QueryData event

DLL Correspondence

SSVGetBufferSize, SSVSetBufferSize functions

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