getActualStyle Method

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

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(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 GcSpread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GcSpread.Sheets.LineBorder("blue");
style.borderTop = new GcSpread.Sheets.LineBorder("blue");
style.borderRight = new GcSpread.Sheets.LineBorder("blue");
style.borderBottom = new GcSpread.Sheets.LineBorder("blue");
activeSheet.setStyle(1,1,style,GcSpread.Sheets.SheetArea.viewport);
var cstyle = activeSheet.getActualStyle(1,1,GcSpread.Sheets.SheetArea.viewport, true);
alert(cstyle.backColor);

Reference

Sheet type