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.1091
Syntax
public abstract class AbstractRange

The AbstractRange type exposes the following members.

Properties
  NameDescription
Public propertyCharacterRanges
Returns all FormattedCharacterRange objects that represents a range of characters within the cell text.
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. Not supported in ODS and XLS.
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. Not supported in ODS and XLS.
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