| | 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.
|
| 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).
|
| 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. |
| 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 IRange is part of a merged cell range,
otherwise the original IRange is returned.
|
| MergeCells |
Gets or sets the property which specifies whether cells are merged.
|
| MergeCellsDefined |
Returns true if the MergeCells property of all cells represented
by this IRange is the same, 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.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.
|
Public Properties