ITabRange

Assembly: Tab.

Description

The ITabRange interface contains properties and methods that are used to work with table cells and cell ranges.

Inheritance Hierarchy

ITabRange

Comments

Cell ranges are used to set up parameters of data areas, formula areas, charts, maps, and to set up visual formatting for tables of various repository objects and development environment components.

To get cell range, use the following properties and methods:

Properties

  Property name Brief description
Address The Address property returns cell range address as a string.

AppliedFormatConditions

The AppliedFormatConditions property returns a list of formatting conditions that are applied for a cell or cell range.

Bottom The Bottom property returns the index of the bottom row of the range.
ColumnPixelWidth The ColumnPixelWidth property determines the width of range columns in pixels.
ColumnWidth The ColumnWidth property determines the width of range columns in millimeters.
Count The Count property returns the number of cells in the range.
DistinctCells The DistinctCells property returns the composite range, which does not contain overlapping parts.
EntireColumns The EntireColumn property returns the range consisting only of the columns included in the current range.
EntireRows The EntireRows property returns the range consisting only of the rows included in the current range.
Footnotes The Footnotes property returns the collection of footnotes in the current range.
FormatConditions The FormatConditions property returns the object containing the collection of cell conditional formats.
FormattedText The FormattedText property returns the cell value taking into account predefined data view format.
Formula The Formula property determines the formula of the cell range but returns the formula of one cell only.
Height The Height property returns range height in millimeters.
Hidden The Hidden property determines visibility of rows or columns depending on usage.
IsCell The IsCell property returns whether the range consists of a single cell.
IsColumn The IsColumn property returns the value that is used to define whether the range is a single column.
IsRow The IsRow property returns the value that is used to define whether the range is a single row.
IsRtfText The IsRtfText property determines whether formatting and text are stored in RTF format.
Item The Item property is not yet implemented.
Left The Left property returns the index of the leftmost column of the range.
Location The Location property returns the top left point of the range.
Merged The Merged property returns the value that is used to define whether the range is a merged one.
Part The Part property returns a part of the range, which index is passed as an input parameter.
PartCount The PartCount property returns the number of parts in the range.
PixelLocation The PixelLocation property returns the upper left point of the range in pixels obtained taken into account pixel resizing of rows and columns.
Prefix The Prefix property determines a table cell prefix.
RealColumnWidth The RealColumnWidth property returns the real width of hidden columns.
RealRowHeight The RealRowHeight property returns the actual height of hidden rows.
Right The Right property returns the index of the rightmost column of the range.
RowHeight The RowHeight property determines the height of range rows in millimeters.
RowPixelHeight The RowPixelHeight property determines the height of range rows in pixels.
Style The Style property determines the style of the range cells to be displayed.
StyleForDraw The StyleForDraw property returns the cell style that takes into account overlapping of other ranges' styles.
StyleIndex The StyleIndex property sets a style from the collection of styles.
Suffix The Suffix property determines a table cell suffix.
TabSheet The TabSheet property returns the table containing this range.
Text The Text property determines a cell range text.
Top The Top property returns the index of the top row of the range.
Type The Type property returns range type.
Value The Value property determines a cell range value.
Width The Width property returns range width in millimeters.

Methods

  Method name Brief description
AdjustHeight The AdjustHeight method automatically adjusts height of range cells to fit cells' contents.
AdjustHeightEx

The AdjustHeightEx method automatically adjusts height of range rows to fit cells' contents if the custom size is not set.

AdjustWidth The AdjustWidth method automatically adjusts width of range columns to fit cells' contents.
AutoFill The AutoFill method automatically fills the specified range based on data of the current range.
CenterAtView The CenterAtView method scrolls the table in such a way that the selected range is in the center of the table.
Clear The Clear method clears all the data and formatting of the cell range.
ClearContent The ClearContent method clears all the data of the range, preserving formatting of the range.
ClearFormat The ClearFormat method clears range formatting preserving range data.
ClearPart The ClearPart method clears the selected elements of the cell range.
Combine The Combine method changes the current range.
Clone The Clone method creates a copy of the cell range.
Copy The Copy method copies the range data to clipboard.
CopyToStream The CopyToStream method copies range data to the specified stream.
CreateIterator The CreateIterator method creates an iterator that is used to navigate the table cells containing values.
Cut The Cut method cuts the range data to clipboard.
Delete The Delete method deletes the set cell range.
DependenceCells The DependenceCells method finds cells, which determine the selected cell.
DependentCells The DependentCells method finds cells that depend on this cell.
Expand The Expand method expands the size of the current range to the size of the merged range, in which it is included.
ExtendToAdjacentCells The ExtendToAdjacentCells method returns the range of cells obtained by extending the current one to adjacent non-empty cells.
Insert The Insert method inserts the cell range.
FillDown The FillDown method fills all the range with values from the first row of the range.
FillLeft The FillLeft method fills all the range with values from the last column of the range.
FillRight The FillRight method fills all the range with values from the first column of the range.
FillUp The FillUp method fills all the range with values from the last row of the range.
Merge The Merge method merges all range cells in one cell.
Offset The Offset method returns the cell range shifted according to the defined parameters.
ParseValue The ParseValue method converts value of the specified row according to its type and sets this value for the range.
Paste The Paste method pastes data from clipboard to the current cell range.
PasteFromStream The PasteFromStream method pastes data from the specified stream to the current range.
PasteFromStreamEx The PasteFromStreamEx method inserts data from the specified stream to the current range according to the set insert parameters.
Recalc The Recalc method calculates data in the current range.
SortColumns The SortColumns method sorts the column range depending on the values contained in the row with the RowIndex index.
SortRows The SortRows method sorts the row range depending on the values contained the column with the ColumnIndex index.
ToArray The ToArray method creates a two-dimension array.
ToDouble2DArray The ToDouble2DArray method transforms range into two dimension array of real numbers.
ToDoubleArray The ToDoubleArray method converts a range into a real array.
ToDoubleArrayEx The ToDoubleArrayEx method transforms the range into integer array with the ability to apply additional transformation parameters.
ToIntegerArray The ToIntegerArray method converts a range into an integer array.
Unmerge The Unmerge method unmerges range cells.

See also:

Tab Assembly Interfaces