Displaying the relationships between cells

<< Click to Display Table of Contents >>

Displaying the relationships between cells

FreeOffice: Formula auditing is not included in SoftMaker FreeOffice.

The command group Formula | Traces provides commands with which the relationships between cells can be graphically represented.

traces_sample

To do so, select the cell that you want to analyze, and then choose one of the following commands in the command group Formula | Traces:

traces_group

Note: The commands Trace to error, Previous error, Next error are described in the next section Detecting errors in calculations.

traces_pre_icon Trace predecessors

This command displays arrows for all cells to which the formula in the current cell refers.
Example: If the current cell contains the formula =A1*A2, this command will display arrows from cells A1 and A2 to the current cell (see figure above).

traces_pre_icon Trace predecessors dropdown_arrow | Select predecessors

This command selects all cells to which the formula in the current cell refers.
Example: If the current cell contains the formula =A1*A2, this command will select cells A1 and A2.

traces_remove_all_icon Remove all traces dropdown_arrow | Remove traces to predecessors

This hides all arrows that were added with the command Trace predecessors for the current cell.

traces_succ_icon Trace successors

This displays an arrow to each cell that refers to the current cell.
Example: If a cell contains the formula =B5*2, this command will display an arrow pointing to this cell when you choose the command in cell B5.

traces_succ_icon Trace successors dropdown_arrow | Select successors

This selects all cells that refer to the current cell.
Example: If any cell contains the formula =B5*2, this cell will be selected when you choose the command in cell B5.

traces_remove_all_icon Remove all traces dropdown_arrow | Remove traces to successors

This hides all arrows that were added with the command Trace successors for the current cell.

traces_remove_all_icon Remove all traces

This removes all arrows added with the commands Trace predecessors or Trace successors for the entire workbook.
Click directly on the icon itself or use the icon's arrow and select Remove all traces in the dropdown menu.

Notes and tips

If desired, you can choose the commands Trace predecessors and Trace successors several times in succession in a cell. Each call displays another level of relationships.

The arrows that can be displayed with the above commands are clickable. If you click on such an arrow, PlanMaker will jump to the cell at the other end of the arrow.

If the current cell refers to a cell that is in another worksheet, only a small arrow will be displayed in the top left corner of the cell. You can also click on this arrow to quickly jump to the corresponding cell.

When you edit, delete or move the contents of a cell, all arrows to that cell are automatically removed.

All displayed arrows also appear in the printout.

However, the arrows are not saved in the document. Thus, when you save a document and then reopen it, all arrows are removed.