| | Name | Description |
|---|
 | AlignMarginsHeaderFooter |
Returns True to align the header and the footer with the margins set in the page setup options.
|
| BestFitColumns |
Gets or sets whether column widths are adjusted to fit the longest text width for printing.
May cause some efficiency problems if the file contains large amounts of data.
|
| BestFitRows |
Gets or sets whether row heights are adjusted to fit the tallest text height for printing.
May cause some efficiency problems if the file contains large amounts of data.
|
| BlackAndWhite |
True if elements of the document will be printed in black and white.
|
| BottomMargin |
Returns or sets the size of the bottom margin, in points.
|
| CenterFooter |
Center aligns the footer information in the PageSetup object.
|
| CenterFooterPicture | Returns a IGraphic object that represents the picture for the center section of the footer. Used to set attributes about the picture. |
| CenterHeader |
Center aligns the header information in the PageSetup object.
|
| CenterHeaderPicture | Returns a IGraphic object that represents the picture for the center section of the header. Used to set attributes about the picture. |
| CenterHorizontally |
True if the sheet is centered horizontally on the page when it's printed.
|
| CenterVertically |
True if the sheet is centered vertically on the page when it's printed.
|
| DifferentFirstPageHeaderFooter |
True if a different header or footer is used on the first page.
|
| Draft |
True if the sheet will be printed without graphics.
|
| EvenPage | Returns the alignment of text on the even IPage of a workbook or section. |
| FirstPage | Returns the alignment of text on the first IPage of a workbook or section. |
| FirstPageNumber |
Returns or sets the first page number that will be used when this sheet is printed. If Automatic, GcExcel chooses the first page number. The default is Automatic.
|
| FitToPagesTall |
Returns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.
|
| FitToPagesWide |
Returns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.
|
| FooterMargin |
Returns or sets the size of the footer margin, in points.
|
| HeaderMargin |
Returns or sets the size of the header margin, in points.
|
| IsPercentScale |
If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.
|
| LeftFooter |
Returns or sets the alignment of text on the left footer of a workbook or section.
|
| LeftFooterPicture | Returns a IGraphic object that represents the picture for the left section of the footer. Used to set attributes about the picture. |
| LeftHeader |
Returns or sets the alignment of text on the left header of a workbook or section.
|
| LeftHeaderPicture | Returns a IGraphic object that represents the picture for the left section of the header. Used to set attributes about the picture. |
| LeftMargin |
Returns or sets the size of the left margin, in points.
|
| OddAndEvenPagesHeaderFooter |
True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages.
|
| Order | Returns or sets a Order value that represents the order that GcExcel uses to number pages when printing a large worksheet. |
| Orientation | Returns or sets a PageOrientation value that represents the portrait or landscape printing mode. |
| PaperHeight |
Represents the height in inches of the paper, considered page orientation.
|
| PaperSize |
Returns or sets the size of the paper.
|
| PaperWidth |
Represents the width in inches of the paper, considered page orientation.
|
| PrintArea |
Returns or sets the range to be printed, as a string using A1-style references in the language of the macro.
|
| PrintComments |
Returns or sets the way comments are printed with the sheet.
|
| PrintCopies |
Gets or sets number of copies to print.
|
| PrintErrors |
Returns or sets an PrintErrors contstant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet.
|
| PrintGridlines |
True if cell gridlines are printed on the page. Applies only to worksheets.
|
| PrintHeadings |
True if row and column headings are printed with this page. Applies only to worksheets.
|
| PrintNotes |
True if cell notes are printed as end notes with the sheet. Applies only to worksheets.
|
| PrintPageRange |
Gets or sets range of pages to print, the numbers or page ranges are separated by commas counting from the beginning of the document. For example, type "1,3,5-12".
|
| PrintQuality | Returns or sets a PrintQuality value that represents the print quality of this page. Default is 600 dpi. |
| PrintTailColumns |
Returns or sets the columns that contain the cells to be repeated on the right side of each page, as a string in A1-style notation in the language of the macro.
|
| PrintTailRows |
Returns or sets the rows that contain the cells to be repeated at the bottom of each page, as a string in A1-style notation in the language of the macro.
|
| 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.
|
| 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.
|
| RightFooter |
Returns or sets the distance (in points) between the right edge of the page and the right boundary of the footer.
|
| RightFooterPicture | Returns a IGraphic object that represents the picture for the right section of the footer. Used to set attributes of the picture. |
| RightHeader |
Returns or sets the right part of the header.
|
| RightHeaderPicture | Returns a IGraphic object that represents the picture for the right section of the header. Used to set attributes of the picture. |
| RightMargin |
Returns or sets the size of the right margin, in points.
|
| ScaleWithDocHeaderFooter |
Returns or sets if the header and footer should be scaled with the document when the size of the document changes.
|
| TopMargin |
Returns or sets the size of the top margin, in points.
|
| Zoom |
Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which GcExcel will scale the worksheet for printing.
|
