Explorer Pro Form Components

Formula Box

The formula box shows you the indented view of the formula.
When you click into the formula the sub-expression you clicked is selected in the Expression Treeview and Source/Results boxes and shows a blue background. If the expression can be resolved to a reference it is selected.

Clicking anywhere in any of these three boxes selects the expression in all 3 boxes.

Results Box: Shown when the Color and Filter button is clicked

Clicking the Filter button shows the results box if the selected reference resolves to more than one cell.

The results box shows the results of evaluating the sub-expression. For sub-expressions returning arrays of results by default only the first 200 rows or columns are shown.
The results can be filtered by type using the filter drop-down. Toggle the filter on or off using the Filter checkbox (Alt-T).
 
The size of the result array is shown as the number of rows and columns ( [RxC] ) before and after filtering.

Three Dimensional references are shown as number of sheets by number of rows by number of columns ( [S x R x C] ).
When showing filtered results the row and column numbers of the results are shown as Rn and Cn.

Three-dimensional references show results with a vertical bar | between adjacent sheets.

Clicking in the results box selected the rows on the worksheet that are shown in the results box.

Expression TreeView/Precedents Box

This box shows a treeview of subexpression components of the formula.
In Precedents mode it shows a list of all the precedents of the formula.
 

Result/Source/Reference Box

This box shows the result of the expression if it is a single value, or the range reference that is the result of the expression.

Splitter Bars

Drag the splitter bars to expand or contract the amount of space given to the Formula Box, Results Box, Expression TreeView box and the Source/Reference Box

Resizing the Form

To resize or move the Explorer Pro form using the keyboard use:

F5 or Control + on the numeric keypad increases the size of the form

F6 or Control - on the numeric keypad decreases the size of the form

F7 or Ctrl Home noves the form to the centre of the screen and resizes it to the default size.

F8 or Ctrl End moves the form to the bottom right

You can drag the drag button in the bottom right corner of the form to resize it horizontally or vertically.

The information in the formula box and result box reflow as the boxes resize.

Copyright © 2020 Decision Models Ltd