GetColumnFooterCellRectangle Method

Visual Basic
C#

'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

This example uses the GetColumnFooterCellRectangle method.

C#

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));
}

Visual Basic

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

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

Reference

SpreadView Class
SpreadView Members