Gets or sets whether the selected range of cells remains highlighted when the component loses the focus.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property RetainSelectionBlock As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As FpSpread
Dim value As Boolean
instance.RetainSelectionBlock = value
value = instance.RetainSelectionBlock |
| C# | |
|---|
public bool RetainSelectionBlock {get; set;} |
Property Value
Boolean:
true to keep cell range highlighted;
false otherwise
Remarks
Example
This example specifies whether the selected range (or block) of cells remains highlighted when the component loses the focus.
| 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;
textBox1.Visible = true;
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.ActiveSheet.AddSelection(1, 1, 3, 3);
dlg = MessageBox.Show("Do you want to retain the selection??", "RetainSelectionBlock", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
fpSpread1.RetainSelectionBlock = true;
textBox1.Focus();
} |
| Visual Basic | Copy Code |
|---|
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
Dim dlg As DialogResult
TextBox1.Visible = True
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.ActiveSheet.AddSelection(1, 1, 3, 3)
dlg = MessageBox.Show("Do you want to retain the selection??", "RetainSelectionBlock", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
fpSpread1.RetainSelectionBlock = True
TextBox1.Focus()
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
