Issue 74566

Summary:	Allow disabling of recalculation when opening
Product:	Calc	Reporter:	jamescrompton <james>
Component:	open-import	Assignee:	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

Hi,

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, ...

@mmp
Matthias what's the opinion of UX here ?

Frank

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. ***