ITabSheet

Assembly: Tab;

Namespace: Prognoz.Platform.Interop.Tab;

Description

The ITabSheet interface contains properties and methods of a table.

Inheritance hierarchy

          ITabSheet

Comments

Tables are used in regular and express reports and are implemented by the following UiTabSheet development environment component and the following visual component TabSheetBox.

Properties

	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, the coordinates of which 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, the coordinates of which are passed as input parameters.
	CellSuffix	The CellSuffix property determines suffix of the table cell.
	CellValue	The CellValue property sets the value of the cell, the coordinates of which are passed as input parameters.
	Column	The Column returns the table column.
	ColumnIndex	The ColumnIndex property returns the index of the table column, the name of which is passed as an input parameter.
	ColumnName	The ColumnName property returns the address of the table column, the number of which 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, the coordinates of which are passed as input parameters.
	Footnotes	The Footnotes property returns 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 the parameters of hyperlinks formatting in table cells.
	Images	The Images property returns the object, containing table images collection.
	MaxNotEmptyColumn	The MaxNotEmptyColumn property returns maximum index of column that contains data.
	MaxNotEmptyRow	The MaxNotEmptyRow property returns maximum index of row that contains data.
	MaxUsedColumn	The MaxUsedColumn property returns maximum index of a used table column.
	MaxUsedRow	The MaxUsedRow property returns maximum index of a used table row.
	Modified	The Modified property determines whether the table is modified.
	Name	The Name property determines the name of the spreadsheet.
	NamedRegions	The NamedRegions property allows to get access to table named regions.
	Objects	The Objects property returns the collection of objects, implemented via 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 table rows number.
	Sparklines	The Sparklines property returns 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 parameter of Undo or Redo stack in the table.
	View	The View property returns the view of a spreadsheet.

Methods

	Method name	Brief description
	AddStyle	The AddStyle method allows to add 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 allows to clear 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 allows to create an object which searches for a table cell.
	CreateColumnSearch	The CreateColumnSearch method allows to create an object which searches for a table column.
	CreateExpander	The CreateExpander method allows to create an expander in a cell.
	CreatePrinter	The CreatePrinter method creates an object that outtypes a table.
	CreateRowSearch	The CreateRowSearch method allows to create an object which searches for a table row.
	Cut	The Cut method cuts the selected cells and places them to clipboard.
	DeleteColumns	The DeleteColumns method allows to delete the specified number of columns.
	DeleteRows	The DeleteRows method allows to delete the specified number of rows.
	EndUpdate	The EndUpdate method resumes standard mode of working for the table.
	InsertColumns	The InsertColumns method allows to insert the specified number of columns.
	InsertRows	The InsertRows method allows to insert 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 receives a cell in the table range.
	ParseRange	The ParseRange method receives a cell range.
	ParseRangeEx	The ParseRangeEx method receives a cell range, the address of which is passed as an input parameter Address, and the region, in which the required range is located - as the parameter Base.
	Paste	The Paste method pastes data from clipboard to the selected table region.
	PasteEx	The PasteEx method performs special pasting.
	Recalc	The Recalc method recalculates the table.
	ResetSkippedErrors	Outdated. Use ITabErrorCheckingOptions.ResetSkippedErrors.
	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:

Tab Assembly Interfaces