SpreadJS 14
Features / Print / Configure Page Breaks
In This Topic
    Configure Page Breaks
    In This Topic

    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.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);
    })
    
    See Also