IRange Interface Methods

Spread.Services Documentation
IRange Interface Methods
Collapse All Expand All Members Options: Show All Members Options: Filtered
Include Inherited Members

GrapeCity.Documents.Spread Namespace : IRange Interface

For a list of all members of this type, see IRange members.

Public Methods

| Name | Description
--- | --- | ---
| Activate | Activates a single cell, which must be inside the current selection.
| AddComment | Adds comments to the current IRange.
| AutoFilter | Filters a list using the AutoFilter.
| Calculate | Calculates formulas of the range as needed.
| Clear | Clears formulas, values, and all formatting from the current IRange.
| ClearComments | Clears the comments from the current IRange
| ClearContents | Clears formulas and values from the current IRange.
| ClearFormats | Clears all formatting from the current IRange.
| ClearHyperlinks | Clears all hyperLinks from the current IRange.
| ClearOutline | Clears the outline for the specified range.
| Copy | Copies the range to the specified range.
| Cut | Cuts the range to the specified range.
| Delete | Deletes a cell or a range of cells from the worksheet and shifts other cells to replace deleted cells. Specifies which way to shift the cells.
| Dirty | Designates all the formulas of the range to be recalculated when the next calculation occurs.
| Group | Increments the OutlineLevel of the specified rows or columns.
| Insert | Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space. Specifies which way to shift the cells.
| Merge | Merges the cells in the represented range into a single merged cell.
| Select | Selects the object.
| Sort | Overloaded. Sorts the cells represented by this range according to the specified options.
| Ungroup | Decrements the OutlineLevel of the specified rows or columns.
| UnMerge | Converts merged cells in the represented range to normal cells.

Top
See Also

#### Reference

IRange Interface
GrapeCity.Documents.Spread Namespace

Copyright © GrapeCity, inc. All rights reserved.

Send Feedback