# GC.Spread.Sheets.LabelVisibility

## Content

# Enumeration: LabelVisibility

[Spread](../modules/GC.Spread).[Sheets](../modules/GC.Spread.Sheets).LabelVisibility

Specifies the cell label visibility.

**`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);
```

## Table of contents

### Enumeration members

- [auto](GC.Spread.Sheets.LabelVisibility#auto)
- [hidden](GC.Spread.Sheets.LabelVisibility#hidden)
- [visible](GC.Spread.Sheets.LabelVisibility#visible)

## Enumeration members

### <a id="auto" name="auto"></a> auto

• **auto** = `2`

 Specifies 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.

___

### <a id="hidden" name="hidden"></a> hidden

• **hidden** = `1`

 Specifies to not show the watermark in the padding area, but to show the watermark in the cell area based on a value condition.

___

### <a id="visible" name="visible"></a> visible

• **visible** = `0`

 Specifies to always show the watermark in the padding area and not to show the watermark in the cell area, regardless of the cell value.