You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2021/04/03 16:19:36 UTC

[Issue 128442] New: Entries in description of functions: HLOOKUP and LOOKUP are not displayed as links

https://bz.apache.org/ooo/show_bug.cgi?id=128442

          Issue ID: 128442
        Issue Type: DEFECT
           Summary: Entries in description of functions: HLOOKUP and
                    LOOKUP are not displayed as links
           Product: General
           Version: 4.1.9
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Trivial
          Priority: P5 (lowest)
         Component: help
          Assignee: issues@openoffice.apache.org
          Reporter: czeslaw.wolanski@gmail.com
  Target Milestone: ---

Created attachment 87013
  --> https://bz.apache.org/ooo/attachment.cgi?id=87013&action=edit
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 receiving this mail because:
You are the assignee for the issue.

[Issue 128442] Entries in description of functions: HLOOKUP and LOOKUP are not displayed as links

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128442

Dave Fisher <wa...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |wave@apache.org

--- Comment #1 from Dave Fisher <wa...@apache.org> ---
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.)

-- 
You are receiving this mail because:
You are the assignee for the issue.