https://bugs.documentfoundation.org/show_bug.cgi?id=170295
Bug ID: 170295
Summary: XLOOKUP horizontal search for empty cell does not work
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 205001
--> https://bugs.documentfoundation.org/attachment.cgi?id=205001&action=edit
File with horizontal lookup for empty cell
Open attached file and examine tab "test".
Recalculate hard.
Notice, that the results in A6, A7 and A12, A13 are wrong.
A7 should be "$mini.$G$2"
A13 should be "$mini.$G$2"
Open the attached file in Excel. It shows the correct cell addresses in
horizontal cases.
I see the problem in Version: 26.2.0.0.beta1 (X86_64)
Build ID: 620(Build:0)
CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan;
VCL: win
Locale: en-US (de_DE); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
