Improved topic relations for a selected set of pages

Following pages are affected by this update:
1. "Functions by Category"
(https://help.libreoffice.org/Calc/Functions_by_Category):
- Added a variable to its heading, so that it can be referenced from
other places
- Removed self-referece in its "Related Topics" (it was turned into
the above heading reference instead, thereby also correcting the
remote HTTP page reference to local help file referece).
Note: Pages already using the reference will auto-ajust (e.g.
"Related Topics" of
https://help.libreoffice.org/Calc/Statistical_Functions_Part_One)
- Corrected "Operators" reference location by moving it into
"Related Topics"

2. "Statistics Functions"
(https://help.libreoffice.org/Calc/Statistics_Functions):
- Added a variable to its heading, so that it can be referenced from
other places (point 6 below)
- Cleaned up references by adding a "Related Topics" section
- Using links to heading variables in "Related Topics", for improved
heading string consistency

3. "Text Functions" (https://help.libreoffice.org/Calc/Text_Functions):
- Added a variable to its heading, so that it can be referenced from
other places (point 5 below)

4. "Add-in Functions" (https://help.libreoffice.org/Calc/Add-in_Functions):
- Added a variable to its heading, so that it can be referenced from
other places (points 5 and 6 below)

5. "Add-in Functions, List of Analysis Functions Part One":
- Added a variable to its heading, so that it can be referenced from
other places (point 6 below)
- Moved "Related Topics" chapter to the bottom of the page
- Using links to heading variables in "Related Topics", for improved
heading string consistency

6. "Add-in Functions, List of Analysis Functions Part Two":
- Added a variable to its heading, so that it can be referenced from
other places (points 2 and 5 above)
- Moved "Related Topics" chapter to the bottom of the page
- Using links to heading variables in "Related Topics", for improved
heading string consistency

The updated pages were tested as described in
https://wiki.documentfoundation.org/HelpContent#Without_the_LibreOffice_Core_Repo
on 32-bit Debian Linux with:
Version: 5.3.0.0.alpha0+
Build ID: d15082cac2306fb9562ff126eb5827b7b9eee1e1
CPU Threads: 2; OS Version: Linux 4.6; UI Render: default;
TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:master, Time: 2016-09-19_05:41:30
Locale: en-US (en_US.UTF-8); Calc: group

Change-Id: Icbb3725fd16d3ff76e5e4244c2284349332cffb7
Reviewed-on: https://gerrit.libreoffice.org/29306
Reviewed-by: jan iversen <jani@documentfoundation.org>
Tested-by: jan iversen <jani@documentfoundation.org>

6 files changed, 23 insertions, 28 deletions

diff --git a/source/text/scalc/01/04060100.xhp b/source/text/scalc/01/04060100.xhp
index ce49610a25..a5945399cc 100644
--- a/source/text/scalc/01/04060100.xhp
+++ b/source/text/scalc/01/04060100.xhp
@@ -32,9 +32,8 @@
       <bookmark_value>list of functions</bookmark_value>
 </bookmark><comment>MW deleted "Calc functions"</comment>
 <paragraph xml-lang="en-US" id="hd_id3154944" role="heading" level="1" l10n="CHG"
-                 oldref="16">Functions by Category</paragraph>
+                 oldref="16"><variable id="drking"><link href="text/scalc/01/04060100.xhp" name="Functions by Category">Functions by Category</link></variable></paragraph>
       <paragraph xml-lang="en-US" id="par_id3149378" role="paragraph" l10n="CHG" oldref="2">This section describes the functions of $[officename] Calc. The various functions are divided into categories in the Function Wizard.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id0120200910234570" role="tip" l10n="NEW">You can find detailed explanations, illustrations, and examples of Calc functions <link href="http://help.libreoffice.org/Calc/Functions_by_Category">in the LibreOffice WikiHelp</link>.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3146972" role="heading" level="2" l10n="U" oldref="3"><link href="text/scalc/01/04060101.xhp" name="Database">Database</link></paragraph>
       <embed href="text/scalc/01/04060101.xhp#datenbanktext"/>
       <paragraph xml-lang="en-US" id="hd_id3155443" role="heading" level="2" l10n="U" oldref="4"><link href="text/scalc/01/04060102.xhp" name="Date &amp; Time">Date &amp; Time</link></paragraph>
@@ -62,10 +61,8 @@
       <paragraph xml-lang="en-US" id="hd_id3156449" role="heading" level="2" l10n="U"
                  oldref="13"><link href="text/scalc/01/04060111.xhp" name="Add-in">Add-in</link></paragraph>
       <embed href="text/scalc/01/04060111.xhp#addintext"/>
-      <paragraph xml-lang="en-US" id="par_id3150715" role="paragraph" l10n="U" oldref="14"><link href="text/scalc/01/04060199.xhp" name="Operators">Operators</link> are also available.</paragraph>
       <section id="relatedtopics">
-          <paragraph xml-lang="en-US" id="par_id0902200809540918" role="paragraph" l10n="NEW"><variable id="drking"><link href="http://help.libreoffice.org/Calc/Functions_by_Category">Calc Functions By Category</link> in the LibreOffice WikiHelp
-</variable></paragraph>
+         <paragraph xml-lang="en-US" id="par_id3150715" role="paragraph" l10n="U" oldref="14"><link href="text/scalc/01/04060199.xhp" name="Operators">Operators</link></paragraph>
       </section>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/04060108.xhp b/source/text/scalc/01/04060108.xhp
index f9e09b1b08..4394377894 100644
--- a/source/text/scalc/01/04060108.xhp
+++ b/source/text/scalc/01/04060108.xhp
@@ -31,7 +31,7 @@
 <bookmark_value>Function Wizard; statistics</bookmark_value>
 <bookmark_value>functions; statistics functions</bookmark_value>
 </bookmark>
-<paragraph role="heading" id="hd_id3153018" xml-lang="en-US" level="1" l10n="U" oldref="1">Statistics Functions</paragraph>
+<paragraph role="heading" id="hd_id3153018" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="head_statistic"><link href="text/scalc/01/04060108.xhp" name="Statistics Functions">Statistics Functions</link></variable></paragraph>
 <paragraph role="paragraph" id="par_id3157874" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="statistiktext">This category contains the <emph>Statistics</emph> functions. 
 </variable></paragraph>
 <section id="howtoget">
@@ -145,7 +145,9 @@
 <embed href="text/scalc/01/04060183.xhp#kl"/>
 <embed href="text/scalc/01/04060184.xhp#mq"/>
 <embed href="text/scalc/01/04060185.xhp#rz"/>
-<paragraph role="paragraph" id="par_id3150271" xml-lang="en-US" l10n="U" oldref="37"><link href="text/scalc/01/04060116.xhp" name="Statistical Functions in the Analysis-AddIn.">Statistical Functions in the Analysis-AddIn</link></paragraph>
-<embed href="text/scalc/01/04060100.xhp#drking"/>
+<section id="relatedtopics">
+    <paragraph role="paragraph" id="par_id3150271" xml-lang="en-US" localize="false" oldref="37"><embedvar href="text/scalc/01/04060116.xhp#head_addin_analysis_two"/></paragraph>
+    <paragraph id="par_id260920162318025898" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/04060100.xhp#drking"/></paragraph>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 5afc866342..c877ba0864 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -31,7 +31,7 @@
       <bookmark_value>functions; text functions</bookmark_value>
       <bookmark_value>Function Wizard;text</bookmark_value>
 </bookmark>
-<paragraph xml-lang="en-US" id="hd_id3145389" role="heading" level="1" l10n="U" oldref="1">Text Functions</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145389" role="heading" level="1" l10n="U" oldref="1"><variable id="head_text"><link href="text/scalc/01/04060110.xhp" name="Text Functions">Text Functions</link></variable></paragraph>
       <paragraph xml-lang="en-US" id="par_id3152986" role="paragraph" l10n="CHG" oldref="2"><variable id="texttext">This section contains descriptions of the <emph>Text</emph> functions.
 </variable></paragraph>
       <section id="howtoget">
diff --git a/source/text/scalc/01/04060111.xhp b/source/text/scalc/01/04060111.xhp
index 7f6950cd1c..6a302b9980 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -31,7 +31,7 @@
 <bookmark_value>functions; add-in functions</bookmark_value>
 <bookmark_value>Function Wizard; add-ins</bookmark_value>
 </bookmark>
-<paragraph role="heading" id="hd_id3150870" xml-lang="en-US" level="1" l10n="U" oldref="1">Add-in Functions</paragraph>
+<paragraph role="heading" id="hd_id3150870" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="head_addin"><link href="text/scalc/01/04060111.xhp" name="Add-in Functions">Add-in Functions</link></variable></paragraph>
 <paragraph role="paragraph" id="par_id3147427" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="addintext">The following describes and lists some of the available add-in functions. 
 </variable></paragraph>
 <paragraph role="paragraph" id="par_id3163713" xml-lang="en-US" l10n="U" oldref="75"><link href="text/scalc/01/04060112.xhp#addinconcept">Add-in concept</link></paragraph>
diff --git a/source/text/scalc/01/04060115.xhp b/source/text/scalc/01/04060115.xhp
index e84a51f68a..e090954026 100644
--- a/source/text/scalc/01/04060115.xhp
+++ b/source/text/scalc/01/04060115.xhp
@@ -30,15 +30,10 @@
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152871"><bookmark_value>add-ins; analysis functions</bookmark_value>
 <bookmark_value>analysis functions</bookmark_value>
 </bookmark>
-<paragraph role="heading" id="hd_id3152871" xml-lang="en-US" level="1" l10n="U" oldref="1">Add-in Functions, List of Analysis Functions Part One</paragraph>
+<paragraph role="heading" id="hd_id3152871" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="head_addin_analysis_one"><link href="text/scalc/01/04060115.xhp" name="Add-in Functions, List of Analysis Functions Part One">Add-in Functions, List of Analysis Functions Part One</link></variable></paragraph>
 <section id="howtoget">
 <embed href="text/scalc/00/00000404.xhp#addinana"/>
 </section>
-<section id="relatedtopics">
-<paragraph role="paragraph" id="par_id3149873" xml-lang="en-US" l10n="U" oldref="102"><link href="text/scalc/01/04060110.xhp" name="General conversion function BASIS">General conversion function BASIS</link></paragraph>
-<paragraph role="paragraph" id="par_id3145324" xml-lang="en-US" l10n="U" oldref="5"><link href="text/scalc/01/04060116.xhp" name="Analysis functions Part Two">Analysis functions Part Two</link></paragraph>
-<paragraph role="paragraph" id="par_id3155751" xml-lang="en-US" l10n="U" oldref="156"><link href="text/scalc/01/04060111.xhp" name="Back to the Overview">Back to the Overview</link></paragraph>
-</section>
 <sort>
 <section id="besseli">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153074"><bookmark_value>Bessel functions</bookmark_value>
@@ -320,8 +315,11 @@
 <item type="input">=HEX2OCT("6a";4)</item> returns 0152.</paragraph>
 </section>
 </sort>
-<section id="Section1">
-<embed href="text/scalc/01/04060100.xhp#drking"/>
+<section id="relatedtopics">
+    <paragraph role="paragraph" id="par_id3155751" xml-lang="en-US" localize="false" oldref="156"><embedvar href="text/scalc/01/04060111.xhp#head_addin"/></paragraph>
+    <paragraph role="paragraph" id="par_id3145324" xml-lang="en-US" localize="false" oldref="5"><embedvar href="text/scalc/01/04060116.xhp#head_addin_analysis_two"/></paragraph>
+    <paragraph role="paragraph" id="par_id3149873" xml-lang="en-US" localize="false" oldref="102"><embedvar href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+    <paragraph id="par_id260920161551025898" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/04060100.xhp#drking"/></paragraph>
 </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp
index 0a9872eef7..18d692f83f 100644
--- a/source/text/scalc/01/04060116.xhp
+++ b/source/text/scalc/01/04060116.xhp
@@ -30,15 +30,10 @@
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145074"><bookmark_value>imaginary numbers in analysis functions</bookmark_value>
       <bookmark_value>complex numbers in analysis functions</bookmark_value>
 </bookmark>
-<paragraph xml-lang="en-US" id="hd_id3154659" role="heading" level="1" l10n="U" oldref="1">Add-in Functions, List of Analysis Functions Part Two</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154659" role="heading" level="1" l10n="U" oldref="1"><variable id="head_addin_analysis_two"><link href="text/scalc/01/04060116.xhp" name="Add-in Functions, List of Analysis Functions Part Two">Add-in Functions, List of Analysis Functions Part Two</link></variable></paragraph>
       <section id="howtoget">
          <embed href="text/scalc/00/00000404.xhp#addinana"/>
       </section>
-      <section id="relatedtopics">
-         <paragraph xml-lang="en-US" id="par_id3151242" role="paragraph" l10n="U" oldref="174"><link href="text/scalc/01/04060108.xhp" name="Category Statistics">Category Statistics</link></paragraph>
-         <paragraph xml-lang="en-US" id="par_id3148869" role="paragraph" l10n="U" oldref="5"><link href="text/scalc/01/04060115.xhp" name="Analysis Functions Part One">Analysis Functions Part One</link></paragraph>
-         <paragraph xml-lang="en-US" id="par_id3147072" role="paragraph" l10n="U" oldref="240"><link href="text/scalc/01/04060111.xhp" name="Back to the Overview">Back to the Overview</link></paragraph>
-      </section>
 <sort>
 <section id="imabs">
          <paragraph xml-lang="en-US" id="par_id3145074" role="paragraph" l10n="E" oldref="166"
@@ -779,8 +774,11 @@
             <item type="input">=FACTDOUBLE(0)</item> returns 1.</paragraph><comment>see also FACT, MULTINOMIAL, PRODUCT  </comment>
 </section>
 </sort>
-<section id="Section1">
-         <embed href="text/scalc/01/04060100.xhp#drking"/>
-      </section>
+<section id="relatedtopics">
+    <paragraph xml-lang="en-US" id="par_id3147072" role="paragraph" localize="false" oldref="240"><embedvar href="text/scalc/01/04060111.xhp#head_addin"/></paragraph>
+    <paragraph xml-lang="en-US" id="par_id3148869" role="paragraph" localize="false" oldref="5"><embedvar href="text/scalc/01/04060115.xhp#head_addin_analysis_one"/></paragraph>
+    <paragraph xml-lang="en-US" id="par_id3151242" role="paragraph" localize="false" oldref="174"><embedvar href="text/scalc/01/04060108.xhp#head_statistic"/></paragraph>
+    <paragraph id="par_id260920161704025898" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/04060100.xhp#drking"/></paragraph>
+</section>
    </body>
 </helpdocument>