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

New commits:
commit 44bd3d8205dd9020b9725a03518cb1316d3062fa
Author:     Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Wed May 19 22:21:04 2021 +0200
Commit:     Olivier Hallot <olivier.hal...@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.hal...@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) &amp; "LibreOffice Calc" 
&amp; 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">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Reply via email to