Bug 60974 - Recalculation on load: Please consider this as a per-spreadsheet option (instead of per-application)
Summary: Recalculation on load: Please consider this as a per-spreadsheet option (inst...
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-02-16 21:18 UTC by Christian Fries
Modified: 2013-02-18 00:03 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Christian Fries 2013-02-16 21:18:16 UTC 
(This is a feature request)

LibreOffice 4.0.0.3 offers a setting at Preferences->LibreOffice Calc->Formula called "Recalculation on file load".

The option is set effective for the whole application. Since I believe that the default behavior ("Never recalculate") will lead to problems in a certain class of spreadsheet-solutions (e.g. spreadsheets with macros making use of external resources) this option should be set on a per-spreadsheet basis (i.e., it should be possible to explicitly save a spreadsheet with "Recalculate upon next open" - or s.th. like that).

This is related to "bug" 60964.
Comment 1 Markus Mohrhard 2013-02-18 00:03:46 UTC 
This is an application option.

We will try to fix the problems for all known cases but the decision to switch to cached value import was long discussed by the Calc developers. It is known that there might be a few cases we need to adapt but we will fix them.