https://bugs.documentfoundation.org/show_bug.cgi?id=120752
Bug ID: 120752
Summary: MATCH() shows inconsistent behavior when used
improperly, could use better documentation
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: pawo2...@gmail.com
Created attachment 145878
--> https://bugs.documentfoundation.org/attachment.cgi?id=145878&action=edit
Screencast of LO Calc, showing the current behavior
MATCH() takes 3 parameters, the last (Type) being optional. Built-in
description only says Type can be -1, 0 or 1, without explaining what any of
those modes do, and without informing that 1 is the default (and it usually is
NOT the mode user wants to use, but it's been default since forever). The
behavior of this function is described here:
https://help.libreoffice.org/Calc/Spreadsheet_Functions#MATCH . IMHO this
description should be copied into Calc.
What is also worrying is that on small datasets, MATCH() works "properly"
(Type=0) independently of what Type is actually set to. See attached
screencast. It is quite confusing, but we may need to leave it as-is to
preserve compatibility.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
