Spread.Sheets Documentation
LabelVisibility Enumeration
GC.Spread.Sheets Namespace : LabelVisibility Enumeration
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

Reference

GC.Spread.Sheets Namespace