Public Class SpreadTextBox
Inherits TextBox
Implements FarPoint.Win.Spread.DrawingSpace.IEmbeddedControlSupport
Private moving As FarPoint.Win.Spread.DrawingSpace.Moving = Moving.None
Private sizing As FarPoint.Win.Spread.DrawingSpace.Sizing = Sizing.None
Private activation As FarPoint.Win.Spread.DrawingSpace.ChildActivationPolicy = ChildActivationPolicy.DoubleClick
Public Overridable Property ActivationPolicy() As FarPoint.Win.Spread.DrawingSpace.ChildActivationPolicy Implements IEmbeddedControlSupport.ActivationPolicy
Get
Return activation
End Get
Set(ByVal Value As FarPoint.Win.Spread.DrawingSpace.ChildActivationPolicy)
' activation = Value
End Set
End Property
Public Overridable Property CanMove() As FarPoint.Win.Spread.DrawingSpace.Moving Implements IEmbeddedControlSupport.CanMove
Get
Return moving
End Get
Set(ByVal Value As FarPoint.Win.Spread.DrawingSpace.Moving)
moving = Value
End Set
End Property
Public Overridable Property CanSize() As FarPoint.Win.Spread.DrawingSpace.Sizing Implements IEmbeddedControlSupport.CanSize
Get
Return sizing
End Get
Set(ByVal Value As FarPoint.Win.Spread.DrawingSpace.Sizing)
sizing = Value
End Set
End Property
Public Sub ControlPaint(ByVal g As Graphics, ByVal r As Rectangle, ByVal appearance As FarPoint.Win.Spread.Appearance,
ByVal value As Object, ByVal isSelected As Boolean, ByVal isLocked As Boolean, ByVal zoomFactor As Single) Implements IEmbeddedControlSupport.ControlPaint
g.SetClip(r, CombineMode.Intersect)
g.FillRectangle(New SolidBrush(Me.BackColor), r)
'g.FillRectangle(New SolidBrush(Me.BackColor), r.X - 120, r.Y - 120, r.Width, r.Height)
g.DrawString(Me.Text, Font, New SolidBrush(Me.ForeColor), r.X, r.Y)
AddHandler Me.TextChanged, AddressOf MeTextChanged
End Sub
Public Sub MeTextChanged(ByVal sender As Object, ByVal e As EventArgs)
Me.BackColor = Color.Beige
End Sub
End Class
Dim tb As New SpreadTextBox()
tb.Name = "TB"
FpSpread1.ActiveSheet.AddControl(tb)