Display Workspace Columns and Rows

Owned by Pamela Totas (Deactivated)
Last updated: Jul 06, 2023
4 min read

In Eagle workspaces, you can manage how data columns are displayed, arranged and grouped. You can freeze or unfreeze panes or specific columns, or select additional columns to be displayed. You can also sort column data displayed in the workspace, use custom filters to customize which data is displayed based on specific criteria, display row numbers and vertical lines in the workspace, and view rows in the workspace vertically for easy readability.

Display Workspace Columns

To customize how workspace columns are displayed:

  1. In the workspace in which you working, click on the Grid tab.

  2. Click the column header. The column data is sorted in descending order by default. To sort the column data in ascending order, click the column header. To revert the view of the column values to descending order, click the column header again.

  3. Click the three red lines  in the top row of the first column to display a drop down menu.

  4. From the drop down menu, select one of the options listed below.

  5. To change the location of a column, drag and drop the column header from its original location to a new location.

  6. To change the column characteristics, click the arrow in the top right corner of the column header. You can sort, add, remove, freeze, find, and filter the column, as well as set date filters.

  7. To clear all custom settings, click Restore Defaults.

 

Option

Description

Option

Description

Columns

 Select the column(s) to display in the data grid by checking next to its name.

Select All

 Selects all columns

Clear All Filters

 Clears all filters applied

Unfreeze

 Unfreezes panes

Expand All

 Expands all group entries

Collapse All

 Collapses all group entries by column values

Fit to Header

 Adjusts the column to width of the header

Fit to Data

 Adjusts the column to width of the data

Restore Defaults

 Restores default settings

 Refresh

 Refreshes settings


Rearrange Workspace Columns

To rearrange workspace columns:

  1. In the workspace in which you are working, click the Grid tab.

  2. Click Columns.

  3. Click to select a column name to display it. If the column name has a check mark next to it, it will be displayed. If there is no check mark, it will not be displayed.

  4. To rearrange the column order, click More on the Columns drop down.

  5. Click Add to add a column, or click Remove to remove a column.

  6. In the Selected columns pane, click the column name that you want to rearrange. Move the column up or down by clicking the Up or arrows.

  7. Click OK to save the column order changes or click Cancel to revert to the original column order.

  8. To clear all custom settings, click Restore Defaults.

Freeze/Unfreeze Columns

To freeze/unfreeze workspace columns:

  1. In the workspace in which you are working, click the Grid tab.

  2. Click Freeze Columns.

  3. Place the cursor in a data column and select Freeze Selected Columns to freeze that column or select Freeze First Column to freeze the first displayed column in the workspace.

  4. To unfreeze, click Unfreeze Panes on the ribbon.

  5. To clear all custom settings, click Restore Defaults.

Sort Columns

To sort workspace columns:

  1. In the workspace in which you are working, click the Grid tab.

  2. Click Custom.

  3. In the Sort dialog box, if there are no existing columns, click the Define columns to sort by link.

  4. Click the Sort item by drop down and select a column. Click the Ascending/Descending drop down and select a sort order.

  5. Click to add additional sort levels. Click to delete sort levels.

  6. Click Save to save the sort options.

  7. To clear all custom settings, click Restore Defaults.


Display Row Numbers and Vertical Lines

To display row numbers and vertical lines:

  1. In the workspace in which you are working, click the Grid tab.

  2. Click to select a row in the workspace and click the Show drop down.

  3. Click Row Numbers to toggle the display of numbers for all workspace rows.

  4. Click Vertical Gridlines to toggle the display of vertical lines between workspace columns.

View Row Details

To view row details:

  1. In the workspace in which you are working, click the Home tab.

  2. Click to select a row in the workspace and click View Row.
    You see the View Row dialog.

    View row dialog

  3. In the View Row dialog the row details are displayed in vertical format. You can navigate backward and forward through all the rows in the workspace by using the Previous Grid Row and  Next Grid Row arrows.

  4. The following options are available in the View Row dialog.

  5. Click Close.

Copy Workspace Data via the Clipboard

In Eagle workspaces, you can copy, cut, and paste data from the workspace to the clipboard and subsequently to other areas of the center you are working in.

To copy and paste data via the clipboard:

  1. In the workspace in which you are working, click the row which you want to copy.

  2. Click Copy on the ribbon.

  3. Navigate to an area in the workspace where you want to paste the data and click Paste.