Matrix

en
Control Elements:
  • Matrix Checks
    Detects logical problems in the selected matrix
    Menu:
    • Check Now
      Detects logical problems in the selected matrix
    • Reset
      Resets the highlighted areas in checked matrices
    • Tasks Report
  • Partition Matrix
    Build partitions by re-arranging rows and columns
  • Show Partitions
    Show partitions in the current matrix
  • Sort Diagonal
    Sort matrix diagonal using primary relations
  • Synchronize Matrix
    Calculate values of groups

Structure

en
Control Elements:
  • Create Snapshot
    Creates a snapshot from the current tree
  • Synchronize Snapshot
    Gets the changes made to the original tree
  • Replace List
    Replaces this tree
  • Reset
    Restores the original tree if a subset had been selected before
  • About Snapshots
    More information about snapshots

Formulas

en
Control Elements:
  • Insert Function
    Inserts a formula
  • Show Formulas
    Shows all formulas of the selected workbook
  • Auto Recalculate
    Toggles automatic recalculation
  • Trace Precedents
    Find formulas that change the cells value
  • Highlight Calculated
    Highlights calculated cells
  • Trace Dependents
    Find formulas that depend on the selected value
  • About Formulas
    More information about formulas

Snapshots

en
Control Elements:
  • Create Snapshot
    Creates a snapshot from the current list
  • Synchronize Snapshot
    Gets the changes made to the original list
  • Select
    Select a list from the set of compatible lists
  • Reset
    Restores the original list if a subset had been selected before
  • About Snapshots
    More information about snapshots

Functions

en
Control Elements:
  • Insert Function
    Inserts a formula
  • Show Formulas
    Shows all formulas of the selected workbook
  • Auto Recalculate
    Toggles automatic recalculation
  • Macros
    Execute a macro function
  • Trace Precedents
    Find formulas that change the cells value
  • Highlight Calculated
    Highlights calculated cells
  • Trace Dependents
    Find formulas that depend on the selected value
  • About Formulas
    More information about formulas

Browse

en
Control Elements:
  • Objects
    Show the objects defined in this workbook
  • Script
    Opens the user defined function module of the current workbook
  • Functions

Feedback

Did you find what you needed?

If you have any further questions or suggestions to improve this page, please let us know:

=