Spread for ASP.NET 7.0 Product Documentation
PrintSheet Event
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : PrintSheet Event


Glossary Item Box

Occurs when a sheet is printed.

Syntax

Visual Basic (Declaration) 
Public Event PrintSheet As PrintEventHandler
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim handler As PrintEventHandler
 
AddHandler instance.PrintSheet, handler
C# 
public event PrintEventHandler PrintSheet

Event Data

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

PropertyDescription
Content Gets or sets the HTML content for the header or the footer of the sheet. For the header, the default is the sheet name. For the footer, the default is an empty string.
Header Gets whether to print the sheet header.
PageBreak Gets or sets whether to include a page break.
Row Gets the row index.
SheetIndex Gets the index of the sheet to print.
Skip Gets or sets whether to skip printing this sheet.

Remarks

This event fires for each row.

Example

This example prints a header and a footer.
C#Copy Code
private void FpSpread1_PrintSheet(object sender, FarPoint.Web.Spread.PrintEventArgs e)
        { 
            if (e.Header == true)
            {
                e.Content = "Header";
            }
            if (e.Header == false)
            {
                e.Content = "Footer";
            }
        }
Visual BasicCopy Code
Private Sub FpSpread1_PrintSheet(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.PrintEventArgs) Handles FpSpread1.PrintSheet
        If e.Header = True Then
            e.Content = "Header"
        End If 
        If e.Header = False Then
            e.Content = "Footer"
        End If
    End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.