Spread.Sheets Documentation
getActualStyle Method
The row index.
The column index.
The sheet area. If this parameter is not provided, it defaults to viewport.
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.
Gets the actual style information for a specified cell in the specified sheet area.
Syntax
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.
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);
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.