PageSetup

Overview

PageSetup is a class in Aspose.Cells FOSS for C++.

Represents worksheet print and page-layout settings.

Methods

SignatureDescription
GetPaperSize()PaperSizeTypeGets or sets the paper size.
SetPaperSize(value: PaperSizeType)
GetOrientation()PageOrientationTypeGets or sets the page orientation.
SetOrientation(value: PageOrientationType)
GetFirstPageNumber()std::optional<int>Gets or sets the first printed page number.
SetFirstPageNumber(value: std::optional<int>)
GetScale()std::optional<int>Gets or sets the print scaling percentage.
SetScale(value: std::optional<int>)
GetFitToPagesWide()std::optional<int>Gets or sets the number of pages wide to fit when printing.
SetFitToPagesWide(value: std::optional<int>)
GetFitToPagesTall()std::optional<int>Gets or sets the number of pages tall to fit when printing.
SetFitToPagesTall(value: std::optional<int>)
GetPrintArea()std::stringGets or sets the print area reference.
SetPrintArea(value: std::string_view)
GetPrintTitleRows()std::stringGets or sets the repeating title rows reference.
SetPrintTitleRows(value: std::string_view)
GetPrintTitleColumns()std::stringGets or sets the repeating title columns reference.
SetPrintTitleColumns(value: std::string_view)
GetLeftMargin()doubleGets or sets the left margin in centimeters.
SetLeftMargin(value: double)
GetRightMargin()doubleGets or sets the right margin in centimeters.
SetRightMargin(value: double)
GetTopMargin()doubleGets or sets the top margin in centimeters.
SetTopMargin(value: double)
GetBottomMargin()doubleGets or sets the bottom margin in centimeters.
SetBottomMargin(value: double)
GetHeaderMargin()doubleGets or sets the header margin in centimeters.
SetHeaderMargin(value: double)
GetFooterMargin()doubleGets or sets the footer margin in centimeters.
SetFooterMargin(value: double)
GetLeftMarginInch()doubleGets or sets the left margin in inches.
SetLeftMarginInch(value: double)
GetRightMarginInch()doubleGets or sets the right margin in inches.
SetRightMarginInch(value: double)
GetTopMarginInch()doubleGets or sets the top margin in inches.
SetTopMarginInch(value: double)
GetBottomMarginInch()doubleGets or sets the bottom margin in inches.
SetBottomMarginInch(value: double)
GetHeaderMarginInch()doubleGets or sets the header margin in inches.
SetHeaderMarginInch(value: double)
GetFooterMarginInch()doubleGets or sets the footer margin in inches.
SetFooterMarginInch(value: double)
GetLeftHeader()std::stringGets or sets the left header text.
SetLeftHeader(value: std::string_view)
GetCenterHeader()std::stringGets or sets the center header text.
SetCenterHeader(value: std::string_view)
GetRightHeader()std::stringGets or sets the right header text.
SetRightHeader(value: std::string_view)
GetLeftFooter()std::stringGets or sets the left footer text.
SetLeftFooter(value: std::string_view)
GetCenterFooter()std::stringGets or sets the center footer text.
SetCenterFooter(value: std::string_view)
GetRightFooter()std::stringGets or sets the right footer text.
SetRightFooter(value: std::string_view)
GetPrintGridlines()boolGets or sets whether gridlines are printed.
SetPrintGridlines(value: bool)
GetPrintHeadings()boolGets or sets whether row and column headings are printed.
SetPrintHeadings(value: bool)
GetCenterHorizontally()boolGets or sets whether content is centered horizontally on the page.
SetCenterHorizontally(value: bool)
GetCenterVertically()boolGets or sets whether content is centered vertically on the page.
SetCenterVertically(value: bool)
GetHorizontalPageBreaks()std::vector<int>Gets the horizontal page breaks as sorted zero-based row indexes.
GetVerticalPageBreaks()std::vector<int>Gets the vertical page breaks as sorted zero-based column indexes.
AddHorizontalPageBreak(rowIndex: int)Adds a horizontal page break at the specified zero-based row index.
AddVerticalPageBreak(columnIndex: int)Adds a vertical page break at the specified zero-based column index.
ClearHorizontalPageBreaks()Removes all horizontal page breaks.
ClearVerticalPageBreaks()Removes all vertical page breaks.

See Also