Click or drag to resize
AbstractRange Class
Base class for classes representing one or more excel cells.
Inheritance Hierarchy

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1018
Syntax
public abstract class AbstractRange

The AbstractRange type exposes the following members.

Properties
  NameDescription
Public propertyComment
Gets or sets comment.
Public propertyFormula
Gets or sets formula string.
Public propertyHyperlink
Gets or sets hyperlink.
Public propertyName
Gets the name of AbstractRange instance.
Public propertyCode exampleStyle
Gets or sets the cell formatting of one or more cells.
Public propertyValue
Gets or sets cell value on one or more excel cells.
Top
Methods
  NameDescription
Public methodCalculate
Calculates formula for one or more excel cells.
Public methodClear
Clears the range (content, formatting, comment, hyperlink or all).
Public methodGetCharacters(Int32)
Returns a FormattedCharacterRange object that represents a range of characters within the cell text. The range starts at a specified character position. Supported in XLSX only.
Public methodGetCharacters(Int32, Int32)
Returns a FormattedCharacterRange object that represents a range of characters within the cell text. The range starts at a specified character position and has a specified length. Supported in XLSX only.
Public methodReplaceText(String, String)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
Public methodReplaceText(String, String, Boolean)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
Public methodReplaceText(String, String, Boolean, Boolean)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
Public methodToString
Returns a String that represents this AbstractRange instance.
(Overrides ObjectToString.)
Top
See Also