# SpreadsheetAddPageBreaks

Adds multiple page breaks (rows and/or columns) to the active sheet

## Method Signature

```
SpreadsheetAddPageBreaks(spreadsheetObj=[any], rows=[any], columns=[any])
```

### Arguments

| Argument         | Type  | Required | Description                                                                      | Default |
| ---------------- | ----- | -------- | -------------------------------------------------------------------------------- | ------- |
| `spreadsheetObj` | `ANY` | `true`   | The spreadsheet object.                                                          |         |
| `rows`           | `ANY` | `false`  | A number or array of row numbers (1-based) where page breaks should be added.    |         |
| `columns`        | `ANY` | `false`  | A number or array of column numbers (1-based) where page breaks should be added. |         |

## Examples

Add page breaks for printing:

```js
// Add page break after row 20
var spreadsheet = SpreadsheetNew();
SpreadsheetAddPageBreaks( spreadsheet, 20, 0 );
```

## Related

* [SpreadsheetSetFitToPage()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetfittopage) - Fit to page
* [SpreadsheetSetHeader()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetheader) - Set header
* [Print Settings Guide](https://github.com/ortus-boxlang/boxlang-docs/blob/v1.x/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/print-settings.md) - Printing configuration