https://bugs.documentfoundation.org/show_bug.cgi?id=164004
Bug ID: 164004
Summary: XLOOKUP across files does not work correctly
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
XLOOKUP across files does not work correctly.
XLOOKUP within the same ods file works correctly.
VLOOKUP works fine.
Steps to Reproduce:
1.write "tiger" in cell B2 and "woods" in cell C2
2.write "woods" in cell B3 and "tiger" in cell C3
3.save sheet as "fR" and file as "Fr.ods"
4.start new file To.ods, sheet "To"
5.in cell B2, write "tiger"
6.in cell C2, enter formula
=XLOOKUP(B2,'file:///tmp/Fr.ods'#$fR.B$1:B$1048576,'file:///tmp/Fr.ods'#$fR.C$1:C$1048576)
Expected Results:
woods
Reproducible: Always
User Profile Reset: No
Additional Info:
* XLOOKUP of string not in remote file results in "#N/A" as expected
* VLOOKUP works correctly, results in "woods"
=VLOOKUP(B2,'file:///tmp/Fr.ods'#$fR.B$1:C$1048576,2,0)
* XLOOKUP within the same ods file works correctly, results in "woods" if you
move sheet [Fr] into same file 'To.ods' as where the XLOOKUP is running
--
You are receiving this mail because:
You are the assignee for the bug.
