[Libreoffice-ux-advise] [Bug 121090] Change name (description) of 4th argument to VLOOKUP and HLOOKUP to "Sorted range lookup" in help and in function wizard (see comment 7, comment 9)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Nov 2 06:04:18 UTC 2018


--- Comment #15 from Jean-Francois Nifenecker <jean-francois.nifenecker at laposte.net> ---
(In reply to Mike Kaganski from comment #14)
> Well, if needed, the first sentence of the 4th param
> > Sorted is an optional parameter that indicates whether the first column in
> > the array is sorted in ascending order.
> could be changed to something like:
> > Sorted(RangeLookup) is an optional parameter that indicates whether the first column in the array represents a range list sorted in ascending order.
> This actually addresses the valid concern from comment 12.

In fact, IMO, the point is not exactly the description of this argument but the
description of its consequences on the function result when VLOOKUP() can't
match an exact value.

If set to 1/True

No exact match -> the result is an approximative match. The user has no clue
about that and could think the result is the actual match (most do!).

If set to 0/False

No exact match -> the result is a #N/A error. Now, the user actually *knows*
the looked up value was not retrieved and can take appropriate action.

Not sure if theses consequences are always made clear. During trainings I
always have to insist on this point because of the consequences of not
selecting the right option.

My 2 euro-cents.

You are receiving this mail because:
You are on the CC list for the bug.

More information about the Libreoffice-ux-advise mailing list