Spread.Sheets Documentation
setStyleName Method
The row index.
The column index.
The name of the style to set.
The sheet area. If this parameter is not provided, it defaults to viewport.
Sets the specified style name for a specified cell in the specified sheet area.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var returnValue; // Type: any
returnValue = instance.setStyleName(row, column, value, sheetArea);
function setStyleName( 
   row : number,
   column : number,
   value : string,
   sheetArea : SheetArea
) : any;

Parameters

row
The row index.
column
The column index.
value
The name of the style to set.
sheetArea
The sheet area. If this parameter is not provided, it defaults to viewport.
Example
This example creates a named style.
<input type="button" id="button1" value="button1"/>

var namedStyle = new GC.Spread.Sheets.Style();
namedStyle.name = "style1";
namedStyle.backColor = "green";
activeSheet.addNamedStyle(namedStyle);
activeSheet.setStyleName(1, 1, "style1"); // cell(1,1)'s backColor is  green.
activeSheet.setStyleName(2, 1, "style1");
 
var style = activeSheet.getNamedStyle("style1");
style.foreColor = "red";    // the namedStyle's foreColor is red.
activeSheet.repaint(); // the foreColor of the cell(1,1) and cell(2,1) is red.
activeSheet.getCell(1,1).value("test");

$("#button1").click(function () {
activeSheet.removeNamedStyle("style1");
    });
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.