Issue 74566

Summary: Allow disabling of recalculation when opening
Product: Calc Reporter: jamescrompton <james>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, richardbrucebaxter
Version: OOo 2.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Description jamescrompton 2007-02-15 10:47:23 UTC
When a spreadsheet is opened everything is recalculated, which can be
time-consuming. If the sheet has no external links, or none that are
automatically updated, this is not necessary, since the values are saved with
the formulae in the file. Therefore:

Provide an option for suppressing recalculation on open file.
Comment 1 frank 2007-02-21 14:32:21 UTC

sorry, but this isn't a good idea. If no re-calculation is made on loading, a
simple hack in the content.xml would show the wrong result of a calculation and
could therefore cause the loss of money, ...

Matthias what's the opinion of UX here ?

Comment 2 jamescrompton 2007-02-26 10:03:27 UTC
If there are security concerns about disabling calculation, how about at least
allowing disabling of 'Adapt row height', which is usually most time-consuming
step in calculation.
Comment 3 jamescrompton 2007-10-18 16:59:44 UTC
Alternatively, allow disabling of recalculation when a file is password
protected, since xml hacking is then not possible.
Comment 4 matthias.mueller-prove 2009-09-06 06:46:49 UTC
I am no longer officially active in OOo. Please take over.
Comment 5 Edwin Sharp 2014-01-12 12:17:10 UTC
If disable adapt row height has no implications other than saving time this is a good idea.
Comment 6 oooforum (fr) 2015-03-05 09:16:28 UTC
*** Issue 126004 has been marked as a duplicate of this issue. ***