RangeExtensions.ClearComments(Range) Method

Removes cell comments.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

public static void ClearComments(
    this Range range
)

VB.NET

<ExtensionAttribute>
Public Shared Sub ClearComments(
    range As Range
)

Parameters

Name	Type	Description
range	Range	A Range object specifying the cell range to clear.

Remarks

The ClearComments method removes cell comments only. Cell content, formatting and hyperlinks remain unchanged. This is an extension method of the Range object that is called by using the instance method syntax.

Another way to delete comments from cells is to use the CommentCollection.Remove or CommentCollection.RemoveAt method of the Worksheet.Comments collection.

To separately remove cell content, formatting, hyperlinks or clear a cell range completely, call the RangeExtensions.ClearContents, RangeExtensions.ClearFormats, RangeExtensions.ClearHyperlinks or RangeExtensions.Clear method, respectively. To delete entire cells from the worksheet, use the RangeExtensions.Delete method.

To clear cells, you can also use the Clear* methods of the Worksheet object (see the How to: Clear Cells of Content, Formatting, Hyperlinks and Comments example).