- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- Serialization
- Keyboard Actions
- Shapes
- Form Controls
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Configure Page Breaks
You can specify page breaks when printing with the setColumnPageBreak and setRowPageBreak methods.
The following code sample sets and gets column and row page breaks.
activeSheet.suspendPaint();
//set value
for (var r = 0, rc = activeSheet.getRowCount(); r < rc; r++) {
for (var c = 0, cc = activeSheet.getColumnCount(); c < cc; c++) {
activeSheet.setValue(r, c, r + c);
}
}
activeSheet.resumePaint();
$("#button1").click(function(){
activeSheet.setRowPageBreak(3, true);
activeSheet.setColumnPageBreak(5, true);
alert(activeSheet.getRowPageBreak(3));
alert(activeSheet.getColumnPageBreak(5));
spread.print(0);
})