https://bugs.documentfoundation.org/show_bug.cgi?id=163614
Bug ID: 163614
Summary: LOOKUP does only work sporadically when referring to
an external file
Product: LibreOffice
Version: 7.6.5.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
For instance:
=LOOKUP(A38;'file:///M:/produktion/ElectrodevArtNr.ods'#$Artikelregister.A$7:A$110;'file:///M:/produktion/ElectrodevArtNr.ods'#$Artikelregister.E$7:E$110)
This can work in one cell but not in another.
I have tried to enter references to local cells and that works also.
Steps to Reproduce:
1.Use the formula in several cells.
2.
3.
Actual Results:
#N/A
Expected Results:
The text in the file that is referred to.
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
No other info.
--
You are receiving this mail because:
You are the assignee for the bug.
