DisplayFormat DisplayFormat DisplayFormat Interface

Definition

Represents the display settings for an associated Range object.

public interface class DisplayFormat
[System.Runtime.InteropServices.Guid("000244C2-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface DisplayFormat
Public Interface DisplayFormat
Attributes

Remarks

Read-only.

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.

Properties

AddIndent AddIndent AddIndent

Gets a value that indicates if Microsoft Excel 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.

Application Application Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object.

Borders Borders Borders

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

Characters[Object, Object] Characters[Object, Object] Characters[Object, Object]

Gets a Characters object that represents a range of characters within the text of the associated Range object as it is displayed in the current user interface.

Creator Creator Creator

Gets a 32-bit integer that indicates the application in which this object was created.

Font Font Font

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

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

HorizontalAlignment HorizontalAlignment HorizontalAlignment

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

IndentLevel IndentLevel IndentLevel

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

Interior Interior Interior

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

Locked Locked Locked

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

MergeCells MergeCells MergeCells

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

NumberFormat NumberFormat NumberFormat

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

NumberFormatLocal NumberFormatLocal NumberFormatLocal

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

Orientation Orientation Orientation

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

Parent Parent Parent

Gets the parent object for the specified object.

ReadingOrder ReadingOrder ReadingOrder

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

ShrinkToFit ShrinkToFit ShrinkToFit

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

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

VerticalAlignment VerticalAlignment VerticalAlignment

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

WrapText WrapText WrapText

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

Applies to