Spread Windows Forms 11.0 Product Documentation
GetColumnFooterCellRectangle Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : GetColumnFooterCellRectangle Method
Index of the column of the viewport
Row index of the cell
Column index of the cell
Gets the rectangle of the cell in the column footer.
Syntax
'Declaration
 
Public Function GetColumnFooterCellRectangle( _
   ByVal columnViewportIndex As Integer, _
   ByVal row As Integer, _
   ByVal column As Integer _
) As Rectangle
'Usage
 
Dim instance As SpreadView
Dim columnViewportIndex As Integer
Dim row As Integer
Dim column As Integer
Dim value As Rectangle
 
value = instance.GetColumnFooterCellRectangle(columnViewportIndex, row, column)
public Rectangle GetColumnFooterCellRectangle( 
   int columnViewportIndex,
   int row,
   int column
)

Parameters

columnViewportIndex
Index of the column of the viewport
row
Row index of the cell
column
Column index of the cell
Example
This example uses the GetColumnFooterCellRectangle method.
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the column footer.
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.ForeColor = Color.Purple;
fpSpread1.Sheets[0].ColumnFooter.Columns[12].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 12].RowSpan = 2;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 0].Value = "test";

private void button1_Click(object sender, EventArgs e)
{
    FarPoint.Win.Spread.SpreadView sv;    
    sv = fpSpread1.GetRootWorkbook();
    listBox1.Items.Add(sv.GetColumnFooterCellRectangle(0, 0, 0));
}
fpSpread1.Sheets(0).RowCount = 10
fpSpread1.Sheets(0).ColumnCount = 15
' Show the column footer.
fpSpread1.Sheets(0).ColumnFooter.Visible = True
fpSpread1.Sheets(0).ColumnFooter.RowCount = 2
fpSpread1.Sheets(0).ColumnFooter.DefaultStyle.ForeColor = Color.Purple
fpSpread1.Sheets(0).ColumnFooter.Columns(12).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left
fpSpread1.Sheets(0).ColumnFooter.Cells(0, 12).RowSpan = 2
fpSpread1.Sheets(0).ColumnFooter.Cells(0, 0).Value = "test"

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim sv As FarPoint.Win.Spread.SpreadView
sv = fpSpread1.GetRootWorkbook()
ListBox1.Items.Add(sv.GetColumnFooterCellRectangle(0, 0, 0))
End Sub
See Also

Reference

SpreadView Class
SpreadView Members