ClearOptions Enumeration

Contains the options that determine what will be cleared when one of the Clear methods is used on a Row, Column, Worksheet or Range.

Syntax

Visual Basic
C#

'Declaration

 

Public Enum ClearOptions 

   Inherits System.Enum

'Usage

 

Dim instance As ClearOptions

public enum ClearOptions : System.Enum

Members

Member	Description
All	This option will clear everything, meaning all the content, the Formulas, the Styles, the Hyperlinks and the Annotations.
Annotations	This option will clear only the Annotations.
Contents	This options will clear the content as well as the Formulas.
Hyperlinks	This option will clear the Hyperlinks but the rest of the content will remain in place.
Styles	This option will clear only the Styles.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Xceed.Workbooks.NET.ClearOptions

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, 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

Reference

Xceed.Workbooks.NET Namespace