bestFitRows Method

Gets or sets whether row heights are adjusted to fit the tallest text height for printing.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Print.PrintInfo();
var returnValue; // Type: any
returnValue = instance.bestFitRows(value);

function bestFitRows( 
   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.

Javascript

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);
   });

Reference

PrintInfo type