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

In This Topic
    BottomMargin Property
    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