編輯

共用方式為


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

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

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

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]

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

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

Font

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

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

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

IndentLevel

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

Interior

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

Locked

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

MergeCells

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

NumberFormat

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

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

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

Parent

Gets the parent object for the specified object.

ReadingOrder

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

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

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

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

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