FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > PrintInfo Class : ShowFilterBar Property |
'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;}
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
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional