<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc: set "Prompt user" as default for "Recalculation on file load""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107929">107929</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc: set "Prompt user" as default for "Recalculation on file load"
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gtimur@gmail.com
</td>
</tr>
<tr>
<th>CC</th>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<pre>From LO 4.0 we have: "Menu/Tools/Options/LibreOffice calc/Formula -
Recalculation on file load" with default setting "Excel 2007 and newer" and
"ODF spreadsheet" to "Never recalculate".
I suggest default setting be "Prompt user" for the following reasons:
- I use it myself like that feeling that's logical
- it's informative about recalculation
- it's not too complicated for average user because there's "Always perform
this/chosen without prompt in the future".
- some bugs and confusions can be avoided like <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FILEOPEN: protected workbook"
href="show_bug.cgi?id=60718">Bug 60718</a>.
What I can be wrong about is that even without recalculation values should be
right, like <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)"
href="show_bug.cgi?id=81396">Bug 81396</a> and in that case I wrongfully closed <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FILEOPEN: protected workbook"
href="show_bug.cgi?id=60718">Bug 60718</a>. But what
would be recalc do then? Help <a href="https://help.libreoffice.org/Calc/Recalculate">https://help.libreoffice.org/Calc/Recalculate</a> is
not correct and useful.
Note: I checked previous bugs but they are not the same, <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Recalculation on load: Behavior problematic to certain sheets"
href="show_bug.cgi?id=60964">Bug 60964</a> was about
"Always recalculate" as default, <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Recalculation on load: Please consider this as a per-spreadsheet option (instead of per-application)"
href="show_bug.cgi?id=60974">Bug 60974</a> for per-spreadsheet so not accepted,
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED INVALID - Recalculation on load: "Prompt user" not working"
href="show_bug.cgi?id=60973">Bug 60973</a> that "Prompt user" not working was probably about those exceptions
that used to exist, such as <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Recalculate does not always work"
href="show_bug.cgi?id=97897">Bug 97897</a>.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>