spreadsheetSetFitToPage

Turns the fit-to-page print option on or off for the active sheet.

spreadsheetSetFitToPage(spreadsheet, fitToPage, pagesWidth, pagesHeight) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

fitToPage boolean
Required

true to enable fit to page, false to disable it.
Values:
  • true
  • false

pagesWidth numeric
Required

Number of pages to fit the columns into. 0 for no horizontal fit.

pagesHeight numeric
Required

Number of pages to fit the rows into. 0 for no vertical fit.

Compatibility

RustCFML:

Not supported on wasm32. Arguments are named state, pagesWide and pagesHigh, are optional, and default to true, 1 and 1. Member form: setFitToPage(state, pagesWide, pagesHigh).

Examples
Sample code invoking the spreadsheetSetFitToPage function

Scale the active sheet to one page wide by one page high.

wb = Spreadsheet("xlsx");
spreadsheetSetFitToPage(wb, true, 1, 1);

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub