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

Glossary Item Box

AllowRowMove Property


See Also    DLL

Applies To

fpSpread control

Description

Sets or returns whether the user can move rows.

Syntax

C++

BOOL CSpreadSheet::GetAllowRowMove( );
void CSpreadSheet::SetAllowRowMove(BOOL value);

Visual Basic

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

Remarks

The default value for the AllowRowMove property is False.

When the AllowRowMove property is set to True, the user can move rows. The user can left click on the row header with the mouse and drag the row header up or down over the row header area. A red indicator will show up. They can then release the mouse when they are over the correct row 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 columns by setting the AllowColMove property

If the user presses the Esc key while in the middle of moving a column or row the action is canceled.

Spread Designer

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

In the Spread Designer the AllowRowMove 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

AllowColMove, Formula, Sheet properties

DLL Correspondence

SSGetBool (SSB_ALLOWROWMOVE), SSSetBool (SSB_ALLOWROWMOVE) functions

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