Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / PrintInfo Class / RowEnd Property
Example


In This Topic
    RowEnd Property
    In This Topic
    Gets or sets the last row to print when printing a cell range.
    Syntax
    'Declaration
     
    Public Property RowEnd As Integer
    'Usage
     
    Dim instance As PrintInfo
    Dim value As Integer
     
    instance.RowEnd = value
     
    value = instance.RowEnd
    public int RowEnd {get; set;}
    Example
    This sets the properties for the PrintInfo class.
    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
    See Also