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

Gabor Kelemen kelemeng at gnome.hu
Mon Sep 19 07:09:36 UTC 2016


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

New commits:
commit e21bf9fa94cae8ec3527bed2aa6b4c71501b65eb
Author: Gabor Kelemen <kelemeng at gnome.hu>
Date:   Mon Sep 19 08:03:35 2016 +0200

    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 at ubuntu.com>
    Tested-by: Adolfo Jayme Barrientos <fitojb at ubuntu.com>

diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index a2d98d3..a9061fc 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">


More information about the Libreoffice-commits mailing list