GrapeCity.Documents.Excel.LabelVisibility

LabelVisibility Enum

Specifies the visibility of a cell label watermark.

Use this enum with LabelOptions and Visibility to control whether a watermark is shown in the padding area, the cell area, or automatically based on whether the cell has a value. Use visible to always show the watermark in the padding area, hidden to show it in the cell area based on the cell value, or auto to switch between the two behaviors automatically.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum LabelVisibility

Public Enum LabelVisibility

Examples

IRange range = worksheet.Range["A3"];
range.Watermark = "OTHER INFORMATION";
range.CellPadding = new CellPadding(20, 0, 0, 0);
range.LabelOptions.Visibility = LabelVisibility.visible;
range.LabelOptions.ForeColor = Color.FromArgb(51, 51, 51);
range.LabelOptions.Margin = new Margin(2, 0, 0, 0);
range.LabelOptions.Font.Size = 7;
LabelVisibility visibility = range.LabelOptions.Visibility;

Fields

Name	Description
auto	Specifies that the watermark is shown in the padding area when the cell contains a value, and is shown in the cell area when the cell is empty.
hidden	Specifies that the watermark is not shown in the padding area, and is shown in the cell area based on whether the cell has a value.
visible	Specifies that the watermark is always shown in the padding area and is not shown in the cell area, regardless of whether the cell has a value.