diff options
| author | Gabor Kelemen <kelemeng@gnome.hu> | 2016-09-19 08:03:35 +0200 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2016-09-19 07:08:16 +0000 |
| commit | e21bf9fa94cae8ec3527bed2aa6b4c71501b65eb (patch) | |
| tree | 5f2ac2519199e8061b4d1cc5742b01cd9a00d682 | |
| parent | 9e65be21197548d68eca86906209f24e36ff4533 (diff) | |
tdf#97821 Add section anchors to VLOOKUP/HLOOKUP links
The missing anchors caused the links to not work
Change-Id: I4af8d0467cec347dee535f510133819987e88491
Reviewed-on: https://gerrit.libreoffice.org/29010
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index a2d98d34bd..a9061fc49a 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -426,7 +426,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERWEIS" id="bm_id3152877" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3159273" role="heading" level="2" l10n="U" oldref="123">LOOKUP</paragraph> - <paragraph xml-lang="en-US" id="par_id3153389" role="paragraph" l10n="CHG" oldref="124"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp" name="HLOOKUP">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153389" role="paragraph" l10n="CHG" oldref="124"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp#Section17" name="HLOOKUP">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.</paragraph> <paragraph xml-lang="en-US" id="par_id4484084" role="note" l10n="NEW">If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion.</paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> <paragraph xml-lang="en-US" id="hd_id3152947" role="heading" level="3" l10n="U" @@ -503,7 +503,7 @@ <paragraph xml-lang="en-US" id="hd_id3154661" role="heading" level="3" l10n="U" oldref="153">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id3146070" role="code" l10n="U" oldref="154">HLOOKUP(SearchCriteria; Array; Index; Sorted)</paragraph> - <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph" l10n="U" oldref="155">See also:<link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</paragraph> + <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph" l10n="U" oldref="155">See also: <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> <section id="Section18"> |