SpreadJS 13
GC.Spread.Sheets Namespace / LabelVisibility Enumeration
In This Topic
    LabelVisibility Enumeration
    In This Topic
    Specifies the cell label visibility.
    Members
    MemberDescription
    autoSpecifies to show the watermark in the padding area when the cell has a value or to show the watermark in the cell area if the cell does not have a value.
    hiddenSpecifies to not show the watermark in the padding area, but to show the watermark in the cell area based on a value condition.
    visibleSpecifies to always show the watermark in the padding area and not to show the watermark in the cell area, regardless of the cell value.
    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);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.LabelVisibility

    See Also