bestFitColumns Method

Gets or sets whether column widths are adjusted to fit the longest text width for printing.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function bestFitColumns( 
   value : boolean
) : any;

Parameters

value: Whether column widths are adjusted to fit the longest text width for printing.

Return Value

If no value is set, returns whether column widths are adjusted to fit the longest text width for printing; otherwise, returns the print setting information.

Example

This example prints the sheet.

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.bestFitColumns(true);
printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.landscape);
printInfo.footerCenter("GrapeCity");
activeSheet.printInfo(printInfo);
spread.print(0);
   });

Reference

PrintInfo type