Spread Windows Forms 12.0 Product Documentation
IRange Interface Members
Properties  Methods 

GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace : IRange Interface

The following tables list the members exposed by IRange.

Public Properties
 NameDescription
 PropertyGets a value indicating whether the range can be edited on a protected worksheet.  
 PropertyGets an IAreas collection that represents all the ranges in a multiple-area selection.  
 PropertyGets the IBorders object that represents the borders of the specified object.  
 PropertyGets a IRange object that represents the cells in the specified range.  
 PropertyGets the zero based column number of the first column of this Range.  
 PropertyGets the zero based column number of the last column of this Range.  
 PropertyGets the number of columns in this Range.  
 PropertyGets a new instance of IRange which represents all columns belong to this IRange.  
 PropertyGets or sets the width of the column.  
 PropertyGet an integer value that represents the number of cells in the range.  
 PropertyGets an IRange object that represents the entire array if the specified cell is part of an array.  
 PropertyReturns a Range object that represents the range containing all the dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent.  
 PropertyReturns a Range object that represents the range containing all the direct dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent.  
 PropertyReturns a Range object that represents the range containing all the direct precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent.  
 PropertyGets a DisplayFormat object that represents the display settings for the specified range.  
 PropertyGets a IRange object that represents the entire column (or columns) that contains the specified range.  
 PropertyGets a IRange object that represents the entire row (or rows) that contains the specified range.  
 PropertyGets the IFont object that represents the font of the specified object.  
 PropertyGets all format conditions of this IRange.  
 PropertyGets or sets the cell value(s).  
 PropertyGets or sets the formula, which will implicitly intersect as required when set, for this IRange.  
 PropertyGets or sets the formula for this IRange.  
 PropertyGets or sets the formula using R1C1-style notation for this IRange.  
 PropertyGets or sets the array formula for this IRange.  
 PropertyGets or sets the formula using R1C1-style notation which will implicitly intersect as required when set, for this IRange.  
 PropertyGets a value indicating whether the specified cell is part of an array formula.  
 PropertyGets a value indicating whether all cells in the range contain formulas.  
 PropertyGets or sets a value indicating whether this IRange is hidden.  
 PropertyGets or sets the horizontal alignment.  
 PropertyGets or sets the indent level.  
 PropertyGets the IInterior object that represents the interior of the specified object.  
 PropertyOverloaded. Gets the IRange with the specified reference.  
 PropertyGets or sets a value indicating whether this IRange is locked.  
 PropertyReturns a Range object that represents the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell.  
 PropertyGets or sets a value indicating whether this range contains merged cells.  
 PropertyGets or sets the number format of current cell.  
 PropertyGets or sets the text orientation.  
 PropertyGets or sets the current outline level of the specified row or column.  
 PropertyGets or sets the location of a page break.  
 PropertyReturns a Range object that represents all the precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one precedent.  
 PropertyGets the zero based row number of the first row of this Range.  
 PropertyGets the zero based row number of the last row of this Range.  
 PropertyGets the number of rows in this Range.  
 PropertyGets or sets the height of the row.  
 PropertyGets a new instance of IRange which represents all rows belong to this IRange.  
 Propertytrue if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline.  
 PropertyGets or sets a value indicating whether text automatically shrinks to fit in the available column width.  
 PropertyGets or sets the style for the cell.  
 PropertyGets a value indicating whether the range is an outlining summary row or column.  
 PropertyGets or sets the text for the cell.  
 PropertyGets an instance of IValidation which may be used to get and set validation properties of the cells represented by this IRange.  
 PropertyGets or sets the cell value.  
 PropertyGets or sets the vertical alignment.  
 PropertyGets a Worksheet object that represents the worksheet containing the specified range.  
 PropertyGets or sets a value indicating whether Spread wraps the text in the object.  
Top
Public Methods
 NameDescription
 MethodActivates a single cell, which must be inside the current selection.  
 MethodOverloaded. Returns a System.String value that represents the range reference.  
 MethodApplies the number format to the range.  
 MethodOverloaded. Applies the named style to the range.  
 MethodOverloaded. Creates the automatic filter for current selection if the filter doesn't exist; otherwise, remove the filter.  
 MethodChanges the width of the columns or the height of the rows in the range to achieve the best fit.  
 MethodCalculates this range of cells on a worksheet.  
 MethodRemoves all the data and formulas from the specified range of cells.  
 MethodOverloaded. Copies the data from a range of cells to a specified range of cells.  
 MethodCreates the ITable at the specified cell range.  
 MethodOverloaded. Calculates the values necessary to achieve a specific goal.  
 MethodDemotes a range in an outline (that is, increases its outline level). The specified range must be a row or column, or a range of rows or columns.  
 MethodCreates a merged cell from the specified IRange object.  
 MethodOverloaded. Moves the data from a range of cells to the specified location.  
 MethodReturns a IRange object that represents a translated range from the specified range.  
 MethodGet an IRange object that represents a cell or a range of cells.  
 MethodSelect a cell or a range of cells.  
 MethodPromotes a range in an outline (that is, decreases its outline level). The specified range must be a row or column, or a range of rows or columns.  
 MethodSeparates a merged area into individual cells.  
Top
See Also

Reference

IRange Interface
GrapeCity.Spreadsheet Namespace