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) & "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"> _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits