# XMLmind XML Editor - Online Help

### 6.4. Spreadsheet menu

You may need to enable this submenu by checking "Enable the Integrated Spreadsheet Engine" in Options → Preferences, General|Features section.

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.