Apache OpenOffice (AOO) Bugzilla – Issue 128442
Entries in description of functions: HLOOKUP and LOOKUP are not displayed as links
Last modified: 2021-04-03 17:31:37 UTC
Created attachment 87013 [details] Screenshot to illustrate the issue Help for Calc, topic "Spreadsheet Functions" ( source file: /aoo419/main/helpcontent2/source/text/scalc/01/04060109.xhp ) Relevant screenshots are in the attached file "H-V-Lookup". 1. HLOOKUP function 2nd entry in the "Syntax" section reads: "See also:VLOOKUP (columns and rows are exchanged)" 2. LOOKUP function 1st paragraph reads: "Returns the contents of a cell either from a one-row or one-column range. Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to VLOOKUP and HLOOKUP, (...)" --------------------- AOO Help should display words "VLOOKUP" and "HLOOKUP" in above quotations as a links - it does not happen because of a missing reference in the source file (within <link ... </link> ) to the appropriate sections. HLOOKUP ---> <section id="Section17"> VLOOKUP ---> <section id="Section9"> --------------------- 1. HLOOKUP <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> text/scalc/01/04060109.xhp should be changed to text/scalc/01/04060109.xhp#Section9 2. LOOKUP <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>, (...) <link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp" name="HLOOKUP">HLOOKUP</link> should be changed 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> LINKS to entries in question 1. HLOOKUP trunk http://openoffice-vm1-he-de.apache.org/xref/trunk/main/helpcontent2/source/text/scalc/01/04060109.xhp?r=02dbb15c#506 4.1.9 http://openoffice-vm1-he-de.apache.org/xref/aoo419/main/helpcontent2/source/text/scalc/01/04060109.xhp?r=02dbb15c#506 4.2.0 http://openoffice-vm1-he-de.apache.org/xref/aoo42x/main/helpcontent2/source/text/scalc/01/04060109.xhp?r=02dbb15c#506 2. LOOKUP trunk http://openoffice-vm1-he-de.apache.org/xref/trunk/main/helpcontent2/source/text/scalc/01/04060109.xhp?r=02dbb15c#429 4.1.9 http://openoffice-vm1-he-de.apache.org/xref/aoo419/main/helpcontent2/source/text/scalc/01/04060109.xhp?r=02dbb15c#429 4.2.0 http://openoffice-vm1-he-de.apache.org/xref/aoo42x/main/helpcontent2/source/text/scalc/01/04060109.xhp?r=02dbb15c#429
You are a committer and in the case where you have researched the correct fix in the code I encourage you to learn how to submit a PR using GitHub. If you need help with that then let's discuss on dev@ (and fix our developer documentation https://openoffice.apache.org/source.html which does not show the GitHub workflow very well.)