AllowEditorReservedLocations Property (FpSpread)

Visual Basic
C#

'Declaration
 
Public Property AllowEditorReservedLocations As Boolean

'Usage
 
Dim instance As FpSpread
Dim value As Boolean
 
instance.AllowEditorReservedLocations = value
 
value = instance.AllowEditorReservedLocations

public bool AllowEditorReservedLocations {get; set;}

When the AllowEditorReservedLocations Property is set to false, all cell editors are prohibited from showing custom cursors over parts of the cell and from entering edit mode on a single click over those parts of the cell. Button and combo cells and cells with drop down buttons will not go into edit mode immediately, and instead the mouse selection will treat those cells as cells without buttons that can be selected.

This example displays a text tip over the button cell.

C#

private void Form1_Load(object sender, EventArgs e)
        {
           fpSpread1.AllowEditorReservedLocations = false;
fpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Fixed;
FarPoint.Win.Spread.CellType.ButtonCellType btest = new FarPoint.Win.Spread.CellType.ButtonCellType();
btest.Text = "This is a TEST";
fpSpread1.Sheets[0].Cells[1, 0].CellType = btest;
        
        }

private void fpSpread1_TextTipFetch(object sender, FarPoint.Win.Spread.TextTipFetchEventArgs e)
        {
            e.ShowTip = true;
            e.TipText = "test";
        }

Visual Basic

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FpSpread1.AllowEditorReservedLocations = False
FpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Fixed
Dim btest As New FarPoint.Win.Spread.CellType.ButtonCellType
btest.Text = "This is a TEST"
FpSpread1.Sheets(0).Cells(1, 0).CellType = btest
End Sub
  
Private Sub FpSpread1_TextTipFetch(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.TextTipFetchEventArgs) Handles FpSpread1.TextTipFetch
        e.ShowTip = True
        e.TipText = "test"
    End Sub
End Class

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FpSpread Class
FpSpread Members