API Reference
Enum
ExcelClearOptions
Selects which cell parts are cleared by ExcelClearOptions).
Inheritance
- Enum
- ExcelClearOptions
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Field ExcelClearOptions.All
- Field ExcelClearOptions.Comments
- Field ExcelClearOptions.ConditionalFormatting
- Field ExcelClearOptions.DataValidations
- Field ExcelClearOptions.Formulas
- Field ExcelClearOptions.Hyperlinks
- Field ExcelClearOptions.Merges
- Field ExcelClearOptions.None
- Field ExcelClearOptions.Sparklines
- Field ExcelClearOptions.Styles
- Field ExcelClearOptions.Values
Accepted by parameters
- Method ExcelCell.Clear
- Method ExcelRange.Clear
- Method ExcelSheet.ClearRange
Inherited Methods
public override sealed Int32 CompareTo(Object target) #Returns:
Int32Inherited from Enum
Parameters
- target Object
public override sealed String ToString(String format, IFormatProvider provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format String
Values
public const ExcelClearOptions Comments #Clear comments in the selected cells when supported.
Value:
8public const ExcelClearOptions DataValidations #Clear data validation rules that overlap the range.
Value:
32public const ExcelClearOptions ConditionalFormatting #Clear conditional formatting rules that overlap the range.
Value:
64public const ExcelClearOptions Merges #Clear merged-cell definitions that overlap the range.
Value:
128public const ExcelClearOptions Sparklines #Clear sparklines whose target cells overlap the range.
Value:
256