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

[Steve Fanning (via logerrit)]

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

New commits:
commit 44bd3d8205dd9020b9725a03518cb1316d3062fa
Author:     Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Wed May 19 22:21:04 2021 +0200
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Fri May 21 01:15:09 2021 +0200

    Add example to help description for Calc's CLEAN function.
    
    Change-Id: Iae7a1f0b8b84be33f5f54a9a7116c0c48670f917
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115833
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 59ded0137..3a4ab2306 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -163,6 +163,10 @@
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3147472" role="code" xml-lang="en-US">CLEAN("Text")</paragraph>
 <paragraph id="par_id3150695" role="paragraph" xml-lang="en-US"> <emph>Text</emph> refers to the text from which to remove all non-printable characters.</paragraph>
+  
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph role="paragraph" id="par_id581621538151600"><input>=LEN(CLEAN(CHAR(7) & "LibreOffice Calc" & CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the beginning and end of the string argument. CLEAN does not remove spaces.</paragraph>
+  
 </section>
 
 <section id="code">