Spread Windows Forms 9.0 Product Documentation
ColumnFooter Property (TextTipFetchEventArgs)
Example 


Gets whether the cell is in the column footer.
Syntax
'Declaration
 
Public ReadOnly Property ColumnFooter As Boolean
'Usage
 
Dim instance As TextTipFetchEventArgs
Dim value As Boolean
 
value = instance.ColumnFooter
public bool ColumnFooter {get;}
Example
This example uses the ColumnFooter property.
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 = "Text Tip string";
fpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating;

private void fpSpread1_TextTipFetch(object sender, FarPoint.Win.Spread.TextTipFetchEventArgs e)
{
listBox1.Items.Add(e.ColumnFooter);
}
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 = "Text Tip string"
FpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating

Private Sub FpSpread1_TextTipFetch(sender As Object, e As FarPoint.Win.Spread.TextTipFetchEventArgs) Handles FpSpread1.TextTipFetch
ListBox1.Items.Add(e.ColumnFooter)
End Sub
Requirements

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

See Also

Reference

TextTipFetchEventArgs Class
TextTipFetchEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.