WorksheetCellFormatOptions Enumeration

Flagged enumeration which indicates which groups of formatting properties are used in a format.

Syntax

Visual Basic

'Declaration
 
Public Enum WorksheetCellFormatOptions 
   Inherits System.Enum

C#

public enum WorksheetCellFormatOptions : System.Enum 

Members

Member	Description
All	All properties are used on the format.
ApplyAlignmentFormatting	The IWorksheetCellFormat.Alignment, IWorksheetCellFormat.Indent, IWorksheetCellFormat.Rotation, IWorksheetCellFormat.ShrinkToFit, IWorksheetCellFormat.VerticalAlignment, and IWorksheetCellFormat.WrapText properties are used on the format.
ApplyBorderFormatting	The BottomBorderColorInfo, BottomBorderStyle, DiagonalBorderColorInfo, IWorksheetCellFormat.DiagonalBorders, DiagonalBorderStyle, LeftBorderColorInfo, LeftBorderStyle, RightBorderColorInfo, RightBorderStyle, TopBorderColorInfo, and TopBorderStyle properties are used on the format.
ApplyFillFormatting	The IWorksheetCellFormat.Fill property is used on the format.
ApplyFontFormatting	The IWorksheetCellFormat.Font property is used on the format.
ApplyNumberFormatting	The IWorksheetCellFormat.FormatString property is used on the format.
ApplyProtectionFormatting	The IWorksheetCellFormat.Locked property is used on the format.
None	No format properties are used on the format.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2