ActiveReports Developer 7
HeaderMargin Property
See Also  Example
GrapeCity.ActiveReports.Export.Excel.v7 Assembly > GrapeCity.SpreadBuilder.Printing Namespace > PageSetup Class : HeaderMargin Property

Glossary Item Box

Returns or sets the distance in points from the top of the page to the header.

Syntax

Visual Basic (Declaration) 
Public Property HeaderMargin As System.Double
C# 
public System.double HeaderMargin {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

C#Copy Code
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;
Visual BasicCopy Code
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