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 GcSpread.Sheets.PrintInfo();
var returnValue; // Type: boolean
returnValue = instance.bestFitColumns(value);

function bestFitColumns( 
   value : boolean
) : boolean;

Parameters

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

Return Value

true if the column widths are adjusted to fit the longest text width for printing; otherwise, false. The default value is false.

Example

This example prints the sheet.

Javascript

activeSheet.setRowCount(3, GcSpread.Sheets.SheetArea.viewport);
activeSheet.setColumnCount(3, GcSpread.Sheets.SheetArea.viewport);

activeSheet.isPaintSuspended(true);
            //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.isPaintSuspended(false);

$("#button1").click(function () {
var printInfo = activeSheet.printInfo();
printInfo.bestFitColumns(true);
printInfo.orientation(GcSpread.Sheets.PrintPageOrientation.Landscape);
printInfo.footerCenter("GrapeCity");
activeSheet.printInfo(printInfo);
spread.print(0);
   });

Reference

PrintInfo type