I found data link error when I try to open file that contain manual link with function INDIRECT.
In LO 4.0.4,4.0.5, 4.1.1
example.
I use file name and address in cell B2 (‘HostLink.ods’#$Sheet1.A1), the B3 formula “=INDIRECT(B2)”,
I place all file in c:\My Document
After I open file cell B3 return “#REF!”. With error message
“The following external file could not be loaded. Data linked from this file did not get updated.
file:///D:/DATA/HostLink.ods”
However, after I made chang with file (input value in cell / Show/Hide Column)
B3 will link data from source correctly.
I 'm sorry, i can’t attach file