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