The worksheet presents you with information about objects in the tree in the form of tables, charts and text, thereby supplementing the Details view. It is typically intended to summarize data for a collection of objects (for example, the Connections folder worksheet reveals the inputs for all contacts, joints and others) or to receive tabular inputs (for example, to specify the coefficients and the analyses to include in Solution Combinations).
Behavior
Dockable Worksheet
By default, when you select an applicable object in the tree, a dockableWorksheet window displays alongside the Geometry window, allowing you to review both at once. You may, however, disable the display of the Worksheet window using the Worksheet option (see below). This preference is persisted in future sessions of the product. There are specific objects that ignore the preference, as outlined below.
Worksheet Function Worksheet Behavior When Object is Selected Example Objects Data input and display information Automatically appears and gains focus Constraint Equation, Solution Combination Display information related to object settings Automatically appears but does not gain focus Analysis Settings Display information related to objects within a folder Appears only if display is turned on manually using the Worksheet option (see below) Geometry folder, Contact folder Worksheet Option
For tree objects that include an associated Worksheet, the Worksheet option of the Views group on the ribbon enables you to toggle the Worksheet window display on or off. The option is not available (grayed out) for objects that do not include a Worksheet.
Worksheets designed to display many data items do not automatically display the data. The data readily appears however when you click the button. This feature applies to the worksheets associated with the following object folders: Geometry, Coordinate System, Contact, Remote Points, Mesh, and Solution.
Features
Go To Selected items
This useful feature enables you to find items in either the tree or Geometry window that match one or more rows of the worksheet. If the worksheet displays a tabular summary of a number of objects, select the rows of interest, right-click, and choose to instantly highlight items that match the contents of the Name column (leftmost column). Control is therefore transferred to the tree or Geometry window, as needed.
When a worksheet includes a table with multiple columns, you can control which columns to display. To do so, right-click anywhere inside the table. From the context menu, check the column names of interest to activate their display. Some columns may ignore this setting and remain hidden should they be found inapplicable.
To choose the columns that will display, right mouse click anywhere inside the worksheet table. From the context menu, click any of the column names. A check mark signifies that the column will appear. There are some columns in the worksheet that will not always be shown even if you check them. For example, if all contact regions have a Pinball Region set to Program Controlled, the Pinball Radius will not display regardless of the setting.