6.1. Spreadsheet menu

Note

As of XMLmind XML Editor v5.8, the integrated spreadsheet engine is implemented as an add-on. Therefore, what follows is available only when add-on "Integrated spreadsheet engine" has been installed.

Show Table Labels

Makes tables look like spreadsheets by adding A1-style labels to their columns and to their rows. This is very useful when you want to type cell references such as A1:C3 in a formula.

Insert/Edit Formula

If a formula (xxe-formula processing instruction) is explicitly selected, a specialized formula editor is opened to allow the user to modify the formula.

Otherwise, a specialized formula editor is opened to allow the user to insert a new formula at caret position. Inserting a new formula in an empty element works too: simply explicitly select this empty element and use this menu item.

Disable Selected Formulas, Enable Selected Formulas

Disables/enables all the formulas (xxe-formula processing instruction) found in the explicit node selection or in the text selection.

Disabling a formula means passivating it. That is, it is no longer used to update the document. In some cases, this is a handy alternative to removing it.

Tip

In the styled view, formulas are represented by a small F icon. Clicking on this icon with the middle button of the mouse allows to switch the state of the formula from enabled to disabled and vice-versa.

Remove Selected Formulas

Remove all the formulas (xxe-formula processing instruction) found in the explicit node selection or in the text selection.

Auto-update Mode

This toggle may be used to switch from auto-update mode to manual update mode.

In manual update mode, only newly inserted formulas are computed. To force a full calculation, the user has to explicitly use the Update command below.

In auto-update mode, a full calculation is automatically performed, if needed to, when the editing context changes. For example: type some text in a paragraph, then click in (or tab to) another paragraph to trigger a spreadsheet calculation.

Note that in both modes, a full calculation is automatically performed, if needed to, before validating or saving the document.

Using manual update mode is recommended if you have a slow computer or if you have inserted a lot of formulas in your document or if your formulas access many external documents.

See also Spreadsheet options.

Update

Forces a full calculation of the spreadsheet.