# 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:

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

SpreadsheetSetFitToPage( spreadsheet, true, true );
```

## Related

* [SpreadsheetAddPageBreaks()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetaddpagebreaks) - Add page breaks
* [SpreadsheetSetPrintOrientation()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetprintorientation) - Set orientation
* [SpreadsheetSetHeader()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetheader) - Set header