diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2021-05-19 22:21:04 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-05-21 01:15:09 +0200 |
| commit | 44bd3d8205dd9020b9725a03518cb1316d3062fa (patch) | |
| tree | 4cae2c2d2c0a6b55285d2ea896a6f32128f81055 | |
| parent | 774b852c14a4a8df49c9ad35e609d8060b9b46a1 (diff) | |
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@libreoffice.org>
| -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"> |