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

In This Topic
    FooterMargin Property
    In This Topic
    Returns or sets the distance in points from the bottom of the page to the footer.
    Syntax
    'Declaration
     
    Public Property FooterMargin As Double
    public double FooterMargin {get; set;}

    Property Value

    Short.  The default value is 36.
    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