setBorder Method

Determines which part of the cell range to set, the option object contains {all:true, left:true, top:true, right:true, bottom:true,outline:true,inside:true, innerHorizontal:true, innerVertical:true}

For example, {all:true}, {left:true, right:true}. The following settings are available:

option.all	boolean type	Specifies all directions for the border.
option.left	boolean type	Specifies the left border.
option.top	boolean type	Specifies the top border.
option.right	boolean type	Specifies the right border.
option.bottom	boolean type	Specifies the bottom border.
option.outline	boolean type	Specifies the left, top, right, and bottom borders.
option.inside	boolean type	Specifies the inner horizontal and vertical borders.
option.innerHorizontal	boolean type	Specifies the horizontal border.
option.innerVertical	boolean type	Specifies the vertical border.

Sets the border for the specified area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
var value; // Type: any
value = instance.setBorder(border, option);

function setBorder( 
   border : LineBorder,
   option : Object
) : any;

Parameters

border

The border line.

option

Determines which part of the cell range to set, the option object contains {all:true, left:true, top:true, right:true, bottom:true,outline:true,inside:true, innerHorizontal:true, innerVertical:true}

For example, {all:true}, {left:true, right:true}. The following settings are available:

option.all	boolean type	Specifies all directions for the border.
option.left	boolean type	Specifies the left border.
option.top	boolean type	Specifies the top border.
option.right	boolean type	Specifies the right border.
option.bottom	boolean type	Specifies the bottom border.
option.outline	boolean type	Specifies the left, top, right, and bottom borders.
option.inside	boolean type	Specifies the inner horizontal and vertical borders.
option.innerHorizontal	boolean type	Specifies the horizontal border.
option.innerVertical	boolean type	Specifies the vertical border.

Example

This example creates borders.

Javascript

sheet.getCell(1, 1).borderTop(new GC.Spread.Sheets.LineBorder("#F0F8FF",GC.Spread.Sheets.LineStyle.double));
sheet.getCell(1, 1).borderLeft(new GC.Spread.Sheets.LineBorder("#F0F8FF",GC.Spread.Sheets.LineStyle.hair));
sheet.getCell(1, 1).borderRight(new GC.Spread.Sheets.LineBorder("#FAEBD7",GC.Spread.Sheets.LineStyle.dashDot));
sheet.getCell(1, 1).borderBottom(new GC.Spread.Sheets.LineBorder("#00FFFF",GC.Spread.Sheets.LineStyle.medium));
sheet.getRange(-1, 5, -1, 1, GC.Spread.Sheets.SheetArea.viewport).borderTop(new GC.Spread.Sheets.LineBorder("#F0FFFF",GC.Spread.Sheets.LineStyle.medium));
sheet.getRange(-1, 5, -1, 1, GC.Spread.Sheets.SheetArea.viewport).borderLeft(new GC.Spread.Sheets.LineBorder("#F5F5DC",GC.Spread.Sheets.LineStyle.medium));
sheet.getRange(-1, 5, -1, 1, GC.Spread.Sheets.SheetArea.viewport).borderRight(new GC.Spread.Sheets.LineBorder("#FF02FF", GC.Spread.Sheets.LineStyle.dashDot));
sheet.getRange(-1, 5, -1, 1, GC.Spread.Sheets.SheetArea.viewport).borderBottom (new GC.Spread.Sheets.LineBorder("#FFE4C4",GC.Spread.Sheets.LineStyle.thin));
sheet.getRange(2, 2, 2, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(new GC.Spread.Sheets.LineBorder("#8A2BE2",GC.Spread.Sheets.LineStyle.thick), { all:true },3);
sheet.getRange(5, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).borderTop( new GC.Spread.Sheets.LineBorder("#A52A2A",GC.Spread.Sheets.LineStyle.mediumDashed));
sheet.getRange(5, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).borderLeft( new GC.Spread.Sheets.LineBorder("#FF02FF",GC.Spread.Sheets.LineStyle.medium));
sheet.getRange(5, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).borderRight(new GC.Spread.Sheets.LineBorder("#5F9EA0", GC.Spread.Sheets.LineStyle.dashDot));
sheet.getRange(5, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).borderBottom (new GC.Spread.Sheets.LineBorder("#6495ED",GC.Spread.Sheets.LineStyle.dotted));

Reference

CellRange type