SpreadJS 13
GC.Spread.Sheets.Print Namespace / PrintInfo type / bestFitRows Method
Whether row heights are adjusted to fit the tallest text height for printing.
In This Topic
    bestFitRows Method
    In This Topic
    Gets or sets whether row heights are adjusted to fit the tallest text height for printing.
    Syntax
    var instance = new GC.Spread.Sheets.Print.PrintInfo();
    var returnValue; // Type: any
    returnValue = instance.bestFitRows(value);
    function bestFitRows( 
       (optional) value : boolean
    ) : any;

    Parameters

    value
    Whether row heights are adjusted to fit the tallest text height for printing.

    Return Value

    If no value is set, returns whether row heights are adjusted to fit the tallest text height for printing; otherwise, returns the print setting information.
    Example
    This example uses the bestFitRows method.
    activeSheet.setRowCount(3, GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.setColumnCount(3, GC.Spread.Sheets.SheetArea.viewport);
    
         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 () {
    var printInfo = new GC.Spread.Sheets.Print.PrintInfo();
    printInfo.bestFitRows(true);
    activeSheet.printInfo(printInfo);
    spread.print(0);
       });
    See Also

    Reference

    PrintInfo type