Displaying a Model in the Spreadsheet

You can browse and edit the data of the active objects that are displayed in the Spreadsheet.

This task shows you how to:

See Also
About the Spreadsheet

Navigate with the Navigation Bar

You can navigate through your model using the Navigation Bar.

This immersive bar:

  • Displays the full path of an active object
  • Lets you activate an object

To activate:

  • A parent object: click its name in the full path
  • A child object: click the arrow on the right of an item, then select the object

Important: The final object displayed from the Navigation Bar is always the active one.
Tip: If the path is too long to be displayed in the Navigation Bar, the first items are hidden. Click the double-arrow on the left to display the root path.

Select, Multiselect, or Activate an Object

To edit one or more objects in the active object, you can select or multiselect items from the tree or from the Spreadsheet table.

  1. To activate an object and display its content in the open Spreadsheet, double-click the object in the tree or use the navigation bar.
  2. To activate a subcomponent of the active object, double-click it in the Spreadsheet.
  3. To select the subcomponent of an active object, click a cell.
  4. To multiselect the subcomponents of an object, hold down Ctrl or Shift and click the cells.

Expand/Collapse the Rows

You can select a view mode to show or hide the hierarchy of your model.

  1. Select Collapse All Rows in the title area.
    The rows are collapsed, and the first level only is displayed.
  2. Select Expand All Rows in the title area.
    The rows are expanded, and all sublevels are displayed.
    Note: You can double-click the command to choose the numbers of levels you want to expand.

Switch Between Hierarchical View and Flattened View

You can select a view mode to show or hide the hierarchy of your model.

  1. By default, Hierarchical View is selected.


  2. Select Flattened View to display all the subcomponents on the same level.


Display Edition Rights

You can identify the editable cells in the spreadsheet.

By default, the edition right view is not activated.

  1. Select Activate Edition Rights View .
    Editable cells are displayed with a white background.

  2. Select Deactivate Edition Rights View .

Filter Values in Columns

You can filter the string, Boolean, integer or double values in a column.

Two filtering modes are available:

  • Basic filter: enables you to select/unselect the values to be displayed.
  • Advanced filter: enables you to compare operators (example: to display only the values that are greater than "2.0").

Note: These options are kept when reopening your model.

  1. Pause over a column with your pointer.
    The Column Filter command appears.
  2. Click Column Filter.
    The list of the values contained in the column appears and all the values are selected.
  3. Clear the values you do not want to display.
  4. Click anywhere outside the table.
    The filter column window disappears and the filter is applied. Only the selected values are displayed.
    Important:
    • The Column Filter command is now persistent in the column title. This indicates that this column does not display all its elements.
    • In a hierarchical view, when a parent object is filtered, its children are hidden by the filter.
  5. Click Column Filter again.
    All values are still listed, you can select another value.
  6. Select Custom Filter.
    The Custom Filter dialog box appears, and lets you select a comparison operator from the list.

    Example of an Operator list:

    • Begins with
    • Does not begin with
    • Ends with
    • Does not end with
    • Contains
    • Does not contain
    • ...

  7. Select a reference in the list.

    Example of a Reference list:

    • Electrical Logical Connector
    • Electrical Logical Net
    • Logical Component Instance DS

  8. Click Apply to close the Custom Filter dialog box and apply your filter.

    Important: Filters are applied on the current view (hierarchical, flattened, search or import views). When changing the view for another one (for example, when performing a search), the filters are not kept.

Organize Columns and Rows

You can select the columns to be displayed in the table, reorganize them and sort rows alphabetically. The selected columns are visible whatever the operation performed (expand/collapse, creation, modification...).

Note: These options are kept when reopening your model.

  1. Right-click a column header.
    The column chooser appears.
  2. Select or clear the columns you want to display.

    Tip: Click to select/deselect all columns.

  3. Click the Up or Down arrows to modify the list order. (This does not modify the order in the Spreadsheet).
    • to move the selected columns on the left in the Spreadsheet table.
    • to move the selected columns on the right in the Spreadsheet table.
  4. Click anywhere in the app to close the context menu and apply your criteria.
    Tip: You can drag and drop one or more columns using the Ctrl key to reorganize them.
  5. To sort alphabetically or reversely the values in a column, click the column title then click the up or down black arrow.
    Tip: You can drag and drop the rows in the table to reorganize the structure.

Deactivate Columns

You can deactivate columns to prevent the computation of some properties. Deactivating columns optimizes the Spreadsheet performance.

  1. Right-click a column header.
    The column chooser appears.
  2. Click Expand to display the Deactivated Columns section.
  3. Select a column, and then click Deactivate .
    In the list of deactivated columns, a color code indicates if the deactivated content is relevant to the active object:
    • : the properties are used in the context of the active object. Therefore, the deactivated content is relevant in the current Spreadsheet.
    • : the properties are not used in the context of the active object. Therefore, the deactivated content is not relevant in the current Spreadsheet.
  4. Click anywhere in the app to apply your selection.

Notes:
  • Your selection is stored in the Spreadsheet preferences.
  • The content of deactivated columns is not displayed in search results.

Search in the Spreadsheet Table

In the Spreadsheet, a search bar enables you to search and display data in the table.

  1. To search data, choose one of the following methods:
    • Enter a search string in the search box.
      Note: The case is insensitive.
      Tip: You can use search operators (and concatenate them, if need be):
      • "&" to include one or more queries in the results
      • "-" to exclude one or more queries in the results
      • "|" to search for at least one of the queries in the results
      • No space between word and operator is needed
    • Click the down arrow in the search box to display your search history and select a search string.

  2. Right-click Search to select search options:
    • Match Case: to display the results that match the case of your search string
    • Selected Rows: to display the results from selected rows only
    • All Rows: to search in all rows (visible and hidden)
    • All Columns: to search in all columns (visible and hidden).

    Note: Checked options are saved for your next search.

  3. Click Search to launch the search.
    The results appear in a search view.
  4. Click to leave the search view.

    Note: You can also double-click an object to switch to the hierarchical/flattened view and automatically scroll the table to the position of the object.

Grouping Nodes

If the Grouping node for tree option is selected from Me > Preferences>3D Modeling > Systems Architecture > Product Structure Design > Display tab, then objects with the same attribute are grouped under a specific node, in the work area and in the Spreadsheet tree.