Bug 160753 - XMATCH function in search for empty cell is different to Excel
Summary: XMATCH function in search for empty cell is different to Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+ Master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-20 19:57 UTC by Regina Henschel
Modified: 2024-04-30 02:43 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Test for XMATCH and empty cell (9.14 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-20 19:57 UTC, Regina Henschel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2024-04-20 19:57:29 UTC 
Created attachment 193773 [details]
Test for XMATCH and empty cell

Open attached document. It has cells with expected value (what Excel calculates) and actual value (what LibreOffice calculates) and a cell, which shows the formula as text.
Press Ctrl+Shift+F9 to force recalculation.

The similar problem for XLOOKUP is in 160711 and Balázs has fixed that already.
Comment 1 m_a_riosv 2024-04-20 22:11:24 UTC 
Reproducible
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7c2ed9919d6d9d286d9062b91577d6bb2b7de8aa
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

On the first case, need to have at least one larger than searched value.
On the second case, having an empty in double quotes (=XMATCH("";B2:B15)) as the first parameter also doesn't work.