Bug 149599 - Enhancement request: manual formula recalculation
Summary: Enhancement request: manual formula recalculation
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-06-18 00:07 UTC by rmikke
Modified: 2022-06-18 00:34 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description rmikke 2022-06-18 00:07:20 UTC
Description:
I'd like to have a possibility to switch off automatic formula recalculation in CALC. Ideally: per file i.e. I'd like to be able to mark a file "do nat recalculate automatically formulas in this file".

This is a very useful feature for big files with plenty of formulas, where I don't need formulas recalculated after every cell change.

Actual Results:
For every cell I change all the formulas in file are recalculated.

Expected Results:
Possibility to mark a file for manual recalculation of formulas


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: CL
Comment 1 Eike Rathke 2022-06-18 00:15:58 UTC
That's already available: switch off menu Data -> Calculate -> AutoCalculate and use F9 to recalculate pending changes within a session, or Shift+Ctrl+F9 to recalculate the entire document.
Comment 2 rmikke 2022-06-18 00:34:19 UTC
(In reply to Eike Rathke from comment #1)
> That's already available: switch off menu Data -> Calculate -> AutoCalculate
> and use F9 to recalculate pending changes within a session, or Shift+Ctrl+F9
> to recalculate the entire document.

Thanks, I was searching in file properties :)