Spreadsheets

In models of the Spreadsheet type you can carry out evaluations and calculations. In addition, you can use this model type if you wish to specify large amounts of attributes.

You can use models and objects that already exist in ARIS as occurrences in models of the Spreadsheet type.

Create spreadsheet

You can create models of the Spreadsheet type and make calculations in a spreadsheet.

Prerequisite

The model type that your model is based on is allowed by the method filter used. You select the method filter when you log in to the database.

Procedure

  1. Click Application launcher Application launcher > Models and objects Models and objects.

  2. Click Create model.

  3. Click the group in which you want to create the spreadsheet or create a new group.

  4. Select Spreadsheet Spreadsheet.

  5. Enter the relevant name.

  6. Click OK.

The spreadsheet is created in the selected group and opened for editing on a new tab.

Add contents to a spreadsheet

You can write contents directly in the cells of your spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click Contents.

  3. Click the cell for which you want to add the content.

  4. Click Insert object Insert object. The dialog opens.

  5. Select the relevant content.

  6. Click OK.

You have added contents to your spreadsheet.

Calculate values in a spreadsheet

You can calculate numerical values directly in your spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click Contents.

  3. Select an empty cell.

  4. Select Insert formula Insert formula. Or enter the relevant formula, for example, =SUM(C10;C13).

  5. Press Enter.

The result of the calculation is displayed in the cell.

You can also calculate with attribute values of ARIS objects in this way.

Example

Calculate the sum of three cells containing the values 10, 14, 10, and 30.

Sum

Add attributes to a spreadsheet

You can add attributes to a spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click Contents.

  3. Click the relevant cell in the spreadsheet. The cell contents of a selected cell is overwritten without confirmation prompt.

  4. Click Add attribute property Insert attributes. The Select attributes dialog opens.

  5. Click the relevant attribute.

  6. Click OK.

You have added the attribute to the spreadsheet.

Specify row height

You can specify the row height of your spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. In the row header, drag the mouse pointer to the border of a cell. The mouse pointer shows the directions in which you can drag the bar border:

    Specify row height

  3. Keep the mouse button pressed, drag the mouse pointer until the desired height is reached and release the mouse button.

    To adapt the row height exactly to the content height, double-click the cell border.

You have specified the row height of a row.

Specify column width

You can specify the column width of your spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. In the column header, drag the mouse pointer to the border of a cell. The mouse pointer shows the directions in which you can drag the bar border:

    Specify column width

  3. Keep the mouse button pressed, drag the mouse pointer until the desired width is reached and release the mouse button.

    To adapt the column width exactly to the content width, double-click the cell border.

You have specified the column width of a column.

Insert row or column

You can add a row or a column to your spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click the a cell of a row or column.

  3. Click Insert cell Insert cells > Insert row above or Insert cell Insert cells > Insert row below Insert row below to insert a row above or below the selected row. Click Insert cell Insert cells > Insert column left or Insert cell Insert cells > Insert column right Insert column right to insert a column left or right to the selected column.

The new row or column is inserted.

Insert objects

You can add objects to a cell.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click Contents.

  3. Click Insert object Insert object. The dialog opens.

  4. Select the object that you want to add to the spreadsheet.select You can type the beginning of the object name to find the object.

  5. Click OK.

An occurrence of the object is now available in your spreadsheet.

Cut object

You can cut an object from a cell.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Select a cell that contains the object you want to cut.

  3. Click Cut Cut.

The object is added to the clipboard.

You can insert the object in any empty cell by selecting the cell and clicking Past Paste. Then, the object is cut out and pasted to the selected cell.

Copy and paste object

You can copy an object in a cell.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Select a cell that contains the object you want to copy.

  3. Click Copy Copy.

The object is copied to the clipboard.

You can insert the object in any empty cell by selecting the cell and clicking Paste Paste.

Save a spreadsheet

You can add objects to a cell.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Make you changes.

  3. Click Save Save.

The spreadsheet is saved.

Show/Hide header

You can show or hide the header of a spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click Contents.

  3. Click Header.

If the header was displayed, it is now hidden and vice versa.

Merge cells

You can merge cells.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Select the cells you want to merge.

  3. Click Merge. If the selected area contains any content, the content is deleted a dialog to confirm the merging opens. Only content of the top left cell of selected area will preserve after the merge.

The selected area of the spreadsheet is merged.

To unmerge, select the merged area and click Unmerge.

Hide columns or rows

You can hide columns or rows temporarily.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Activate the Start tab bar.

  3. Select the columns or rows you want to hide. Select multiple rows or columns by holding down the Shift key and clicking the first and last row or column. You can select rows or columns that are not adjacent by holding down the Ctrl key.

  4. Click Hide Visibility > Hide column(s) or Hide Visibility > Hide row(s).

The columns or rows are no longer displayed.

To display the rows or columns again, click Hide Visibility > Show column(s) or Hide Visibility > Show row(s).

Delete content

You can clear the content of cells. The cell format and conditional formatting of the cells are retained.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Select a cell.

  3. Click Delete Delete cells.

    • Select Delete Delete cells to delete the selected cell.

    • Select Clear formatting to remove the formatting but preserve the content of the cell.

    • Select Clear formatting and content to remove both the formatting and the content of the cell.

    • Select Delete rows Delete rows to delete the complete rows of the selection.

    • Select Delete columns Delete columns to delete the complete columns of the selection.

You have deleted the contents of the selected cells. The objects or attributes are still available in the database.

Delete row or column

You can delete rows or columns from a spreadsheet.

Warning

Deleting rows deletes all the contents of those rows.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Select the rows or columns you want to delete.

  3. Click Delete cells > Delete row(s). to delete rows. Click Delete cells > Delete column(s). to delete rows.

The selected row(s) or column(s) including their content are deleted without further confirmation.

Protect an area of a spreadsheet

You can protect areas of a spreadsheet to prevent people from changing, moving, or deleting important data.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    • You have the ARIS Connect Designer license privilege.

    • The model type is allowed by the method filter in use.

    Procedure

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Published content Published content.

    3. Click Groups in the Classic or Processes in the Default configuration set.

    4. Select the group or process area containing the required model. The content of the selected group or process area is listed.

    5. Click the name of the relevant model.

    6. Click Diagram if you want to display the model graphically.

    7. Click Edit Edit > Edit model Edit model.

    1. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    2. In the database, select the group containing the relevant model. The content of the selected group is listed.

    3. Click the name of the model you want to open.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click Application launcher Application launcher > Models and objects Models and objects. The Models and objects view in the repository is opened.

    3. Click Recent changes Recently used. All models are listed that have recently been changed or created.

    4. Click the tile of the model you want to open.

    You can select models in the Published content Published content view and open them for editing in a separate tab.

    Prerequisite

    You have the ARIS Connect Designer license privilege.

    Procedure

    1. Click Application launcher Application launcher > Published content Published content.

    2. Click Groups in the Classic or Processes in the Default configuration set.

    3. Navigate to the relevant model.

    4. Click the name of the model you want to edit.

    5. Click Edit Edit > Edit model Edit model. The model opens on an individual tab.

    6. Make the required changes.

    7. Click Save Save.

    Your changes are saved in the model.

    1. If you are authorized to use multiple databases, select the database containing the contents you want to access.

    2. Click the Find Search field and enter a term that is included in the model name. The search results list all models that have the term in their name.

    3. In the Models category, click the name of the model you want to open.

    The model opens on a separate tab.

  2. Click Contents.

  3. Select the area of the spreadsheet you want to protect.

    You can select an entire row or column by clicking the row or column header. You can select rows or columns that are adjacent by holding down the Shift key.

  4. Click Locked items # Protect.

The area of the spreadsheet is now protected from editing. To be able to edit this area again, select the area and click Unlock Unprotect.