getActualStyle Method

Gets the actual 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.getActualStyle(row, column, sheetArea, sheetStyleOnly);

function getActualStyle( 
   row : number,
   column : number,
   sheetArea : SheetArea,
   sheetStyleOnly : boolean
) : Style;

Parameters

row: The row index.
column: The column index.
sheetArea: The sheet area. If this parameter is not provided, it defaults to viewport.
sheetStyleOnly: If true, the row filter and the conditional format style are not applied to the return style; otherwise, the return style only contains the cell's inherited style.

Return Value

Returns the cell style of the specified cell.

Example

This example uses the getActualStyle 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.getActualStyle(1,1,GC.Spread.Sheets.SheetArea.viewport, true);
alert(cstyle.backColor);

Reference

Worksheet type