https://bugs.documentfoundation.org/show_bug.cgi?id=159467
Bug ID: 159467
Summary: XLOOKUP does not work if embedded in another XLOOKUP
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 150900
Created attachment 192274
--> https://bugs.documentfoundation.org/attachment.cgi?id=192274&action=edit
Example file from Excel 2021/O365
Attached example file was taken from https://trumpexcel.com/xlookup-function/
and demonstrates various uses of the XLOOKUP function.
After the patch
1. Open attached file
2. Go to the "Ex 5" sheet
3. In the A12 cell enter a value from the A2:A8 range such as "Ned"
-> In B12 the XLOOKUP gives back #N/A error instead of the matching value from
the B2:B8 range.
This happens because XLOOKUP has the ability to run an embedded function as its
4th if_not_found parameter, and here that one gives back the #N/A error.
Excel handles this in an unusual way and does not propagate this error as the
final result of the XLOOKUP function, but Calc does.
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9de73be119eb288ee0a1f54e9c0f2b236ef41821
CPU threads: 2; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
(this is local build from https://gerrit.libreoffice.org/c/core/+/131905 )
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=150900
[Bug 150900] [META] Excel Functions
--
You are receiving this mail because:
You are the assignee for the bug.
