https://bugs.documentfoundation.org/show_bug.cgi?id=146529
Bug ID: 146529
Summary: External document loading lookup fails if optimal
height calculation is enabled on cell with reference
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After opening a Calc document with a reference in it to another document, the
lookup for the referenced file fails with this warning message:
"The following external file could not be loaded. Data linked from this file
did not get updated.
file:///C:/Users/prozsa/Documents/base.ods"
Calculations are fine after closing the warning dialog.
I managed to work around the issue, it seems that optimal row height styling
triggers too early cell value evaluation on the open document, and the
referenced document's path lookup fails.
The mentioned code part checks if there's any cell range that has to be
evaluated, and then calls an update on those ranges, thus the cells with the
INDIRECT reference to the other file get evaluated, and the referenced document
gets loaded:
https://github.com/LibreOffice/core/blob/4e2c4bd9228bd0cf973f13dbe4410a2391d06ab8/sc/source/filter/xml/xmlimprt.cxx#L1424
If I turn off every "style:use-optimal-row-height" in the base documents
content.xml then the issue resolves.
See attached files; base.ods is the referenced file, good.ods shows the good
behaviour with optimal row height turned off, bad.ods shows the problematic
loading.
Steps to Reproduce:
1.Create an indirect reference to another Calc doc like =INDIRECT(A1) where A1
contains a reference like this: 'base.ods'#Sheet1.A1:B10
2.Save and close the document
3.Reopen it
Actual Results:
Warning dialog with this message: The following external file could not be
loaded. Data linked from this file did not get updated.
file:///C:/Users/prozsa/Documents/base.ods
Expected Results:
No warning dialog
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Verzió: 6.4.7.2 (x64)
Build az.: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU szálak: 4; OS: Windows 10.0 Build 19043; Felületmegjelenítés:
alapértelmezett; VCL: win;
Területi beállítások: hu-HU (hu_HU); Felület nyelve: hu-HU
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
