diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-10-24 09:19:57 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-10-24 17:52:30 +0200 |
| commit | 6d3349d68ca4d6a488d7226f18012f2a69de4f7d (patch) | |
| tree | 9bc75f6e8c9851bbc9cfc7aa3464939e144558dc /source/text | |
| parent | e60bf0a677ddf64ba4d5bda78399f9991c5a665e (diff) | |
Completion of CHAR and CLEAN functions
Added link to wiki pages.
Change-Id: I9c5b5d44f05c8d803994cd9efc864ab873bdd386
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175554
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text')
| -rw-r--r-- | source/text/scalc/01/func_char.xhp | 5 | ||||
| -rw-r--r-- | source/text/scalc/01/func_clean.xhp | 5 |
2 files changed, 8 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_char.xhp b/source/text/scalc/01/func_char.xhp index 5b2db08ace..b96bbdd3ef 100644 --- a/source/text/scalc/01/func_char.xhp +++ b/source/text/scalc/01/func_char.xhp @@ -34,5 +34,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3149890" role="paragraph"> <item type="input">=CHAR(100)</item> returns the character d.</paragraph> <paragraph id="par_id0907200910283297" role="paragraph">="abc" & CHAR(10) & "def" inserts a newline character into the string.</paragraph> + <section id="relatedtopics"> + <tip id="par_id411677015788900"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHAR">CHAR wiki page</link>.</tip> + </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/01/func_clean.xhp b/source/text/scalc/01/func_clean.xhp index 9897db361c..a9d1e5e517 100644 --- a/source/text/scalc/01/func_clean.xhp +++ b/source/text/scalc/01/func_clean.xhp @@ -34,5 +34,8 @@ <paragraph id="par_id3150695" role="paragraph"> <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 id="relatedtopics"> + <tip id="par_id411677015788900"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CLEAN">CLEAN wiki page</link>.</tip> + </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |