Render using Cell References

Renders the selected cell by using the absolute cell references. Therefore, if a formula uses a Name that refers to a cell or range, then it is converted back into the 'A1' reference style.

Appearance

• Variables that refer to the cell using the 'A1' style coordinate system (i.e. column letter followed by row number) are shown in Green text by default (all color defaults can be changed in settings).
• Named Excel cells, which can be used to refer to specific cells within a formulas, are replaced with the 'A1' style cell reference in the rendered equation - useful for finding the exact cells that are being referenced.

---

Commond to buttons:
• Function names, e.g. sin() or min(), are shown in Dark Red text by default.
• Constant values, operators and other symbols are shown in Black by default.

Usage

New Equations

With new rendered equations, the system will use the current defaults. These include all the formatting pane options and the current state of the following buttons:

• Display Assignment ()
• Display Units ()
• Box ()

Existing Equations:

Where there is an existing rendered equation for a formula, the default action is to reuse as many of the properties from the previous equation as possible, including the:

• Display Assignment ()
• Display Units ()
• Box ()
• Its position and size. An equation can be dragged anywhere on the same sheet and resized; rendering it again replaces it where you put it rather than moving it back.
• The size it is set at
• The Style (Excel, Math, Matrix)

Locking a button on: hold ⌘ on a Mac, or Alt on Windows, while pressing Ref to turn the button on or off without rendering anything. Left on, it is added to every equation you render afterwards, alongside whichever other form you choose — so Ref and Value together give an equation that shows both. The button's own tooltip names the key for the machine you are on.

ctrl still works everywhere, which is what the Windows add-in used. On a Mac it is the one key that cannot be offered, since ctrl-click there opens the context menu instead.

Updating: All features of any rendered equation can be changed, by selecting one or more rendered equations (or formula cell) and clicking the alternative formatting required from the toolbar.

Note: These Usage instruction apply equally to all the main Rendering buttons.

Example 1

Download the 'Example spreadsheet' and follow these steps:

• Select tab 'Example 1'
• Select cell C5, which contains the formula "=(C2*C3)/SQRT(C2^2+C3^2)".
• Click the Cell Reference (Ref) button in the Render section.
• The rendered equation will appear in the first empty space to the right of the selected cell.