Using Datagrid

Datagrid is used to display data in tabular format (similar to Excel worksheet).

• Datagrids in the Main Form are read-only ie displayed data can not be changed directly in the datagrid, instead one of the menu-item in the [ Record ] Menu (such as [ Record > Edit ] should be used.
• Datagrids used in the Setup Form allows to change value directly in the datagrid.

Illustrative snapshot (Toolbar):

1. Click here to select all the cells (ie entire rows and columns) of the datagrid. Rows can be selected using one of the following options as well.
   • Use CTRL + Click to select individual row
   • Select a row and then SHIFT + Click to select group of rows 
   • Click on Row select and DRAG mouse to select multiple row
2. Any column in the datagrid can be drag and drop to different position.
3. It indicates that the data grid is sorted by Site Name on Ascending Order
4. [ Right Click ] in the data grid to activate context menu of the datagrid.
5. Select one or more rows and click this menu to view data in [ Column Name: Value ] format.
6. Copy selected rows and paste in Excel.
7. Resize width of all the columns to fit content of each cell.
8. Resize height of all the rows to fit content of each cell.
9. Enter a value to search in all the cells of the datagrid. When a match is found, the background column of the cell is changed.
10. Press [ CTRL + F ] to find again the next match
11. Click it to remove all the search-highlights.

1. Double click on a cell of datagrid to copy its content to clipboard so that cell content can be paste in any application. It can be useful to copy genotype, pedigree, trial acronym and many more.
2. Click auto-resize width to reset the width of the column based on its contents (data).
3. Click on auto-resize height to reset height of all the rows based on its content (data) and current column width.