Edit

Share via


CellFormat Interface

Definition

Represents the search criteria for the cell format.

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

Remarks

Use the FindFormat or ReplaceFormat properties of the Application object to return a CellFormat object.

You can use the Borders, Font, or Interior properties of the CellFormat object to define the search criteria for the cell format.

Properties

AddIndent

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

Application

Returns an Application object that represents the Microsoft Excel application.

Borders

Allows the user to set or return the search criteria based on the cell's border format.

Creator

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

Font

Returns a Font object, allowing the user to set or return the search criteria based on the cell's font format.

FormulaHidden

True if the formula will be hidden when the worksheet is protected. Returns Null if the specified range contains some cells with FormulaHidden equal to True and some cells with FormulaHidden equal to False.

HorizontalAlignment

Returns or sets the horizontal alignment for the specified object.

IndentLevel

Returns or sets the indent level for the cell or range. Can be an integer from 0 to 15.

Interior

Returns an Interior object allowing the user to set or return the search criteria based on the cell's interior format.

Locked

True if the object is locked; False if the object can be modified when the sheet is protected. Returns Null if the specified range contains both locked and unlocked cells.

MergeCells

True if the range or style contains merged cells.

NumberFormat

Returns or sets the format code for the object. Returns Null if all cells in the specified range don't have the same number format.

NumberFormatLocal

Returns or sets the format code for the object as a string in the language of the user.

Orientation

The text orientation. Can be an integer value from –90 to 90 degrees.

Parent

Returns the parent object for the specified object.

ShrinkToFit

True if text automatically shrinks to fit in the available column width. Returns Null if this property isn’t set to the same value for all cells in the specified range.

VerticalAlignment

Returns or sets the vertical alignment of the specified object.

WrapText

True if Microsoft Excel wraps the text in the object. Returns Null if the specified range contains some cells that wrap text and other cells that don’t.

Methods

Clear()

Clears the criteria set in the FindFormat and ReplaceFormat properties.

Applies to