Prev
20.1 Standard ICM Tables
Next

[ New Table | Read | Table save | Basics | Grid View | Save Table View | Search | Table Color | Table Font | Table Alignment | Mark a Row | Right click | rename | clone | delete | Page Setup | Print | Excel | Save | Column and Row Width | Selections | Edit | Insert/Columns | Statistics | Insert/Rows | Copy, Cut and Paste | Copy Cell | Copy to Table | Delete | Hide/Show | Column Format & Custom Actions | Sort | Filter/Append | Mark and Select Rows | Table Mouse Actions ]

20.1.1 Generate New Table


To generate a new empty table:

20.1.2 Reading a Table


A table can be read and saved as a *.csv , *.tsv or a .tab file. Saving or reading your table as a csv (comma separated value) file enables the table to be transfered or loaded from other applications such as Microsoft Excel. A compound database such as an .sdf file can also be viewed as a table in ICM, additional details on how to manipulate a molecular table is explained in the next section.

A table can be read into ICM by selecting:

OR

Sometimes data is naturally stored and displayed in a table - e.g. PDB data. A common use of tables is for compound data. An explanation of how to use compound molecular tables is in the next section entitled ICM Molecular Tables.

For an example of a table try the following:

A table of all the PDB structures will be displayed at the bottom of the GUI.

NOTE: If you have loaded a table and it is not displayed it may be because the table window is hidden. To display the table, select the window menu and select table see the Window Menu Section .

20.1.3 Saving a table


To save the whole table:

To save a row selection:

20.1.4 Basic Table Navigation


To view the contents of a table you can move the table up and down using the scroll bars on the side and bottom of the display.

NOTE: If you have loaded a table and it isnt displayed it may be because the table display isnt selected. To select the table display, select the window menu and select table (See Window Menu Section ).

If you have read more than one table in ICM you can select a table by clicking the tab on the top of the table (See Below).

NOTE: Double clicking on the tab allows two tables to be displayed at once. Double clicking again returns to the default table layout.

NOTE: Information regarding the number of rows and columns within a table is displayed at the bottom of the table.

If you would like the table to be the main window in the graphical user interface:

20.1.5 Table View (Grid Layout)


To change the table view (layout):

NOTE: You can save a table view.

20.1.6 Table View Save


Once you have a table view that you want to keep. You can save it by:

20.1.7 Table Search


To search a table:

20.1.8 Table Color


You can color your table based on values within a column by:

20.1.9 Table Font


20.1.10 Table Alignment


Rows can be colored by marking them as described here

20.1.11 Mark a Row


A row in a table can be marked and grouped by a label which enables the row(s) to be selected easily at a later time.

To mark a row

To select marked rows

20.1.12 Table right click options


Right-click options vary according to where you click and what is selected. The options are intuitive, for example options that are performed on the whole table (eg Save and Delete) are performed by right-clicking on the Table tab. Other right-click options vary according to whether the row or column is selected or not.

20.1.13 Rename a Table


To rename a table:

20.1.14 Clone a Table


20.1.15 Delete a Table


20.1.16 Page Setup


Before printing a table you can change the orientation and scale.

To do this:

20.1.17 Print a Table


A table can be printed by:

20.1.18 Export to Excel


To export a table to excel.

20.1.19 Save a Table


NOTE: You can save your table in comma separated format if you want to read it into another program such as Microsoft Excel.

20.1.20 Change Column and Row Width


To change the width of column and rows:

You can change the width of a row or column by clicking on the separating line and dragging. You can make each row the same width by holding down the Shift key and dragging one of the row edges.

20.1.21 Making Table Selections


To select one column of a table:

To select one row of a table:

To select more than one row or column:

NOTE: The Ctrl key acts as a toggle enabling select and unselect.

To select a range of columns or rows:

To invert a selection:

NOTE: Invert selection can only be used on rows.

To select the whole table:

To remove a selection:

A selection can also be made from a plot select(`table-plot{See Select plot section}).

20.1.22 Editing a Table


To edit the contents of a table column:

OR

To edit the text or values within a cell:

To edit the name of a column:

20.1.23 Inserting Columns


To insert a column:

A dialog box will then be displayed as shown below.

Many different functions are available:

Once the function and the correct arguments have been entered:

NOTE: If you want to add more than one column choose Add to List and the action will be added to a list on the right hand side of the dialog box.

20.1.24 Column Statistics


To calculate various statistics describing columns and inter-column relationship:

The output is printed into the ICM Terminal window and the Column Statistics Window.

20.1.25 Inserting Rows


To insert a row:

A blank row will be inserted. You can add data to this row by following the instructions in the edit table section.

20.1.26 Copy Cut and Paste Row


Copy, Cut and Paste Row:

20.1.27 Copy Cell


To copy a table cell:

20.1.28 Copy Selection to an ICM Table


To copy a selection to a new table:

20.1.29 Deleting Columns and Rows


To delete a column or row:

20.1.30 Hide and Show Columns


If you have a large table you may wish to only show and display certain columns and hide others. By default any loaded table will have all the columns displayed.

To select which columns you wish to hide:

To show hidden columns:

20.1.31 Column Format and Custom Actions


To change the font color or size, the alignment of the column data, the background color, add hyperlink, or script:

To add a hyperlink to PubMed, PDB or Uniprot:

To add a user-defined hyperlink:

To add an internal ICM link:

The value of the clicked cell is accessed as %1. To refer to the other cells and/or table itself the following shortcuts can be used:

Example:

To add a an internal ICM link that reads a pdb dile and then displays it you could use the following ICM commands in the link:

20.1.32 Table Sorting


To sort a table by a column value:

20.1.33 Table Filtering and Appending


Here we will describe how you can filter your table so that you can then append the filtered data to a new table or display only relevant information to your filter query.

To filter a table:

NOTE: When a column has been filtered a symbol as shown below will appear in the header of the column.

To append the filtered information into a new table:

OR

Selected rows can be appended to a new table by:

A table can be filtered by a cell value:

A filter can be cleared by:

20.1.34 Mark and Select Rows


A row in a table can be marked and grouped by a label which enables the row(s) to be selected easily at a later time.

To mark a row

To select marked rows

20.1.35 Mouse and Cursor Actions on a Table


The actions resulting from a mouse click or cursor on a table can be changed by:

NOTE: The action associated with cursor and double click is placed in a variable name TableName.cursor and TableName.doubleClick


Prev
Tables
Home
Up
Next
Molecular Tables