Assembly: Tab;
The ITabSheet interface contains properties and methods of a table.
ITabSheet
Tables are used in regular and express reports and are implemented by the following UiTabSheet development environment component and the following visual component TabSheetBox.
Property name | Brief description | |
BackgroundPicture | The BackgroundPicture property determines a background image of the entire table. | |
Cell | The Cell property returns the cell, which coordinates are passed as input parameters. | |
CellAddress | The CellAddress property returns the address of the cell, which coordinates are passed as input parameters. | |
CellComment | The CellComment property determines the cell comment. | |
CellHint | The CellHint property determines the tooltip for the specified cell. | |
CellPrefix | The CellPrefix property determines the table cell prefix. | |
Cells | The Cells property returns the cell range, which coordinates are passed as input parameters. | |
CellSuffix | The CellSuffix property determines a table cell suffix. | |
CellValue | The CellValue property sets the value of the cell, which coordinates are passed as input parameters. | |
Column | The Column returns the table column. | |
ColumnIndex | The ColumnIndex property returns the index of the table column, which name is passed as an input parameter. | |
ColumnName | The ColumnName property returns the address of the table column, which number is passed as an input parameter. | |
ColumnPixelWidth | The ColumnPixelWidth property determines the column width in pixels. | |
Columns | The Columns property returns the table columns range. | |
ColumnsCount | The ColumnsCount property determines the number of table columns. | |
ColumnWidth | The ColumnWidth property returns the column width in millimeters. | |
CustomSort | The CustomSort property determines parameters of configured sorting in a table using various sorting conditions. | |
DefaultHeight | The DefaultHeight property determines the default height of rows. | |
DefaultWidth | The DefaultWidth property determines the default width of columns. | |
EnableFormulas | The EnableFormulas property determines whether formulas are calculated in cells. | |
ErrorCheckingOptions | The ErrorCheckingOptions property returns parameters of error indicating in table formulas. | |
EventMask | The EventMask property determines, which event groups will be called for the table. | |
ExpanderKind | The ExpanderKind property returns expander type. | |
ExpanderLength | The ExpanderLength property returns the number of rows or columns affected by the expander. | |
ExpanderOffPicture | The ExpanderOffPicture property determines index of the icon corresponding to collapsed expander (). | |
ExpanderOnPicture | The ExpanderOnPicture property determines index of the icon corresponding to expanded expander (). | |
ExpanderState | The ExpanderState property determines the state of the expander in the cell, which coordinates are passed as input parameters. | |
Footnotes | The Footnotes property returns the collection of table footnotes. | |
FormatConditions | The FormatConditions property returns the collection of conditional formats applied to some table cell ranges. | |
FormulaCollection | The FormulaCollection property returns the table formula regions collection. | |
HyperlinkFont | The HyperlinkFont property determines parameters of hyperlinks formatting in table cells. | |
Images | The Images property returns the object containing table images collection. | |
MaxNotEmptyColumn | The MaxNotEmptyColumn property returns the maximum index of column that contains data. | |
MaxNotEmptyRow | The MaxNotEmptyRow property returns the maximum index of row that contains data. | |
MaxUsedColumn | The MaxUsedColumn property returns the maximum index of a used table column. | |
MaxUsedRow | The MaxUsedRow property returns the maximum index of a used table row. | |
Modified | The Modified property determines whether the table is modified. | |
Name | The Name property determines a spreadsheet name. | |
NamedRegions | The NamedRegions property allows to get access to table named regions. | |
Objects | The Objects property returns the collection of objects implemented in the ITabObjects interface. | |
Options | The Options property returns the object containing table parameters. | |
PageSettings | The PageSettings property determines page settings. | |
Regions | The Regions property returns the object containing table regions collection. | |
Row | The Row property returns table row. | |
RowHeight | The RowHeight property returns cell height in millimeters. | |
RowPixelHeight | The RowPixelHeight property determines cell height in pixels. | |
Rows | The Rows property returns table rows range. | |
RowsCount | The RowsCount determines the number of table rows. | |
Sparklines | The Sparklines property returns the collection of sparklines displayed in the table. | |
StyleSheet | The StyleSheet property returns the table formatting styles collection. | |
Table | The Table property returns the range that includes the entire table. | |
TableStyles | The TableStyles property allows to get access to table styles. | |
UndoRedo | The UndoRedo property determines parameters of the Undo/Redo stack in the table. | |
View | The View property returns the view of a spreadsheet. |
Method name | Brief description | |
AddStyle | The AddStyle method adds a new formatting style. | |
AdjustCellAddress | The AdjustCellAddress method adjusts relative cell address. | |
AdjustFormula | The AdjustFormula method adjusts cell formula. | |
AdjustRangeAddress | The AdjustRangeAddress method adjusts the relative cell range address during moving a formula. | |
BeginUpdate | The BeginUpdate method disables some of the table functions to reduce the time required to update and process table data. | |
Clear | The Clear method clears the entire spreadsheet. | |
ClearPart | The ClearPart method clears the specified table area. | |
Copy | The Copy method copies the selected cells of the spreadsheet to clipboard. | |
CreateCellSearch | The CreateCellSearch method creates an object, which searches for a table cell. | |
CreateColumnSearch | The CreateColumnSearch method creates an object, which searches for a table column. | |
CreateExpander | The CreateExpander method creates an expander in a cell. | |
CreatePrinter | The CreatePrinter method creates an object that prints a table. | |
CreateRowSearch | The CreateRowSearch method creates an object, which searches for a table row. | |
Cut | The Cut method cuts the selected spreadsheet cells and places them to clipboard. | |
DeleteColumns | The DeleteColumns method deletes the specified number of columns. | |
DeleteRows | The DeleteRows method deletes the specified number of rows. | |
EndUpdate | The EndUpdate method resumes standard mode of working for the table. | |
InsertColumns | The InsertColumns method inserts the specified number of columns. | |
InsertRows | The InsertRows method inserts the specified number of rows. | |
LoadStyleSheetFromXml | The LoadStyleSheetFromXml method loads the collection of table styles from the row in the XML format. | |
PackStyles | The PackStyles method deletes duplicate and unused internal table styles. | |
ParseCell | The ParseCell method parses the cell absolute address. | |
ParseCellEx | The ParseCellEx method gets a cell in the table range. | |
ParseRange | The ParseRange method gets a cell range. | |
ParseRangeEx | The ParseRangeEx method gets a cell range, which address is passed as the Address input parameter, and the region, in which the required range is located - as the Base parameter. | |
Paste | The Paste method pastes data from clipboard to the selected table region. | |
PasteEx | The PasteEx method executes special paste. | |
PasteInRange | The PasteInRange method pastes data from the clipboard to the current cell range area. | |
PasteInRangeEx | The PasteInRangeEx method pastes special data from the clipboard to the current cell range area. | |
Recalc | The Recalc method recalculates the spreadsheet. | |
SaveStyleSheetToXml | The SaveStyleSheetToXml method saves the collection of table formatting styles to the row in the XML format. | |
SetDefaultHyperlinkFont | The SetDefaultHyperlinkFont method is used to set parameters for default hyperlink formatting. |
See also: