Class PageSetupGroup
Summary description for PageSetupGroup.
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation.Collections.Grouping
Assembly: Syncfusion.XlsIO.Base.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 | Description |
---|---|
System.Boolean |
AutoFirstPageNumber
Indicates whether summary rows will appear below detail in outlines.
Declaration
public bool AutoFirstPageNumber { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
BackgoundImage
Gets / sets background image.
Declaration
public Bitmap BackgoundImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Bitmap |
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 | Description |
---|---|
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 | Description |
---|---|
System.Double |
CenterFooter
Returns or sets the center part of the footer. Read / write String.
Declaration
public string CenterFooter { get; set; }
Property Value
Type | Description |
---|---|
System.String |
CenterFooterImage
Gets / set image for center part of the footer.
Declaration
public Image CenterFooterImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Image |
CenterHeader
Returns or sets the center part of the header. Read / write String.
Declaration
public string CenterHeader { get; set; }
Property Value
Type | Description |
---|---|
System.String |
CenterHeaderImage
Gets / set image for center part of the header.
Declaration
public Image CenterHeaderImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.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 | Description |
---|---|
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 | Description |
---|---|
System.Boolean |
Copies
Number of copies to print.
Declaration
public int Copies { get; set; }
Property Value
Type | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
System.Boolean |
Draft
True if the sheet will be printed without graphics. Read / write Boolean.
Declaration
public bool Draft { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
EvenPage
Gets / sets values for even page.
Declaration
public IPage EvenPage { get; }
Property Value
Type | Description |
---|---|
IPage |
FirstPage
Gets / sets values for First page.
Declaration
public IPage FirstPage { get; }
Property Value
Type | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
System.Boolean |
IsFitToPage
Indicates whether fit to page mode is selected.
Declaration
public bool IsFitToPage { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
IsSummaryColumnRight
Indicates whether summary columns will appear right of the detail in outlines.
Declaration
public bool IsSummaryColumnRight { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
IsSummaryRowBelow
Indicates whether summary rows will appear below detail in outlines.
Declaration
public bool IsSummaryRowBelow { get; set; }
Property Value
Type | Description |
---|---|
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 | Description |
---|---|
System.String |
LeftFooterImage
Gets / set image for left part of the footer.
Declaration
public Image LeftFooterImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Image |
LeftHeader
Returns or sets the left part of the header. Read / write String.
Declaration
public string LeftHeader { get; set; }
Property Value
Type | Description |
---|---|
System.String |
LeftHeaderImage
Gets / set image for left part of the header.
Declaration
public Image LeftHeaderImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.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 | Description |
---|---|
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 | Description |
---|---|
ExcelOrder |
Orientation
Portrait or landscape printing mode. Read / write ExcelPageOrientation.
Declaration
public ExcelPageOrientation Orientation { get; set; }
Property Value
Type | Description |
---|---|
ExcelPageOrientation |
PaperSize
Returns or sets the size of the paper. Read / write ExcelPaperSize.
Declaration
public ExcelPaperSize PaperSize { get; set; }
Property Value
Type | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
System.Boolean |
PrintQuality
Returns or sets the print quality. Read / write ushort.
Declaration
public int PrintQuality { get; set; }
Property Value
Type | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
System.String |
RightFooter
Returns or sets the right part of the footer. Read / write String.
Declaration
public string RightFooter { get; set; }
Property Value
Type | Description |
---|---|
System.String |
RightFooterImage
Gets / set image for right part of the footer.
Declaration
public Image RightFooterImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Image |
RightHeader
Returns or sets the right part of the header. Read / write String.
Declaration
public string RightHeader { get; set; }
Property Value
Type | Description |
---|---|
System.String |
RightHeaderImage
Gets / set image for right part of the header.
Declaration
public Image RightHeaderImage { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.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 | Description |
---|---|
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 | Description |
---|---|
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 | Description |
---|---|
System.Int32 |