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

Glossary Item Box

Returns or sets the order in which pages are numbered when printing a large worksheet.

Syntax

Visual Basic (Declaration) 
Public Property Order As PagePrintOrder
C# 
public PagePrintOrder Order {get; set;}

Property Value

PagePrintOrder enumeration.

The default value is GrapeCity.SpreadBuilder.Printing.PagePrintOrder.DownThenOver

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