ITabView

Assembly: Tab;

Description

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

Inheritance Hierarchy

          ITabView

Comments

The ITabSheet.View property provides access to spreadsheet appearance.

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 access permissions are to be 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.

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.

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.

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 a border color of selected table cells.

SelectionColor

The SelectionColor property determines a fill color of selected table cells.

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.

TabLineFeed

The TabLineFeed property determines whether it is possible to navigate table line-by-line.

TopRow

The TopRow property returns index of the uppermost visible row located at the border of the table's visible area.

UserIntearactiveSelections

The UserIntearactiveSelections property returns the collection of interactive cell ranges.

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.

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.

ShowFormatDialogEx

The ShowFormatDialog method displays a format dialog box for the current selection.

ShowFormulaWizard

The ShowFormulaWizard method calls formula wizard dialog box for TabRange.

See also:

Tab Assembly Interfaces