SetFitToPagesTall
Sets the number of pages tall the worksheet is scaled to when printed (0 means automatic). Setting this property turns on the "fit to page" mode.
Syntax
expression.SetFitToPagesTall(nPages);
expression - A variable that represents an ApiPageSetup class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| nPages | Required | number | The number of pages tall (0 for automatic). |
Returns
boolean
Example
Scale the printout to fit a given number of pages tall in a spreadsheet.
// How do I fit all rows onto a fixed number of pages when printing in a spreadsheet?
// Shrink the worksheet so it prints within a fixed number of pages vertically in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let pageSetup = worksheet.GetPageSetup();
pageSetup.SetFitToPagesTall(2);