Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Allow disabling of recalculation when opening|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||elish, issues, richardbrucebaxter|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||4.1.0-dev|
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.