Spread Windows Forms 12.0 Product Documentation
GetColumnFooterCellRectangle Method

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.
Public Function GetColumnFooterCellRectangle( _
   ByVal columnViewportIndex As Integer, _
   ByVal row As Integer, _
   ByVal column As Integer _
) As Rectangle
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


Index of the column of the viewport
Row index of the cell
Column index of the cell
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


SpreadView Class
SpreadView Members