Determines whether adjacent cells can overflow into this cell.
Syntax
Visual Basic (Declaration) | |
---|
Function CanBeOverflown() As Boolean |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As IRenderer
Dim value As Boolean
value = instance.CanBeOverflown() |
Return Value
Boolean:
true if cell can be overflowed into;
false otherwise
Example
This example subclasses the IRenderer class and creates a custom renderer for the first cell in the spreadsheet to illustrate the use of the methods and events.
C# | Copy Code |
---|
public static CheckBox ck = new CheckBox();
class myRenderer : FarPoint.Win.Spread.CellType.IRenderer
{
public bool CanOverflow()
{
return true;
}
public bool CanBeOverflown()
{
return true;
}
public Size GetPreferredSize(Graphics g, Size s, FarPoint.Win.Spread.Appearance appr, object value, float zoom)
{
s = new Size(50, 50);
return s;
}
public void PaintCell(Graphics g, Rectangle r, FarPoint.Win.Spread.Appearance appr, object value, bool issel, bool islocked,
float zoom)
{
string s;
ck.CheckState = CheckState.Checked;
s = ck.CheckState.ToString();
Font f = new Font("MS Sans Serif", 10);
appr.BackColor = Color.Red;
appr.ForeColor = Color.Yellow;
appr.Font = f;
Brush b, b1;
b = new SolidBrush(appr.BackColor);
b1 = new SolidBrush(appr.ForeColor);
g.FillRectangle(b, r);
g.DrawString(s, appr.Font, b1, r);
b.Dispose();
b1.Dispose();
}
}
private void Form1_Load(object sender, System.EventArgs e)
{
fpSpread1.ActiveSheet.Cells[0, 0].Renderer = new myRenderer();
} |
Visual Basic | Copy Code |
---|
Shared ck As New CheckBox()
Public Class myRenderer
Implements FarPoint.Win.Spread.CellType.IRenderer
Public Function CanBeOverflown() As Boolean Implements FarPoint.Win.Spread.CellType.IRenderer.CanBeOverflown
Return True
End Function
Public Function CanOverflow() As Boolean Implements FarPoint.Win.Spread.CellType.IRenderer.CanOverflow
Return True
End Function
Public Function GetPreferredSize(ByVal g As Graphics, ByVal s As Size, ByVal appr As FarPoint.Win.Spread.Appearance, ByVal
value As Object, ByVal zoom As Single) As Size Implements FarPoint.Win.Spread.CellType.IRenderer.GetPreferredSize
s = New Size(50, 50)
Return s
End Function
Public Sub PaintCell(ByVal g As Graphics, ByVal r As Rectangle, ByVal appr As FarPoint.Win.Spread.Appearance, ByVal Value
As Object, ByVal issel As Boolean, ByVal islocked As Boolean, ByVal zoom As Single) Implements FarPoint.Win.Spread.CellType.IRenderer.PaintCell
Dim s As String
ck.CheckState = CheckState.Checked
s = ck.CheckState.ToString()
Dim f As New Font("MS Sans Serif", 10)
appr.BackColor = Color.Red
appr.ForeColor = Color.Yellow
appr.Font = f
Dim b, b1 As Brush
b = New SolidBrush(appr.BackColor)
b1 = New SolidBrush(appr.ForeColor)
g.FillRectangle(b, r)
g.DrawString(s, appr.Font, b1, r.X, r.Y)
b.Dispose()
b1.Dispose()
End Sub
End Class
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FpSpread1.ActiveSheet.Cells(0, 0).Renderer = New myRenderer()
End Sub
|
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also