Spread.Sheets Documentation
bestFitRows Method
Whether row heights are adjusted to fit the tallest text height for printing.
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( 
   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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.