source/text/scalc/01/04060110.xhp | 2 -
source/text/scalc/01/common_func.xhp | 3 ++
source/text/scalc/01/func_numbervalue.xhp | 32 +++++++++++++++++++++---------
source/text/shared/01/05020300.xhp | 2 -
4 files changed, 28 insertions(+), 11 deletions(-)
New commits:
commit 3b9bcb7ae54aed523e1b0f4bce7f8f05ad64a20a
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Tue Jul 6 22:48:50 2021 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Jul 13 13:25:54 2021 +0200
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.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 7ca7d5cdf..cee63d9d7 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 8a3f7241a..87be41691 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 026f8a592..a0ccbe172 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 17f0311b2..4bb82c6a7 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
