API Reference
Enum
ExcelClearOptions
Selects which cell parts are cleared by ExcelRange.Clear.
Inheritance
- Enum
- ExcelClearOptions
Usage
Explore 14 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 11
- 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 3
- Method ExcelCell.Clear
- Method ExcelRange.Clear
- Method ExcelSheet.ClearRange
Inherited Methods
public override Boolean Equals(Object? obj) #Returns:
BooleanInherited from Enum
Parameters
- obj Object?
ToString 4 overloads
public String ToString(IFormatProvider? provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString() instead.")Parameters
- provider IFormatProvider?
public String ToString(String? format, IFormatProvider? provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format String?
- provider IFormatProvider?
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