IRange Interface Members

The following tables list the members exposed by IRange.

Public Properties

	Name	Description
	AddIndent	Gets or sets the property which controls indentation of text when horizontal or vertical alignment is set to distributed.
	AddIndentDefined	Returns true if the AddIndent property of all cells represented by this IRange is the same, otherwise false is returned.
	Address	Returns the cell or range address of the cells represented by this IRange using ReferenceStyle.A1.
	AllowEdit	Returns true if all of the cells represented by a range may be edited.
	AreaCount	Returns the number of areas in this IRange.
	Areas	Returns an instance of IAreas which represents an array of IRanges where each IRange returned by IAreas represents one cell or range.
	Borders	Returns an instance of IBorders which represents the cell borders of the cell or range represented by this IRange.
	CellCount	Returns the number of cells represented by this range.
	Cells	Returns the cells represented by this instance of IRange.
	Column	Returns the zero based column number of the first column of this IRange.
	ColumnCount	Returns the number of columns in this IRange.
	Columns	Returns a new instance of IRange which represents the same range of cells but which may be used to determine the number of columns in the range or to AutoFit the columns in the range.
	ColumnWidth	Gets or sets the width of the individual columns represented this range in characters.
	ColumnWidthDefined	Returns true if the ColumnWidth property of all columns represented by this IRange is the same, otherwise false is returned.
	Comment	Returns an instance of IComment representing the comment which is associated the single cell represented by this range, or null if there is no comment.
	Count	Deprecated - use CellCount, RowCount or ColumnCount.
	CurrentArray	Returns the range of cells containing the array formula of the top-left cell of this IRange, or null if the top-left cell is not an array formula.
	CurrentRegion	Returns an expanded range of contiguous non-empty cells.
	EndDown	Returns a single cell at the end of the current contiguous non-empty range, or at the start of the next non-empty range, starting with the top-left cell of this range.
	EndLeft	Returns a single cell at the start of the current contiguous non-empty range, or at the end of the previous non-empty range, starting with the top-left cell of this range.
	EndRight	Returns a single cell at the end of the current contiguous non-empty range, or at the start of the next non-empty range, starting with the top-left cell of this range.
	EndUp	Returns a single cell at the start of the current contiguous non-empty range, or at the end of the previous non-empty range, starting with the top-left cell of this range.
	EntireColumn	Returns a new instance of IRange which represents the same range of cells, but expanded to include all rows.
	EntireMergeArea	Returns an IRange representing the area of the current IRange which is iteratively grown as needed until it includes no partial merged cells.
	EntireRow	Returns a new instance of IRange which represents the same range of cells, but expanded to include all columns.
	Entry	Returns the text which is displayed in the workbook view's formula bar.
	Font	Returns an instance of IFont which may be used to get and set font properties of the cells represented by this IRange.
	FormatConditions	Returns a collection which represents the conditional formatting options of this range.
	FormatConditionsDefined	Returns true if the conditional formatting options of all cells represented by this IRange are the same, otherwise false is returned.
	Formula	Gets the formula, or sets the value or formula, of the cells represented by this IRange.
	FormulaArray	Gets or sets the array formula for a range.
	FormulaHidden	Gets or sets the property which specifies whether formulas should be hidden.
	FormulaHiddenDefined	Returns true if the FormulaHidden property of all cells represented by this IRange is the same, otherwise false is returned.
	FormulaR1C1	Gets or sets the value or formula of the cells represented by this IRange using ReferenceStyle.R1C1.
	HasArray	Returns true if the cell or range contains any array formulas, otherwise false is returned.
	HasArrayDefined	Returns true if the HasArray property of all cells represented by this IRange is the same, otherwise false is returned.
	HasFormula	Returns true if the cell or range contains any formulas, otherwise false is returned.
	HasFormulaDefined	Returns true if the HasFormula property of all cells represented by this IRange is the same, otherwise false is returned.
	HasValidation	Returns true if any of the cells represented by this range have data validation associated with them.
	Height	Returns the height of the range in points.
	Hidden	Gets or sets the property which specifies whether rows or columns should be hidden.
	HorizontalAlignment	Gets or sets the horizontal alignment of a cell or range.
	HorizontalAlignmentDefined	Returns true if the HorizontalAlignment property of all cells represented by this IRange is the same, otherwise false is returned.
	Hyperlinks	Returns a hyperlink collection representing the hyperlinks which are attached to this range.
	IndentLevel	Gets or sets the indent level of the specified cell(s).
	Interior	Returns the IInterior which represents the interior (background) color and pattern of the specified cell(s).
	IsDisposed	Returns `true` if the worksheet referred to by this range has been disposed.
	IsEntireColumns	Returns true if the current range represents one or more entire columns.
	IsEntireRows	Returns true if the current range represents one or more entire rows.
	IsVolatileOrCircularFormula	Returns true if the single cell range is, or depends on, a volatile function or circular reference.
	Item	Overloaded. Returns a new instance of IRange which is offset from this IRange.
	Locked	Gets or sets the property which specifies whether cells should be locked.
	LockedDefined	Returns true if the Locked property of all cells represented by this IRange is the same, otherwise false is returned.
	MergeArea	Returns an IRange representing the merged cell area if the cell represented by this single cell IRange is part of a merged cell range, otherwise the original IRange is returned.
	MergeCells	Gets or sets the property which specifies whether the top left cell of this IRange is merged.
	MergeCellsDefined	Returns true if the MergeCells property of all cells represented by this IRange is false or if all cells represented by this IRange are contained by the same merged cell area, otherwise false is returned.
	Name	Returns the first defined name which refers to the cells represented by this range, or null if no defined name refers to the range.
	NumberFormat	Gets or sets the number format of the cells in the range.
	NumberFormatDefined	Returns true if the NumberFormat property of all cells represented by this IRange is the same, otherwise false is returned.
	NumberFormatType	Returns the number format type of the top-left cell of this range.
	Orientation	Gets or sets the text orientation of a cell or range, which may be from -90 to 90 degrees or SpreadsheetGear.Orientation.Vertical.
	OrientationDefined	Returns true if the Orientation property of all cells represented by this IRange is the same, otherwise false is returned.
	OutlineLevel	Gets or sets the outline level of a range of rows or columns, which provides the ability to group and summarize information.
	OutlineLevelDefined	Returns true if the OutlineLevel property of all rows or columns represented by this IRange is the same, otherwise false is returned.
	PageBreak	Adds or removes manual page breaks for a range.
	PrefixCharacter	Returns '\'' if text was entered into a cell with a leading apostrophe, otherwise '\0' is returned.
	PrefixCharacterDefined	Returns true if the PrefixCharacter property of all cells represented by this IRange is the same, otherwise false is returned.
	Range	Returns the cells represented by this instance of IRange.
	Row	Returns the zero based row number of the first row.
	RowCount	Returns the number of rows in this IRange.
	RowHeight	Gets or sets the height of the individual rows represented by this range in points.
	RowHeightDefined	Returns true if the RowHeight property of all rows represented by this IRange is the same, otherwise false is returned.
	Rows	Returns a new instance of IRange which represents the same range of cells but which may be used to determine the number of rows in the range or to AutoFit the rows in the range.
	ShowDetail	Gets or sets the property which specifies whether the detail corrresponding to the outline level of the represented row or column will be shown (expanded) or hidden (collapsed).
	ShrinkToFit	Gets or sets the property which specifies whether cells will be drawn in a smaller font if needed to display the contents of the cell.
	ShrinkToFitDefined	Returns true if the ShrinkToFit property of all cells represented by this IRange is the same, otherwise false is returned.
	Style	Gets or sets the named cell style associated with the cells represented by this IRange.
	StyleDefined	Returns true if the Style property of all cells represented by this IRange is the same, otherwise false is returned.
	Text	Returns the value of the cell represented by this IRange as a formatted string.
	Validation	Returns an instance of IValidation which may be used to get and set validation properties of the cells represented by this IRange.
	ValidationDefined	Returns true if the validation options of all cells represented by this IRange are the same, otherwise false is returned.
	Value	Gets the value of the specified range as a System.String, System.Double, System.Boolean, SpreadsheetGear.ValueError, object[,] or null; or sets the value of the specified cell as a System.String, System.Double, System.Int32, System.Int64, System.Int16, System.Char, System.Boolean, System.DateTime, SpreadsheetGear.ValueError, System.Decimal, System.DBNull, object[,] or null.
	ValueType	Returns the value type of the top-left cell of this range.
	VerticalAlignment	Gets or sets the vertical alignment of a cell or range.
	VerticalAlignmentDefined	Returns true if the VerticalAlignment property of all cells represented by this IRange is the same, otherwise false is returned.
	Width	Returns the width of the range in points.
	WorkbookSet	Returns the parent IWorkbookSet of this range.
	Worksheet	Returns the parent IWorksheet of this range.
	WrapText	Get or sets the flag which indicates whether word wrap is enabled in a cell.
	WrapTextDefined	Returns true if the WrapText property of all cells represented by this IRange is the same, otherwise false is returned.

Top

Public Methods

	Name	Description
	Activate	Sets the active cell of the worksheet associated with this IRange to the top-left cell of this IRange.
	AddComment	Adds a single comment with the specified text to the single cell represented by this range.
	AutoFill	Automatically fills the destination range given the starting values from this range and the specified AutoFillType.
	AutoFilter	Overloaded. Adds autofilter dropdowns to the columns of the specified range if none exist, or removes autofilter dropdowns if they do exist.
	AutoFit	Automatically sets the width of the specified columns or the height of the specified rows.
	Clear	Clears formulas, values and all formatting from the current IRange.
	ClearComments	Clears all comments associated with any cells in this range.
	ClearContents	Clears formulas and values from the current IRange.
	ClearFormats	Clears all formatting from the current IRange.
	ClearOutline	Clears the specified represented row or column outline levels, or all outline levels of the associated worksheet if this range does not represent rows or columns.
	Copy	Overloaded. Copies the cells, rows and/or columns of the current IRange to the destination IRange.
	CopyDown	Copies values, formulas and formats in the top row of the range to subsequent rows.
	CopyFromDataTable	Copies the specified DataTable to this range.
	CopyRight	Copies values, formulas and formats in the left column of the range to subsequent columns.
	DataSeries	Fill this range with a data series based on the specified type and options.
	Delete	Overloaded. Deletes cells, rows or columns, shifting remaining cells left or up and fixing up formulas.
	FillDown	Copies from the top row of this range to the remaining rows.
	FillLeft	Copies from the right column of this range to the preceding columns.
	FillRight	Copies from the left column of this range to the remaining columns.
	FillUp	Copies from the bottom row of this range to the preceding rows.
	Find	Searches for the specified text according to the specified options, and returns an IRange representing the found cell or null if no cell is found.
	GetAddress	Returns a string representing the address of the range.
	GetArea	Returns the zero based instance of IRange specified by index.
	GetCharacters	Returns an instance of ICharacters which represents a range of characters belonging to a text cell.
	GetDataSet	Returns a newly created data set from the cells referred to by this IRange.
	GetDataTable	Returns a newly created data table from the cells referred to by this IRange.
	GetEnumerator	(Inherited from System.Collections.IEnumerable)
	GoalSeek	Attempts to achieve the specified goal, from the calculated result of the formula in the cell represented by this IRange, by modifying the specified changingCell using a simple iterative linear search.
	Group	Increments the OutlineLevel of the specified rows or columns.
	Insert	Overloaded. Inserts rows or columns by shifting rows down or columns right and fixing up formulas and formats.
	Intersect	Returns a new range which consists of the intersection of this range and range2, or null if the ranges do not intersect.
	Merge	Merges the cells in the represented range into a single merged cell.
	Offset	Returns a copy of the current IRange which is offset by the specified number of rows and columns.
	Replace	Attempts to replace the specified text according to the specified options, returning the number of replacements if successful or zero if not successful.
	SaveAs	Saves this range using the specified filename and FileFormat, and updates the FullName property.
	SaveToMemory	Saves this range to a newly created memory buffer in the specified FileFormat.
	SaveToStream	Saves this range to a stream in the specified FileFormat.
	Select	Sets the current selection of the worksheet associated with the this range to the cells in this range.
	Sort	Sorts the cells represented by this range according to the specified options.
	Subtract	Returns a new range which consists of this range with range2 removed, or null if the resulting range is empty.
	Table	Sets up this range as a data table calculation range with the specified row input cell, column input cell or both.
	Ungroup	Decrements the OutlineLevel of the specified rows or columns.
	Union	Returns a new range which consists of the union of this range and range2.
	UnMerge	Converts merged cells in the represented range to normal cells.

Top

Reference

IRange Interface
SpreadsheetGear Namespace
Cells Property