Spread Windows Forms 10.0 Product Documentation
AllowEditorReservedLocations Property (FpSpread)
Example 


Gets or sets whether cell editor reserved mouse locations are allowed.
Syntax
'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;}
Remarks
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.
Example
This example displays a text tip over the button cell.
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";
        }
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
Requirements

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

See Also

Reference

FpSpread Class
FpSpread Members

 

 


Copyright © GrapeCity, inc. All rights reserved.