[Libreoffice-bugs] [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 #25 from Commit Notification --- Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/572a8132e0e460b17c80c456dfb5e07f6b9a9c6a tdf#121090: Correct

[Libreoffice-bugs] [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 Mike Kaganski changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [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 #24 from Commit Notification --- Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/7179225dccf23dbe347ca6ad88e4eb22cc0abf6a Related: tdf#121090:

[Libreoffice-bugs] [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 Commit Notification changed: What|Removed |Added Whiteboard||target:6.4.0 -- You are

[Libreoffice-bugs] [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 #23 from Mike Kaganski --- https://gerrit.libreoffice.org/82376 is about Function Wizard/tooltips. -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [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 #22 from Mike Kaganski --- https://gerrit.libreoffice.org/82375 is the proposed change to help (not related to function wizard/AutoInput tooltips). -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [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 #21 from gmoll...@us.es --- In LO Calc 6.3 the problem continue: VLOOKUP: VLOOKUP(SearchCriterion; Array; Index; Sorted) HLOOKUP: HLOOKUP(SearchCriterion; Array; Index; Sorted) Both must be like this: ...(SearchCriterion;

[Libreoffice-bugs] [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 #20 from QA Administrators --- Dear gmolleda, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been

[Libreoffice-bugs] [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 #19 from gmoll...@us.es --- Created attachment 146252 --> https://bugs.documentfoundation.org/attachment.cgi?id=146252=edit Screenshot with the help inline of the 4th parameter. When you write in the cell the function

[Libreoffice-bugs] [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 |

[Libreoffice-bugs] [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

[Libreoffice-bugs] [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

[Libreoffice-bugs] [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 > >

[Libreoffice-bugs] [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

[Libreoffice-bugs] [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

[Libreoffice-bugs] [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

[Libreoffice-bugs] [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

[Libreoffice-bugs] [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 Mike Kaganski changed: What|Removed |Added Summary|Help of vlookup and |Change name (description)