Spread Windows Forms 15.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet.Printing Namespace / PageSetup Class
Fields Properties Methods


In This Topic
    PageSetup Class Members
    In This Topic

    The following tables list the members exposed by PageSetup.

    Public Fields
     NameDescription
    Public FieldFIRSTPAGENUMBER_MAXThe max value the first page number can take. This field is constant and read-only.  
    Public FieldFIRSTPAGENUMBER_MINThe min value the first page number can take. This field is constant and read-only.  
    Top
    Public Properties
     NameDescription
    Public PropertyAlignMarginsHeaderFooterGets or sets a value indicating whether the header and the footer are aligned with the margins set in the page setup options.  
    Public PropertyBlackAndWhiteGets or sets a value indicating whether elements of the document will be printed in black and white.  
    Public PropertyBottomMarginGets or sets the size of the bottom margin, in pixels.  
    Public PropertyCellCommentsGets or sets a CellComments contstant specifying the type of print cell comments displayed. This feature allows users to suppress the display of cell comments when printing a worksheet.  
    Public PropertyCenterFooterGets or sets a value indicating whether a picture or text to be center-aligned in the page footer.  
    Public PropertyCenterHeaderGets or sets a value indicating whether a picture or text to be center-aligned in the page header.  
    Public PropertyCenterHorizontallyGets or sets a value indicating whether the sheet is centered horizontally on the page when it's printed.  
    Public PropertyCenterVerticallyGets or sets a value indicating whether the sheet is centered vertically on the page when it's printed.  
    Public PropertyDifferentFirstPageHeaderFooterGets or sets a value indicating whether the different header or footer is used on the first page.  
    Public PropertyDraftGets or sets a value indicating whether the sheet will be printed without graphics.  
    Public PropertyEvenPageGets or sets a PageSetup value indicating whether the alignment of text on the even page of a worksheet or section. A PageSetup value specifying the alignment of text on the even page.  
    Public PropertyFirstPageGets or sets a PageSetup value indicating whether the alignment of text on the first page of a worksheet or section.  
    Public PropertyFirstPageNumberGets or sets the first page number that will be used when this sheet is printed.  
    Public PropertyFitToPagesGets or sets a boolean value indicating whether the worksheet will be scaled to fit to the specified number of pages when it's printed.  
    Public PropertyFitToPagesTallGets or sets a value indicating the number of pages tall the worksheet will be scaled to when it's printed.  
    Public PropertyFitToPagesWideGets or sets a value indicating the number of pages wide the worksheet will be scaled to when it's printed.  
    Public PropertyFooterMarginGets or sets the distance from the bottom of the page to the footer, in pixels.  
    Public PropertyHeaderMarginGets or sets the distance from the top of the page to the header, in pixels.  
    Public PropertyLeftFooterGets or sets a value indicating whether a picture or text to be left-aligned in the page footer.  
    Public PropertyLeftHeaderGets or sets a value indicating whether a picture or text to be left-aligned in the page header.  
    Public PropertyLeftMarginGets or sets the size of the left margin, in pixels.  
    Public PropertyNumberOfCopiesGets or sets the number of copies to print.  
    Public PropertyOddAndEvenPagesHeaderFooterGets or sets a value indicating whether the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages.  
    Public PropertyOrderGets or sets an Order value that represents the order that Microsoft Excel uses to number pages when printing a large worksheet.  
    Public PropertyOrientationGets or sets a PageOrientation value that represents the portrait or landscape printing mode.  
    Public PropertyPaperSizeGets or sets the size of the paper.  
    Public PropertyPrintAreaGets or sets the range to be printed.  
    Public PropertyPrintColumnHeaderGets or sets a value indicating whether column headings are printed with this page.  
    Public PropertyPrintErrorsGets or sets a PrintErrors contstant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet.  
    Public PropertyPrintGridlinesGets or sets a value indicating whether cell gridlines are printed on the page.  
    Public PropertyPrintHeadingsGets or sets a value indicating whether row and column headings are printed with this page.  
    Public PropertyPrintNotesGets or sets a value indicating whether cell notes are printed as end notes with the sheet.  
    Public PropertyPrintRowHeaderGets or sets a value indicating whether row headings are printed with this page.  
    Public PropertyPrintTitleColumnsGets or sets a value indicating the columns that contain the cells to be repeated on the left side of each page.  
    Public PropertyPrintTitleRowsGets or sets a value indicating the rows that contain the cells to be repeated on the left side of each page.  
    Public PropertyRightFooterGets or sets a value indicating whether a picture or text to be right-aligned in the page footer.  
    Public PropertyRightHeaderGets or sets a value indicating whether a picture or text to be right-aligned in the page header.  
    Public PropertyRightMarginGets or sets the size of the right margin, in pixels.  
    Public PropertyScaleWithDocHeaderFooterGets or sets a value indicating whether the header and footer should be scaled with the document when the size of the document changes.  
    Public PropertyTopMarginGets or sets the size of the top margin, in pixels.  
    Public PropertyZoomGets or sets the percentage scale of the worksheet for printing.  
    Top
    Public Methods
     NameDescription
    Public MethodGetHeaderFooterGets the original string of print header/footer.  
    Public MethodSetHeaderFooterSets raw header/footer code.  
    Top
    See Also

    Reference

    PageSetup Class
    GrapeCity.Spreadsheet.Printing Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page