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
More help on this topic

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.

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 .

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.