Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ClearOptions Enumeration


In This Topic
    ClearOptions Enumeration
    In This Topic
    Contains the options that determine what will be cleared when one of the Clear methods is used on a Row, ColumnWorksheet or Range.
    Syntax
    'Declaration
     
    
    Public Enum ClearOptions 
       Inherits System.Enum
    'Usage
     
    
    Dim instance As ClearOptions
    public enum ClearOptions : System.Enum 
    Members
    MemberValueDescription
    All15This option will clear everything, meaning all the content, the Formulas, the Styles, the Hyperlinks and the Annotations.
    Annotations8This option will clear only the Annotations.
    Contents1This options will clear the content as well as the Formulas.
    Hyperlinks4This option will clear the Hyperlinks but the rest of the content will remain in place.
    Styles2This option will clear only the Styles.
    Inheritance Hierarchy

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

    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also