Dropdown Menus - EcoSys - 3.02 - Help - Hexagon PPM

EcoSys Contracts Help (3.02)

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Standard Version
3.02

Sheet Dropdown

The Sheet dropdown consists of the following options:

  • Save records all updates to the spreadsheet cells.

  • Refresh will reload the spreadsheet.

  • Report will launch the EcoSys reporting engine and generate a report from the data displayed in the spreadsheet. This option often has a larger volume limit than the Sheet > Export to Excel option.

  • Import will allow the user to import an Excel spreadsheet or tab-delimited text file. This option is only displayed for those EcoSys spreadsheets for which import capability is enabled.

  • Export to Excel will export the EcoSys spreadsheet to an Excel Spreadsheet.

  • Export to Text will export the EcoSys spreadsheet to a .txt file.

To export a spreadsheet as a text format such as RTF, CSV, etc., select Report and choose the desired export format.

Edit Dropdown

The Edit dropdown consists of the following options:

  • Cut or Copy a cell value and Paste into a different cell within EcoSys or to/from desktop spreadsheet applications.

  • Fill Down, Fill Down All, Fill Up, Fill Right, or Fill Left to auto-populate the selected adjoining cells with the same value.

  • Clear Values removes data from the selected cells.

The Fill Down All option is available only in the Edit menu and will fill down across all rows loaded in the spreadsheet, not just the rows currently being displayed via paging controls.

Display Dropdown

The Edit dropdown consists of the following options:

  • Show/Hide Columns option.

  • Auto Size Left Columns allows the application to resize the columns on the left side of the screen (only available if Splitter is visible on the screen).

  • Reset Column Widths will reset the columns widths to values assigned by the spreadsheet designer.

  • Spreadsheet Metrics displays data related to time and volume of data loaded by the spreadsheet. Refer to the Spreadsheet Browser Metrics section below for additional information.

  • Show Filter enables the Display Filter. Refer to the Display Filter section below for additional information.

  • Add to Display Filter: Within a data cell, Ctrl+Shift+A will copy the data up to the Display Filter.

  • Clear Filter will clear all filter values.

  • Show Paging Bar displays the paging bar at the bottom of the spreadsheet. Deselect this option to hide the bar.

  • Display row capabilities are: Show All Rows, First Page, Previous Page, Next Page, Last Page.

  • Zoom capabilities are: Zoom Out, Zoom In, and Zoom Reset.

Many of the items available in the Display menu are also present in the Tool Bar.

Rows Dropdown

The Row dropdown consists of the following options:

  • Edit Row Details launches a separate pop-up that provides access to all potential row values. (This option is not recommended and may be deactivated within the spreadsheet configuration.)

  • Duplicate will create an exact copy of the selected row with all fields completed with the same information.

  • Insert to insert a blank row.

  • Select Insert Multiple to insert multiple blank rows. Enter the desired number of new rows in the pop-up, then click OK.

  • Select Insert Under to add an additional line item under the selected parent or an item that will be assigned the value of the group band, depending on the spreadsheet configuration. This is available only to grouped data and hierarchical mode spreadsheets.

  • Insert Multiple Under will insert multiple rows under the selected parent or multiple items that will be assigned the value of the group band row, depending on the spreadsheet configuration. Enter the desired number of new rows in the pop-up, then click OK. This is available only to grouped data and hierarchical mode spreadsheets.

  • Select Delete to remove an entire row from the spreadsheet. Click OK to confirm the deletion, otherwise click Cancel in the pop-up that appears. Once saved, data cannot be retrieved.

Right Click Menu

Right click in the spreadsheet area and a dropdown menu will be displayed. The available options consist of select commands discussed above.