SpreadsheetSetFitToPage

Toggles the fit-to-page print option on the active sheet

Method Signature

SpreadsheetSetFitToPage(spreadsheetObj=[any], fitToPage=[any], pagesWide=[any], pagesHigh=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
fitToPage	BOOLEAN	true	True to enable fit-to-page, false to disable.
pagesWide	NUMERIC	true	Number of pages to fit the sheet's columns (0 for no horizontal constraint).
pagesHigh	NUMERIC	true	Number of pages to fit the sheet's rows (0 for no vertical constraint).

Examples

Fit spreadsheet to page:

// Fit content to one page width
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRows( spreadsheet, [ ["A", "B", "C", "D"] ] );

SpreadsheetSetFitToPage( spreadsheet, true, true );

Related

• SpreadsheetAddPageBreaks() - Add page breaks

• SpreadsheetSetPrintOrientation() - Set orientation

• SpreadsheetSetHeader() - Set header