[Libreoffice-commits] help.git: source/text

Mon Nov 11 12:32:30 UTC 2019

source/text/scalc/01/04060109.xhp |    6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

New commits:
commit 7179225dccf23dbe347ca6ad88e4eb22cc0abf6a
Author:     Mike Kaganski <mike.kaganski at collabora.com>
AuthorDate: Sun Nov 10 11:44:59 2019 +0200
Commit:     Eike Rathke <erack at redhat.com>
CommitDate: Mon Nov 11 13:32:06 2019 +0100

    Related: tdf#121090: Rewrite descriptions for the last argument of HLOOKUP/VLOOKUP
    
    That parameter is not about telling the *functions* if the search column in
    the array is sorted or not, but about different semantical treatment of the
    array, i.e. whether it's the array of values or sorted ranges. The wording
    "Sorted" and "indicates whether the first column in the array is sorted in
    ascending order" is misleading, not providing the idea behind the argument,
    and create an impression that all sorted array lookups must have it ser to
    TRUE.
    
    Change-Id: I795c29f3c7d5632db6f72f7906bfdacaa372832e
    Reviewed-on: https://gerrit.libreoffice.org/82375
    Tested-by: Jenkins
    Reviewed-by: Eike Rathke <erack at redhat.com>

diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 5bfce339f..0c8549426 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -275,7 +275,7 @@
          <paragraph xml-lang="en-US" id="par_id3149984" role="paragraph"><ahelp hid="HID_FUNC_SVERWEIS">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type="literal">Index</item>. If the <item type="literal">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type="literal">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type="literal">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order.</paragraph>
          <embed href="text/shared/00/00000001.xhp#regulaer"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-         <paragraph xml-lang="en-US" id="par_id3150156" role="code">=VLOOKUP(SearchCriterion; Array; Index; Sorted)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3150156" role="code">=VLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)</paragraph>
          <paragraph xml-lang="en-US" id="par_id3149289" role="paragraph">
             <emph>SearchCriterion</emph> is the value searched for in the first column of the array.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3153884" role="paragraph">
@@ -283,7 +283,7 @@
          <paragraph xml-lang="en-US" id="par_id3156005" role="paragraph">
             <emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3151208" role="paragraph">
-            <emph>Sorted</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>.</paragraph>
+            <emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than SearchCriterion. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was no
 t matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>.</paragraph>
          <embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
          <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
          <paragraph xml-lang="en-US" id="par_id3154129" role="paragraph">You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains <item type="input">100</item>, E1 contains the name <item type="input">Vegetable Soup</item>, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional <item type="literal">Sorted</item> parameter is not necessary.</paragraph>
@@ -453,7 +453,7 @@
          <paragraph xml-lang="en-US" id="par_id3148688" role="paragraph"><ahelp hid="HID_FUNC_WVERWEIS">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column.</paragraph>
          <embed href="text/shared/00/00000001.xhp#regulaer"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-         <paragraph xml-lang="en-US" id="par_id3146070" role="code">HLOOKUP(SearchCriterion; Array; Index; Sorted)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3146070" role="code">HLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)</paragraph>
          <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For an explanation on the parameters, see: <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</paragraph>
          <embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
       </section>
