getStyle Method

Gets the style information for a specified cell in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: Style
value = instance.getStyle(row, column, sheetArea);

function getStyle( 
   row : number,
   column : number,
   sheetArea : SheetArea
) : Style;

Parameters

row: The row index.
column: The column index.
sheetArea: The sheet area. If this parameter is not provided, it defaults to viewport.

Return Value

Returns the cell style of the specified cell.

Example

This example uses the getStyle method.

Javascript

var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
var cstyle = activeSheet.getStyle(1,1,GC.Spread.Sheets.SheetArea.viewport, true);
alert(cstyle.backColor);

Reference

Worksheet type