GrapeCity.Documents.Excel.IDisplayFormat

Interface IDisplayFormat

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the display settings for an associated Range object.

Remark: Actions such as changing the conditional formatting or table style of a range can cause what is displayed in the current user interface to be inconsistent with the values in the corresponding properties of the Range object. Use the properties of the DisplayFormat object to return the values as they are displayed in the current user interface.

public interface IDisplayFormat

Properties

AddIndent

Gets a value that indicates if the application automatically indents text of the associated Range object when the text alignment in a cell is set to equal distribution (either horizontally or vertically), as it is displayed in the current user interface.

Returns: Returns True if text is automatically indented when the text alignment in the cell is set, either horizontally or vertically, to equal distribution.

bool AddIndent { get; }

Property Value

bool

Borders

Gets a Borders object that represents the borders of the associated Range object as it is displayed in the current user interface.

IBorders Borders { get; }

Property Value

IBorders

Font

Gets a Font object that represents the font of the associated Range as it is displayed in the current user interface.

IFont Font { get; }

Property Value

IFont

FormulaHidden

Gets a value that indicates if the formula of the associated Range object is hidden when the worksheet is protected as it is displayed in the current user interface.

bool FormulaHidden { get; }

Property Value

bool

HorizontalAlignment

Gets a value that represents the horizontal alignment of the associated Range object as it is displayed in the current user interface.

HorizontalAlignment HorizontalAlignment { get; }

Property Value

HorizontalAlignment

IndentLevel

Gets a value that represents the indent level of the associated Range object as it is displayed in the current user interface.

int IndentLevel { get; }

Property Value

int

Interior

Gets an Interior object that represents the interior of the associated Range object as it is displayed in the current user interface.

IInterior Interior { get; }

Property Value

IInterior

Locked

Gets a value that indicates if the associated Range object is locked as it is displayed in the current user interface.

bool Locked { get; }

Property Value

bool

MergeCells

Gets a value that indicates if the associated Range object contains merged cells as it is displayed in the current user interface.

bool MergeCells { get; }

Property Value

bool

NumberFormat

Gets a value that represents the format code of the associated Range object as it is displayed in the current user interface.

string NumberFormat { get; }

Property Value

string

Orientation

Gets a value that represents the text orientation of the associated Range object as it is displayed in the current user interface.

int Orientation { get; }

Property Value

int

ReadingOrder

Gets the reading order of the associated Range object as it is displayed in the current user interface.

ReadingOrder ReadingOrder { get; }

Property Value

ReadingOrder

ShrinkToFit

Gets a value that indicates if the application automatically shrinks text to fit in the available column width of the associated Range object as it is displayed in the current user interface.

bool ShrinkToFit { get; }

Property Value

bool

Style

Gets a value, containing a Style object, that represents the style of the associated Range object as it is displayed in the current user interface.

IStyle Style { get; }

Property Value

IStyle

VerticalAlignment

Gets a value that represents the vertical alignment of the associated Range object as it is displayed in the current user interface.

VerticalAlignment VerticalAlignment { get; }

Property Value

VerticalAlignment

WrapText

Gets a value that indicates if the application wraps the text of the associated Range object as it is displayed in the current user interface.

bool WrapText { get; }

Property Value

bool