Context Menu

Copy

Copy the value of a cell.

Paste

Paste a value from the clipboard into a cell. If the value in the clipboard has another format than the cell value, Iotellect Client will attempt to convert it. If the value cannot be converted, it will not be pasted.

Copy Records

Copy selected rows to the clipboard.

Paste Records

Paste previously copied records after the selected row.

Remove Value

Resets cell value to NULL (<Not set>). This operation is only applicable if current field is nullable, i.e. supports NULL values.

Undo Cell Changes

Reset the cell value to the one it contained when the Data Table Editor was opened. If the cell didn't exist when the editor was opened (i.e. the cell belongs to a newly created row) this operation will reset its value to default (see below).

Reset Cell To Default

Reset the cell value to the default for this column (usually defined on the server, as part of the table format description).

Fill Column With Cell Value

Copy value from the selected cell to all other cells of current column.

Duplicate Record

Creates a copy of current record.

Reset Table

Resets all changes made to the table since it was opened.

View Table Format

Shows format of current table.

Auto Resize This Column

Auto-adjust size of clicked column to fit all data.

Auto Resize All Columns

Auto-adjust size of all columns to maximize the amount of visible data.

Group This Column (soft ascending)

Enables row grouping by the values of current column's cells, with ascending sorting.

Group This Column (soft descending)

Enables row grouping by the values of current column's cells, with descending sorting.

Expand All

Expand all row groups.

Collapse All

Collapse all row groups.

Hide This Column

Hides current column.

Show All Hidden Columns

Shows all currently invisible columns.

Reset Columns To Default

Resets columns widths.

More...

Opens a popup dialog allowing to select visible columns.

Select All Cells

Selects the whole table.

Clear Selection

Clears cell selection.