[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com |.freedesktop.org| --- Comment #18 from Heiko Tietze --- (In reply to Olivier Hallot from comment #13) > The help content for VLOOKUP is quite precise. How about an example, something like in comment 7. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 --- Comment #17 from Mike Kaganski --- (In reply to Jean-Francois Nifenecker from comment #15) > 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!). The "approximative match" is misinterpretation: please see comment 7. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 --- Comment #16 from Mike Kaganski --- (In reply to Jean-Francois Nifenecker from comment #15) ... which is why I keep using that "range" word, and want to stress that 1 means "look for range", not "look for value". And of course, that might be improved over my suggestion in comment 14. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 --- Comment #15 from Jean-Francois Nifenecker --- (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. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 --- Comment #14 from Mike Kaganski --- 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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 --- Comment #13 from Olivier Hallot --- The help content for VLOOKUP is quite precise. en-US https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 es https://help.libreoffice.org/6.2/es/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 eo https://help.libreoffice.org/6.2/eo/text/scalc/01/04060109.html?=CALC=UNIX#Section9 I don't see any need for changing the name of the parameters. If absolutely needed, I'll choose "SortedRangeLookup", + adjust the help pages and the UI dialog. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 --- Comment #12 from gmoll...@us.es --- "and range, order vs. sort... not a big difference" If the user reads "Ordered" he may think that if the list is ordered he has to put True. But no, the list could be ordered but the type of search needed could be exact using False as the fourth parameter. Si el usuario lee "Ordenado" puede pensar que si la lista es ordenada tiene que poner Verdadero. Pero no, la lista podría estar ordenada pero el tipo de búsqueda necesitada podría ser exacta usando Falso como cuarto parámetro. Se la uzanto legas "Ordonita" li eble pensas, ke se la listo estas ordigita, li devas meti Vera. Sed ne, la listo povus esti ordigita sed la tipo de serĉo bezonata povus esti ĝusta uzante Falsa en la kvara parametro. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[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)
https://bugs.documentfoundation.org/show_bug.cgi?id=121090 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEW Severity|trivial |normal CC||libreoffice-ux-advise@lists ||.freedesktop.org, ||olivier.hallot@documentfoun ||dation.org, ||so...@libreoffice.org Ever confirmed|0 |1 --- Comment #11 from Heiko Tietze --- If I get it right the request is to rename "Order sort" to "Range lookup" or "Sorted range lookup" or "Ordered range lookup". I don't think any of those wording helps the user to understand what the parameter means. The "lookup" term is clear from the function itself and range, order vs. sort... not a big difference in particular when translation is applied. But OTOH it also does not hurt to change the terms (except l10n). The only way to understand complex functions like this with all the parameter is to provide a good help. Added Olivier for that. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
