https://bugs.documentfoundation.org/show_bug.cgi?id=163736
Bug ID: 163736
Summary: XMATCH produce wrong results
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
XMATCH especially with reversed search-direction produce wrong results.
worse enough, if you use the Formulawizard it shows the correct result … but
changes its »mind« later on recalculation with ctrl+shift+F9
Steps to Reproduce:
1. open attached …ods
2. select cell E12
3. switch to Formula-Wizard
4. see the (correct) return »16«
5. close the wizard ⇒ E12 shows »16« #right!
6. hit ctrl+shift+enter ⇒ E12 shows »4« #wrong
Actual Results:
see #6.
Expected Results:
the correct result should persist!
Reproducible: Always
User Profile Reset: No
Additional Info:
with me:
__________
Version: 24.8.2.1 (AARCH64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
see also:
https://ask.libreoffice.org/t/xmatch-and-match-in-neighbour-cells/113282/5
--
You are receiving this mail because:
You are the assignee for the bug.
