SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setDefaultStyle Method
The style to set.
The sheet area. If this parameter is not provided, it defaults to viewport.
In This Topic
    setDefaultStyle Method
    In This Topic
    Sets the default style information for the sheet.
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.setDefaultStyle(style, sheetArea);
    function setDefaultStyle( 
       style : Style,
       (optional) sheetArea : SheetArea
    ) : any;


    The style to set.
    The sheet area. If this parameter is not provided, it defaults to viewport.
    This example creates a default style.
    activeSheet.setRowCount(5, GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.setColumnCount(5, GC.Spread.Sheets.SheetArea.viewport);
        //Set the default styles.
        var defaultStyle = new GC.Spread.Sheets.Style();
        defaultStyle.backColor = "LemonChiffon";
        defaultStyle.foreColor = "Red";
        defaultStyle.formatter = "0.00";
        defaultStyle.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
        defaultStyle.borderLeft = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
        defaultStyle.borderTop = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
        defaultStyle.borderRight = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
        defaultStyle.borderBottom = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
        activeSheet.setDefaultStyle(defaultStyle, GC.Spread.Sheets.SheetArea.viewport);
        var rowCount = activeSheet.getRowCount();
        var colCount = activeSheet.getColumnCount();
        for(var i = 0; i < rowCount; i++){
            for(var j = 0; j < colCount; j++){
                activeSheet.setValue(i, j, i+j, GC.Spread.Sheets.SheetArea.viewport);
    See Also


    Worksheet type