https://bugs.documentfoundation.org/show_bug.cgi?id=160753
Bug ID: 160753
Summary: XMATCH function in search for empty cell is different
to Excel
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]
CC: [email protected]
Created attachment 193773
--> https://bugs.documentfoundation.org/attachment.cgi?id=193773&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
