source/text/scalc/01/func_aggregate.xhp | 1 +
source/text/scalc/01/func_arabic.xhp | 1 +
source/text/scalc/01/func_asc.xhp | 1 +
source/text/scalc/01/func_averageif.xhp | 1 +
source/text/scalc/01/func_averageifs.xhp | 1 +
source/text/scalc/01/func_ceiling.xhp | 3 ++-
source/text/scalc/01/func_color.xhp | 3 +++
source/text/scalc/01/func_concat.xhp | 1 +
source/text/scalc/01/func_convert.xhp | 2 +-
source/text/scalc/01/func_countifs.xhp | 1 +
source/text/scalc/01/func_date.xhp | 1 +
source/text/scalc/01/func_datedif.xhp | 1 +
source/text/scalc/01/func_datevalue.xhp | 1 +
source/text/scalc/01/func_day.xhp | 1 +
source/text/scalc/01/func_days.xhp | 1 +
source/text/scalc/01/func_days360.xhp | 1 +
source/text/scalc/01/func_eastersunday.xhp | 1 +
source/text/scalc/01/func_edate.xhp | 1 +
source/text/scalc/01/func_eomonth.xhp | 2 +-
source/text/scalc/01/func_error_type.xhp | 2 +-
source/text/scalc/01/func_findb.xhp | 1 +
source/text/scalc/01/func_floor.xhp | 1 +
source/text/scalc/01/func_forecastetsadd.xhp | 1 +
source/text/scalc/01/func_forecastetsmult.xhp | 1 +
source/text/scalc/01/func_forecastetspiadd.xhp | 1 +
source/text/scalc/01/func_forecastetspimult.xhp | 1 +
source/text/scalc/01/func_forecastetsseason.xhp | 1 +
source/text/scalc/01/func_forecastetsstatadd.xhp | 1 +
source/text/scalc/01/func_forecastetsstatmult.xhp | 1 +
source/text/scalc/01/func_fourier.xhp | 1 +
source/text/scalc/01/func_hour.xhp | 1 +
source/text/scalc/01/func_ifs.xhp | 1 +
source/text/scalc/01/func_imcos.xhp | 1 +
source/text/scalc/01/func_imcosh.xhp | 1 +
source/text/scalc/01/func_imcot.xhp | 1 +
source/text/scalc/01/func_imcsc.xhp | 1 +
source/text/scalc/01/func_imcsch.xhp | 1 +
source/text/scalc/01/func_imsec.xhp | 1 +
source/text/scalc/01/func_imsech.xhp | 1 +
source/text/scalc/01/func_imsin.xhp | 1 +
source/text/scalc/01/func_imsinh.xhp | 1 +
source/text/scalc/01/func_imtan.xhp | 1 +
source/text/scalc/01/func_isoweeknum.xhp | 1 +
source/text/scalc/01/func_jis.xhp | 1 +
source/text/scalc/01/func_maxifs.xhp | 1 +
source/text/scalc/01/func_minifs.xhp | 1 +
source/text/scalc/01/func_minute.xhp | 1 +
source/text/scalc/01/func_month.xhp | 1 +
source/text/scalc/01/func_networkdays.intl.xhp | 1 +
source/text/scalc/01/func_networkdays.xhp | 1 +
source/text/scalc/01/func_now.xhp | 1 +
source/text/scalc/01/func_numbervalue.xhp | 1 +
source/text/scalc/01/func_opt_barrier.xhp | 1 +
source/text/scalc/01/func_opt_prob_hit.xhp | 1 +
source/text/scalc/01/func_opt_prob_inmoney.xhp | 1 +
source/text/scalc/01/func_opt_touch.xhp | 1 +
source/text/scalc/01/func_rawsubtract.xhp | 3 +++
source/text/scalc/01/func_regex.xhp | 1 +
source/text/scalc/01/func_replaceb.xhp | 3 +--
source/text/scalc/01/func_roman.xhp | 1 +
source/text/scalc/01/func_rounddown.xhp | 1 +
source/text/scalc/01/func_roundsig.xhp | 1 +
source/text/scalc/01/func_searchb.xhp | 1 +
source/text/scalc/01/func_second.xhp | 3 ++-
source/text/scalc/01/func_skewp.xhp | 1 +
source/text/scalc/01/func_style.xhp | 1 +
source/text/scalc/01/func_sum.xhp | 10 +++++-----
source/text/scalc/01/func_sumifs.xhp | 1 +
source/text/scalc/01/func_switch.xhp | 1 +
source/text/scalc/01/func_textjoin.xhp | 1 +
source/text/scalc/01/func_time.xhp | 3 ++-
source/text/scalc/01/func_timevalue.xhp | 3 ++-
source/text/scalc/01/func_today.xhp | 1 +
source/text/scalc/01/func_trunc.xhp | 1 +
source/text/scalc/01/func_value.xhp | 1 +
source/text/scalc/01/func_webservice.xhp | 10 +++++++++-
source/text/scalc/01/func_weekday.xhp | 1 +
source/text/scalc/01/func_weeknum.xhp | 1 +
source/text/scalc/01/func_weeknum_ooo.xhp | 1 +
source/text/scalc/01/func_weeknumadd.xhp | 1 +
source/text/scalc/01/func_workday.intl.xhp | 1 +
source/text/scalc/01/func_workday.xhp | 1 +
source/text/scalc/01/func_year.xhp | 1 +
83 files changed, 103 insertions(+), 15 deletions(-)
New commits:
commit 5639f320e16619cd9f5b099752317eee10973125
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Feb 21 19:24:24 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Feb 22 11:09:36 2023 +0000
Add links to wiki for Calc Functions (part)
Change-Id: I454e60818fb30d154653d7ba2d343f72dc2f8581
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147427
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_aggregate.xhp
b/source/text/scalc/01/func_aggregate.xhp
index 656baaa9ae..a18f0b4765 100644
--- a/source/text/scalc/01/func_aggregate.xhp
+++ b/source/text/scalc/01/func_aggregate.xhp
@@ -433,6 +433,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.AGGREGATE</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id651677017267822"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AGGREGATE";>AGGREGATE
wiki page</link>.</tip>
<paragraph id="par_id241712879431120" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060184.xhp#average">AVERAGE</link>, <link
href="text/scalc/01/04060181.xhp#count">COUNT</link>, <link
href="text/scalc/01/04060181.xhp#counta">COUNTA</link>, <link
href="text/scalc/01/04060184.xhp#max">MAX</link>, <link
href="text/scalc/01/04060184.xhp#min">MIN</link>, <link
href="text/scalc/01/04060106.xhp#Section26">PRODUCT</link>, <link
href="text/scalc/01/04060185.xhp#stdevdots">STDEV.S</link>, <link
href="text/scalc/01/04060185.xhp#stdevdotp">STDEV.P</link>, <link
href="text/scalc/01/04060106.xhp#Section16">SUM</link>, <link
href="text/scalc/01/04060185.xhp#vardots">VAR.S</link>, <link
href="text/scalc/01/04060185.xhp#vardotp">VAR.P</link>, <link
href="text/scalc/01/04060184.xhp#median">MEDIAN</link>, <link
href="text/scalc/01/04060184.xhp#modedotsngl">MODE.SNGL</link>, <link
href="text/scalc/01/04060183.xhp#large">LARGE</link>, <link
href="text/scalc/01/04060183.xhp#small">SMALL
</link>, <link
href="text/scalc/01/04060184.xhp#percentileinc">PERCENTILE.INC</link> , <link
href="text/scalc/01/04060184.xhp#quartileinc">QUARTILE.INC</link>, <link
href="text/scalc/01/04060184.xhp#percentileexc">PERCENTILE.EXC</link>, <link
href="text/scalc/01/04060184.xhp#quartileexc">QUARTILE.EXC</link></paragraph>
<paragraph id="par_id125062615028497" role="paragraph" xml-lang="en-US"><link
href="text/shared/optionen/01060500.xhp#hd_id3156199">Automatically find column
and row labels</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_arabic.xhp
b/source/text/scalc/01/func_arabic.xhp
index 4b1ab51eb2..f597ef5c06 100644
--- a/source/text/scalc/01/func_arabic.xhp
+++ b/source/text/scalc/01/func_arabic.xhp
@@ -35,6 +35,7 @@
<paragraph role="paragraph"
id="par_id101628778036134"><input>=ARABIC("")</input> returns 0.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id721677017247207"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ARABIC";>ARABIC
wiki page</link>.</tip>
<embed href="text/scalc/01/func_roman.xhp#Roman_h1"/>
<paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
</section>
diff --git a/source/text/scalc/01/func_asc.xhp
b/source/text/scalc/01/func_asc.xhp
index 22f5cdb029..a9f0974f7a 100644
--- a/source/text/scalc/01/func_asc.xhp
+++ b/source/text/scalc/01/func_asc.xhp
@@ -35,6 +35,7 @@
<paragraph role="paragraph"
id="par_id101628778036375"><input>=ASC("ライト")</input> returns the string "ﾗｲﾄ",
which is composed of single-byte characters.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id931677017229646"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASC";>ASC
wiki page</link>.</tip>
<embed href="text/scalc/01/func_jis.xhp#Jis_h1"/>
<embed href="text/scalc/01/04060110.xhp#head_text"/>
</section>
diff --git a/source/text/scalc/01/func_averageif.xhp
b/source/text/scalc/01/func_averageif.xhp
index 5fbfb61f55..8da396d2ca 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -66,6 +66,7 @@ If the whole range is empty, contains only text or all values
of the range do no
<paragraph id="par_id316901523627285" role="paragraph" xml-lang="en-US"><item
type="input">=AVERAGEIF(B2:B6;"<"&E2;C2:C6)</item></paragraph>
<paragraph id="par_id302181300528607" role="paragraph" xml-lang="en-US">The
function searches what cells from the range B2:B6 are less than the value
specified in E2, and calculates the average of corresponding values from the
C2:C6 range. If E2 = 35, the function returns 145.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id421677017213184"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF";>AVERAGEIF
wiki page</link>.</tip>
<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"
localize="false">
<embedvar href="text/scalc/01/04060184.xhp#average_head"/>,
<embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>,
diff --git a/source/text/scalc/01/func_averageifs.xhp
b/source/text/scalc/01/func_averageifs.xhp
index 2e28b34118..ee15589df8 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -55,6 +55,7 @@
<paragraph id="par_id65612244926745" role="paragraph" xml-lang="en-US">If E2 =
pen, the function returns 65, because the link to the cell is substituted with
its content.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
+ <tip id="par_id371677017196557"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS";>AVERAGEIFS
wiki page</link>.</tip>
<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"
localize="false">
<embedvar href="text/scalc/01/04060184.xhp#average_head"/>,
<embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>,
diff --git a/source/text/scalc/01/func_ceiling.xhp
b/source/text/scalc/01/func_ceiling.xhp
index 37d0060162..b52b1a453e 100644
--- a/source/text/scalc/01/func_ceiling.xhp
+++ b/source/text/scalc/01/func_ceiling.xhp
@@ -23,7 +23,7 @@
</bookmark>
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OBERGRENZE"
id="bm_id3152530" localize="false"/>
- <h1 id="hd_id3152518"><variable id="CEILINGh1"><link
href="text/scalc/01/func_ceiling.xhp#ceiling">CEILING</link></variable></h1>
+ <h2 id="hd_id3152518"><variable id="CEILINGh1"><link
href="text/scalc/01/func_ceiling.xhp#ceiling">CEILING</link></variable></h2>
<paragraph id="par_id3153422" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_OBERGRENZE">Rounds a number to the nearest multiple of a
significance value.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id601586207136514">For a positive
number and a positive significance value, the function rounds up (away from
zero). For a negative number and a negative significance value, the direction
of rounding is determined by the value of a mode parameter. The function
returns an error if the number and significance values have opposite
signs.</paragraph>
<warning id="par_id3163792">If the spreadsheet is exported to
Microsoft Excel, the CEILING function is exported as the equivalent
CEILING.MATH function that has existed since Excel 2013. If you plan to use the
spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has
existed since Excel 2010, or CEILING.XCL that is exported as the CEILING
function compatible with all Excel versions.</warning>
@@ -141,6 +141,7 @@
<comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND,
ROUNDDOWN, ROUNDUP</comment>
</section>
<section id="relatedtopics">
+ <tip id="par_id971677016806972"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING";>CEILING</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.XCL";>CEILING.XCL</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.PRECISE";>CEILING.PRECISE</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISO.CEILING";>ISO.CEILING</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.MATH";>CEILING.MATH</link>
wiki pages.</tip>
<embed href="text/scalc/01/func_floor.xhp#FLOORh1"/>
<embed href="text/scalc/01/func_floor.xhp#FLOOR.XCLh1"/>
<embed href="text/scalc/01/func_floor.xhp#FLOOR.PRECISEh1"/>
diff --git a/source/text/scalc/01/func_color.xhp
b/source/text/scalc/01/func_color.xhp
index 26b6b6722c..bfcb7e7d35 100644
--- a/source/text/scalc/01/func_color.xhp
+++ b/source/text/scalc/01/func_color.xhp
@@ -49,5 +49,8 @@
<embed href="text/scalc/00/avail_release.xhp#4.4"/>
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.COLOR</literal></paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id61677016779611"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/COLOR";>COLOR
wiki page</link>.</tip>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_concat.xhp
b/source/text/scalc/01/func_concat.xhp
index a352297f99..277a43af4d 100644
--- a/source/text/scalc/01/func_concat.xhp
+++ b/source/text/scalc/01/func_concat.xhp
@@ -36,6 +36,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.CONCAT</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONCAT";>CONCAT
wiki page</link>.</tip>
<embed href="text/scalc/01/func_textjoin.xhp#textjoinfunct"/>
<paragraph role="paragraph" id="par_id781556244709752"><link
href="text/scalc/01/04060110.xhp#concatenate">CONCATENATE</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_convert.xhp
b/source/text/scalc/01/func_convert.xhp
index b7cad69a30..d89e69d872 100644
--- a/source/text/scalc/01/func_convert.xhp
+++ b/source/text/scalc/01/func_convert.xhp
@@ -1738,7 +1738,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.CONVERT</literal></paragraph>
<section id="relatedtopics">
- <paragraph role="paragraph" id="par_id871621424421294"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT";>CONVERT
Wiki page</link></paragraph>
+ <tip id="par_id871621424421294"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT";>CONVERT
Wiki page</link></tip>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_countifs.xhp
b/source/text/scalc/01/func_countifs.xhp
index a395c48bb4..a949fd34f2 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -57,6 +57,7 @@
<paragraph id="par_id738533068520" role="paragraph" xml-lang="en-US">If E2 =
pen, the function returns 1, because the link to the cell is substituted with
its content and it works as a function above.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
+ <tip id="par_id131677016670241"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIFS";>COUNTIFS
wiki page</link>.</tip>
<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"
localize="false">
<embedvar href="text/scalc/01/04060181.xhp#count_head"/>,
<embedvar href="text/scalc/01/04060181.xhp#countif_head"/>,
diff --git a/source/text/scalc/01/func_date.xhp
b/source/text/scalc/01/func_date.xhp
index 9d67547b04..be186d3a0c 100644
--- a/source/text/scalc/01/func_date.xhp
+++ b/source/text/scalc/01/func_date.xhp
@@ -44,6 +44,7 @@
<paragraph role="paragraph" id="par_id3152589" xml-lang="en-US">
<item type="input">=DATE(00;1;31)</item> yields 1/31/00 if the cell format
setting is MM/DD/YY.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id701677016652715"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE";>DATE
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_datedif.xhp
b/source/text/scalc/01/func_datedif.xhp
index ea722d5833..1e2c6fc385 100644
--- a/source/text/scalc/01/func_datedif.xhp
+++ b/source/text/scalc/01/func_datedif.xhp
@@ -107,6 +107,7 @@ Birthday calculation. A man was born on 1974-04-17. Today
is 2012-06-13.</paragr
<paragraph role="paragraph" id="par_id3752589" xml-lang="en-US">
<item type="input">=DATEDIF("1974-04-17";DATE(2012;06;13);"yd")</item> yields
57, his birthday was 57 days ago.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id311677016639702"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEDIF";>DATEDIF
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_datevalue.xhp
b/source/text/scalc/01/func_datevalue.xhp
index b51253d5f3..430fa46503 100644
--- a/source/text/scalc/01/func_datevalue.xhp
+++ b/source/text/scalc/01/func_datevalue.xhp
@@ -45,6 +45,7 @@
<paragraph xml-lang="en-US" id="par_id3155841" role="paragraph">
<item type="input">=DATEVALUE("1954-07-20")</item> yields
19925.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id331677016625664"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEVALUE";>DATEVALUE
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_day.xhp
b/source/text/scalc/01/func_day.xhp
index a407680530..434f5bae47 100644
--- a/source/text/scalc/01/func_day.xhp
+++ b/source/text/scalc/01/func_day.xhp
@@ -40,6 +40,7 @@
<paragraph role="paragraph" id="par_id3154130" xml-lang="en-US"><item
type="input">=DAY(NOW())</item> returns the current day.</paragraph>
<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US"><item
type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the
date value might get formatted differently after you press Enter).</paragraph>
<section id="relatedtopics">
+ <tip id="par_id951677016613386"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAY";>DAY
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_days.xhp
b/source/text/scalc/01/func_days.xhp
index fe5e71a328..308c4cf5d7 100644
--- a/source/text/scalc/01/func_days.xhp
+++ b/source/text/scalc/01/func_days.xhp
@@ -40,6 +40,7 @@
<paragraph role="paragraph" id="par_id3159101" xml-lang="en-US"><item
type="input">=DAYS(NOW();"2010-01-01"))</item> returns the number of days from
January 1, 2010 until today.</paragraph>
<paragraph role="paragraph" id="par_id3163720" xml-lang="en-US"><item
type="input">=DAYS("1990-10-10";"1980-10-10")</item> returns 3652
days.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id381677016601040"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAYS";>DAYS
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_days360.xhp
b/source/text/scalc/01/func_days360.xhp
index e7c5a8e30d..70cdceea1d 100644
--- a/source/text/scalc/01/func_days360.xhp
+++ b/source/text/scalc/01/func_days360.xhp
@@ -39,6 +39,7 @@
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<paragraph role="paragraph" id="par_id3156348" xml-lang="en-US"><item
type="input">=DAYS360("2000-01-01";NOW())</item> returns the number of interest
days from January 1, 2000 until today.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id981677016583605"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAYS360";>DAYS360
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_eastersunday.xhp
b/source/text/scalc/01/func_eastersunday.xhp
index d93d4047d5..32d10a9041 100644
--- a/source/text/scalc/01/func_eastersunday.xhp
+++ b/source/text/scalc/01/func_eastersunday.xhp
@@ -44,6 +44,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.EASTERSUNDAY</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id331677016571572"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EASTERSUNDAY";>EASTERSUNDAY
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_edate.xhp
b/source/text/scalc/01/func_edate.xhp
index a9937748c0..87b08cded6 100644
--- a/source/text/scalc/01/func_edate.xhp
+++ b/source/text/scalc/01/func_edate.xhp
@@ -44,6 +44,7 @@
<paragraph role="paragraph" id="par_id3155999" xml-lang="en-US">
<item type="input">=EDATE("2001-03-31";-1)</item> returns the serial number
36950. Formatted as a date, this is 2001-02-28.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id621677016556933"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EDATE";>EDATE
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_eomonth.xhp
b/source/text/scalc/01/func_eomonth.xhp
index a3f8abc8bf..b706b9f3cf 100644
--- a/source/text/scalc/01/func_eomonth.xhp
+++ b/source/text/scalc/01/func_eomonth.xhp
@@ -43,7 +43,7 @@
<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US"><item
type="input">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number
37346. Formatted as a date, this is 2002-03-31.</paragraph>
<paragraph role="paragraph" id="par_id3156144" xml-lang="en-US"><item
type="input">=EOMONTH("2001-09-14";6)</item> works as well. If you specify the
date directly, we recommend using the standard ISO 8601 format because this
should be independent of your selected locale settings.</paragraph>
<section id="relatedtopics">
- <paragraph role="paragraph" id="par_id681621540307527"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH";>EOMONTH
wiki page</link></paragraph>
+ <tip id="par_id791677012677088"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH";>EOMONTH
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_error_type.xhp
b/source/text/scalc/01/func_error_type.xhp
index 59d526430b..5cd4f9173b 100644
--- a/source/text/scalc/01/func_error_type.xhp
+++ b/source/text/scalc/01/func_error_type.xhp
@@ -121,9 +121,9 @@
<paragraph id="par_id12475201719494" role="paragraph" xml-lang="en-US">The
ISERROR function returns TRUE or FALSE depending on whether there is an error
or not. If the error takes place, the function IF addresses to the second
argument, if there is no error, it returns the result of the division. The
second argument checks the index number representing the specific Error type,
and if it is equal to 2, it returns the specified text "the denominator can't
be zero" or 0 otherwise. Thus, clear text would signify the division by zero,
the result of the division would appear when the division is successful, or if
there is, for example, an error of another type, zero would be
returned.</paragraph>
<warning id="par_id26251175451270">If the ERROR.TYPE function is used as
condition of the IF function and the ERROR.TYPE returns #N/A, the IF function
returns #N/A as well. Use ISERROR to avoid it as shown in the example
above.</warning>
<section id="relatedtopics">
+<tip id="par_id201677013027422"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ERROR.TYPE";>ERROR.TYPE
wiki page</link>.</tip>
<paragraph id="par_id352953529535295" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060104.xhp#iserror">ISERROR</link>, <link
href="text/scalc/01/04060104.xhp#na">NA</link>, <link
href="text/scalc/01/04060104.xhp#Section4">IF</link></paragraph>
<paragraph id="par_id312932390024933" role="paragraph" xml-lang="en-US"><link
href="text/scalc/05/02140000.xhp">Error codes</link></paragraph>
</section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/func_findb.xhp
b/source/text/scalc/01/func_findb.xhp
index ef6411bb74..eb74621a38 100644
--- a/source/text/scalc/01/func_findb.xhp
+++ b/source/text/scalc/01/func_findb.xhp
@@ -34,6 +34,7 @@
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<paragraph role="paragraph" id="par_id481573517830373"><input>=FINDB("ａ";
"LibreOffice Ｃａｌｃ")</input> returns 15. The <emph>Find Text</emph> argument is
a text string that comprises a full-width, double-byte "a" character, while the
<emph>Text</emph> argument comprises 12 single-byte characters followed by four
full-width, double-byte characters.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id491677016507189"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FINDB";>FINDB
wiki page</link>.</tip>
<paragraph role="paragraph" localize="false"
id="par_id961573510093188"><embedvar
href="text/scalc/01/func_replaceb.xhp#replaceb" markup="ignore"/></paragraph>
<paragraph role="paragraph" localize="false"
id="par_id831573510098350"><embedvar
href="text/scalc/01/func_searchb.xhp#searchb" markup="ignore"/></paragraph>
<paragraph role="paragraph" localize="false"
id="par_id251573510740369"><embedvar href="text/scalc/01/04060110.xhp#lenbvar"
markup="ignore"/></paragraph>
diff --git a/source/text/scalc/01/func_floor.xhp
b/source/text/scalc/01/func_floor.xhp
index f60e5b3012..745a27e600 100644
--- a/source/text/scalc/01/func_floor.xhp
+++ b/source/text/scalc/01/func_floor.xhp
@@ -122,6 +122,7 @@
<paragraph role="paragraph" id="par_id341640873978703"
localize="false"><literal>COM.MICROSOFT.FLOOR</literal></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id911677016119101"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR";>FLOOR</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.MATH";>FLOOR.MATH</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.PRECISE";>FLOOR.PRECISE</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.XCL";>FLOOR.XCL</link>
wiki pages.</tip>
<embed href="text/scalc/01/func_ceiling.xhp#CEILINGh1"/>
<embed href="text/scalc/01/func_ceiling.xhp#CEILING.MATHh1"/>
<embed href="text/scalc/01/func_ceiling.xhp#CEILING.PRECISEh1"/>
diff --git a/source/text/scalc/01/func_forecastetsadd.xhp
b/source/text/scalc/01/func_forecastetsadd.xhp
index 75d66554ff..36b576fb7d 100644
--- a/source/text/scalc/01/func_forecastetsadd.xhp
+++ b/source/text/scalc/01/func_forecastetsadd.xhp
@@ -48,6 +48,7 @@
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.FORECAST.ETS</literal></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id691677016005343"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.ADD";>FORECAST.ETS.ADD
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
<link
href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
diff --git a/source/text/scalc/01/func_forecastetsmult.xhp
b/source/text/scalc/01/func_forecastetsmult.xhp
index 014b5d2ed1..b776719808 100644
--- a/source/text/scalc/01/func_forecastetsmult.xhp
+++ b/source/text/scalc/01/func_forecastetsmult.xhp
@@ -49,6 +49,7 @@
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FORECAST.ETS.MULT</literal></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id501677015984498"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.MULT";>FORECAST.ETS.MULT
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
<link
href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
diff --git a/source/text/scalc/01/func_forecastetspiadd.xhp
b/source/text/scalc/01/func_forecastetspiadd.xhp
index 633b99b810..7f0d0ed62e 100644
--- a/source/text/scalc/01/func_forecastetspiadd.xhp
+++ b/source/text/scalc/01/func_forecastetspiadd.xhp
@@ -53,6 +53,7 @@
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.COFINT</literal></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id221677015965308"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.PI.ADD";>FORECAST.ETS.PI.ADD
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
<link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
diff --git a/source/text/scalc/01/func_forecastetspimult.xhp
b/source/text/scalc/01/func_forecastetspimult.xhp
index 3419231172..63162a5a87 100644
--- a/source/text/scalc/01/func_forecastetspimult.xhp
+++ b/source/text/scalc/01/func_forecastetspimult.xhp
@@ -53,6 +53,7 @@
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FORECAST.ETS.PI.MULT</literal></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id401677015936466"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.PI.MULT";>FORECAST.ETS.PI.MULT
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
<link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
diff --git a/source/text/scalc/01/func_forecastetsseason.xhp
b/source/text/scalc/01/func_forecastetsseason.xhp
index a747be5e91..6bcbbefa66 100644
--- a/source/text/scalc/01/func_forecastetsseason.xhp
+++ b/source/text/scalc/01/func_forecastetsseason.xhp
@@ -45,6 +45,7 @@
</section>
<section id="relatedtopics">
+ <tip id="par_id101677015916462"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.SEASONALITY";>FORECAST.ETS.SEASONALITY
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
<link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
diff --git a/source/text/scalc/01/func_forecastetsstatadd.xhp
b/source/text/scalc/01/func_forecastetsstatadd.xhp
index 51170e3d38..f1566526e3 100644
--- a/source/text/scalc/01/func_forecastetsstatadd.xhp
+++ b/source/text/scalc/01/func_forecastetsstatadd.xhp
@@ -51,6 +51,7 @@
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.STAT</literal></paragraph>
</section>
<section id="relatedtopics">
+<tip id="par_id471677015885195"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.STAT.ADD";>FORECAST.ETS.STAT.ADD
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD </link>,
<link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT
</link>,
diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp
b/source/text/scalc/01/func_forecastetsstatmult.xhp
index 2601deedf2..37ee6744a4 100644
--- a/source/text/scalc/01/func_forecastetsstatmult.xhp
+++ b/source/text/scalc/01/func_forecastetsstatmult.xhp
@@ -50,6 +50,7 @@
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FORECAST.ETS.STAT.MULT</literal></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id31677015816211"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.STAT.MULT";>FORECAST.ETS.STAT.MULT
wiki page</link>.</tip>
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
<link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
<link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
diff --git a/source/text/scalc/01/func_fourier.xhp
b/source/text/scalc/01/func_fourier.xhp
index bf08ae9320..a9ff9ce563 100644
--- a/source/text/scalc/01/func_fourier.xhp
+++ b/source/text/scalc/01/func_fourier.xhp
@@ -44,6 +44,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FOURIER</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id411677015788900"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FOURIER";>FOURIER
wiki page</link>.</tip>
<embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysysh1"/>
<embed href="text/scalc/01/04060107.xhp#arrayfunctit"/>
</section>
diff --git a/source/text/scalc/01/func_hour.xhp
b/source/text/scalc/01/func_hour.xhp
index 73c7d75ad8..90f4afec5b 100644
--- a/source/text/scalc/01/func_hour.xhp
+++ b/source/text/scalc/01/func_hour.xhp
@@ -41,6 +41,7 @@
<paragraph role="paragraph" id="par_id3145152" xml-lang="en-US">
<item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item
type="input">17:20:00</item>.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id851677015767824"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR";>HOUR
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_ifs.xhp
b/source/text/scalc/01/func_ifs.xhp
index e01672ed3c..6b4eb761b7 100644
--- a/source/text/scalc/01/func_ifs.xhp
+++ b/source/text/scalc/01/func_ifs.xhp
@@ -44,6 +44,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.IFS</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id971677015751595"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IFS";>IFS
wiki page</link>.</tip>
<embed href="text/scalc/01/func_switch.xhp#switchfunct"/>
<paragraph role="paragraph" id="par_id781556244709752"><link
href="text/scalc/01/04060105.xhp#Section4">IF</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_imcos.xhp
b/source/text/scalc/01/func_imcos.xhp
index e8e7afa165..ab0095971a 100644
--- a/source/text/scalc/01/func_imcos.xhp
+++ b/source/text/scalc/01/func_imcos.xhp
@@ -62,6 +62,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id631677015732848"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCOS";>IMCOS
wiki page</link>.</tip>
<paragraph id="par_id208171544029884" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imcosh.xhp#imcosh_head"/>,
<embedvar
href="text/scalc/01/func_imsin.xhp#imsin_head"/>,
diff --git a/source/text/scalc/01/func_imcosh.xhp
b/source/text/scalc/01/func_imcosh.xhp
index e09da9b477..2b41dc7bf0 100644
--- a/source/text/scalc/01/func_imcosh.xhp
+++ b/source/text/scalc/01/func_imcosh.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id331677015717191"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCOSH";>IMCOSH
wiki page</link>.</tip>
<paragraph id="par_id127621276212762" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imcos.xhp#imcos_head"/>,
<embedvar
href="text/scalc/01/func_imsin.xhp#imsin_head"/>,
diff --git a/source/text/scalc/01/func_imcot.xhp
b/source/text/scalc/01/func_imcot.xhp
index d0c4c6c6ce..f11373e7a2 100644
--- a/source/text/scalc/01/func_imcot.xhp
+++ b/source/text/scalc/01/func_imcot.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id81677015703376"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCOT";>IMCOT
wiki page</link>.</tip>
<paragraph id="par_id766137661376614" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imtan.xhp#imtan_head"/>
</paragraph>
diff --git a/source/text/scalc/01/func_imcsc.xhp
b/source/text/scalc/01/func_imcsc.xhp
index aedded0b1b..c34c0221ff 100644
--- a/source/text/scalc/01/func_imcsc.xhp
+++ b/source/text/scalc/01/func_imcsc.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id631677015682837"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCSC";>IMCSC
wiki page</link>.</tip>
<paragraph id="par_id933269332693326" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imcsch.xhp#imcsch_head"/>,
<embedvar
href="text/scalc/01/func_imsec.xhp#imsec_head"/>,
diff --git a/source/text/scalc/01/func_imcsch.xhp
b/source/text/scalc/01/func_imcsch.xhp
index ba6980fc76..945a1a530b 100644
--- a/source/text/scalc/01/func_imcsch.xhp
+++ b/source/text/scalc/01/func_imcsch.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id441677015667207"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCSCH";>IMCSCH
wiki page</link>.</tip>
<paragraph id="par_id981669816698166" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imcsc.xhp#imcsc_head"/>,
<embedvar
href="text/scalc/01/func_imsec.xhp#imsec_head"/>,
diff --git a/source/text/scalc/01/func_imsec.xhp
b/source/text/scalc/01/func_imsec.xhp
index eb91979f5f..865f4b8933 100644
--- a/source/text/scalc/01/func_imsec.xhp
+++ b/source/text/scalc/01/func_imsec.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+<tip id="par_id541677015629523"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSEC";>IMSEC
wiki page</link>.</tip>
<paragraph id="par_id57381738213791" role="paragraph" localize="false"
xml-lang="en-US">
<embedvar href="text/scalc/01/func_imcsc.xhp#imcsc_head"/>,
<embedvar href="text/scalc/01/func_imcsch.xhp#imcsch_head"/>,
diff --git a/source/text/scalc/01/func_imsech.xhp
b/source/text/scalc/01/func_imsech.xhp
index 52adb76dfa..449b141601 100644
--- a/source/text/scalc/01/func_imsech.xhp
+++ b/source/text/scalc/01/func_imsech.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id251677015610700"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSECH";>IMSECH
wiki page</link>.</tip>
<paragraph id="par_id26960257451996" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imcsc.xhp#imcsc_head"/>,
<embedvar
href="text/scalc/01/func_imcsch.xhp#imcsch_head"/>,
diff --git a/source/text/scalc/01/func_imsin.xhp
b/source/text/scalc/01/func_imsin.xhp
index c45d8d9e93..c07251f25b 100644
--- a/source/text/scalc/01/func_imsin.xhp
+++ b/source/text/scalc/01/func_imsin.xhp
@@ -62,6 +62,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id331677015597133"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSIN";>IMSIN
wiki page</link>.</tip>
<paragraph id="par_id2773214341302" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imsinh.xhp#imsinh_head"/>,
<embedvar
href="text/scalc/01/func_imcos.xhp#imcos_head"/>,
diff --git a/source/text/scalc/01/func_imsinh.xhp
b/source/text/scalc/01/func_imsinh.xhp
index 64b5e1f3af..4fa44545b9 100644
--- a/source/text/scalc/01/func_imsinh.xhp
+++ b/source/text/scalc/01/func_imsinh.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id121677015577147"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSINH";>IMSINH
wiki page</link>.</tip>
<paragraph id="par_id2773214341302" localize="false"
role="paragraph" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imsin.xhp#imsin_head"/>,
<embedvar
href="text/scalc/01/func_imcos.xhp#imcos_head"/>,
diff --git a/source/text/scalc/01/func_imtan.xhp
b/source/text/scalc/01/func_imtan.xhp
index 7902a49ad1..bf5855bdb4 100644
--- a/source/text/scalc/01/func_imtan.xhp
+++ b/source/text/scalc/01/func_imtan.xhp
@@ -63,6 +63,7 @@
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/>
<section id="relatedtopics">
+ <tip id="par_id151677015537314"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMTAN";>IMTAN
wiki page</link>.</tip>
<paragraph id="par_id2479417868613" role="paragraph"
localize="false" xml-lang="en-US">
<embedvar
href="text/scalc/01/func_imcot.xhp#imcot_head"/>
</paragraph>
diff --git a/source/text/scalc/01/func_isoweeknum.xhp
b/source/text/scalc/01/func_isoweeknum.xhp
index 51ae0e8847..e5392b93ff 100644
--- a/source/text/scalc/01/func_isoweeknum.xhp
+++ b/source/text/scalc/01/func_isoweeknum.xhp
@@ -43,6 +43,7 @@
<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item
type="input">=ISOWEEKNUM(DATE(1995;1;1))</item> returns 52. Week 1 starts on
Monday, 1995-01-02.</paragraph>
<paragraph role="paragraph" id="par_id3149794" xml-lang="en-US"><item
type="input">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on
Monday, 1999-01-04.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id361677015520799"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISOWEEKNUM";>ISOWEEKNUM
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_jis.xhp
b/source/text/scalc/01/func_jis.xhp
index 028f6dd4ad..8eb248a412 100644
--- a/source/text/scalc/01/func_jis.xhp
+++ b/source/text/scalc/01/func_jis.xhp
@@ -34,6 +34,7 @@
<paragraph role="paragraph"
id="par_id101628778036375"><input>=JIS("ﾗｲﾄ")</input> returns the string "ライト",
which is composed of double-byte characters.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id801677015502335"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS";>JIS
wiki page</link>.</tip>
<embed href="text/scalc/01/func_asc.xhp#Asc_h1"/>
<embed href="text/scalc/01/04060110.xhp#head_text"/>
</section>
diff --git a/source/text/scalc/01/func_maxifs.xhp
b/source/text/scalc/01/func_maxifs.xhp
index 697e2d7a0a..8b89e56603 100644
--- a/source/text/scalc/01/func_maxifs.xhp
+++ b/source/text/scalc/01/func_maxifs.xhp
@@ -59,6 +59,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.MAXIFS</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id401677015482616"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS";>MAXIFS
wiki page</link>.</tip>
<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"
localize="false">
<embedvar href="text/scalc/01/04060184.xhp#max_head"/>,
<embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>,
diff --git a/source/text/scalc/01/func_minifs.xhp
b/source/text/scalc/01/func_minifs.xhp
index 9b78328dd2..6981fe242e 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -59,6 +59,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.MINIFS</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id941677015454359"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS";>MINIFS
wiki page</link>.</tip>
<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"
localize="false">
<embedvar href="text/scalc/01/04060184.xhp#max_head"/>,
<embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>,
diff --git a/source/text/scalc/01/func_minute.xhp
b/source/text/scalc/01/func_minute.xhp
index ea48c1fae7..3c1b5275cf 100644
--- a/source/text/scalc/01/func_minute.xhp
+++ b/source/text/scalc/01/func_minute.xhp
@@ -43,6 +43,7 @@
<paragraph role="paragraph" id="par_id3144755" xml-lang="en-US">
<item type="input">=MINUTE(NOW())</item> returns the current minute
value.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id831677015434176"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINUTE";>MINUTE
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_month.xhp
b/source/text/scalc/01/func_month.xhp
index ba38c14918..efba950ddc 100644
--- a/source/text/scalc/01/func_month.xhp
+++ b/source/text/scalc/01/func_month.xhp
@@ -41,6 +41,7 @@
<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US"><item
type="input">=MONTH(NOW())</item> returns the current month.</paragraph>
<paragraph role="paragraph" id="par_id3154790" xml-lang="en-US"><item
type="input">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4
(that date value might get formatted differently after you press
Enter).</paragraph>
<section id="relatedtopics">
+ <tip id="par_id601677015418666"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MONTH";>MONTH
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp
b/source/text/scalc/01/func_networkdays.intl.xhp
index 87223e0233..bcbad829aa 100644
--- a/source/text/scalc/01/func_networkdays.intl.xhp
+++ b/source/text/scalc/01/func_networkdays.intl.xhp
@@ -55,6 +55,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.NETWORKDAYS.INTL</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id421677015404173"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS.INTL";>NETWORKDAYS.INTL
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_networkdays.xhp
b/source/text/scalc/01/func_networkdays.xhp
index bda19031db..aeb0a05018 100644
--- a/source/text/scalc/01/func_networkdays.xhp
+++ b/source/text/scalc/01/func_networkdays.xhp
@@ -53,6 +53,7 @@
<paragraph id="par_id160920161751233621" role="paragraph" xml-lang="en-US">How
many workdays fall between September 12nd and 25th in 2016 if only Mondays,
Tuesdays and Wednesdays are considered as workdays?</paragraph>
<paragraph id="par_id160920161751235483" role="paragraph"
xml-lang="en-US"><item type="input">=NETWORKDAYS(DATE(2016;9;12);
DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id151677015372427"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS";>NETWORKDAYS
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_now.xhp
b/source/text/scalc/01/func_now.xhp
index 2cb7f55afa..846f48cfff 100644
--- a/source/text/scalc/01/func_now.xhp
+++ b/source/text/scalc/01/func_now.xhp
@@ -39,6 +39,7 @@
<paragraph role="paragraph" id="par_id3150774" xml-lang="en-US">
<item type="input">=NOW()-A1</item> returns the difference between the date in
A1 and now. Format the result as a number.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id481677015356908"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/NOW";>NOW
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_numbervalue.xhp
b/source/text/scalc/01/func_numbervalue.xhp
index 50524c4c4c..5a7995aec9 100644
--- a/source/text/scalc/01/func_numbervalue.xhp
+++ b/source/text/scalc/01/func_numbervalue.xhp
@@ -54,6 +54,7 @@
<tip id="par_id451626100385699">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE";>NUMBERVALUE</link>
wiki page for more details about this function.</tip>
<section id="relatedtopics">
+ <tip id="par_id411677015337340"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE";>NUMBERVALUE
wiki page</link>.</tip>
<embed href="text/scalc/01/func_value.xhp#Value_h1"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_opt_barrier.xhp
b/source/text/scalc/01/func_opt_barrier.xhp
index 7e4dfa1ccc..19cc456c43 100644
--- a/source/text/scalc/01/func_opt_barrier.xhp
+++ b/source/text/scalc/01/func_opt_barrier.xhp
@@ -48,6 +48,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id471677015317570"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_BARRIER";>OPT_BARRIER
wiki page</link>.</tip>
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
<embed
href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
diff --git a/source/text/scalc/01/func_opt_prob_hit.xhp
b/source/text/scalc/01/func_opt_prob_hit.xhp
index b18d3c1a39..43c6aeaa30 100644
--- a/source/text/scalc/01/func_opt_prob_hit.xhp
+++ b/source/text/scalc/01/func_opt_prob_hit.xhp
@@ -46,6 +46,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBHIT</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id461677015195417"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_PROB_HIT";>OPT_PROB_HIT
wiki page</link>.</tip>
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
<embed
href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
diff --git a/source/text/scalc/01/func_opt_prob_inmoney.xhp
b/source/text/scalc/01/func_opt_prob_inmoney.xhp
index 66bc374167..58293feaf3 100644
--- a/source/text/scalc/01/func_opt_prob_inmoney.xhp
+++ b/source/text/scalc/01/func_opt_prob_inmoney.xhp
@@ -55,6 +55,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBINMONEY</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id181677015166578"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_PROB_INMONEY";>OPT_PROB_INMONEY
wiki page</link>.</tip>
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
<embed
href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
diff --git a/source/text/scalc/01/func_opt_touch.xhp
b/source/text/scalc/01/func_opt_touch.xhp
index f688c4db8d..05e0e9168b 100644
--- a/source/text/scalc/01/func_opt_touch.xhp
+++ b/source/text/scalc/01/func_opt_touch.xhp
@@ -78,6 +78,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id501677015107961"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_TOUCH";>OPT_TOUCH
wiki page</link>.</tip>
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
<embed
href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
diff --git a/source/text/scalc/01/func_rawsubtract.xhp
b/source/text/scalc/01/func_rawsubtract.xhp
index 72fd4b050c..0d84c65848 100644
--- a/source/text/scalc/01/func_rawsubtract.xhp
+++ b/source/text/scalc/01/func_rawsubtract.xhp
@@ -39,5 +39,8 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.RAWSUBTRACT</literal></paragraph>
</section>
+<section id="relatedtopics">
+ <tip id="par_id861677015066708"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/RAWSUBTRACT";>RAWSUBTRACT
wiki page</link>.</tip>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_regex.xhp
b/source/text/scalc/01/func_regex.xhp
index fe57b7aa29..890e2b7df0 100644
--- a/source/text/scalc/01/func_regex.xhp
+++ b/source/text/scalc/01/func_regex.xhp
@@ -44,6 +44,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.REGEX</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id631677014948784"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REGEX";>REGEX
wiki page</link>.</tip>
<paragraph role="paragraph" id="par_id711542233602553"
xml-lang="en-US"><link href="text/shared/01/02100001.xhp">List of regular
expressions</link></paragraph>
<paragraph role="paragraph" id="par_id431542233650614"
xml-lang="en-US"><link
href="https://unicode-org.github.io/icu/userguide/strings/regexp.html";>ICU
regular expressions</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_replaceb.xhp
b/source/text/scalc/01/func_replaceb.xhp
index 86ef8380d9..d9c61cf31b 100644
--- a/source/text/scalc/01/func_replaceb.xhp
+++ b/source/text/scalc/01/func_replaceb.xhp
@@ -36,9 +36,8 @@
<paragraph role="paragraph"
id="par_id431573515742206"><input>=REPLACEB("ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ";4;1;"ab")</input>
returns "ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ" .</paragraph>
- <tip id="par_id721626381053212">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB";>REPLACEB</link>
wiki page for more details about this function.</tip>
-
<section id="relatedtopics">
+ <tip id="par_id71677014897959"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB";>REPLACEB
wiki page</link>.</tip>
<paragraph role="paragraph" localize="false"
id="par_id171573510071709"><embedvar href="text/scalc/01/func_findb.xhp#findb"
markup="ignore"/></paragraph>
<paragraph role="paragraph" localize="false"
id="par_id831573510098350"><embedvar
href="text/scalc/01/func_searchb.xhp#searchb" markup="ignore"/></paragraph>
<paragraph role="paragraph" localize="false"
id="par_id251573510740369"><embedvar href="text/scalc/01/04060110.xhp#lenbvar"
markup="ignore"/></paragraph>
diff --git a/source/text/scalc/01/func_roman.xhp
b/source/text/scalc/01/func_roman.xhp
index 3f16a2acb8..e80a7e2610 100644
--- a/source/text/scalc/01/func_roman.xhp
+++ b/source/text/scalc/01/func_roman.xhp
@@ -39,6 +39,7 @@
<paragraph role="paragraph"
id="par_id101628778036019"><input>=ROMAN(0)</input> returns "" (empty
text).</paragraph>
<section id="relatedtopics">
+ <tip id="par_id81677014876175"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROMAN";>ROMAN
wiki page</link>.</tip>
<embed href="text/scalc/01/func_arabic.xhp#Arabic_h1"/>
<paragraph role="paragraph" id="par_id81634670394769"
localize="false"><embedvar
href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
</section>
diff --git a/source/text/scalc/01/func_rounddown.xhp
b/source/text/scalc/01/func_rounddown.xhp
index 091d73669a..e273fcdab4 100644
--- a/source/text/scalc/01/func_rounddown.xhp
+++ b/source/text/scalc/01/func_rounddown.xhp
@@ -45,6 +45,7 @@
<paragraph role="paragraph"
id="par_id641641928712287"><input>=ROUNDDOWN(214.2,-1)</input> returns 210.
Note the negative value for <emph>Count</emph>, which causes the first integer
value before the decimal separator to be rounded towards zero.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id161677014850199"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROUNDDOWN";>ROUNDDOWN
wiki page</link>.</tip>
<embed href="text/scalc/01/func_trunc.xhp#trunc_h1"/>
<embed href="text/scalc/01/04060106.xhp#math_functions_h1"/>
</section>
diff --git a/source/text/scalc/01/func_roundsig.xhp
b/source/text/scalc/01/func_roundsig.xhp
index b5d486728e..7aba312e96 100644
--- a/source/text/scalc/01/func_roundsig.xhp
+++ b/source/text/scalc/01/func_roundsig.xhp
@@ -41,6 +41,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.ROUNDSIG</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id181677014829126"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROUNDSIG";>ROUNDSIG
wiki page</link>.</tip>
<paragraph role="paragraph" id="par_id51519156941987"
xml-lang="en-US">See also <link
href="text/scalc/01/04060106.xhp#Section21">ROUND</link>, <link
href="text/scalc/01/04060106.xhp#Section7">MROUND</link>, <link
href="text/scalc/01/04060106.xhp#Section19">ROUNDUP</link>, <link
href="text/scalc/01/04060106.xhp#Section20">ROUNDDOWN</link>.</paragraph>
</section>
diff --git a/source/text/scalc/01/func_searchb.xhp
b/source/text/scalc/01/func_searchb.xhp
index c81a0681cb..482ad1013b 100644
--- a/source/text/scalc/01/func_searchb.xhp
+++ b/source/text/scalc/01/func_searchb.xhp
@@ -35,6 +35,7 @@
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<paragraph role="paragraph"
id="par_id561573517310749"><input>=SEARCHB("ᄫᄬ";"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ";17)</input>
returns 20.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id531677014781664"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEARCHB";>SEARCHB
wiki page</link>.</tip>
<paragraph role="paragraph" localize="false"
id="par_id171573510071709"><embedvar href="text/scalc/01/func_findb.xhp#findb"
markup="ignore"/></paragraph>
<paragraph role="paragraph" localize="false"
id="par_id961573510093188"><embedvar
href="text/scalc/01/func_replaceb.xhp#replaceb" markup="ignore"/></paragraph>
<paragraph role="paragraph" localize="false"
id="par_id251573510740369"><embedvar href="text/scalc/01/04060110.xhp#lenbvar"
markup="ignore"/></paragraph>
diff --git a/source/text/scalc/01/func_second.xhp
b/source/text/scalc/01/func_second.xhp
index 56246f0519..f2bebbcb56 100644
--- a/source/text/scalc/01/func_second.xhp
+++ b/source/text/scalc/01/func_second.xhp
@@ -19,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_secondxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">SECOND </title>
+<title id="tit" xml-lang="en-US">SECOND</title>
<filename>/text/scalc/01/func_second.xhp</filename>
</topic>
</meta>
@@ -41,6 +41,7 @@
<paragraph role="paragraph" id="par_id3150831" xml-lang="en-US">
<item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item
type="input">12:20:17</item>.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id71677014729834"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND";>SECOND
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_skewp.xhp
b/source/text/scalc/01/func_skewp.xhp
index 9ed2804c3b..5b7960ec8c 100644
--- a/source/text/scalc/01/func_skewp.xhp
+++ b/source/text/scalc/01/func_skewp.xhp
@@ -46,6 +46,7 @@
<paragraph id="par_id1102201618185378" role="paragraph"
xml-lang="en-US"><input>SKEWP(A1:A6)</input> returns 0.2329985562, when the
range A1:A6 contains {2;3;1;6;8;5}</paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id31677014685531"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SKEWP";>SKEWP
wiki page</link>.</tip>
<paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060185.xhp#skew">SKEW</link></paragraph>
</section>
</body>
diff --git a/source/text/scalc/01/func_style.xhp
b/source/text/scalc/01/func_style.xhp
index e6d62ca8a8..22b002d4f1 100644
--- a/source/text/scalc/01/func_style.xhp
+++ b/source/text/scalc/01/func_style.xhp
@@ -63,6 +63,7 @@
<paragraph role="paragraph" id="par_id311644873986703"
localize="false"><literal>ORG.OPENOFFICE.STYLE</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id201677014634447"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE";>STYLE
wiki page</link>.</tip>
<paragraph role="paragraph" id="par_id631673379195650"><link
href="text/scalc/01/04060109.xhp">Spreadsheet Functions</link></paragraph>
<paragraph role="paragraph" id="par_id151673379420755"><link
href="text/scalc/guide/cellstyle_by_formula.xhp">Assigning Formats by
Formula</link></paragraph>
<paragraph role="paragraph" id="par_id461673376361959"><link
href="text/scalc/01/04060104.xhp#func_current_description">CURRENT
function</link></paragraph>
diff --git a/source/text/scalc/01/func_sum.xhp
b/source/text/scalc/01/func_sum.xhp
index a421e588c3..c67b55a555 100644
--- a/source/text/scalc/01/func_sum.xhp
+++ b/source/text/scalc/01/func_sum.xhp
@@ -21,7 +21,7 @@
<bookmark xml-lang="en-US" branch="index" id="id431636401649762">
<bookmark_value>SUM function</bookmark_value>
<bookmark_value>adding;numbers in cell ranges</bookmark_value>
- </bookmark>
+ </bookmark>
<h1 id="hd_id121636398275790"><variable id="sum_head"><link
href="text/scalc/01/func_sum.xhp">SUM</link></variable></h1>
<paragraph id="par_id491636401806866" role="paragraph"><variable
id="func_sum_desc"><ahelp hid=".">Adds a set of
numbers.</ahelp></variable></paragraph>
</section>
@@ -35,14 +35,14 @@
<paragraph id="par_id3151740" role="paragraph" xml-lang="en-US"><item
type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three
cells.</paragraph>
<paragraph id="par_id931636109030406" role="paragraph"
xml-lang="en-US"><item type="input">=SUM(A1:E10)</item> calculates the sum of
all cells in the A1 to E10 cell range.</paragraph>
<paragraph id="par_id3151756" role="paragraph" xml-lang="en-US">A formula
such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be
entered as an <link href="text/scalc/01/04060107.html#hd_id3148474">array
formula</link> by pressing the Shift<switchinline select="sys"><caseinline
select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter
keys instead of simply pressing the Enter key to finish entering the formula.
The formula will then be shown in the Formula bar enclosed in braces and
operates by multiplying corresponding elements of the arrays together and
returning their sum.</paragraph>
- <tip id="par_id661636108218550">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM";>SUM</link>
wiki page for more details about this function.</tip>
<section id="relatedtopics">
+ <tip id="par_id771677014538669"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM";>SUM
wiki page</link>.</tip>
<paragraph id="par_id381636401121931" role="paragraph" localize="false">
<embedvar href="text/scalc/01/04060106.xhp#sumif_head"/>,
<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
</paragraph>
- </section>
-
+ </section>
+
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/func_sumifs.xhp
b/source/text/scalc/01/func_sumifs.xhp
index f742293fff..c71cd408d3 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -56,6 +56,7 @@
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 =
pen, the function returns 65, because the link to the cell is substituted with
its content.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
+ <tip id="par_id971677014512029"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIFS";>SUMIFS
wiki page</link>.</tip>
<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"
localize="false">
<embedvar href="text/scalc/01/04060106.xhp#sum_head"/>,
<embedvar href="text/scalc/01/04060106.xhp#sumif_head"/>
diff --git a/source/text/scalc/01/func_switch.xhp
b/source/text/scalc/01/func_switch.xhp
index 5cb72fb9f5..3b58df372a 100644
--- a/source/text/scalc/01/func_switch.xhp
+++ b/source/text/scalc/01/func_switch.xhp
@@ -40,6 +40,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.SWITCH</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id171677014475983"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SWITCH";>SWITCH
wiki page</link>.</tip>
<embed href="text/scalc/01/func_ifs.xhp#ifsfunct"/>
<paragraph role="paragraph" id="par_id781556244709752"><link
href="text/scalc/01/04060105.xhp#Section4">IF</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_textjoin.xhp
b/source/text/scalc/01/func_textjoin.xhp
index ee01389fbb..e391da0f9a 100644
--- a/source/text/scalc/01/func_textjoin.xhp
+++ b/source/text/scalc/01/func_textjoin.xhp
@@ -41,6 +41,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.TEXTJOIN</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN";>TEXTJOIN
wiki page</link>.</tip>
<embed href="text/scalc/01/func_concat.xhp#concatfunct"/>
<paragraph role="paragraph" id="par_id781556244709752"><link
href="text/scalc/01/04060110.xhp#concatenate">CONCATENATE</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_time.xhp
b/source/text/scalc/01/func_time.xhp
index 43a95dd076..a44214dffc 100644
--- a/source/text/scalc/01/func_time.xhp
+++ b/source/text/scalc/01/func_time.xhp
@@ -19,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_timexml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">TIME </title>
+<title id="tit" xml-lang="en-US">TIME</title>
<filename>/text/scalc/01/func_time.xhp</filename>
</topic>
</meta>
@@ -42,6 +42,7 @@
<paragraph role="paragraph" id="par_id3156090" xml-lang="en-US">
<item type="input">=TIME(4;20;4)</item> returns 04:20:04</paragraph>
<section id="relatedtopics">
+ <tip id="par_id741677014416564"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIME";>TIME
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_timevalue.xhp
b/source/text/scalc/01/func_timevalue.xhp
index 28f83cf9a4..96f4acc772 100644
--- a/source/text/scalc/01/func_timevalue.xhp
+++ b/source/text/scalc/01/func_timevalue.xhp
@@ -19,7 +19,7 @@
****************************************************************-->
<meta>
<topic id="topic_0506201512165345" status="PUBLISH">
- <title xml-lang="en-US" id="tit">TIMEVALUE </title>
+ <title xml-lang="en-US" id="tit">TIMEVALUE</title>
<filename>/text/scalc/01/func_timevalue.xhp</filename>
</topic>
</meta>
@@ -40,6 +40,7 @@
<paragraph id="par_id3146829" role="paragraph" xml-lang="en-US"><item
type="input">=TIMEVALUE("4PM")</item> returns 0.67. When formatting in time
format HH:MM:SS, you then get 16:00:00.</paragraph>
<paragraph id="par_id3153632" role="paragraph" xml-lang="en-US"><item
type="input">=TIMEVALUE("24:00")</item> returns 0. If you use the HH:MM:SS time
format, the value is 00:00:00.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id191677014389883"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIMEVALUE";>TIMEVALUE
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_today.xhp
b/source/text/scalc/01/func_today.xhp
index df71f6a9ab..46f2b96beb 100644
--- a/source/text/scalc/01/func_today.xhp
+++ b/source/text/scalc/01/func_today.xhp
@@ -39,6 +39,7 @@
<paragraph role="paragraph" id="par_id3156106" xml-lang="en-US">
<item type="input">TODAY()</item> returns the current computer system
date.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id691677014365707"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TODAY";>TODAY
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_trunc.xhp
b/source/text/scalc/01/func_trunc.xhp
index 6da86e12a9..ed3a1b9679 100644
--- a/source/text/scalc/01/func_trunc.xhp
+++ b/source/text/scalc/01/func_trunc.xhp
@@ -47,6 +47,7 @@
<paragraph role="paragraph"
id="par_id641641928712287"><input>=TRUNC(214.2,-1)</input> returns 210. Note
the negative value for <emph>Count</emph>, which causes the first integer value
before the decimal separator to be rounded towards zero.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id821677013765236"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC";>TRUNC
wiki page</link>.</tip>
<embed href="text/scalc/01/func_rounddown.xhp#rounddown_h1"/>
<embed href="text/scalc/01/04060106.xhp#math_functions_h1"/>
</section>
diff --git a/source/text/scalc/01/func_value.xhp
b/source/text/scalc/01/func_value.xhp
index 94a8caa920..7480edb401 100644
--- a/source/text/scalc/01/func_value.xhp
+++ b/source/text/scalc/01/func_value.xhp
@@ -39,6 +39,7 @@
<tip id="par_id801628779804928">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE";>VALUE</link>
wiki page for more details about this function.</tip>
<section id="relatedtopics">
+ <tip id="par_id711677013742963"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE";>VALUE
wiki page</link>.</tip>
<embed href="text/scalc/01/func_datevalue.xhp#datevalue"/>
<embed href="text/scalc/01/func_numbervalue.xhp#numbervalue_h1"/>
<embed href="text/scalc/01/func_timevalue.xhp#timevalue"/>
diff --git a/source/text/scalc/01/func_webservice.xhp
b/source/text/scalc/01/func_webservice.xhp
index ca1b378463..50ba6d5fe3 100644
--- a/source/text/scalc/01/func_webservice.xhp
+++ b/source/text/scalc/01/func_webservice.xhp
@@ -15,13 +15,18 @@
</topic>
</meta>
<body>
+ <section id="section identification">
+ <bookmark id="bm_id521677019419913" xml-lang="en-US"
branch="hid/CHANGE ME" localize="false"/>
+ <h1 id="hd_id391677019419915"><variable id="h1"><link
href="text/scalc/01/func_webservice.xhp">URI Functions</link></variable></h1>
+ <paragraph id="par_id141677019419921" role="paragraph"
xml-lang="en-US">These spreadsheet functions are used for inserting data from
Universal Resource Identifiers (URI).</paragraph>
+ </section>
<section id="webservice">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149012">
<bookmark_value>WEBSERVICE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEBSERVICE"
id="bm_id3150028" localize="false"/>
<section id="webservicefuncheader">
- <h1 id="hd_id3149012"><variable id="webservicefuncname"><link
href="text/scalc/01/func_webservice.xhp#webservice">WEBSERVICE</link></variable></h1>
+ <h2 id="hd_id3149012"><variable id="webservicefuncname"><link
href="text/scalc/01/func_webservice.xhp#webservice">WEBSERVICE</link></variable></h2>
<paragraph role="paragraph" id="par_id3149893"
xml-lang="en-US"><ahelp
hid="HID_FUNC_WEBSERVICE">Get some web content from a
URI.</ahelp></paragraph>
</section>
@@ -78,5 +83,8 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id301640873986703"
localize="false"><literal>COM.MICROSOFT.ENCODEURL</literal></paragraph>
</section>
+ <section id="relatedtopics">
+ <tip id="par_id781677019731175"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEBSERVICE";>WEBSERVICE</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTERXML";>FILTERXML</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ENCODEURL";>ENCODEURL</link>
wiki pages.</tip>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_weekday.xhp
b/source/text/scalc/01/func_weekday.xhp
index 486409bd82..7094574d56 100644
--- a/source/text/scalc/01/func_weekday.xhp
+++ b/source/text/scalc/01/func_weekday.xhp
@@ -144,6 +144,7 @@
<paragraph id="par_id3150575" role="paragraph" xml-lang="en-US"><item
type="input">=WEEKDAY(NOW())</item> returns the number of the current
day.</paragraph>
<tip id="par_id3150588">To obtain a function indicating whether a day in A1 is
a business day, use the IF and WEEKDAY functions as follows: <br/><item
type="input">IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</item></tip>
<section id="relatedtopics">
+ <tip id="par_id131677013566555"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKDAY";>WEEKDAY
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_weeknum.xhp
b/source/text/scalc/01/func_weeknum.xhp
index 4ccf703381..7f139d446c 100644
--- a/source/text/scalc/01/func_weeknum.xhp
+++ b/source/text/scalc/01/func_weeknum.xhp
@@ -179,6 +179,7 @@
<paragraph role="paragraph" id="par_id3149793" xml-lang="en-US"><item
type="input">=WEEKNUM(DATE(1995;1;1);21)</item> returns 52. Week 1 starts on
Monday, 1995-01-02.</paragraph>
<paragraph role="paragraph" id="par_id3149794" xml-lang="en-US"><item
type="input">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on
Monday, 1999-01-04.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id361677013519430"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM";>WEEKNUM
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp
b/source/text/scalc/01/func_weeknum_ooo.xhp
index 875ac05174..f2d32dd954 100644
--- a/source/text/scalc/01/func_weeknum_ooo.xhp
+++ b/source/text/scalc/01/func_weeknum_ooo.xhp
@@ -50,6 +50,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.WEEKNUM_OOO</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id521677013377460"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM_OOO";>WEEKNUM_OOO
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_weeknumadd.xhp
b/source/text/scalc/01/func_weeknumadd.xhp
index c74b3d1191..3d7f80e0ff 100644
--- a/source/text/scalc/01/func_weeknumadd.xhp
+++ b/source/text/scalc/01/func_weeknumadd.xhp
@@ -42,6 +42,7 @@
<paragraph role="paragraph" id="par_id3149914" xml-lang="en-US">
<item type="input">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns
52.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id801677013334251"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM_EXCEL2003";>WEEKNUM_EXCEL2003
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_workday.intl.xhp
b/source/text/scalc/01/func_workday.intl.xhp
index 140c9b4660..356acb8304 100644
--- a/source/text/scalc/01/func_workday.intl.xhp
+++ b/source/text/scalc/01/func_workday.intl.xhp
@@ -60,6 +60,7 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.WORKDAY.INTL</literal></paragraph>
<section id="relatedtopics">
+ <tip id="par_id521677013308530"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY.INTL";>WORKDAY.INTL
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_workday.xhp
b/source/text/scalc/01/func_workday.xhp
index bc0afd3454..9b3e142ed6 100644
--- a/source/text/scalc/01/func_workday.xhp
+++ b/source/text/scalc/01/func_workday.xhp
@@ -51,6 +51,7 @@
<paragraph id="par_id23102016225717242" role="paragraph"
xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date
functions</link></paragraph>
</section>
<section id="relatedtopics">
+ <tip id="par_id501677013269388"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY";>WORKDAY
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
diff --git a/source/text/scalc/01/func_year.xhp
b/source/text/scalc/01/func_year.xhp
index 65544fe66d..9cf89c4bb4 100644
--- a/source/text/scalc/01/func_year.xhp
+++ b/source/text/scalc/01/func_year.xhp
@@ -45,6 +45,7 @@
<paragraph role="paragraph"
id="par_id141577548861101"><input>=YEAR(DATEVALUE('2010-09-28'))</input>
returns 2010.</paragraph>
<section id="relatedtopics">
+ <tip id="par_id371677013165080"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/YEAR";>YEAR
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
