Improve NUMBERVALUE help page

This patch improves the help page by adding some of the new contents available in the Wiki:
https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE

Change-Id: Icf21b924973d7e12a67e11c3c213765a3a06c0fc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118494
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

4 files changed, 28 insertions, 11 deletions

diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 7ca7d5cdf1..cee63d9d76 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -800,7 +800,7 @@
 
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WERT" id="bm_id3150814" localize="false"/>
 
-<h2 id="hd_id3150802">VALUE</h2>
+<h2 id="hd_id3150802"><variable id="ValueFunction"><link href="text/scalc/01/04060110.xhp#value" name="ValueLink">VALUE</link></variable></h2>
 <paragraph id="par_id3152551" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WERT">Converts a text string into a number.</ahelp></paragraph>
 
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp
index 8a3f7241ad..87be416917 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -21,6 +21,9 @@
     <section id="sectionexample">
         <h3 id="hd_id281171">Example</h3>
     </section>
+    <section id="sectionexamples">
+        <h3 id="hd_id281996">Examples</h3>
+    </section>
     <section id="datenumbersequencenote">
         <note id="par_id301616845402409">This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href="text/scalc/01/03080000.xhp" name="value highlight">value highlighting</link> feature.</note>
     </section>
diff --git a/source/text/scalc/01/func_numbervalue.xhp b/source/text/scalc/01/func_numbervalue.xhp
index 026f8a5926..a0ccbe1724 100644
--- a/source/text/scalc/01/func_numbervalue.xhp
+++ b/source/text/scalc/01/func_numbervalue.xhp
@@ -34,16 +34,30 @@
       </variable>
     </paragraph>
     <paragraph xml-lang="en-US" id="par_id3145087" role="paragraph">
-      <ahelp hid="HID_FUNC_NUMBERVALUE">Convert text to number, in a locale-independent way.</ahelp>
+      <ahelp hid="HID_FUNC_NUMBERVALUE">Converts the string representation of a number into a locale-independent numeric value.</ahelp>
     </paragraph>
-    <paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator</paragraph>
     <embed href="text/scalc/00/avail_release.xhp#4.1"/>
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-    <paragraph xml-lang="en-US" id="par_id3149268" role="code">NUMBERVALUE("Text" [;decimal_separator [;group_separator]])</paragraph>
-    <paragraph xml-lang="en-US" id="par_id3154819" role="paragraph"><emph>Text</emph> is a valid number expression and must be entered with quotation marks.</paragraph>
-    <paragraph xml-lang="en-US" id="par_id3154820" role="paragraph"><emph>decimal_separator</emph> (optional) defines the character used as the decimal separator.</paragraph>
-    <paragraph xml-lang="en-US" id="par_id3154821" role="paragraph"><emph>group_separator</emph> (optional) defines the character(s) used as the group separator.</paragraph>
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-    <paragraph xml-lang="en-US" id="par_id3155841" role="paragraph"><item  type="input">=NUMBERVALUE("123.456";".";",")</item> yields 123.456</paragraph>
+    <paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">The input text may be in a locale-dependent or other bespoke format.</paragraph>
+    <paragraph role="paragraph" id="par_id381625600941159">The output number is formatted as a valid floating point value and shown using the current cell's number format.</paragraph>
+    <tip id="par_id351625601754290">Refer to the <embedvar href="text/shared/01/05020300.xhp#NumbersLink"/> help page to learn how to change the format of numbers in a cell.</tip>
+    <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+    <paragraph role="code" id="par_id721625602228575">NUMBERVALUE(Text[; Decimal Separator[; Group Separator]])</paragraph>
+    <paragraph xml-lang="en-US" id="par_id3154819" role="paragraph"><emph>Text</emph> is a string that contains the number to be converted.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id3154820" role="paragraph"><emph>Decimal Separator</emph> is a single character that specifies the decimal separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any decimal or group separators.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id3154821" role="paragraph"><emph>Group Separator</emph> is a string that specifies the character(s) used as the group separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any group separators. The <emph>Decimal Separator</emph> character should not be used in <emph>Group Separator</emph>.</paragraph>
+    <embed href="text/scalc/01/common_func.xhp#sectionexamples"/>
+    <paragraph xml-lang="en-US" id="par_id3155841" role="paragraph">
+      <input>=NUMBERVALUE("1.234.567,89"; ","; ".")</input> returns 1234567.89 (considering en-US locale). The function removes the two group separators and changes the decimal separator from a comma to a full stop.</paragraph>
+    <paragraph role="paragraph" id="par_id721625603302860">
+      <input>=NUMBERVALUE("123·4"; "·")</input> returns 123.4 (considering en-US locale). The function changes the decimal separator from a "·" to a full stop. No group separator is used in the supplied number and so the <emph>Group Separator</emph> argument is omitted.</paragraph>
+    <paragraph role="paragraph" id="par_id491625603415715">
+      <input>=NUMBERVALUE("123e12")</input> returns 1.23E+14 (considering en-US locale). No decimal or group separators are used in the supplied number and so the <emph>Decimal Separator</emph> and <emph>Group Separator</emph> arguments are omitted.</paragraph>
+    <paragraph role="paragraph" id="par_id801625603497421">
+      <input>=NUMBERVALUE("1#!234#!567"; "."; "#!")</input> returns 1234567 (considering en-US locale). Note that in this case the group separator is specified as a two-character string.</paragraph>
+  <tip id="par_id451626100385699">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE" name="NUMBERVALUE_Wiki">NUMBERVALUE</link> wiki page for more details about this function.</tip>
+
+  <section id="relatedtopics">
+    <embed href="text/scalc/01/04060110.xhp#ValueFunction"/>
+  </section>
   </body>
 </helpdocument>
diff --git a/source/text/shared/01/05020300.xhp b/source/text/shared/01/05020300.xhp
index 17f0311b2c..4bb82c6a7b 100644
--- a/source/text/shared/01/05020300.xhp
+++ b/source/text/shared/01/05020300.xhp
@@ -39,7 +39,7 @@
 <section id="numbersh1">
 <switch select="appl">
 <case select="CALC">
-<h1 id="hd_id3162942"><link href="text/shared/01/05020300.xhp" name="Numbers">Numbers</link></h1>
+<h1 id="hd_id3162942"><variable id="NumbersLink"><link href="text/shared/01/05020300.xhp" name="Numbers">Numbers</link></variable></h1>
 <paragraph xml-lang="en-US" id="par_id3145071" role="paragraph"><variable id="zahlen"><ahelp hid=".uno:TableNumberFormatDialog">Specify the formatting options for the selected cell(s).</ahelp></variable></paragraph>
 </case>
 <default>