PrintHeaderFooterArea Event

Visual Basic
C#

'Declaration
 
Public Event PrintHeaderFooterArea As PrintHeaderFooterAreaEventHandler

'Usage
 
Dim instance As FpSpread
Dim handler As PrintHeaderFooterAreaEventHandler
 
AddHandler instance.PrintHeaderFooterArea, handler

public event PrintHeaderFooterAreaEventHandler PrintHeaderFooterArea

The event handler receives an argument of type PrintHeaderFooterAreaEventArgs containing data related to this event. The following PrintHeaderFooterAreaEventArgs properties provide information specific to this event.

Property	Description
Cancel	Gets or sets the cancel flag.
Cells	Returns the range of cells being printed.
Graphics	Gets or sets the graphics device that does the printing.
IsHeader	Gets whether the header or footer is being printed.
PageNumber	Gets or sets the current page being printed.
Rectangle	Gets or sets the rectangular area that represents the sheet.

This example uses the PrintHeaderFooterArea event.

C#

private void fpSpread1_PrintHeaderFooterArea(object sender, FarPoint.Win.Spread.PrintHeaderFooterAreaEventArgs e) 
{ 
if (e.IsHeader) 
{ 
e.Graphics.DrawString("Quarterly Report", new Font("Comic Sans MS", 8.5), Brushes.Black, e.Rectangle.X, e.Rectangle.Y); 
} 
else 
{ 
e.Graphics.DrawString("FarPoint Technologies", new Font("Comic Sans MS", 8.5), Brushes.Black, e.Rectangle.X, e.Rectangle.Y);

} 
}

VB.NET

Private Sub FpSpread1_PrintHeaderFooterArea(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.PrintHeaderFooterAreaEventArgs)
Handles FpSpread1.PrintHeaderFooterArea
If e.IsHeader Then
e.Graphics.DrawString("Quarterly Report", New Font("Comic Sans MS", 8.5), Brushes.Black, e.Rectangle.X, e.Rectangle.Y)
Else
e.Graphics.DrawString("FarPoint Technologies", New Font("Comic Sans MS", 8.5), Brushes.Black, e.Rectangle.X, e.Rectangle.Y)
End If
End Sub

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

FpSpread Class
FpSpread Members