[Libreoffice-commits] help.git: source/text
Steve Fanning (via logerrit)
logerrit at kemper.freedesktop.org
Fri Feb 5 15:45:14 UTC 2021
source/text/scalc/01/04060109.xhp | 92 ++++++++++++++++++++++++++++++++++++++
1 file changed, 92 insertions(+)
New commits:
commit f654fc362e2ca75a1ff10b772f4b72065484fab2
Author: Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Thu Feb 4 15:07:17 2021 +0100
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Fri Feb 5 16:44:54 2021 +0100
Add Examples section to Help description for Calc's HLOOKUP function.
File 04060109.xhp
Change-Id: If5828bba9aec04564c9eab37f41731ac4d886c1a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110364
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index c695e9165..c571dc97a 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -458,6 +458,98 @@
<paragraph xml-lang="en-US" id="par_id3146070" role="code">HLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])</paragraph>
<paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For an explanation on the parameters, see: <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"/>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <paragraph role="paragraph" id="par_id141612447324913">Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”.</paragraph>
+ <table id="tab_id221612450364379">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id271612450364379" role="tablehead" localize="false">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301612450364379" role="tablehead" localize="false">B</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id551612452808535" role="tablehead" localize="false">C</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251612452859597" role="tablehead" localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id751612450364379" role="tablehead" localize="false">DO4</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id711612450364379" role="tablecontent">Hydrogen</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id681612450364379" role="tablecontent">Helium</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531612453345232" role="tablecontent">Lithium</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id951612452954067" role="tablecontent" localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id571612453039430" role="tablecontent">Oganesson</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id71612453081581" role="tablecontent" localize="false">H</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id791612453096630" role="tablecontent" localize="false">He</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111612453384301" role="tablecontent" localize="false">Li</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id921612453115601" role="tablecontent" localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id161612453127250" role="tablecontent" localize="false">Og</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id491612453663656" role="tablecontent" localize="false">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501612453736586" role="tablecontent" localize="false">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id421612453790984" role="tablecontent" localize="false">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21612453805178" role="tablecontent" localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id961612453816419" role="tablecontent" localize="false">118</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id771612453688379" role="tablecontent" localize="false">1.008</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id281612453852664" role="tablecontent" localize="false">4.0026</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id431612453888389" role="tablecontent" localize="false">6.94</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id91612453914383" role="tablecontent" localize="false">...</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461612453928537" role="tablecontent" localize="false">294</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+ <paragraph role="paragraph" id="par_id51612447346319"><input>=HLOOKUP("Lead"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead.</paragraph>
+ <paragraph role="paragraph" id="par_id291612447349416"><input>=HLOOKUP("Gold"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold.</paragraph>
+ <paragraph role="paragraph" id="par_id971612447352912"><input>=HLOOKUP("Carbon"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon.</paragraph>
</section>
<section id="Section18">
<bookmark xml-lang="en-US" branch="index" id="bm_id3147321"><bookmark_value>ROW function</bookmark_value>
More information about the Libreoffice-commits
mailing list