diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-02-21 19:24:24 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-02-22 11:09:36 +0000 |
| commit | 5639f320e16619cd9f5b099752317eee10973125 (patch) | |
| tree | 55b1b4f4845928a98ef788e13c90d040c4f36468 /source/text/scalc | |
| parent | 36d7838ecf321f5053559878d0b922cb384af1ad (diff) | |
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.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
83 files changed, 103 insertions, 15 deletions
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> |