Class PageSetupGroup

Summary description for PageSetupGroup.

Inheritance
System.Object
CommonObject
PageSetupGroup
Implements
System.IDisposable
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation.Collections.Grouping
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public class PageSetupGroup : CommonObject, IDisposable, IPageSetup, IPageSetupBase, IParentApplication

Constructors

PageSetupGroup(IApplication, Object)

Initializes new instance and sets its application and parent properties.

Declaration
public PageSetupGroup(IApplication application, object parent)
Parameters
Type Name Description
IApplication application

Application object for the new instance.
System.Object parent

Parent object for the new instance.

Properties

AlignHFWithPageMargins

Indicates whether the header and footer margins are aligned with page margins. Read/Write Boolean.

Declaration
public bool AlignHFWithPageMargins { get; set; }
Property Value
Type
System.Boolean

AutoFirstPageNumber

Indicates whether summary rows will appear below detail in outlines.

Declaration
public bool AutoFirstPageNumber { get; set; }
Property Value
Type
System.Boolean

BackgoundImage

Gets / sets background image.

Declaration
public Image BackgoundImage { get; set; }
Property Value
Type
Image

BlackAndWhite

True if elements of the document will be printed in black and white. Read / write Boolean.

Declaration
public bool BlackAndWhite { get; set; }
Property Value
Type
System.Boolean

BottomMargin

Returns or sets the size of the bottom margin, in inches. Read / write Double.

Declaration
public double BottomMargin { get; set; }
Property Value
Type
System.Double

CenterFooter

Returns or sets the center part of the footer. Read / write String.

Declaration
public string CenterFooter { get; set; }
Property Value
Type
System.String

CenterFooterImage

Gets / set image for center part of the footer.

Declaration
public Image CenterFooterImage { get; set; }
Property Value
Type
Image

CenterHeader

Returns or sets the center part of the header. Read / write String.

Declaration
public string CenterHeader { get; set; }
Property Value
Type
System.String

CenterHeaderImage

Gets / set image for center part of the header.

Declaration
public Image CenterHeaderImage { get; set; }
Property Value
Type
Image

CenterHorizontally

True if the sheet is centered horizontally on the page when it is printed. Read / write Boolean.

Declaration
public bool CenterHorizontally { get; set; }
Property Value
Type
System.Boolean

CenterVertically

True if the sheet is centered vertically on the page when it is printed. Read / write Boolean.

Declaration
public bool CenterVertically { get; set; }
Property Value
Type
System.Boolean

Copies

Number of copies to print.

Declaration
public int Copies { get; set; }
Property Value
Type
System.Int32

DifferentFirstPageHF

True - The header / footer of the first page is different with other pages.False otherwise.

Declaration
public bool DifferentFirstPageHF { get; set; }
Property Value
Type
System.Boolean

DifferentOddAndEvenPagesHF

True - The header/footer odd pages are differed with even page. False otherwise.

Declaration
public bool DifferentOddAndEvenPagesHF { get; set; }
Property Value
Type
System.Boolean

Draft

True if the sheet will be printed without graphics. Read / write Boolean.

Declaration
public bool Draft { get; set; }
Property Value
Type
System.Boolean

EvenPage

Gets / sets values for even page.

Declaration
public IPage EvenPage { get; }
Property Value
Type
IPage

FirstPage

Gets / sets values for First page.

Declaration
public IPage FirstPage { get; }
Property Value
Type
IPage

FirstPageNumber

Returns or sets the first page number that will be used when this sheet is printed. If xlAutomatic, Microsoft Excel chooses the first page number. The default is xlAutomatic. Read / write Long.

Declaration
public short FirstPageNumber { get; set; }
Property Value
Type
System.Int16

FitToPagesTall

Returns or sets the number of pages tall the worksheet will be scaled to when it is printed. Applies only to worksheets. Read / write int.

Declaration
public int FitToPagesTall { get; set; }
Property Value
Type
System.Int32

FitToPagesWide

Returns or sets the number of pages wide the worksheet will be scaled to when it is printed. Applies only to worksheets. Read / write int.

Declaration
public int FitToPagesWide { get; set; }
Property Value
Type
System.Int32

FooterMargin

Returns or sets the distance from the bottom of the page to the footer, in inches. Read / write Double.

Declaration
public double FooterMargin { get; set; }
Property Value
Type
System.Double

HeaderMargin

Returns or sets the distance from the top of the page to the header, in inches. Read / write Double.

Declaration
public double HeaderMargin { get; set; }
Property Value
Type
System.Double

HFScaleWithDoc

Indicates whether the header and footer are scaled with document scaling.Read/Write Boolean.

Declaration
public bool HFScaleWithDoc { get; set; }
Property Value
Type
System.Boolean

IsFitToPage

Indicates whether fit to page mode is selected.

Declaration
public bool IsFitToPage { get; set; }
Property Value
Type
System.Boolean

IsSummaryColumnRight

Indicates whether summary columns will appear right of the detail in outlines.

Declaration
public bool IsSummaryColumnRight { get; set; }
Property Value
Type
System.Boolean

IsSummaryRowBelow

Indicates whether summary rows will appear below detail in outlines.

Declaration
public bool IsSummaryRowBelow { get; set; }
Property Value
Type
System.Boolean

LeftFooter

Returns or sets the left part of the footer. Read / write String. &L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document.

Declaration
public string LeftFooter { get; set; }
Property Value
Type
System.String

LeftFooterImage

Gets / set image for left part of the footer.

Declaration
public Image LeftFooterImage { get; set; }
Property Value
Type
Image

LeftHeader

Returns or sets the left part of the header. Read / write String.

Declaration
public string LeftHeader { get; set; }
Property Value
Type
System.String

LeftHeaderImage

Gets / set image for left part of the header.

Declaration
public Image LeftHeaderImage { get; set; }
Property Value
Type
Image

LeftMargin

Returns or sets the size of the left margin, in inches. Read / write Double.

Declaration
public double LeftMargin { get; set; }
Property Value
Type
System.Double

Order

Returns or sets the order that Microsoft Excel uses to number pages when printing a large worksheet. Read / write ExcelOrder.

Declaration
public ExcelOrder Order { get; set; }
Property Value
Type
ExcelOrder

Orientation

Portrait or landscape printing mode. Read / write ExcelPageOrientation.

Declaration
public ExcelPageOrientation Orientation { get; set; }
Property Value
Type
ExcelPageOrientation

PaperSize

Returns or sets the size of the paper. Read / write ExcelPaperSize.

Declaration
public ExcelPaperSize PaperSize { get; set; }
Property Value
Type
ExcelPaperSize

PrintArea

Returns or sets the range to be printed, as a string using A1-style references in the language of the macro. Read / write String.

Declaration
public string PrintArea { get; set; }
Property Value
Type
System.String

PrintComments

Returns or sets the way comments are printed with the sheet. Read / write ExcelPrintLocation.

Declaration
public ExcelPrintLocation PrintComments { get; set; }
Property Value
Type
ExcelPrintLocation

PrintErrors

Sets or returns an ExcelPrintErrors constant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet. Read / write.

Declaration
public ExcelPrintErrors PrintErrors { get; set; }
Property Value
Type
ExcelPrintErrors

PrintGridlines

True if cell gridlines are printed on the page. Applies only to worksheets. Read / write Boolean.

Declaration
public bool PrintGridlines { get; set; }
Property Value
Type
System.Boolean

PrintHeadings

True if row and column headings are printed with this page. Applies only to worksheets. Read / write Boolean.

Declaration
public bool PrintHeadings { get; set; }
Property Value
Type
System.Boolean

PrintNotes

True if cell notes are printed as end notes with the sheet. Applies only to worksheets. Read / write Boolean.

Declaration
public bool PrintNotes { get; set; }
Property Value
Type
System.Boolean

PrintQuality

Returns or sets the print quality. Read / write ushort.

Declaration
public int PrintQuality { get; set; }
Property Value
Type
System.Int32

PrintTitleColumns

Returns or sets the columns that contain the cells to be repeated on the left side of each page, as a string in A1-style notation in the language of the macro. Read / write String.

Declaration
public string PrintTitleColumns { get; set; }
Property Value
Type
System.String

PrintTitleRows

Returns or sets the rows that contain the cells to be repeated at the top of each page, as a string in A1-style notation in the language of the macro. Read / write String.

Declaration
public string PrintTitleRows { get; set; }
Property Value
Type
System.String

RightFooter

Returns or sets the right part of the footer. Read / write String.

Declaration
public string RightFooter { get; set; }
Property Value
Type
System.String

RightFooterImage

Gets / set image for right part of the footer.

Declaration
public Image RightFooterImage { get; set; }
Property Value
Type
Image

RightHeader

Returns or sets the right part of the header. Read / write String.

Declaration
public string RightHeader { get; set; }
Property Value
Type
System.String

RightHeaderImage

Gets / set image for right part of the header.

Declaration
public Image RightHeaderImage { get; set; }
Property Value
Type
Image

RightMargin

Returns or sets the size of the right margin, in inches. Read / write Double.

Declaration
public double RightMargin { get; set; }
Property Value
Type
System.Double

TopMargin

Returns or sets the size of the top margin, in inches. Read / write Double.

Declaration
public double TopMargin { get; set; }
Property Value
Type
System.Double

Zoom

Returns or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets. Read / write ushort.

Declaration
public int Zoom { get; set; }
Property Value
Type
System.Int32

Implements

System.IDisposable