SpreadJS 13
GC.Spread.Sheets Namespace / Style class / cellPadding Field
In This Topic
    cellPadding Field
    In This Topic
    Indicates the cell padding.
    Syntax
    var instance = new GC.Spread.Sheets.Style(backColor,
                                             foreColor,
                                             hAlign,
                                             vAlign,
                                             font,
                                             themeFont,
                                             formatter,
                                             borderLeft,
                                             borderTop,
                                             borderRight,
                                             borderBottom,
                                             diagonalDown,
                                             diagonalUp,
                                             locked,
                                             textIndent,
                                             wordWrap,
                                             shrinkToFit,
                                             backgroundImage,
                                             cellType,
                                             backgroundImageLayout,
                                             tabStop,
                                             textDecoration,
                                             imeMode,
                                             name,
                                             parentName,
                                             watermark,
                                             cellPadding,
                                             labelOptions,
                                             labelOptions.alignment,
                                             labelOptions.visibility,
                                             labelOptions.font,
                                             labelOptions.foreColor,
                                             labelOptions.margin,
                                             isVerticalText,
                                             textOrientation);
    var value; // Type: string
    value = instance.cellPadding;
    var cellPadding : string;
    Example
    This example sets the cell padding for the watermark.
    var type = new GC.Spread.Sheets.Style();
    type.watermark = "User name";
    type.cellPadding = "20";
    type.labelOptions = {alignment:GC.Spread.Sheets.LabelAlignment.topLeft, visibility: GC.Spread.Sheets.LabelVisibility.visible};
    activeSheet.setStyle(0, 1, type);
    activeSheet.getRange(0, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).height(60);
    activeSheet.getRange(-1, 1, -1, 1).width(150);
    
    var combo = new GC.Spread.Sheets.CellTypes.ComboBox();
    combo.items([{ text: "Oranges", value: "11k" }, { text: "Apples", value: "15k" }, { text: "Grape", value: "100k" }]);
    combo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
    activeSheet.setCellType(2, 1, combo, GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.getCell(2, 1, GC.Spread.Sheets.SheetArea.viewport).watermark("ComboBox Cell Type").cellPadding('10 10 20 10');
    activeSheet.getCell(2, 1, GC.Spread.Sheets.SheetArea.viewport).labelOptions({alignment: GC.Spread.Sheets.LabelAlignment.bottomCenter, foreColor: 'yellowgreen', font: 'bold 15px Arial'});
    activeSheet.getRange(2, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).height(60);
    See Also

    Reference

    Style class