Spreadsheet View - Revision history

Kristina at 14:25, 12 December 2014

2014-12-12T14:25:14Z

Kristina at 10:05, 19 March 2013

2013-03-19T10:05:44Z

Kristina: Created page with "The '''Spreadsheet View''' is an interface intended for the manipulation (browsing, filtering, sorting, profiling, prioritization, etc.) of multiple compound libraries.

2012-07-04T13:05:30Z

Created page with "The '''Spreadsheet View''' is an interface intended for the manipulation (browsing, filtering, sorting, profiling, prioritization, etc.) of multiple compound libraries. <b..."

New page
The '''Spreadsheet View''' is an interface intended for the manipulation (browsing, filtering, sorting, profiling, prioritization, etc.) of multiple compound libraries. 
 
[[Image:Spreadsheet_View.png|center]]
 
# 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. 
# 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.  
# Status line indicating the current position of the cursor, number of visible lines and the total number of records in the analyzed spreadsheet. [[File:Go_to_window.png|right]]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. 
# Hover over row headings to see the hint window with the corresponding enlarged structure. [[Image:Spreadsheet_Hint.png|right]] 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. 
# Click on the column heading to select the entire column. Double-click to open the column rename dialog window. [[Image:Column_rename.png]] 
# 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. 
# 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. 
# 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. 
# 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. 
# 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.