Table Properties
The properties defined in the Table class are summarized in the following table.
| Property | Description |
|---|---|
| accessedCell | Contains a reference to the cell returned by the accessCell method |
| accessedColumn | Contains a reference to the column returned by the accessColumn method |
| accessedRow | Contains a reference to the row returned by the accessRow method |
| accessedSheet | Contains a reference to the sheet returned by the accessSheet method |
| accessMode | Enables table cells to have different colors, fonts, alignments, and input modes |
| alignment | Contains the placement of text in a cell |
| allowDrag | Enables a row or column to be dragged to a new position within the table |
| allowResize | Specifies whether users can resize the rows and columns of a table |
| autoSize | Controls whether the table automatically sets the width of columns and the height of rows to fit the size of the contents of the cells |
| cellControl | Controls the input and display within a table by defining a user-specified control that is placed over the cell when that cell becomes current |
| column | Contains the current column on the current sheet |
| columns | Contains the number of columns on the current sheet |
| columnVisible | Specifies whether a column is displayed or hidden, or the visibility status |
| columnWidth | Contains the size of a column to be accessed |
| comboIndex | Contains the index of a combo box in a cell |
| comboList | Contains the list entries displayed in a combo box in the sheet, column, row, or cell |
| decimals | Specifies that a cell controlled by the accessMode property can accept decimal input for cells with a numeric text or signed numeric input type |
| defaultRowHeight | Specifies the default height of rows in a table independent of the font size |
| displayHotKey | Specifies whether the character following an ampersand (&) character is underlined |
| dropDown | Specifies that a table need only occupy the space required for one row and yet still provide all the features of an expanded display |
| editMask | Sets the mask used for edit mask input for a cell, row, column, or sheet |
| expandedHeight | Contains the height of the table in pixels when it is expanded |
| fixed3D | Specifies whether a 3D button image is painted on the cells in the fixed area |
| fixedColumns | Contains the number of fixed columns in a table |
| fixedRows | Contains the number of fixed rows in a table |
| gridColor | Contains the color of grid lines |
| gridLines | Specifies whether lines are drawn between the rows and columns of the current sheet |
| hyperlinkColumn | Contains an array of integers that represent a column in each row of the table |
| inputType | Contains the type of input (if any) that is accepted by a cell, row, column, or sheet |
| itemObject | Contains an object for each cell |
| leftColumn | Contains the column that is displayed at the left edge of the non-fixed area of the current sheet |
| maxLength | Contains the amount of text that can be entered into a cell |
| partialTextIndication | Specifies if an indication is displayed when there is insufficient room to show all text of a cell |
| picture | Contains a graphic to be displayed in a cell |
| readOnly | Specifies whether a control is read-only for user input |
| row | Contains the current row on the current sheet |
| rowHeight | Contains the size of a row of a table control |
| rows | Contains the number of rows on the current sheet |
| rowVisible | Specifies whether a row is displayed or hidden |
| scrollBars | Specifies whether the table has horizontal or vertical scroll bars when required |
| selected | Contains the selected status of the current cell on the current sheet |
| selectMode | Specifies the selections that are made automatically when the user selects a cell in the table |
| sheet | Contains the index of the current sheet |
| sheetCaption | Contains the caption for the current sheet |
| sheets | Contains the number of sheets |
| sheetVisible | Specifies whether a sheet is visible |
| showFocus | Specifies whether the focus rectangle is shown on the current cell of a table when it has focus |
| sortAsc | Specifies whether the sorting is ascending or descending |
| sortCased | Specifies whether the sorting is case-sensitive |
| sortColumn | Contains the column number for which the text is to be sorted |
| sortType | Specifies the type of data the cell text represents |
| stretch | Specifies whether pictures placed in the cells are drawn to fit the cell |
| tabActiveColor | Contains the color drawn for the active tab of multiple sheet table |
| tabInactiveColor | Contains the color drawn for the inactive tabs of multiple sheet tables |
| tabKey | Specifies the key that is used to tab within cells of the table |
| text | Contains the text in the current cell on the current sheet |
| topRow | Contains the row that is displayed at the top edge of the non-fixed area of the current sheet |
| topSheet | Contains the sheet that is currently visible |
| userInputEnabled | Specifies whether input (inputType and cellControl property actions) for the table cells is enabled or disabled |
| wordWrap | Specifies whether text displayed in a cell is displayed using word wrap when the width of the cell is less than the length of the text |
For details, see "Window, Form, and Control Properties", later in this document.
