Spread Windows Forms 12.0 Product Documentation
RetainSelectionBlock Property (FpSpread)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : RetainSelectionBlock Property
Gets or sets whether the selected range of cells remains highlighted when the component loses the focus.
Public Property RetainSelectionBlock As Boolean
Dim instance As FpSpread
Dim value As Boolean
instance.RetainSelectionBlock = value
value = instance.RetainSelectionBlock
public bool RetainSelectionBlock {get; set;}

Property Value

Boolean: true to keep cell range highlighted; false otherwise
The RetainSelectionBlock property applies to cell selections in the grid modes (Normal and ReadOnly) and also applies to cell focus indicators (Normal and RowMode). This property does not apply to row selections in the list modes (RowMode, SingleSelect, MultiSelect, ExtendedSelect). List boxes always show their row selections.
This example specifies whether the selected range (or block) of cells remains highlighted when the component loses the focus.
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;
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;
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
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
End If
See Also


FpSpread Class
FpSpread Members

User-Task Documentation

Customizing the Selection