[Libreoffice-bugs] [Bug 135862] New: Calc Spreadsheet formulas are automatically recalculated on file load when the option is set to disable recalculation on file load

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135862

            Bug ID: 135862
           Summary: Calc Spreadsheet formulas are automatically
                    recalculated on file load when the option is set to
                    disable recalculation on file load
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: oaoutpost0 at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200818/c188881e/attachment.htm>