TdxSpreadSheetTableView Members
In This Article
#Constructors
Name | Description |
---|---|
Create |
Creates a new persistent object for the specified Spreadsheet or Report Designer control.
Inherited from Tdx |
#Properties
Name | Description |
---|---|
Active |
Specifies if the worksheet is active.
Inherited from Tdx |
Bottom |
Specifies an index of the row displayed at the bottom of the Table View worksheet’s visible area. |
Bounds |
Returns the boundaries of the displayed worksheet area.
Inherited from Tdx |
Caption |
Specifies the worksheet‘s caption (name).
Inherited from Tdx |
Cells | Provides indexed access to cell objects in the worksheet. |
Cell |
Stores all cell styles used in the current worksheet.
Inherited from Tdx |
Columns | Provides access to the column collection within the current Table View worksheet. |
Conditional |
Provides access to the conditional formatting controller that manages rules that apply to cell ranges within the worksheet. |
Containers |
Provides access to the floating container collection created within the current worksheet.
Inherited from Tdx |
Dimensions | Returns the populated worksheet area. |
Frozen |
Specifies an index of the frozen column adjacent to a frozen pane separator. |
Frozen |
Specifies an index of the frozen row adjacent to a frozen pane separator. |
History | Provides access to the history of the Spreadsheet control instance to which the current Table View worksheet belongs. |
Hit |
Returns Hit |
Hyperlinks | Provides access to hyperlink collection within the current Table View worksheet. |
Index |
Specifies the worksheet tab position within the caption bar.
Inherited from Tdx |
Is |
Returns a value indicating whether an in-place editor is active within the current Table View worksheet. |
Left |
Specifies an index of the on the left side of the Table View worksheet’s visible area. |
Merged |
Provides access to the merged cell collection within the current Table View worksheet. |
Options | Specifies the Table View worksheet’s appearance and functionality settings. |
Options |
Provides access to all Table View worksheet’s print settings. |
Options |
Specifies the Table View worksheet protection settings. |
Print |
Returns the Table View worksheet’s content print limitation area. |
Right |
Specifies the index of the column at the right edge of the Table View worksheet’s visible area. |
Rows | Provides access to the Table View worksheet’s row collection. |
Selection | Provides access to the collection of selected cell ranges and objects in the worksheet. |
Spread |
Provides access to the Spreadsheet or Report Designer control to which the persistent object belongs.
Inherited from Tdx |
Top |
Specifies an index of the row at the top of the Table View worksheet’s visible area. |
Visible |
Specifies if the worksheet is currently available to an end-user. f Inherited from Tdx |
#Methods
Name | Description |
---|---|
Add |
Creates a new array formula expression at the specified cell range. |
Add |
Creates a new array formula expression in the specified cell range. |
Assign |
Inherited from TPersistent. |
Assign |
Inherited from TPersistent. |
Begin |
Postpones all worksheet redraw operations and related notifications that reflect any content change until an End |
Can |
Identifies if it is possible to clear the current cell selection. |
Can |
Identifies if is possible to clear the specified cell range. |
Can |
Identifies if it is possible to clear the specified cell range. |
Can |
Identifies if it is possible to copy the worksheet’s content to the clipboard. |
Can |
Identifies if it is possible to move the worksheet’s content to the clipboard. |
Can |
Identifies if users can delete cell data from the worksheet. |
Can |
Identifies if users can delete cell data from the worksheet. |
Can |
Identifies if it is possible to delete comments in the worksheet. |
Can |
Identifies if it is possible to delete comments in the specified cell range. |
Can |
Identifies if it is possible to delete comments in the specified cell range. |
Can |
Identifies if an end-user can remove a hyperlink. |
Can |
Identifies if it is possible to edit comment containers within the worksheet. |
Can |
Identifies if an end-user can create and/or delete floating containers.
Inherited from Tdx |
Can |
|
Can |
Returns a value indicating whether the Auto |
Can |
Identifies if users can insert cell data to the worksheet. |
Can |
Identifies if users can insert columns or rows to the worksheet. |
Can |
Identifies if it is possible to insert cells into the specified cell range. |
Can |
Identifies if it is possible to insert cells into the specified cell range. |
Can |
Identifies whether the currently selected cell range can be merged into a single cell. |
Can |
Identifies if it is possible to change values within the specified cell range. |
Can |
|
Can |
|
Can |
Identifies if it is possible to insert the clipboard’s content to the worksheet. |
Can |
Identifies if it is possible to sort cell values. |
Can |
Identifies whether the currently selected merged cell object can be split into ordinary cells. |
Cell |
Returns a cell object located at the specified position. |
Cell |
Identifies a cell located at the specified position. |
Clear |
Clears the specified cell range. |
Clear |
|
Clear |
|
Clear |
|
Clear |
Clears all values from the current cell selection. |
Copy |
Copies cell values and formatting from the cell range specified in A1 format to a stream. |
Copy |
Copies cell values and formatting from the specified cell range to a stream. |
Copy |
Copies the current selection to the clipboard. |
Create |
Returns an underlying cell object of a cell at the specified position in the worksheet. |
Create |
|
Cut |
Moves the current selection to the clipboard. |
Delete |
Removes all cell objects from the worksheet. |
Delete |
|
Delete |
Deletes the current cell selection or a specified cell range. |
Delete |
|
Delete |
Removes a specified number of columns starting from a designated column. |
Delete |
|
Delete |
|
Delete |
Deletes all comment containers within the current selection or a designated cell range. |
Delete |
Deletes a hyperlink. |
Delete |
Removes a specified number of rows starting from a designated row. |
Edit |
Invokes the Customize Object dialog window with the active Text tab for a comment container. |
Edit |
Invokes the Edit Hyperlink dialog. |
End |
Applies all pending changes and redraws the worksheet after a Begin |
Equals |
Inherited from TObject. |
Fill |
|
Fill |
|
Fill |
|
Fill |
Populates cells from the specified source. |
Fill |
|
For |
|
For |
Performs a specific set of actions on all populated cells within a specific portion of the Table View worksheet. |
For |
|
Freeze |
|
Freeze |
Immobilizes one or more sequential worksheet columns at the left border of the Spreadsheet control’s content area. |
Freeze |
Freezes the specified numbers of rows and columns at the top and left edges of the Table View worksheet. |
Freeze |
|
Freeze |
Prevents one or more sequential rows from scrolling, immobilizing them at the top border of the Table View worksheet. |
Get |
Returns data from a worksheet cell. |
Get |
Obtains both the value and error code of a cell within the Table View worksheet. |
Get |
Inherited from TObject. |
Get |
Returns the index of the last column in the worksheet. |
Get |
Returns the index of the last row in the worksheet. |
Get |
Inherited from TPersistent. |
Get |
Returns the index of the nearest column object that follows or precedes the target cell position. |
Get |
Returns the index of the nearest row object above or below the specified cell position. |
Get |
Inherited from TPersistent. |
Hide |
Closes an active in-place cell editor. |
Hide |
Hides all columns that intersect the cell selection area. |
Hide |
Hides all rows that intersect the cell selection area. |
Insert |
|
Insert |
Inserts an empty cell range into the worksheet. |
Insert |
|
Insert |
|
Insert |
Inserts a specified number of uninitialized columns following the designated column. |
Insert |
Inserts a specified number of uninitialized rows following the designated row. |
Invalidate |
Invalidates the Spreadsheet control‘s View area.
Inherited from Tdx |
Invalidate |
Invalidates a specified portion within the Spreadsheet control‘s View area.
Inherited from Tdx |
Is |
Identifies if the specified worksheet row is visible for the Spreadsheet formula engine. |
Make |
Scrolls the worksheet horizontally and/or vertically to show the focused cell. |
Make |
Scrolls the worksheet horizontally and/or vertically to show a specified floating container. |
Make |
Scrolls the worksheet horizontally and/or vertically to show a cell specified by its row and column indexes. |
Make |
Scrolls the worksheet horizontally and/or vertically to show a specified cell range. |
Make |
Scrolls the worksheet horizontally and/or vertically to show a specified cell range. |
Make |
Scrolls the worksheet horizontally to show the specified column. |
Make |
Scrolls the worksheet horizontally to show the specified column. |
Make |
Scrolls the worksheet vertically to show the specified row. |
Merge |
Creates merged cells from selected cell ranges. |
Paste |
Pastes cell data and formatting from a stream object into the worksheet at the specified position. |
Paste |
|
Paste |
Inserts the clipboard’s content into the current cell selection. |
Protect | Invokes the Protect Sheet dialog. |
Query |
Inherited from TInterfaced |
Set |
Populates a cell at the specified position with a value and an error code. |
Show |
Activates an in-place editor for the focused cell. |
Show |
Activates an in-place editor for the focused cell and replaces its content with a specified character. |
Show |
Activates an in-place editor for a cell under the mouse pointer. |
Sort |
|
Sort |
Sorts the specified cell range against multiple columns. |
Sort |
|
Sort |
Sorts the specified cell range against multiple rows. |
Split |
Splits one or more merged cells into one or more selected cell ranges. |
To |
Inherited from TObject. |
Unfreeze |
Unlocks all previously frozen rows and columns. |
Unhide |
Displays all previously hidden columns that intersect the cell selection area. |
Unhide |
Displays all previously hidden rows that intersect the cell selection area. |
Unprotect | Cancels the worksheet protection. |
See Also