Contingut
Índex 🔎︎

# Recalcula

Recalculates formula cells.

Per a accedir a aquesta ordre...

Trieu Dades ▸ Calcula ▸ Recalcula.

F9

If AutoCalculate is disabled, the Recalculate command recalculates all (so-called dirty) formula cells that depend on changed cell content and their dependents, and formula cells containing volatile functions such as RAND() or NOW() and formula cells that depend on them.

If AutoCalculate is enabled, the Recalculate command applies only to formula cells containing volatile functions like RAND() or NOW() and formula cells that depend on them.

In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation.

Premeu F9 per recalcular. Premeu Maj+Ordre Ctrl+F9 per recalcular totes les fórmules del document.

Per a accedir a aquesta ordre...

Trieu LibreOffice ▸ Preferències Eines ▸ Opcions ▸ LibreOffice Calc ▸ Fórmula.

Recalculation options are, Recalculation on File Load, with values:

Always recalculate, Never recalculate (default option), Prompt user.

Press Shift+Command Ctrl+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells.

Després que el document s'hagi recalculat, s'actualitza la pantalla. També s'actualitzaran tots els diagrames.