columnEnd Method

Gets or sets the last column to print when printing a cell range.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function columnEnd( 
   value : number
) : any;

Parameters

value: The last column to print when printing a cell range.

Return Value

If no value is set, returns the last column to print when printing a cell range; otherwise, returns the print setting information.

Example

This example uses the columnEnd 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.columnStart(0);
printInfo.columnEnd(2);
printInfo.centering(GC.Spread.Sheets.Print.PrintCentering.horizontal);
activeSheet.printInfo(printInfo);
spread.print(0);
   });

Reference

PrintInfo type