NamedRange Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Represents a named range in the worksheet.

public sealed class NamedRange
Public NotInheritable Class NamedRange
Inheritance:
System.Object
NamedRange

Properties

GlobalName

gets global flag

public bool GlobalName { get; }
Public ReadOnly Property GlobalName As Boolean
Property Value
System.Boolean

if this name is global

Name

Gets the named range name.

public string Name { get; }
Public ReadOnly Property Name As String
Property Value
System.String

The named range name.

Range

Gets or sets the named cell range.

public CellRange Range { get; set; }
Public Property Range As CellRange
Property Value
CellRange

The named cell range.

Methods

Delete()

Deletes this named range from the named ranges collection.

public void Delete()
Public Sub Delete

Equals(Object)

Determines whether the specified System.Object is equal to this NamedRange instance.

public override bool Equals(object obj)
Public Overrides Function Equals(obj As Object) As Boolean
Parameters
obj
System.Object

The System.Object to compare with this NamedRange instance.

Returns
System.Boolean

true if the specified System.Object is a NamedRange and is equal to this NamedRange instance; otherwise, false.

Overrides
System.Object.Equals(System.Object)

GetHashCode()

Returns a hash code for this NamedRange instance.

public override int GetHashCode()
Public Overrides Function GetHashCode As Integer
Returns
System.Int32

An integer value that specifies a hash value for this NamedRange instance.

Overrides
System.Object.GetHashCode()

ToString()

Returns a System.String that represents this NamedRange instance.

public override string ToString()
Public Overrides Function ToString As String
Returns
System.String

A System.String that represents this NamedRange instance.

Overrides
System.Object.ToString()
Remarks

This method should be used primarily for debugging purposes and should be considered volatile (format of its return value might change in future versions).

Operators

Equality(NamedRange, NamedRange)

Determines whether first and second NamedRanges are equal.

public static bool operator ==(NamedRange first, NamedRange second)
Public Shared Operator =(first As NamedRange, second As NamedRange) As Boolean
Parameters
first
NamedRange

The first NamedRange.

second
NamedRange

The second NamedRange.

Returns
System.Boolean

true if first and second NamedRanges are equal; otherwise, false.

Inequality(NamedRange, NamedRange)

Determines whether first and second NamedRanges are not equal.

public static bool operator !=(NamedRange first, NamedRange second)
Public Shared Operator <>(first As NamedRange, second As NamedRange) As Boolean
Parameters
first
NamedRange

The first NamedRange.

second
NamedRange

The second NamedRange.

Returns
System.Boolean

true if first and second NamedRanges are not equal; otherwise, false.