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:

=