About the Spreadsheet

The Spreadsheet lets you display an object and edit its content.

You can:

Browse the properties: name, type, path...
Edit objects
Insert a new object
Use any command available in the current app
Display additional information with a B.I.

This page discusses:

Description
Spreadsheet Commands

Description

The Spreadsheet is an alternative to a 2D or 3D display.

The Spreadsheet is divided into five areas:


	Area	Description
	Navigation Bar	Displays the path of the active object. In the Spreadsheet, you can use this bar to navigate through an entire model without using the tree. See Navigate with the Navigation Bar.
	Spreadsheet Commands	See Spreadsheet Commands.
	Properties	Subcomponents All the subcomponents of the active object are listed in rows. The first row is the active object. Properties The properties of the subcomponents are listed in columns. All the properties of all objects are listed in the Spreadsheet. (R) in the column indicates that this property is related to the reference. The Mandatory icon indicates that this property is mandatory. The Identifier icon indicates that this property is part of the identifier set. Except for Display Name, Path and Type, the properties can be edited, as soon as the object is editable.
	Hierarchical View Flattened View Edition Rights View	See Switch Between Hierarchical View and Flattened View and Display Edition Rights.
	Search bar	See Search in the Spreadsheet Table.

Spreadsheet Commands

All the commands that are available in the work area of the current app are also enabled in the Spreadsheet. Furthermore, additional commands are provided to edit your model or customize the Spreadsheet.


Icon	Properties
	Insert New Row Creates an empty row on the same level as the selected object. See Creating an Object in the Spreadsheet.
	Insert New Child Creates a row under the selected object. See Creating an Object in the Spreadsheet.
	Duplicate Row Creates a new instance of the selected reference, i.e. to duplicate the selected row. See Creating an Object in the Spreadsheet.
	Insert Existing Object Inserts an existing object from the tree, the work area or from a Search. See Insert an Existing Object.
	Anchor Balloon By default, Anchor Balloon is active and the row insertion commands are displayed in the title area: . When this option is not active, these commands are displayed above a selected cell. See Creating an Object in the Spreadsheet.
	Display/hide additional properties Displays the properties that have been hidden. See Displaying a Model in the Spreadsheet.
	Expand All Rows Displays the sublevels of the active object. See Expand/Collapse the Rows.
	Collapse All Rows Hides the sublevels of the active object. See Expand/Collapse the Rows.
	Export to File... Exports the Spreadsheet table into a excel or a .csv file. See Exporting a Spreadsheet.