Issue 74566 - Allow disabling of recalculation when opening
Summary: Allow disabling of recalculation when opening
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 126004 (view as issue list)
Depends on:
Reported: 2007-02-15 10:47 UTC by jamescrompton
Modified: 2015-03-05 09:16 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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. ***