SpreadJS 14
GC.Spread.Sheets Namespace / Style class / labelOptions Field
In This Topic
    labelOptions Field
    In This Topic
    Indicates the cell label options.
    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: Object
    value = instance.labelOptions;
    var labelOptions : Object;
    Example
    This example sets label options 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