Spread Windows Forms 6.0 Product Documentation
MoveActiveOnFocus Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : MoveActiveOnFocus Property


Glossary Item Box

Gets or sets whether the location of the active cell moves when the user moves the focus to the view using the mouse.

Syntax

Visual Basic (Declaration) 
Public Property MoveActiveOnFocus As Boolean
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim value As Boolean
 
instance.MoveActiveOnFocus = value
 
value = instance.MoveActiveOnFocus
C# 
public bool MoveActiveOnFocus {get; set;}

Property Value

Boolean: true if the location moves; false otherwise

Example

This example specifies whether the location of the active cell moves when the user moves the focus using the mouse.
C#Copy Code
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
DialogResult dlg;
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.ActiveSheet.SetActiveCell(3, 4);
dlg = MessageBox.Show("Do you want the active cell to remain where it is??(Click back on the control when closing this dialog)",
"MoveActiveOnFocus", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
     fpSpread1.MoveActiveOnFocus = false;
}
else
{
     fpSpread1.MoveActiveOnFocus = true;
}
}
Visual BasicCopy Code
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
Dim dlg As DialogResult
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.ActiveSheet.SetActiveCell(3, 4)
dlg = MessageBox.Show("Do you want the active cell to remain where it is??(Click back on the control when closing this dialog)",
"MoveActiveOnFocus", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
     fpSpread1.MoveActiveOnFocus = False
Else
     fpSpread1.MoveActiveOnFocus = True
End If

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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