source/text/scalc/01/04060110.xhp | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
New commits:
commit bb7b1fec521559170657017a193f4cc83fa8be3d
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Thu Mar 26 09:51:01 2020 +0100
Commit: Mike Kaganski <mike.kagan...@collabora.com>
CommitDate: Thu Mar 26 09:55:24 2020 +0100
Clarify TEXT spreadsheet function's first parameter (not only number)
Change-Id: Icf5c8a6ff2fe5f9238afdb9c35e22eb91937f778
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91106
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 22b1e92fd..91ff8aa62 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -672,16 +672,17 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEXT" id="bm_id3156426"
localize="false"/>
<h2 id="hd_id3147132">TEXT</h2>
-<paragraph id="par_id3147213" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_TEXT">Converts a number into text according to a given
format.</ahelp></paragraph>
+<paragraph id="par_id3147213" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_TEXT">Converts a value into text according to a given
format.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3147377" role="code" xml-lang="en-US">TEXT(Number;
Format)</paragraph>
-<paragraph id="par_id3147389" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is the numerical value to be converted.</paragraph>
+<paragraph id="par_id3147377" role="code" xml-lang="en-US">TEXT(Value;
Format)</paragraph>
+<paragraph id="par_id3147389" role="paragraph" xml-lang="en-US">
<emph>Value</emph> is the value (numerical or textual) to be
converted.</paragraph>
<paragraph id="par_id3156167" role="paragraph" xml-lang="en-US">
<emph>Format</emph> is the text which defines the format. Use decimal and
thousands separators according to the language set in the cell
format.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id9044770" role="paragraph" xml-lang="en-US"> <item
type="input">=TEXT(12.34567;"###.##")</item> returns the text 12.35</paragraph>
<paragraph id="par_id3674123" role="paragraph" xml-lang="en-US"> <item
type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph>
+<paragraph id="par_id3674124" role="paragraph" xml-lang="en-US"> <item
type="input">=TEXT("xyz";"=== @ ===")</item> returns the text === xyz
===</paragraph>
<tip id="par_id3145364">See also <link href="text/shared/01/05020301.xhp"
name="Number format codes">Number format codes</link>: custom format codes
defined by the user.</tip>
</section>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
