Grids

Many pages have spreadsheet-like grids; these work in a similar way to common spreadsheet applications such as Microsoft Excel.

Note: There are two types of grid in AVEVA Unified Supply Chain: the simpler, legacy type described in this section, and a more advanced type described in Advanced Grids.

You can transpose a grid (that is, turn rows into columns and columns into rows) in two ways:

• Right-click anywhere in the grid and choose Transpose from the context menu.

• Click the Transpose icon () in the status bar at the bottom of the AVEVA Unified Supply Chain window.

Note that not all grids support being transposed.

You can export a grid to Excel by clicking the icon in the status bar at the bottom of the AVEVA Unified Supply Chain window.

You can zoom in and out by using the slider and buttons in the bottom right corner of the AVEVA Unified Supply Chain window. Click the percentage zoom value to reset the zoom to 100%.

You can resize any row or column by dragging their borders. To restore the original widths and heights, right-click anywhere in the grid and choose Reset Sizes from the context menu.

You can select any rectangular portion of a grid by clicking on a cell, and dragging to the opposite corner.

Use the following shortcuts when you have a number of cells selected:

• Delete all the contents by pressing the Delete key, or by clicking Cut in the Clipboard group of the Home ribbon tab.

• Press the space bar to toggle the status of all check boxes in the selected cells.

Manage views

You can configure many aspects of a grid, such as the columns that are shown, their widths and their names. You can save these settings as a view, which you can then select from the View menu near the top right corner of the grid. Each grid has one or more predefined views, and you can add your own. Click the button next to the View menu to open the View Manager, from which you can edit your views and create new ones. Note that you cannot change predefined views.

In the Columns tab, use the buttons next to the View drop-down list to create, copy, rename and delete views.

Use the buttons below the list of columns on the left-hand side of the tab to add, remove and move columns.

You can sort the items in a view according to the contents of up to three columns. In the Sorting tab choose the columns to use for sorting from the three drop-down menu. Select either the Ascending or Descending option button in each case to set the sorting order. Click Clear All to remove all custom settings from the Sorting tab.

Filter grid contents

You can filter the data shown in a grid by selecting one of the available filters from the Filter menu near the top left corner of the grid.

To create and edit your own filters, click the button next to the Filter menu. This opens the Filter Manager.

Use the buttons at the top of the window to add, copy, rename and delete filters.

Each filter is made of one or more criteria. Each criterion correspond to a row in the table shown in the Filter Manager. Follow these steps to add a criterion:

1. Double click the cell in the Field column. From the list that appears, choose the view column to which the criterion applies.

2. Double click the cell in the middle column of the table. Choose one operator to filter the contents of the selected view column. Examples are <, >, =, Contains, True and False.

3. In the Criteria column enter a value to complete the expression.