SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setRowPageBreak Method
The row index.
Set to true to force a page break before the specified row on this sheet when printing.
In This Topic
    setRowPageBreak Method
    In This Topic
    Sets whether a forced page break is inserted before the specified row on this sheet when printing.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var returnValue; // Type: any
    returnValue = instance.setRowPageBreak(row, value);
    function setRowPageBreak( 
       row : number,
       value : boolean
    ) : any;

    Parameters

    row
    The row index.
    value
    Set to true to force a page break before the specified row on this sheet when printing.
    Example
    This example sets row and page breaks for printing.
    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();
    activeSheet.setRowPageBreak(3, true);
    activeSheet.setColumnPageBreak(5, true);
    alert(activeSheet.getRowPageBreak(3));
    alert(activeSheet.getColumnPageBreak(5));
    //Remove following comment to use the print method
    //spread.print(0);
    See Also

    Reference

    Worksheet type