FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > PrintInfo Class : ShowGrid Property |
FarPoint.Web.Spread.PrintInfo prinf = new FarPoint.Web.Spread.PrintInfo(); prinf.BestFitCols = true; prinf.BestFitRows = true; prinf.Centering = FarPoint.Web.Spread.Centering.Both; prinf.ColEnd = 10; prinf.Colors = new System.Drawing.Color[] { System.Drawing.Color.Green, System.Drawing.Color.Yellow, System.Drawing.Color.Gold, System.Drawing.Color.Indigo, System.Drawing.Color.Brown}; prinf.ColStart = 0; prinf.FirstPageNumber = 1; prinf.Footer = "/g\"1\"/cl\"4\"This is Page /p of /pc Pages"; prinf.FooterHeight = 40; prinf.Header = "/cl\"0\"Print Job For FarPoint Inc./n /n "; prinf.HeaderHeight = 40; prinf.Images = new System.Drawing.Image[] { System.Drawing.Image.FromFile("D:\\images\\point.jpg"), System.Drawing.Image.FromFile("D:\\images\\logo.gif"), System.Drawing.Image.FromFile("D:\\images\\icon.jpg")}; prinf.Margin = new FarPoint.Web.Spread.PrintMargin(10, 10, 10, 10, 20, 20); prinf.Opacity = 50; prinf.Orientation = FarPoint.Web.Spread.PrintOrientation.Landscape; prinf.PageEnd = 5; prinf.PageOrder = FarPoint.Web.Spread.PrintPageOrder.OverThenDown; prinf.PageStart = 1; prinf.PrintNotes = FarPoint.Web.Spread.PrintNotes.None; prinf.PrintType = FarPoint.Web.Spread.PrintType.All; prinf.RepeatColEnd = 10; prinf.RepeatColStart = 1; prinf.RepeatRowEnd = 10; prinf.RepeatRowStart = 1; prinf.RowEnd = 10; prinf.RowStart = 1; prinf.ShowBorder = false; prinf.ShowColumnFooter = FarPoint.Web.Spread.PrintHeader.Show; prinf.ShowColumnFooterEachPage = true; prinf.ShowColumnHeader = FarPoint.Web.Spread.PrintHeader.Show; prinf.ShowGrid = true; prinf.ShowRowHeader = FarPoint.Web.Spread.PrintHeader.Show; prinf.ShowSubtitle = true; prinf.ShowTitle = true; prinf.SmartPrintPagesTall = 1; prinf.SmartPrintPagesWide = 1; FarPoint.Web.Spread.SmartPrintRulesCollection prules = new FarPoint.Web.Spread.SmartPrintRulesCollection(); prules.Add(new FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None)); prinf.SmartPrintRules = prules; prinf.UseMax = true; prinf.UseSmartPrint = false; prinf.ZoomFactor = 2; FpSpread1.ActiveSheetView.PrintInfo = prinf;
Dim prinf As New FarPoint.Web.Spread.PrintInfo prinf.BestFitCols = True prinf.BestFitRows = True prinf.Centering = FarPoint.Web.Spread.Centering.Both prinf.ColEnd = 10 prinf.Colors = New Drawing.Color() {Drawing.Color.Green, Drawing.Color.Yellow, Drawing.Color.Gold, Drawing.Color.Indigo, Drawing.Color.Brown} prinf.ColStart = 0 prinf.FirstPageNumber = 1 prinf.Footer = "/g""1""/cl""4""This is Page /p of /pc Pages" prinf.FooterHeight = 40 prinf.Header = "/cl""0""Print Job For FarPoint Inc./n /n " prinf.HeaderHeight = 40 prinf.Images = New System.Drawing.Image() {System.Drawing.Image.FromFile("D:\images\point.jpg"), System.Drawing.Image.FromFile("D:\images\logo.gif"), System.Drawing.Image.FromFile("D:\images\icon.jpg")} prinf.Margin = New FarPoint.Web.Spread.PrintMargin(10, 10, 10, 10, 20, 20) prinf.Opacity = 50 prinf.Orientation = FarPoint.Web.Spread.PrintOrientation.Landscape prinf.PageEnd = 5 prinf.PageOrder = FarPoint.Web.Spread.PrintPageOrder.OverThenDown prinf.PageStart = 1 prinf.PrintNotes = FarPoint.Web.Spread.PrintNotes.None prinf.PrintType = FarPoint.Web.Spread.PrintType.All prinf.RepeatColEnd = 10 prinf.RepeatColStart = 1 prinf.RepeatRowEnd = 10 prinf.RepeatRowStart = 1 prinf.RowEnd = 10 prinf.RowStart = 1 prinf.ShowBorder = False prinf.ShowColumnFooter = FarPoint.Web.Spread.PrintHeader.Show prinf.ShowColumnFooterEachPage = True prinf.ShowColumnHeader = FarPoint.Web.Spread.PrintHeader.Show prinf.ShowGrid = True prinf.ShowRowHeader = FarPoint.Web.Spread.PrintHeader.Show prinf.ShowSubtitle = True prinf.ShowTitle = True prinf.SmartPrintPagesTall = 1 prinf.SmartPrintPagesWide = 1 Dim prules As New FarPoint.Web.Spread.SmartPrintRulesCollection prules.Add(New FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None)) prinf.SmartPrintRules = prules prinf.UseMax = True prinf.UseSmartPrint = False prinf.ZoomFactor = 2 FpSpread1.ActiveSheetView.PrintInfo = prinf
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional