Class
WorksheetPageSetup

Configures page setup for worksheet printing and export, including scaling, page breaks, print area, and print titles.

Definition

Properties

CenterHorizontally

Gets or sets whether the printed content is centered horizontally on the page.

Declaration

cs-api-definition
public bool CenterHorizontally { get; set; }

Property Value

bool

The value indicating whether the print content should be centered horizontally.

CenterVertically

Gets or sets whether the printed content is centered vertically on the page.

Declaration

cs-api-definition
public bool CenterVertically { get; set; }

Property Value

bool

The value indicating whether the print content should be centered vertically.

FitToPages

Gets or sets whether scaling is determined by FitToPagesWide and FitToPagesTall (when true) or by ScaleFactor (when false).

Declaration

cs-api-definition
public bool FitToPages { get; set; }

Property Value

bool

If true, the worksheet will be scaled according to the FitToPagesWide and FitToPagesTall values. If false, it will be scaled according to the ScaleFactor value.

FitToPagesTall

Gets or sets the number of pages tall the worksheet content will scale to fit when FitToPages is enabled.

Declaration

cs-api-definition
public int FitToPagesTall { get; set; }

Property Value

int

FitToPagesWide

Gets or sets the number of pages wide the worksheet content will scale to fit when FitToPages is enabled.

Declaration

cs-api-definition
public int FitToPagesWide { get; set; }

Property Value

int

PageBreaks

Gets the page breaks that control where manual horizontal and vertical page boundaries are inserted.

Declaration

cs-api-definition
public PageBreaks PageBreaks { get; }

Property Value

PageBreaks

The page breaks.

PageOrder

Gets or sets the page order that determines whether multi-page content is printed down then across or across then down.

Declaration

cs-api-definition
public PageOrder PageOrder { get; set; }

Property Value

PageOrder

The page order.

PrintArea

Gets the print area that defines which cell ranges are printed when exporting or printing.

Declaration

cs-api-definition
public PrintArea PrintArea { get; }

Property Value

PrintArea

The print area.

PrintOptions

Gets the print options that control gridline and heading visibility during print or export.

Declaration

cs-api-definition
public override WorksheetPrintOptions PrintOptions { get; }

Property Value

WorksheetPrintOptions

The print options.

Overrides SheetPageSetup<WorksheetPrintOptions>.PrintOptions

PrintTitles

Gets the print titles that define rows and columns to repeat on every printed page for improved readability.

Declaration

cs-api-definition
public PrintTitles PrintTitles { get; }

Property Value

PrintTitles

ScaleFactor

Gets or sets the scale factor as percentages for width and height, used when FitToPages is false.

Declaration

cs-api-definition
public Size ScaleFactor { get; set; }

Property Value

Size

The scale factor.