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

Glossary Item Box

AllowColMove Property


See Also    DLL

Applies To

fpSpread control

Description

Sets or returns whether the user can move columns.

Syntax

C++

BOOL CSpreadSheet::GetAllowColMove( );
void CSpreadSheet::SetAllowColMove(BOOL value);

Visual Basic

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

Remarks

The default value for the AllowColMove property is False.

When the AllowColMove property is set to True, the user can move columns. The user can left click on the column header with the mouse and drag the column header to the left or right over the column header area. A red indicator will show up. They can then release the mouse when they are over the correct column header.

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.

Specify that users can move rows by setting the AllowRowMove property.

If the user hits the Esc key while in the middle of moving a column or row the action will be canceled.

Spread Designer

Choose the Sheet menu, then the Sheets menu, and then select the Allow Column Move check box in the Sheet Settings dialog box.

In the Spread Designer the AllowColMove property is temporarily reset to True when in design mode, to assist you in the design process. When you switch to run-time mode, the sheet behaves according to the setting you have chosen for this property.

Data Type

Integer (Boolean)

See Also

Allowing Users to Move Columns or Rows

AllowRowMove, Formula, Sheet properties

DLL Correspondence

SSGetBool (SSB_ALLOWCOLMOVE), SSSetBool (SSB_ALLOWCOLMOVE) functions

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