Spreadsheet View

The Spreadsheet View is an interface intended for the manipulation (browsing, filtering, sorting, profiling, prioritization, etc.) of multiple compound libraries.

1. Menu bar. Select between different menu options allowing you to execute corresponding actions: perform data manipulations (Import/Export, Open/Save), edit the spreadsheet, filter and sort the data, carry out calculations, construct scatter plots, etc.
   
   
2. Spreadsheet grid area displaying actual loaded data: compound structures, names, property values and class indicators (whether calculated within the program, or imported from external sources), etc. Click on individual spreadsheet cells to select, or navigate the current selection cursor by using the arrow keys.
   
   
3. Status line indicating the current position of the cursor, number of visible lines and the total number of records in the analyzed spreadsheet.
   
   Click it to open Go to window and type a record number to view it directly.
   Calculation progress bar is also displayed here, when relevant.
   
   
4. Hover over row headings to see the hint window with the corresponding enlarged structure.
   
   The row heading region remains active and displays a hint in any situation, even when the actual structure column is not visible due to scrolling far to the right in large spreadsheets.
   Double-click anywhere in the structure field to open the Edit Structure window. This can be accessed as well by right-clicking in the structure field and choosing the Edit... command.
   
   
5. Click on the column heading to select the entire column. Double-click to open the column rename dialog window.
   
   
   
   
6. Drag the column header separator in order to change the width of the column.
   NOTE: Resizing the width of the Structure column scales the structures, increasing or decreasing the height of the rows.
   
   
7. Click on the sorting pictogram in the column header to sort/un-sort the corresponding column instantly. The change of the sorting function state (sort ascending, sort descending, and unsorted – all cycling in a continuous loop) upon each click is represented by a corresponding change in the pictogram appearance.
   
   
8. When the spreadsheet is being affected by any filters, columns to which the filtering conditions have been applied are indicated with a filter pictogram in the header.
   
   
9. Whenever the property value in the selected cell has been calculated by an internal ACD/Percepta module, a blue info pictogram appears in the bottom-right corner. Clicking it will take you to the corresponding Module View (if you have purchased that module) for a detailed analysis of predictions for that molecule.
   
   
10. Double-clicking any individual cell containing numerical values or plain text, allows content editing. Any user modifications to the original spreadsheet data are indicated by a square dot in the upper-left corner of the affected cells.
    
    
11. Click a circle to apply a label to the current compound. To set the color of the label, click the arrow button to expand the color settings list:
    
    

a. When clicking the label circle while this option is selected, the color of the label for the displayed compound will alternate between green or none.

b. When clicking the label circle while this option is selected, the color of the label for the displayed compound will alternate between red or none.

c. To set an arbitrary label color, select the "Color selector" option and click the label circle. The color palette will appear. Choose one color of your preference from a predefined set of colors.