Setting Page Breaks when Printing

You can specify page breaks when printing with the setColumnPageBreak and setRowPageBreak methods.

Using Code

This example sets and gets column and row page breaks.

JavaScript	Copy Code
activeSheet.isPaintSuspended(true); //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.isPaintSuspended(false); activeSheet.setRowPageBreak(3, true); activeSheet.setColumnPageBreak(5, true); alert(activeSheet.getRowPageBreak(3)); alert(activeSheet.getColumnPageBreak(5)); spread.print(0);

JavaScript

Copy Code

activeSheet.isPaintSuspended(true);
            //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.isPaintSuspended(false);
activeSheet.setRowPageBreak(3, true);
activeSheet.setColumnPageBreak(5, true);
alert(activeSheet.getRowPageBreak(3));
alert(activeSheet.getColumnPageBreak(5));
spread.print(0);