diff options
| -rw-r--r-- | source/text/scalc/01/04060110.xhp | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 59ded0137f..3a4ab2306f 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"> |