Sep 13 2018 Feedback.
Contents
 
Help Videos
Reference Guide
Getting Started
Protein Structure
Molecular Graphics
Slides & ActiveICM
Cheminformatics
Tables and Plots
 Standard
  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
 Molecular Tables
 Insert Objects
 Plot
 PCA
 Learn and Predict
 Clustering
Local Databases
Tutorials
 
Index
PrevICM User's Guide
8.1 Standard ICM Tables
Next

[ 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 ]

Available in the following product(s): ICM-Chemist | ICM-Chemist-Pro | ICM-VLS

8.1.1 Generate New Table


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.

8.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 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 .

8.1.3 Saving a table


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.

8.1.6 Change Row Height


To change the row height:

  • Click and drag on the row separator
  • Hold the Ctl key to change the height of all rows.

8.1.7 Table View Save


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.

8.1.8 Table Search


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.

8.1.9 Table Color


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.

8.1.10 Table Font


  • Right click on the column header and select Format.
  • Change the font using the options in the Font panel.

8.1.11 Table Alignment


  • 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

8.1.12 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

  • 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.

8.1.14 Rename a Table


To rename a table:

  • Right click on the table tab and select rename.
  • Enter a new name and select OK.

8.1.15 Clone a Table


  • Right click on the table tab and select clone.

8.1.16 Delete a Table


  • Right click on the table tab and select delete.

8.1.17 Page Setup


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

To do this:

  • Right click on the table header and select Page Setup.

8.1.18 Print a Table


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.

8.1.19 Export to Excel


To export a table to excel.

  • Right click on the table header.
  • Select the option to Export to Excel.

8.1.20 Save a Table


  • 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:

  • Click on the row header

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}).

8.1.23 Editing a Table


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 .

8.1.24 Rename Column


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.

8.1.25 Inserting Columns


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.

8.1.27 Column Visibility


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.

8.1.28 Column Order


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.

8.1.29 Freeze Column


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.

8.1.30 Freeze Row


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.

8.1.31 Column Statistics


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.

8.1.32 Inserting Rows


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.

8.1.33 Insert Image


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)

8.1.35 Copy Cell


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.

8.1.41 Table Sorting


To sort a table by a column value:

  • Right click on the column header.
  • Select the Sort option.

8.1.42 Table Filtering


| 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

8.1.43 Append Table


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


Prev
Tables and Plots
Home
Up
Next
Molecular Tables

Copyright© 1989-2018, Molsoft,LLC - All Rights Reserved.
This document contains proprietary and confidential information of Molsoft, LLC.
The content of this document may not be disclosed to third parties, copied or duplicated in any form,
in whole or in part, without the prior written permission from Molsoft, LLC.