[Libreoffice-bugs] [Bug 87739] FILEOPEN : XLSX - formulas linked to other sheets are not refreshed when opening file (hard recalc needed)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from Svatopluk Vít <svatopluk.vit at gmail.com> ---
Created attachment 170146
  --> https://bugs.documentfoundation.org/attachment.cgi?id=170146&action=edit
Same files but in Calc native (ODS) format

Investigation : When you change the format to Calc native format ODS and relink
the file 2 to file 1, it is working as expected.

- open the file 1-lo.ods and change the value
- save the file in ods format
- open the file 2-lo.ods
- yellow message "Automatic update of external links has been disabled." is
there
- click to button Allow updating
- file is updated without problem

Looks like that XLSX import omits this functionality after opening.

Version: 7.1.1.1 / LibreOffice Community
Build ID: 575c5867c4cc13d7ae78f9ce39a54a52ed38c769
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

-- 
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/20210301/718bcf9c/attachment.htm>