[ New Table | Read | Table save | Basics | Grid View | Row Height | Save Table View | Search | Table Color | Table Font | Table Alignment | Mark a Row | Right click | Rename | Clone | Delete Table | Page Setup | Print | Excel | Save | Column and Row Width | Selections | Edit | Rename Column | Insert/Columns | Increment ID | Column Visibility | Column Order | Freeze Column | Freeze Row | Statistics | Insert/Rows | Insert Image | Copy, Cut and Paste | Copy Cell | Copy to Table | Delete Column Row | Hide/Show | Column Format & Custom Actions | Column Annotation | Sort | Filter | Append Table | Mark and Select Rows | Group View | Table Mouse Actions ]
NOTE: To generate a new chemical table use the options in Chemistry/Create Empty Chemical Table.
|
To generate a new empty table:
- File/New and select the Table tab and a window as shown below will be displayed.
- Enter the number of rows and columns you wish to include in your table and whether you wish to add a column with chemical data.
- If you wish to make a chemical table (chemical spreadsheet) select the Chemical Column box.
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 chemical file such as an .sdf file can also be viewed as a chemical spreadsheet.
A table can be read into ICM by selecting:
- File/Open and then selecting the table you have saved (e.g. csv, sdf, tab).
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 .
|
To save the whole table:
- To save a table right click on the table header tab and select Save As..
To save a row selection:
- Select a row(s)
- Right click and choose Save Selection As or Save Selection As Csv + Headers
8.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:
- Select Windows/Table->Main
8.1.5 Table View (Grid Layout) |
To change the table view (layout):
- Select the columns you wish to display in grid view. No selection will place all columns in grid view
- Right click on a table row and select Table View
- You can view the table in Grid View and toggle between grid and standard view. You can define your own grid using the Custon Grid option or display the table in Form View.
NOTE: You can save a table view.
|
To change the row height:
- Click and drag on the row separator
- Hold the Ctl key to change the height of all rows.
Once you have a table view that you want to keep. You can save it by:
- Right click on a table row and select Store Views
- Select Save Current View
- Enter a name for the table view and you can return to that view by repeating the first two steps above.
- You can rename, delete or restore view by right clicking on the name of the table view.
To search a table:
- Right click on a table row and select Find and Replace. You can also use CTRL F.
- Enter a search string.
- Press the Find button.
You can color your table based on values within a column by:
Single Color
- Right click on the column header and select Format,Color,Action.
- In the Background panel select the color you desire using the option Single Color.
Color by Rainbow
- Right click on the column header and select Format,Color,Action.
- In the Background panel select the option rainbow. To edit the range of values relating to each color click on the pencil (edit) button as shown below.
Color Range - Advanced
- Right click on the column header and select Format,Color,Action.
- In the Background panel select the option Range/Advanced
- A dialog as shown below will be displayed where you can specify ranges and colors for each range. If two colors for range are equal then the whole range will be colored with single color, otherwise color will be interpolated within the range.
- Right click on the column header and select Format.
- Change the font using the options in the Font panel.
- Right click on the column header and select Format.
- Change the font using the options in the Alignment panel.
Rows can be colored by marking them as described here
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
- Right click on the row in the table you wish to mark. Or select multiple rows and then right click.
- Select Mark Row/ and then choose a number. In the GUI the number of rows that can be marked is limited to 5 but this can be increased using the command line command.
- A row that is marked will be colored - each number is assigned a color. The coloring can be changed in the gui tab in preferences.
To select marked rows
- Right click on the table and choose Select Marked Rows and choose a number which relates to the marked rows as described earlier.
- Selected rows will be highlighted blue - once rows are selected a number of right click options are activated such as copy selection to new ICM table.
8.1.13 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.
To rename a table:
- Right click on the table tab and select rename.
- Enter a new name and select OK.
- Right click on the table tab and select clone.
- Right click on the table tab and select delete.
Before printing a table you can change the orientation and scale.
To do this:
- Right click on the table header and select Page Setup.
A table can be printed by:
- Right click on the table tab and a menu will be displayed.
- Select the "Print" option. You may want to change the setup of the table (eg orientation and scale. You can do this using Page Setup option.
To export a table to excel.
- Right click on the table header.
- Select the option to Export to Excel.
- Right click on the table tab and select Save As..
NOTE: You can save your table in comma separated format if you want to read it into another program such as Microsoft Excel.
|
8.1.21 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.
8.1.22 Making Table Selections |
To select one column of a table:
- Click on the column header
To select one row of a table:
To select more than one row or column:
- Click on one row or column whilst pressing the Ctrl key
- Select multiple number of rows or columns whilst still pressing the Ctrl key
NOTE: The Ctrl key acts as a toggle enabling select and unselect.
|
To select a range of columns or rows:
- Click on the first row or column in the range whilst pressing the Shift key.
- Click on the last row or column in the range whilst pressing the Shift key.
To invert a selection:
- Right click on the original selection and a menu will be displayed.
- Select the Row Selection/Invert selection option.
NOTE: Invert selection can only be used on rows.
|
To select the whole table:
- Right click in the table and a menu will be displayed.
- Select the Row Selection/Select All option.
To remove a selection:
- Click anywhere within the table.
A selection can also be made from a plot select(`table-plot{See Select plot section}).
To edit a table:
Click on the Edit Cells by Double Click button on the right hand side of the table. You can then edit each cell by double clicking on it.
OR
To edit the text or values within a cell:
- Right click on the table and select Edit Cells by Double-click .
To edit the name of a column:
- Right click on the column header and a menu will be displayed.
- Select the option "Rename Column..." and enter the appropriate new text.
To insert a column:
- Identify the position within the table where you wish the column to be inserted.
- Right click on the column header and a menu will be displayed.
- Select "Insert Column"
A dialog box will then be displayed as shown below.
- Select the function you wish to add to the new column. Functions can be applied to many columns e.g. add etc..
- A set of arguments related to the function selected will then be displayed.
- Enter the appropriate arguments related to the function selected.
- Select where you want the new column to be located in the table.
- Enter the new column name
- If you wish to add multiple columns then use the Add to List option.
Many different functions are available:
- New Add a new column containing a real number, integer, string,or random number.
- Transformations A number of transformations can be selected and applied to a table column as shown below.
- Mathematical A number of mathematical functions
- Text Apply a number of different functions to the text in a column.
- Chemical Calculate a number of different chemical properties.
- Convert Units Radian to Degrees and Degree to Radian
Once the function and the correct arguments have been entered:
- Select whether you wish the new column to be added before,after or in place of this column.
- Enter the name of the new column.
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.
|
8.1.26 Increment ID Number |
To add and Increment name ID in cell as a column (e.g. mol1, mol2, mol3…):
- Right click on a column and choose Insert Column.
- Select Function New -> ID.
- Enter name and starting number and press OK.
To hide a column:
- Right click on any column header and choose "Manage Column Visibility and Order"
- A dialog box as shown below will be displayed.
- Click on the arrows to move a column from hidden to visible and vice-versa. Multiple columns can be selected by holding the Ctrl key and clicking.
To re-order the columns in a table:
- Right click on any column header and choose "Manage Column Visibility and Order"
- A dialog box as shown below will be displayed.
- Click on the arrow buttons to re-order. Multiple columns can be selected by holding the Ctrl key and clicking.
NOTE One application of Freeze column is to rename rows.
|
To freeze a column:
- Right click on the column you wish to freeze and select Freeze Column.
To unfreeze a column:
- Right click on the column you wish to unfreeze and select Unfreeze Column.
To freeze a row:
- Right click on the row number of the row you wish to freeze and select Freeze Row.
To unfreeze a row:
- Right click on the row number of the row you wish to unfreeze and select Unfreeze Row.
To calculate various statistics describing columns and inter-column relationship:
- Right click on the column header and a menu will be displayed.
- Select "Column Statistics"
The output is printed into the ICM Terminal window and the Column Statistics Window.
To insert a row:
- Identify the position within the table where you wish the row to be inserted and select the row.
- Right click on the row name (eg the number of the row) and a menu will be displayed.
- Select Insert Row Before or Insert Row After.
A blank row will be inserted. You can add data to this row by following the instructions in the edit table section.
To insert an image into a table:
- First create an image column in the table. Use the Insert Colun option and choose Function > New > Image.
- Right click on a cell in the new image column you have created and choose Set Image and choose the image you wish to import.
8.1.34 Copy Cut and Paste Row |
Copy, Cut and Paste Row:
- Select the row(s) See table selection section.
- Right click on the row header
- Select Copy Row(s).
- To paste a row select the row header under which you wish to paste the row. Right click and select Paste Row(s)
To copy a table cell:
- Right click on cell.
- Select Copy Cell - you can then paste it into a new table.
8.1.36 Copy Selection to an ICM Table |
To copy a selection to a new table:
- Select the row(s) See table selection section.
- Right click on the row header
- Select Copy Selection to ICM Table and then choose Auto (ICM will name the table or New and you can enter a new table name.
8.1.37 Deleting Columns and Rows |
To delete a column or row:
- Select the column(s) or row(s) you wish to delete. See the select table section for information on how to make
table selections.
- Right click on the row number to delete a row or right click on the column header to delete a column and select the delete option from the menu.
8.1.38 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:
- Select the column(s) you wish to hide. See the select table section for information on how to make
table selections.
- Right click and select the hide option from the menu.
To show hidden columns:
- Right click on the column header and a menu will be displayed.
- Select the Show Columns options.
- Select which column you wish to show from the drop down list.
Note: In versions 3.8-6 and higher there is an option called "Manage Column Visibility and Order" as described here.
|
8.1.39 Column Format and Custom Actions |
To change the column format, font color or size, the alignment of the column data, the background color, add hyperlink, or script:
- Right click on the column header and select Format
- A window as shown below will be displayed.
- Make the desired changes and click Apply
To add a hyperlink to PubMed, PDB or Uniprot:
- Click on the drop down hyper link button.
- If the data in the column is a PDB, Uniprot/SwissProt or PubMed code then choose the built in format from the menu.
- Click Apply and the data in the column will become blue hyperlinks.
To add a user-defined hyperlink:
- Click on the drop down hyperlink button.
- Choose "Simple link" See below for details on how to access cell data.
- Click Apply and the data in the column will become blue hyperlinks.
To add an internal ICM link:
- Click on the drop down hyperlink button.
- Choose "Internal ICM link" See below for details on how to access cell data.
- Enter ICM scripting language in the panel that opens (see image below).
- Click Apply and the data in the column will become blue hyperlinks.
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:
- %@ # table name
- %# # clicked row number
- %^ # clicked column number
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:
8.1.40 Column Table Annotation |
- Right click on the column you wish to annotate and choose Format, Color Action.
- Enter the comment in the bottom panel labeled Comments.
- The comments will be displayed when the user hovers the mouse over the column header. Other table comments can be added using the HTML panel.
To sort a table by a column value:
- Right click on the column header.
- Select the Sort option.
| Video |
There are two ways to filter table content one is via the table panel or by using the right click column header options.
To filter a table using the extra panel sliders:
|
Open the extra panel and choose the filter tab. Click and drag on the sliders to conveniently choose the filtering values or enter the values directly. Click on the green 'tick' to apply filters. |
To filter a table using the column header:
- Select the column you wish to filter. See the select table section for information on how to make
table selections.
- Right click on the column header.
- Select the Filter option.
- Select the "Custom" option and a data entry box as shown below will be displayed.
- Enter the appropriate operations and filter values for your search.
- Click OK.
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:
- Select the whole table either by right clicking or pressing Ctrl A.
- Right click on the table and select "Append to other table".
- Enter a new name for the table you are appending with your filter results.
OR
Selected rows can be appended to a new table by:
- Right clicking on the selected rows and a menu will be displayed.
- Selecting the "copy selection to ICM table" option.
A table can be filtered by a cell value:
- By clicking once in a cell.
- Right click and a menu will be displayed.
- Select the option "Filter by cell value".
A filter can be cleared by:
- Right clicking on the column selection and selecting Filter/Clear or Filter/Clear All
To append rows to a new table:
- Select the rows you wish to copy to a new table.
- Right click on the table and choose Copy/Append Selected Rows to table.
Or you can use the Tools menu option here.
8.1.44 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
- Right click on the row in the table you wish to mark.
- Select Mark Row/ and then choose a number. In the GUI the number of rows that can be marked is limited to 5 but this can be increased using the command line command.
- A row that is marked will be colored - each number is assigned a color. The coloring can be changed in the gui tab in preferences.
To select marked rows
- Right click on the table and choose Select Marked Rows and choose a number which relates to the marked rows as described earlier.
- Selected rows will be highlighted blue - once rows are selected a number of right click options are activated such as copy selection to new ICM table.
8.1.45 Group View by Column |
To group a column by value:
- Right click on the column header and choose "Group View by Column". Chemicals in the same group are grouped in the same row. You can expand the view by clicking on the "+" sign".
To remove grouping:
- Right click on the column header and choose "Undo the Group View"
8.1.46 Mouse and Cursor Actions on a Table |
The actions resulting from a mouse click or cursor on a table can be changed by:
- Right click on a table and select Table View/Show Extra Panel
- A panel as shown below will be displayed.
- Double click in the Value column and the column can be edited. Add ICM commands for the action you want. A value in a column can be referred to using "%" e.g. column two would be referred to as "%2". In the example shown above the function nice is acting on the contents of column one for the double click action.
NOTE: The action associated with cursor and double click is placed in a variable name TableName.cursor and TableName.doubleClick
|
|