ITabView

Assembly: Tab;

Namespace: Prognoz.Platform.Interop.Tab;

Description

The ITabView interface contains properties and methods that are used to set up table appearance.

Inheritance hierarchy

          ITabView

Comments

Access to spreadsheet appearance is given by the ITabSheet.View property.

Properties

	Property name	Brief description
	ActiveColumn	The ActiveColumn property determines the number of the last column, in which the hyperlink was clicked.
	ActiveRow	The ActiveRow property determines the number of the last row in which the hyperlink was clicked.
	AllowMouseWheelScroll	The AllowMouseWheelScroll property determines whether it is possible to scroll the table rows using the mouse wheel.
	AllowUnlimitedScroll	The AllowUnlimitedScroll property determines the scrolling mode for table rows.
	AutoFilter	The AutoFilter property returns the object, which contains the auto filter of the table.
	BottomRow	The TopRow property returns index of the lowermost row located in the visible range of the table.
	ColumnsHeaderHeight	The ColumnsHeaderHeight property determines the column header height.
	DisplayAccessRights	The DisplayAccessRights property determines whether the icons showing permissions to access data are displayed.
	DisplayClippedCellHints	The DisplayClippedCellHints property determines whether to show a tooltip containing the full text of table cell.
	DisplayColumnNames	The DisplayColumnNames property determines visibility of table column headers.
	DisplayDarkFixedBorder	The DisplayDarkFixedBorder property determines whether the shadow of the fixed area is displayed.
	DisplayFixedAreaLines	The DisplayFixedAreaLines property determines whether the fixed area lines are displayed.
	DisplayFootnotesToolTips	The DisplayFootnotesToolTips property determines whether tooltip with footnote text will be displayed on hovering mouse cursor over footnote number in the cell area.
	DisplayGrid	The DisplayGrid property determines visibility of the table grid.
	DisplayNumberSigns	The DisplayNumberSigns property determines a method that is used to display non-text data that overrun text borders.
	DisplayNumericColumnNames	The DisplayNumericColumnNames property determines whether the names of table columns are displayed as numbers.
	DisplayPaperOut	The DisplayPaperOut property determines whether the pagination is visible.
	DisplayPasteOptions	The DisplayPasteOptions property determines whether parameters of data pasting are displayed.
	DisplayRegion	The DisplayRegion property determines whether the borders of data and formula areas are visible.
	DisplayRowNumbers	The DisplayRowNumbers property determines whether the row numbers are visible.
	DisplayScrollBars	Outdated. The DisplayScrollBars property determines whether the horizontal and vertical scroll bars are visible. The property is outdated, use the ITabView.VisibleScrollBars property instead.
	EnableEdit	The EnableEdit property determines whether the table cells contents can be edited.
	EnableHyperlinks	The EnableHyperlinks property determines whether hyperlinks should work in table cells.
	EnableInteractiveSelection	The EnableInteractiveSelection property determines whether data of the selected range can be moved, and cells can be automatically filled based on the selected range.
	ErrorIndicatorsColor	Outdated. Use the ITabErrorCheckingOptions.ErrorIndicatorsColor property.
	ExpanderWidth	The ExpanderWidth property returns the size of the table expander in millimeters.
	Fixed	The Fixed property returns the value that is used to determine whether a fixed area is present in the table.
	FixedAreaLinesColor	The FixedAreaLinesColor property determines the color of the fixed area lines.
	FixedBehaviour	The FixedBehaviour property determines the mode of working with rows and columns, if there is a fixed area.
	FixedBordersStyle	The FixedBorderStyleProperty returns style of display for the lines of a fixed region.
	FixedColumnsCount	The FixedColumnsCount property determines the number of fixed columns in the table.
	FixedRowsCount	The FixedRowsCount property determines the number of fixed rows in the table.
	HeadersSelectionColor	The HeadersSelectionColor property determines the highlight color of headers in the table.
	HighlightFormulas	The HighlightFormulas property determines whether the table cells with formulas are highlighted.
	LeftColumn	The LeftColumn property returns index of the leftmost column located at the border of the table's visible range.
	Protection	The Protection property returns the object, that contains table protection settings.
	RedoAction	The RedoAction property returns the name of the operation, that can be repeated.
	RedoCount	The RedoCount property returns the number of operations, that can be repeated.
	RightColumn	The RightColumn property returns index of the rightmost column located on the border of the table's visible range.
	RowsHeaderWidth	The RowsHeaderWidth property determines the row header width.
	Scale	The Scale property determines the scale of the table.
	Selection	The Selection property returns the current selection in the table.
	SelectionBorderColor	The SelectionBorderColor property determines color of selection border in the table.
	SelectionColor	The SelectionColor property determines the selection color in the table.
	SelectionMovementDirection	The SelectionMovementDirection property determines direction of selection movement after pressing ENTER.
	Size	The Size property returns the size of the visible area of the table in millimeters.
	TopRow	The TopRow property returns index of the uppermost visible row located at the border of the table's visible area.
	UndoAction	The UndoAction property returns the name of the element in the undo stack.
	UndoCount	The UndoCount property returns the number of operations, which can be undone.
	UndoEnabled	The UndoEnabled property determines whether the table changes are recorded in the undo stack.
	UserIntearactiveSelections	The UserIntearactiveSelections property returns the collection of interactive cell ranges.
	UseWpfEditor	The UseWpfEditor property enables and disables using WPF editor on editing value of a cell.
	VisibleScrollBars	The VisibleScrollBars property determines whether the horizontal and vertical scroll bars of the table are visible.

Methods

	Method name	Brief description
	ConvertPtToView	The ConvertPtToView method converts a point in screen coordinates into a point relative to the upper left corner of the table visible area.
	EditCell	The EditCell method makes a cell editable.
	EmulateCellClick	The EmulateCellClick method emulates a click on the specified cell.
	EmulateCellPictureClick	The EmulateCellPictureClick method emulates a click on the image located in the specified cell.
	EmulateHyperlinkClick	The EmulateHyperlinkClick method emulates the click on the hyperlink in the specified cell.
	EndEdit	The EndEdit method exits cell editing mode.
	EnsureRowVisible	The EnsureRowVisible method scrolls the table in such a way, that the defined row is in the visible range.
	FlushUndo	The FlushUndo method clears the list of all the operations, performed by the user.
	HitTest	The HitTest method returns the table region, containing the point, the coordinates of which are passed as input parameters.
	HitTestCell	The HitTestCell method calculates indexes of the row and the column for the table cell containing the point, the coordinates of which are passed as input parameters.
	HitTestObject	The HitTestObject method returns the table object, containing the point, the coordinates of which are passed as input parameters.
	HitTestRegion	The HitTestRegion method returns the table region, containing the point, the coordinates of which are passed as input parameters.
	Redo	The Redo method repeats the last cancelled operation.
	RedoEx	The RedoEx method repeats several cancelled operations.
	ShowFormatDialog	Outdated. Use ITabView.ShowFormatDialogEx.
	ShowFormatDialogEx	The ShowFormatDialog method displays a format dialog box for the current selection.
	ShowFormulaWizard	The ShowFormulaWizard method calls the formula wizard dialog box for the TabRange.
	Undo	The Undo method cancels the last operation.
	UndoEx	The UndoEx method cancels several operations.

See also:

Tab Assembly Interfaces