Assembly: Tab.
The ITabRange interface contains properties and methods that are used to work with table cells and cell ranges.
ITabRange
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:
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. |
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: