tdf#97823 Change VLOOKUP parameter SortOrder to Sorted

Sync with HLOOKUP's Sorted parameter. This is a boolean
indicating if the data is sorted or not, not the order
like ascending or descending.

Change-Id: Ic48de6597c6b1997502c4dffb4a5bb15cbe49d74
Reviewed-on: https://gerrit.libreoffice.org/29013
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>

1 files changed, 4 insertions, 4 deletions

diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index a9061fc49a..f1af725bcf 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -296,11 +296,11 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SVERWEIS" id="bm_id3152809" localize="false"/>
 <paragraph xml-lang="en-US" id="hd_id3153152" role="heading" level="2" l10n="U"
                     oldref="87">VLOOKUP</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3149984" role="paragraph" l10n="CHG" oldref="88"><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">SortOrder</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">SortOrder</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>
+         <paragraph xml-lang="en-US" id="par_id3149984" role="paragraph" l10n="CHG" oldref="88"><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"/>
          <paragraph xml-lang="en-US" id="hd_id3146898" role="heading" level="3" l10n="U"
                     oldref="89">Syntax</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3150156" role="code" l10n="U" oldref="90">=VLOOKUP(SearchCriterion; Array; Index; SortOrder)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3150156" role="code" l10n="U" oldref="90">=VLOOKUP(SearchCriterion; Array; Index; Sorted)</paragraph>
          <paragraph xml-lang="en-US" id="par_id3149289" role="paragraph" l10n="U" oldref="91">
             <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" l10n="U" oldref="92">
@@ -308,11 +308,11 @@
          <paragraph xml-lang="en-US" id="par_id3156005" role="paragraph" l10n="U" oldref="93">
             <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" l10n="U" oldref="94">
-            <emph>SortOrder</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 between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message: <emph>Error: Value Not Available</emph>.</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 between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message: <emph>Error: Value Not Available</emph>.</paragraph>
          <embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
          <paragraph xml-lang="en-US" id="hd_id3147487" role="heading" level="3" l10n="U"
                     oldref="95">Example</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3154129" role="paragraph" l10n="U" oldref="96">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">SortOrder</item> parameter is not necessary.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3154129" role="paragraph" l10n="U" oldref="96">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>
          <paragraph xml-lang="en-US" id="par_id3145663" role="paragraph" l10n="U" oldref="97">Enter the following formula in B1:</paragraph>
          <paragraph xml-lang="en-US" id="par_id3151172" role="paragraph" l10n="U" oldref="98">
             <item type="input">=VLOOKUP(A1;D1:E100;2)</item>