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;