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

Glossary Item Box

VirtualMode Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether virtual mode is on or off.

Syntax

C++

BOOL CSpreadSheet::GetVirtualMode( );
void CSpreadSheet::SetVirtualMode(BOOL value);

Visual Basic

[form.]fpSpread.VirtualMode[= boolean%]

Remarks

The default value for the VirtualMode property is False.

Use virtual mode to inform the sheet to store only a specified number of rows of data in memory at a time.

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.

For more information on virtual mode, refer to Using Virtual Mode.

Notes:
  • If you are using a bound sheet that is using virtual mode, the Data control bound to the sheet might not behave as you expect. For more information, refer to Using Virtual Mode with Bound Sheets.
  • Do not set the PrintScalingMethod property to 1 (SmartPrint) to print a sheet that is using virtual mode.
  • If the sheet does not know the total number of rows, the row header might not display the correct numbers for the rows. For best results, hide the row header.
  • For best results, do not use multiple- or extended-selection operation mode in a sheet that is using virtual mode.
  • Do not freeze rows in a sheet that is using virtual mode.
  • You cannot sort a sheet that is using virtual mode.

Spread Designer

Choose the Book menu, then the Virtual Mode menu, and then choose the Virtual Mode check box in the Settings group box in the Virtual Mode dialog box.

Data Type

Integer (Boolean)

See Also

Turning on Virtual Mode

PrintScalingMethod, PrintUseDataMax, Sheet, VirtualCurRowCount, VirtualCurTop, VirtualMaxRows, VirtualOverlap, VirtualRows, VirtualScrollBuffer, VScrollSpecial, VscrollSpecialType properties

QueryData event

DLL Correspondence

SSGetBool (SSB_VIRTUALMODE), SSSetBool (SSB_VIRTUALMODE) functions

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