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.
    Syntax
    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;

    Parameters

    style
    The style to set.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.
    Example
    This example creates a default style.
    //setDefaultStyle
    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

    Reference

    Worksheet type