[]
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
Public Interface IDisplayFormat
Name | Description |
---|---|
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. |
Borders | Gets a Borders object that represents the borders of the associated Range object as it is displayed in the current user interface. |
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. |
Orientation | Gets a value that represents the text orientation of the associated Range object as it is displayed in the current user interface. |
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 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. |
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 the application wraps the text of the associated Range object as it is displayed in the current user interface. |