Spread for ASP.NET 10 Product Documentation
ShowFilterBar Property (PrintInfo)
Example 


Gets or sets whether to print the filter bar.
Syntax
'Declaration
 
Public Property ShowFilterBar As PrintHeader
'Usage
 
Dim instance As PrintInfo
Dim value As PrintHeader
 
instance.ShowFilterBar = value
 
value = instance.ShowFilterBar
public PrintHeader ShowFilterBar {get; set;}
Example
This example sets the ShowFilterBar property.
protected void Page_Load(object sender, EventArgs e)
{
 if (this.IsPostBack) return;
 FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;
 FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
 FpSpread1.Sheets[0].Cells[1, 0].Value = 2;
 FpSpread1.Sheets[0].Cells[1, 1].Value = 10;
 FpSpread1.Sheets[0].Cells[0, 1].Value = 1;
}

protected void Button1_Click(object sender, EventArgs e)
{ 
 FarPoint.Web.Spread.PrintInfo prinf = new FarPoint.Web.Spread.PrintInfo();
 prinf.ShowFilterBar = FarPoint.Web.Spread.PrintHeader.Show;
 FpSpread1.ActiveSheetView.PrintInfo = prinf;
 FpSpread1.SavePdf("c:\\test.pdf");
}
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (IsPostBack) Then
    Return
End If
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 10
FpSpread1.Sheets(0).Cells(0, 1).Value = 1
End Sub

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim prinf As New FarPoint.Web.Spread.PrintInfo
prinf.ShowFilterBar = FarPoint.Web.Spread.PrintHeader.Show
FpSpread1.ActiveSheetView.PrintInfo = prinf
FpSpread1.SavePdf("c:\test.pdf")
End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

PrintInfo Class
PrintInfo Members

 

 


Copyright © GrapeCity, inc. All rights reserved.