ActiveReports 14 .NET Edition
GrapeCity.ActiveReports.Export.Excel Assembly / GrapeCity.SpreadBuilder.Printing Namespace / PageSetup Class / BottomMargin Property
Example

In This Topic
    BottomMargin Property (PageSetup)
    In This Topic
    Sets or returns the bottom margin value in points.
    Syntax
    'Declaration
     
    Public Property BottomMargin As Double
    public double BottomMargin {get; set;}

    Property Value

    Double. The default value is 72.
    Remarks
    The value MUST be greater than or equal to 0 and less than 3528.
    Example
    sb.Sheets[0].PageSetup.BlackAndWhite = true;
    sb.Sheets[0].PageSetup.BottomMargin = 144;
    sb.Sheets[0].PageSetup.Draft = true;
    sb.Sheets[0].PageSetup.FirstPageNumber = 100;
    sb.Sheets[0].PageSetup.FooterMargin = 72;
    sb.Sheets[0].PageSetup.HeaderMargin = 72;
    sb.Sheets[0].PageSetup.LeftMargin = 108;
    sb.Sheets[0].PageSetup.Order = GrapeCity.SpreadBuilder.Printing.PagePrintOrder.OverThenDown;
    sb.Sheets[0].PageSetup.Orientation = GrapeCity.SpreadBuilder.Printing.PagePrintOrientation.Landscape;
    sb.Sheets[0].PageSetup.PaperSize = Printing.PaperKind.A4;
    sb.Sheets[0].PageSetup.PrintNotes = true;
    sb.Sheets[0].PageSetup.RightMargin = 108;
    sb.Sheets[0].PageSetup.TopMargin = 144;
    sb.Sheets[0].PageSetup.Zoom = 200;
    With sb.Sheets(0).PageSetup
        .BlackAndWhite = True
        .BottomMargin = 144
        .Draft = True
        .FirstPageNumber = 100
        .FooterMargin = 72
        .HeaderMargin = 72
        .LeftMargin = 108
        .Order = GrapeCity.SpreadBuilder.Printing.PagePrintOrder.OverThenDown
        .Orientation = GrapeCity.SpreadBuilder.Printing.PagePrintOrientation.Landscape
        .PaperSize = Printing.PaperKind.A4
        .PrintNotes = True
        .RightMargin = 108
        .TopMargin = 144
        .Zoom = 200
    End With
    See Also