[Libreoffice-commits] help.git: source/text

Mike Kaganski (via logerrit) logerrit at kemper.freedesktop.org
Thu Mar 26 08:55:43 UTC 2020


 source/text/scalc/01/04060110.xhp |    7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

New commits:
commit bb7b1fec521559170657017a193f4cc83fa8be3d
Author:     Mike Kaganski <mike.kaganski at collabora.com>
AuthorDate: Thu Mar 26 09:51:01 2020 +0100
Commit:     Mike Kaganski <mike.kaganski at 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.kaganski at 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>


More information about the Libreoffice-commits mailing list