<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 Spreadsheet formulas are automatically recalculated on file load when the option is set to disable recalculation on file load"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135862">135862</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc Spreadsheet formulas are automatically recalculated on file load when the option is set to disable recalculation on file load
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 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>minor
</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>oaoutpost0@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When the Tools > Option > LibreOffice Calc > Formula > Recalculation on File
Load options are set to "Never" or "Prompt", LibreOffice still recalculates the
formulas (at least, external links) unless Data > Calculate > AutoCalculate is
disabled.
This makes sharing files with external links difficult (without sharing the
externally linked document, which may not be shareable for any number of
reasons), since the receiver of the document has no way to prevent LibreOffice
from destroying the values inside the document if the sender forgot to uncheck
the AutoCalculate option.
This creates a chicken-and-the-egg problem:
1. In order to disable AutoCalculate, one must open the spreadsheet; destroying
the links.
2. To avoid destroying the links, one has to disable AutoCalculate; requiring
one to open the document.
Apart from extracting the file with a tool like 7zip and reconfiguring the
options to disable AutoCalculate, there is no way for the receiver to fix the
problem. The only easy workaround is to pester the sender every time to fix the
setting.
Steps to Reproduce:
1. Create two spreadsheets. Have on spreadsheet link to the other.
2. Disable Tools > Option > LibreOffice Calc > Formula > Recalculation on File
Load
3. Leave AutoCalculate enabled.
4. Save the spreadsheets, send one to the other side of the world (anywhere
separated from the parent spreadsheet), and open it there.
Actual Results:
AutoCalculate resolved external links on document load, destroying the saved
values, even before enabling the automatic external link resolution.
Expected Results:
AutoCalculate should not execute at all on file load when Recalculate on File
Load is disabled or set to prompt.
Reproducible: Always
User Profile Reset: No
Additional Info:
I have no idea about the earliest version this bug exists in.
Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 16; OS: Windows 10.0 Build 19041; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: CL</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>