source/text/scalc/01/func_proper.xhp | 4 ++++
source/text/scalc/01/func_replace.xhp | 4 ++++
source/text/scalc/01/func_rept.xhp | 5 ++++-
source/text/scalc/01/func_right.xhp | 4 ++++
source/text/scalc/01/func_search.xhp | 4 ++++
source/text/scalc/01/func_substitute.xhp | 4 ++++
source/text/scalc/01/func_t.xhp | 4 ++++
source/text/scalc/01/func_text.xhp | 4 ++++
source/text/scalc/01/func_trim.xhp | 4 ++++
source/text/scalc/01/func_unichar.xhp | 8 ++++++--
source/text/scalc/01/func_unicode.xhp | 8 ++++++--
source/text/scalc/01/func_upper.xhp | 4 ++++
12 files changed, 52 insertions(+), 5 deletions(-)
New commits:
commit 02fd40af9c8a62babb4d8549be8af8dcd39f7635
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Nov 2 15:10:27 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Nov 2 19:14:55 2024 +0100
Tweaks for text function for navigation (3)
Change-Id: I6a4246acf9e6ade45e9692a24fb358fc44a90a05
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175955
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/func_proper.xhp
b/source/text/scalc/01/func_proper.xhp
index 13b5ded0c0..14fcad9a3d 100644
--- a/source/text/scalc/01/func_proper.xhp
+++ b/source/text/scalc/01/func_proper.xhp
@@ -34,5 +34,9 @@
<paragraph id="par_id3147509" role="paragraph"> <emph>Text</emph> refers
to the text to be converted.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3155364" role="paragraph"> <item
type="input">=PROPER("the document foundation")</item> returns The Document
Foundation.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/PROPER";>PROPER
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_replace.xhp
b/source/text/scalc/01/func_replace.xhp
index bd039f80a0..bf55be77b8 100644
--- a/source/text/scalc/01/func_replace.xhp
+++ b/source/text/scalc/01/func_replace.xhp
@@ -36,5 +36,9 @@
<paragraph id="par_id3159188" role="paragraph"> <emph>NewText</emph>
refers to the text which replaces <emph>Text</emph>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3154096" role="paragraph"> <item
type="input">=REPLACE("1234567";1;1;"444")</item> returns "444234567". One
character at position 1 is replaced by the complete <item
type="literal">NewText</item>.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACE";>REPLACE
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_rept.xhp
b/source/text/scalc/01/func_rept.xhp
index 70c220eeaa..b96317412e 100644
--- a/source/text/scalc/01/func_rept.xhp
+++ b/source/text/scalc/01/func_rept.xhp
@@ -35,6 +35,9 @@
<paragraph id="par_id3150638" role="paragraph"> <emph>Number</emph> is the
number of repetitions.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3148626" role="paragraph"> <item
type="input">=REPT("Good morning";2)</item> returns Good morningGood
morning.</paragraph>
- <tip id="par_id381626381556310">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT";>REPT</link>
wiki page for more details about this function.</tip>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT";>REPT
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_right.xhp
b/source/text/scalc/01/func_right.xhp
index 4d94225118..504d12ad6d 100644
--- a/source/text/scalc/01/func_right.xhp
+++ b/source/text/scalc/01/func_right.xhp
@@ -35,5 +35,9 @@
<paragraph id="par_id3153350" role="paragraph"> <emph>Number</emph>
(optional) is the number of characters from the right part of the text. If this
parameter is not defined, one character is returned.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3151132" role="paragraph"> <item
type="input">=RIGHT("Sun";2)</item> returns un.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/RIGHT";>RIGHT
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_search.xhp
b/source/text/scalc/01/func_search.xhp
index 4bcc4bbf38..b05c75ddf0 100644
--- a/source/text/scalc/01/func_search.xhp
+++ b/source/text/scalc/01/func_search.xhp
@@ -35,5 +35,9 @@
<paragraph id="par_id3149559" role="paragraph"> <emph>Position</emph>
(optional) is the position in the text where the search is to start.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3154564" role="paragraph"> <item
type="input">=SEARCH(54;998877665544)</item> returns 10.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEARCH";>SEARCH
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_substitute.xhp
b/source/text/scalc/01/func_substitute.xhp
index 14e6a1daf3..784e34c724 100644
--- a/source/text/scalc/01/func_substitute.xhp
+++ b/source/text/scalc/01/func_substitute.xhp
@@ -38,5 +38,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3150412" role="paragraph"> <item
type="input">=SUBSTITUTE("123123123";"3";"abc")</item> returns
12abc12abc12abc.</paragraph>
<paragraph id="par_id3154915" role="paragraph"> <item
type="input">=SUBSTITUTE("123123123";"3";"abc";2)</item> returns
12312abc123.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUBSTITUTE";>SUBSTITUTE
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_t.xhp b/source/text/scalc/01/func_t.xhp
index bfd369c5d4..4075f190e0 100644
--- a/source/text/scalc/01/func_t.xhp
+++ b/source/text/scalc/01/func_t.xhp
@@ -36,5 +36,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3151062" role="paragraph"> <item
type="input">=T(12345)</item> returns an empty string. </paragraph>
<paragraph id="par_id4650105" role="paragraph"> <item
type="input">=T("12345")</item> returns the string 12345.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/T";>T
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_text.xhp
b/source/text/scalc/01/func_text.xhp
index f4d5daf969..0456c86acd 100644
--- a/source/text/scalc/01/func_text.xhp
+++ b/source/text/scalc/01/func_text.xhp
@@ -38,5 +38,9 @@
<paragraph id="par_id3674123" role="paragraph"> <item
type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph>
<paragraph id="par_id3674124" role="paragraph"> <item
type="input">=TEXT("xyz";"=== @ ===")</item> returns the text === xyz
===</paragraph>
<tip id="par_id3145364">See also <link
href="text/shared/01/05020301.xhp">Number format codes</link>: custom format
codes defined by the user.</tip>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXT";>TEXT
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_trim.xhp
b/source/text/scalc/01/func_trim.xhp
index 9f69efa813..d523c736e7 100644
--- a/source/text/scalc/01/func_trim.xhp
+++ b/source/text/scalc/01/func_trim.xhp
@@ -34,5 +34,9 @@
<paragraph id="par_id3151362" role="paragraph"> <emph>Text</emph> refers
to text in which spaces are to be removed.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3156074" role="paragraph"> <item type="input">=TRIM("
hello world ")</item> returns hello world without leading and trailing
spaces and with single space between words.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRIM";>TRIM
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_unichar.xhp
b/source/text/scalc/01/func_unichar.xhp
index 51893f7623..f03f5e1421 100644
--- a/source/text/scalc/01/func_unichar.xhp
+++ b/source/text/scalc/01/func_unichar.xhp
@@ -34,7 +34,11 @@
<item type="literal">UNICHAR(number)</item>
</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
- <paragraph id="par_id090720090412378" role="paragraph">=UNICHAR(169)
returns the Copyright character <emph>©</emph>.</paragraph>
- <tip id="par_id050220170755399756">See also the UNICODE() function.</tip>
+ <paragraph id="par_id090720090412378"
role="paragraph"><input>=UNICHAR(169)</input> returns the Copyright character
<emph>©</emph>.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/UNICHAR";>UNICHAR
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id050220170755399756"
localize="false"><embedvar
href="text/scalc/01/func_unicode.xhp#unicode_h1"/></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_unicode.xhp
b/source/text/scalc/01/func_unicode.xhp
index b118a2637a..d111e501ce 100644
--- a/source/text/scalc/01/func_unicode.xhp
+++ b/source/text/scalc/01/func_unicode.xhp
@@ -34,7 +34,11 @@
<item type="literal">UNICODE("Text")</item>
</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
- <paragraph id="par_id0907200904123919" role="paragraph">=UNICODE("©")
returns the Unicode number 169 for the Copyright character.</paragraph>
- <tip id="par_id050220170755393174">See also the UNICHAR() function.</tip>
+ <paragraph id="par_id0907200904123919"
role="paragraph"><input>=UNICODE("©")</input> returns the Unicode number 169
for the Copyright character.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/UNICODE";>UNICODE
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id050220170755399756"
localize="false"><embedvar
href="text/scalc/01/func_unichar.xhp#unichar_h1"/></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_upper.xhp
b/source/text/scalc/01/func_upper.xhp
index 15fd132ca9..de596ee670 100644
--- a/source/text/scalc/01/func_upper.xhp
+++ b/source/text/scalc/01/func_upper.xhp
@@ -34,5 +34,9 @@
<paragraph id="par_id3148496" role="paragraph"> <emph>Text</emph> refers
to the lower case letters you want to convert to upper case.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3146757" role="paragraph"> <item
type="input">=UPPER("Good Morning")</item> returns GOOD MORNING.</paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/UPPER";>UPPER
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+ </section>
</body>
</helpdocument>
