source/text/scalc/01/func_averageif.xhp | 1 + source/text/scalc/01/func_averageifs.xhp | 1 + source/text/scalc/01/func_countifs.xhp | 3 ++- source/text/scalc/01/func_date.xhp | 3 ++- source/text/scalc/01/func_datedif.xhp | 3 ++- source/text/scalc/01/func_datevalue.xhp | 3 ++- source/text/scalc/01/func_day.xhp | 3 ++- source/text/scalc/01/func_days.xhp | 4 +++- source/text/scalc/01/func_days360.xhp | 3 ++- source/text/scalc/01/func_edate.xhp | 3 ++- source/text/scalc/01/func_eomonth.xhp | 3 ++- source/text/scalc/01/func_error_type.xhp | 3 ++- source/text/scalc/01/func_hour.xhp | 3 ++- source/text/scalc/01/func_imcos.xhp | 4 +++- source/text/scalc/01/func_imcosh.xhp | 4 +++- source/text/scalc/01/func_imcot.xhp | 4 +++- source/text/scalc/01/func_imcsc.xhp | 4 +++- source/text/scalc/01/func_imcsch.xhp | 4 +++- source/text/scalc/01/func_imsec.xhp | 4 +++- source/text/scalc/01/func_imsech.xhp | 3 ++- source/text/scalc/01/func_imsin.xhp | 3 ++- source/text/scalc/01/func_imsinh.xhp | 3 ++- source/text/scalc/01/func_imtan.xhp | 5 +++-- source/text/scalc/01/func_minute.xhp | 3 ++- source/text/scalc/01/func_month.xhp | 3 ++- source/text/scalc/01/func_networkdays.xhp | 3 ++- source/text/scalc/01/func_now.xhp | 3 ++- source/text/scalc/01/func_second.xhp | 3 ++- source/text/scalc/01/func_sum.xhp | 4 ++-- source/text/scalc/01/func_sumif.xhp | 3 ++- source/text/scalc/01/func_sumifs.xhp | 3 ++- source/text/scalc/01/func_time.xhp | 3 ++- source/text/scalc/01/func_timevalue.xhp | 3 ++- source/text/scalc/01/func_today.xhp | 3 ++- source/text/scalc/01/func_weekday.xhp | 3 ++- source/text/scalc/01/func_weeknum.xhp | 3 ++- source/text/scalc/01/func_workday.xhp | 4 +++- source/text/scalc/01/func_year.xhp | 4 ++-- source/text/scalc/01/func_yearfrac.xhp | 3 ++- 39 files changed, 85 insertions(+), 40 deletions(-)
New commits: commit 87b11b274a5a8654a16b9dbb9a03214e71478c40 Author: Olivier Hallot <[email protected]> AuthorDate: Thu Aug 7 12:26:45 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Thu Aug 7 17:29:17 2025 +0200 Add tech info on function pages (part) Change-Id: I2e555b379c05a27494bd011859e773b2071d294e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/189115 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index e637b60f0a..363e4a2adc 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_id172572288310247" role="paragraph">The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5.</paragraph> <paragraph id="par_id316901523627285" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;"<"&E2;C2:C6)</item></paragraph> <paragraph id="par_id302181300528607" role="paragraph">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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="relatedtopics"> <tip id="par_id421677017213184"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF";>AVERAGEIF wiki page</link>.</tip> diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 53b007c8ce..24badc5dc5 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -53,6 +53,7 @@ <paragraph id="par_id67531072426731" role="paragraph"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id65612244926745" role="paragraph">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"/> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="relatedtopics"> <tip id="par_id371677017196557"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS";>AVERAGEIFS wiki page</link>.</tip> diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 02a0c07151..0d19d66de4 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -36,7 +36,6 @@ <paragraph role="paragraph" id="par_id14734320631377"><emph>Range, Range2, ...</emph> and <emph>Criterion, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id3861259759512">Simple usage</h4> @@ -57,6 +56,8 @@ <paragraph id="par_id109501907712434" role="paragraph"><item type="input">=COUNTIFS(A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id738533068520" role="paragraph">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"/> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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" localize="false"> diff --git a/source/text/scalc/01/func_date.xhp b/source/text/scalc/01/func_date.xhp index ad6a5e3ed6..78494f5b10 100644 --- a/source/text/scalc/01/func_date.xhp +++ b/source/text/scalc/01/func_date.xhp @@ -29,7 +29,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><h1 id="hd_id3155511"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link> </variable></h1> <paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATUM">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3150474" xml-lang="en-US">DATE(Year; Month; Day)</paragraph> <paragraph role="paragraph" id="par_id3152815" xml-lang="en-US"> @@ -43,6 +42,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3152589" xml-lang="en-US"> <item type="input">=DATE(00;1;31)</item> yields the date 2000-01-31 written as 1/31/00 if the cell format setting is MM/DD/YY.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_datedif.xhp b/source/text/scalc/01/func_datedif.xhp index 1e2c6fc385..617e2f0d00 100644 --- a/source/text/scalc/01/func_datedif.xhp +++ b/source/text/scalc/01/func_datedif.xhp @@ -21,7 +21,6 @@ <h1 id="hd_id3155511"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link></variable></h1> <paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATEDIF">This function returns the number of whole days, months or years between Start date and End date.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#3.6"/> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="paragraph" id="par_id531642776283977"> <input>DATEDIF(Start date; End date; Interval)</input> @@ -106,6 +105,8 @@ Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13.</paragr <item type="input">=DATEDIF("1974-04-17";"2012-06-13";"d")</item> yields 13937, he has been living for 13937 days.</paragraph> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_datevalue.xhp b/source/text/scalc/01/func_datevalue.xhp index 430fa46503..dc19601346 100644 --- a/source/text/scalc/01/func_datevalue.xhp +++ b/source/text/scalc/01/func_datevalue.xhp @@ -35,7 +35,6 @@ <paragraph xml-lang="en-US" id="par_id3145087" role="paragraph"><ahelp hid="HID_FUNC_DATWERT">Returns the internal date number for text in quotes.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates.</paragraph> <paragraph xml-lang="en-US" id="par_id0119200903491982" role="paragraph">If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion.</paragraph> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph xml-lang="en-US" id="par_id3149268" role="code">DATEVALUE("Text")</paragraph> <paragraph xml-lang="en-US" id="par_id3154819" role="paragraph"><emph>Text</emph> is a valid date expression and must be entered with quotation marks.</paragraph> @@ -44,6 +43,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph xml-lang="en-US" id="par_id3155841" role="paragraph"> <item type="input">=DATEVALUE("1954-07-20")</item> yields 19925.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_day.xhp b/source/text/scalc/01/func_day.xhp index 94242055a9..f5e4faf314 100644 --- a/source/text/scalc/01/func_day.xhp +++ b/source/text/scalc/01/func_day.xhp @@ -29,7 +29,6 @@ <bookmark branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h1 id="hd_id3147317"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> </variable></h1> <paragraph role="paragraph" id="par_id3147584"><ahelp hid="HID_FUNC_TAG">Returns the day of given date value.</ahelp> The day is returned as an integer between 1 and 31. You can also enter a negative date/time value.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3149430">DAY(Number)</paragraph> <paragraph role="paragraph" id="par_id3149443"><emph>Number</emph> is the internal date number.</paragraph> @@ -40,6 +39,8 @@ <paragraph role="paragraph" id="par_id3151200"><item type="input">=DAY(1)</item> returns 31 (since $[officename] starts counting at zero from December 30, 1899)</paragraph> <paragraph role="paragraph" id="par_id3154130"><item type="input">=DAY(NOW())</item> returns the current day.</paragraph> <paragraph role="paragraph" id="par_id3159190"><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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_days.xhp b/source/text/scalc/01/func_days.xhp index 680c76964b..3a0cd3423d 100644 --- a/source/text/scalc/01/func_days.xhp +++ b/source/text/scalc/01/func_days.xhp @@ -29,7 +29,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/><h1 id="hd_id3151328"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link> </variable></h1> <paragraph role="paragraph" id="par_id3155139" xml-lang="en-US"><ahelp hid="HID_FUNC_TAGE">Calculates the difference between two date values.</ahelp> Returns the number of days between the two days. May return a fraction of a day when the arguments include time parts.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3149578" xml-lang="en-US">DAYS(Date2; Date1)</paragraph> <paragraph role="paragraph" id="par_id3151376" xml-lang="en-US"> @@ -40,6 +39,9 @@ <paragraph role="paragraph" id="par_id3159101" xml-lang="en-US"><item type="input">=DAYS(TODAY();"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> <paragraph role="paragraph" id="par_id3163722" xml-lang="en-US"><item type="input">=DAYS(NOW(); TODAY())</item> returns a fraction of the current day.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> + <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/guide/calc_date.xhp#calc_date"/> diff --git a/source/text/scalc/01/func_days360.xhp b/source/text/scalc/01/func_days360.xhp index 70cdceea1d..a6f2bc5d7f 100644 --- a/source/text/scalc/01/func_days360.xhp +++ b/source/text/scalc/01/func_days360.xhp @@ -29,7 +29,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE360" id="bm_id3155906" localize="false"/><h1 id="hd_id3148555"><variable id="days360"><link href="text/scalc/01/func_days360.xhp">DAYS360</link> </variable></h1> <paragraph role="paragraph" id="par_id3156032" xml-lang="en-US"><ahelp hid="HID_FUNC_TAGE360">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp></paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3155313" xml-lang="en-US">DAYS360(Date1; Date2[; Type])</paragraph> <paragraph role="paragraph" id="par_id3145263" xml-lang="en-US">If <emph>Date2</emph> is earlier than <emph>Date1</emph>, the function will return a negative number.</paragraph> @@ -38,6 +37,8 @@ <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_edate.xhp b/source/text/scalc/01/func_edate.xhp index 87b08cded6..c0f02bd58f 100644 --- a/source/text/scalc/01/func_edate.xhp +++ b/source/text/scalc/01/func_edate.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3151184"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link> </variable></h1> <paragraph role="paragraph" id="par_id3150880" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_EDATE">The result is a date which is a number of <emph>months</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp></paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3153212" xml-lang="en-US">EDATE(StartDate; Months)</paragraph> <paragraph role="paragraph" id="par_id3146860" xml-lang="en-US"> @@ -43,6 +42,8 @@ <paragraph role="paragraph" id="par_id3155845" xml-lang="en-US">What date is one month prior to 2001-03-31?</paragraph> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_eomonth.xhp b/source/text/scalc/01/func_eomonth.xhp index b706b9f3cf..68570fb189 100644 --- a/source/text/scalc/01/func_eomonth.xhp +++ b/source/text/scalc/01/func_eomonth.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3150991"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link> </variable></h1> <paragraph role="paragraph" id="par_id3152766" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_EOMONTH">Returns the date of the last day of a month which falls months away from the start date.</ahelp></paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3150351" xml-lang="en-US">EOMONTH(StartDate; Months)</paragraph> <paragraph role="paragraph" id="par_id3146787" xml-lang="en-US"> @@ -42,6 +41,8 @@ <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="relatedtopics"> <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"/> diff --git a/source/text/scalc/01/func_error_type.xhp b/source/text/scalc/01/func_error_type.xhp index 0844ded1de..e703b3e71e 100644 --- a/source/text/scalc/01/func_error_type.xhp +++ b/source/text/scalc/01/func_error_type.xhp @@ -107,7 +107,6 @@ </tablecell> </tablerow> </table> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <h4 id="hd_id182972884627444">Simple usage</h4> @@ -120,6 +119,8 @@ <paragraph id="par_id16083887218317" role="paragraph" xml-lang="en-US"><item type="input">=IF(ISERROR(A1/A2);IF(ERROR.TYPE(A1/A2)=2;"the denominator can't be equal to zero");A1/A2)</item></paragraph> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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> diff --git a/source/text/scalc/01/func_hour.xhp b/source/text/scalc/01/func_hour.xhp index 89af023368..affeef6124 100644 --- a/source/text/scalc/01/func_hour.xhp +++ b/source/text/scalc/01/func_hour.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3154725"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> </variable></h1> <paragraph role="paragraph" id="par_id3149747"><ahelp hid="HID_FUNC_STUNDE">Returns the hour for a given time value.</ahelp> The hour is returned as an integer between 0 and 23.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3150637">HOUR(Number)</paragraph> <paragraph role="paragraph" id="par_id3147547"> @@ -41,6 +40,8 @@ <item type="input">=HOUR(NOW())</item> returns the current hour</paragraph> <paragraph role="paragraph" id="par_id3145152"> <item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type="input">17:20:00</item>.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_imcos.xhp b/source/text/scalc/01/func_imcos.xhp index 9fb9d344dd..d0537972d0 100644 --- a/source/text/scalc/01/func_imcos.xhp +++ b/source/text/scalc/01/func_imcos.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/sc_func_imcos.svg" id="img_id211575078735993" width="452.06109px" height="31.5px"><alt xml-lang="en-US" id="alt_id401575078735994">IMCOS equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id164021484116762" role="code" xml-lang="en-US"> IMCOS(Complex_number) @@ -61,6 +60,9 @@ returns -0.416146836547142 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> + <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"> diff --git a/source/text/scalc/01/func_imcosh.xhp b/source/text/scalc/01/func_imcosh.xhp index 9a97a7a627..5b4e560f61 100644 --- a/source/text/scalc/01/func_imcosh.xhp +++ b/source/text/scalc/01/func_imcosh.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/sc_func_imcosh.svg" id="img_id211575078735993" width="464.56109px" height="31.5px"><alt xml-lang="en-US" id="alt_id401575078735994">IMCOSH equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id16051131322110" role="code" xml-lang="en-US"> @@ -62,6 +61,9 @@ returns 3.76219569108363 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> + <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"> diff --git a/source/text/scalc/01/func_imcot.xhp b/source/text/scalc/01/func_imcot.xhp index 6d32744fc9..3302960dfb 100644 --- a/source/text/scalc/01/func_imcot.xhp +++ b/source/text/scalc/01/func_imcot.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/scalc/IMCOT_equation.svg" id="img_id211575078735993" width="341.869px" height="59.5625px"><alt xml-lang="en-US" id="alt_id401575078735994">IMCOT equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id16051131322110" role="code" xml-lang="en-US"> @@ -62,6 +61,9 @@ returns -0.457657554360286 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> + <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"> diff --git a/source/text/scalc/01/func_imcsc.xhp b/source/text/scalc/01/func_imcsc.xhp index 76564689d4..1ded0a33c7 100644 --- a/source/text/scalc/01/func_imcsc.xhp +++ b/source/text/scalc/01/func_imcsc.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/scalc/IMCSC_equation.svg" id="img_id211575078735993" width="491.844px" height="59.5625px"><alt xml-lang="en-US" id="alt_id401575078735994">IMCSC equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id30461169611909" role="code" xml-lang="en-US"> @@ -62,6 +61,9 @@ returns 1.09975017029462 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> + <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"> diff --git a/source/text/scalc/01/func_imcsch.xhp b/source/text/scalc/01/func_imcsch.xhp index 4b8329b1c1..a1f40258ca 100644 --- a/source/text/scalc/01/func_imcsch.xhp +++ b/source/text/scalc/01/func_imcsch.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/scalc/IMCSCH_equation.svg" id="img_id211575078735993" width="504.344px" height="59.5625px"><alt xml-lang="en-US" id="alt_id401575078735994">IMCSCH equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id30461169611909" role="code" xml-lang="en-US"> @@ -62,6 +61,9 @@ returns 0.275720564771783 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> + <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"> diff --git a/source/text/scalc/01/func_imsec.xhp b/source/text/scalc/01/func_imsec.xhp index 805207426f..9e49a16b39 100644 --- a/source/text/scalc/01/func_imsec.xhp +++ b/source/text/scalc/01/func_imsec.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/scalc/IMSEC_equation.svg" id="img_id211575078735993" width="491.194px" height="59.5625px"><alt xml-lang="en-US" id="alt_id401575078735994">IMSEC equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id66061624115094" role="code" xml-lang="en-US"> @@ -62,6 +61,9 @@ returns -2.40299796172238 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> + <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"> diff --git a/source/text/scalc/01/func_imsech.xhp b/source/text/scalc/01/func_imsech.xhp index 2e1828b5f2..a391f2fa4e 100644 --- a/source/text/scalc/01/func_imsech.xhp +++ b/source/text/scalc/01/func_imsech.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/scalc/IMSECH_equation.svg" id="img_id211575078735993" width="503.694px" height="59.5625px"><alt xml-lang="en-US" id="alt_id401575078735994">IMSECH equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id17253876723855" role="code" xml-lang="en-US"> @@ -62,6 +61,8 @@ returns 0.26580222883408 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"> diff --git a/source/text/scalc/01/func_imsin.xhp b/source/text/scalc/01/func_imsin.xhp index 2b286fb827..541f364370 100644 --- a/source/text/scalc/01/func_imsin.xhp +++ b/source/text/scalc/01/func_imsin.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/sc_func_imsin.svg" id="img_id211575078735993" width="447.2611px" height="31.5px"><alt xml-lang="en-US" id="alt_id401575078735994">IMSIN equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id284611113926520" role="code" xml-lang="en-US"> IMSIN(Complex_number) @@ -61,6 +60,8 @@ returns 0.909297426825682 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"> diff --git a/source/text/scalc/01/func_imsinh.xhp b/source/text/scalc/01/func_imsinh.xhp index 378b1609b7..7946d2749d 100644 --- a/source/text/scalc/01/func_imsinh.xhp +++ b/source/text/scalc/01/func_imsinh.xhp @@ -35,7 +35,6 @@ <image src="media/helpimg/sc_func_imsinh.svg" id="img_id211575078735993" width="459.7611px" height="31.5px"><alt xml-lang="en-US" id="alt_id401575078735994">IMSINH equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id284611113926520" role="code" xml-lang="en-US"> @@ -62,6 +61,8 @@ returns 3.62686040784702 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"> diff --git a/source/text/scalc/01/func_imtan.xhp b/source/text/scalc/01/func_imtan.xhp index 7462487fe4..ecfd8a6bde 100644 --- a/source/text/scalc/01/func_imtan.xhp +++ b/source/text/scalc/01/func_imtan.xhp @@ -35,8 +35,7 @@ <image src="media/helpimg/scalc/IMTAN_equation.svg" id="img_id211575078735993" width="353.294px" height="59.5625px"><alt xml-lang="en-US" id="alt_id401575078735994">IMTAN equation</alt></image> </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> + <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id23219159944377" role="code" xml-lang="en-US"> IMTAN(Complex_number) @@ -62,6 +61,8 @@ returns -2.18503986326152 as a string. <embedvar href="text/scalc/01/ful_func.xhp#func_imag_zero"/> </paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#imtrigon"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"> diff --git a/source/text/scalc/01/func_minute.xhp b/source/text/scalc/01/func_minute.xhp index 8b5021dba0..cc5051bbe8 100644 --- a/source/text/scalc/01/func_minute.xhp +++ b/source/text/scalc/01/func_minute.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3149803"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> </variable></h1> <paragraph role="paragraph" id="par_id3148988"><ahelp hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3148660">MINUTE(Number)</paragraph> <paragraph role="paragraph" id="par_id3154611"> @@ -43,6 +42,8 @@ <item type="input">=MINUTE(8.9999)</item> returns 59</paragraph> <paragraph role="paragraph" id="par_id3144755"> <item type="input">=MINUTE(NOW())</item> returns the current minute value.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_month.xhp b/source/text/scalc/01/func_month.xhp index 0213a7981c..61d95422f7 100644 --- a/source/text/scalc/01/func_month.xhp +++ b/source/text/scalc/01/func_month.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3149936"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> </variable></h1> <paragraph role="paragraph" id="par_id3153538"><ahelp hid="HID_FUNC_MONAT">Returns the month for the given date value.</ahelp> The month is returned as an integer between 1 and 12.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3145602">MONTH(Number)</paragraph> <paragraph role="paragraph" id="par_id3149485"> @@ -41,6 +40,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3149244"><item type="input">=MONTH(NOW())</item> returns the current month.</paragraph> <paragraph role="paragraph" id="par_id3154790"><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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp index 1636ec6623..4cff0ff134 100644 --- a/source/text/scalc/01/func_networkdays.xhp +++ b/source/text/scalc/01/func_networkdays.xhp @@ -36,7 +36,6 @@ <h1 id="hd_id3151254"><variable id="networkdays"><link href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></variable></h1> <paragraph id="par_id3153788" role="paragraph"><ahelp hid="HID_AAI_FUNC_NETWORKDAYS">Returns the number of workdays between a <emph>start date</emph> and an <emph>end date</emph>. Holidays can be deducted.</ahelp></paragraph> <embed href="text/scalc/01/04060102.xhp#ADD_note"/> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3145775" role="code">NETWORKDAYS(StartDate; EndDate [; [ Holidays ] [; Workdays ] ])</paragraph> <paragraph id="par_id3153885" role="paragraph"><emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.</paragraph> @@ -51,6 +50,8 @@ <paragraph id="par_id3147328" role="paragraph"><item type="input">=NETWORKDAYS(C3;D3;F3:J3)</item> returns 17 workdays.</paragraph> <paragraph id="par_id160920161751233621" role="paragraph">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"><item type="input">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_now.xhp b/source/text/scalc/01/func_now.xhp index 846f48cfff..1557ade2bb 100644 --- a/source/text/scalc/01/func_now.xhp +++ b/source/text/scalc/01/func_now.xhp @@ -31,13 +31,14 @@ </variable></h1> <paragraph role="paragraph" id="par_id3148829" xml-lang="en-US"><ahelp hid="HID_FUNC_JETZT">Returns the computer system date and time.</ahelp> The value is updated when you recalculate the document or each time a cell value is modified.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_volatile"/> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3154897" xml-lang="en-US">NOW()</paragraph> <paragraph role="paragraph" id="par_id4598529" xml-lang="en-US">NOW is a function without arguments.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_second.xhp b/source/text/scalc/01/func_second.xhp index 7576e75007..88bbdcdfc9 100644 --- a/source/text/scalc/01/func_second.xhp +++ b/source/text/scalc/01/func_second.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3159390"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> </variable></h1> <paragraph role="paragraph" id="par_id3148974"><ahelp hid="HID_FUNC_SEKUNDE">Returns the second for the given time value.</ahelp> The second is given as an integer between 0 and 59.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3148407">SECOND(Number)</paragraph> <paragraph role="paragraph" id="par_id3155904"> @@ -41,6 +40,8 @@ <item type="input">=SECOND(NOW())</item> returns the current second</paragraph> <paragraph role="paragraph" id="par_id3150831"> <item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item type="input">12:20:17</item>.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_sum.xhp b/source/text/scalc/01/func_sum.xhp index cee32e58b9..1af853c437 100644 --- a/source/text/scalc/01/func_sum.xhp +++ b/source/text/scalc/01/func_sum.xhp @@ -30,13 +30,13 @@ <paragraph id="par_id3163656" role="code">SUM(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_id3163704" role="paragraph"><input>=SUM(2;3;4)</input> returns 9.</paragraph> <paragraph id="par_id3151740" role="paragraph"><item type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three cells.</paragraph> <paragraph id="par_id931636109030406" role="paragraph"><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">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.xhp">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> - + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"> diff --git a/source/text/scalc/01/func_sumif.xhp b/source/text/scalc/01/func_sumif.xhp index c04eb5ad64..ebae33ece4 100644 --- a/source/text/scalc/01/func_sumif.xhp +++ b/source/text/scalc/01/func_sumif.xhp @@ -35,7 +35,6 @@ <embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/> <embed href="text/shared/00/00000001.xhp#regex"/> <paragraph id="par_id3152083" role="paragraph"><emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed.</paragraph> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="ex_sumif"> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> @@ -56,6 +55,8 @@ <paragraph role="paragraph" id="par_id331711030450765"><input>=SUMIF(A2:A6;E2;C2:C6)</input></paragraph> <paragraph role="paragraph" id="par_id11711031541218">If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents.</paragraph> </section> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="relatedtopics"> <tip id="par_id771677014538669"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF";>SUMIF wiki page</link>.</tip> <paragraph id="par_id11921178730928" role="paragraph" localize="false"> diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp index 4e7bc391d3..5709bb9d09 100644 --- a/source/text/scalc/01/func_sumifs.xhp +++ b/source/text/scalc/01/func_sumifs.xhp @@ -37,7 +37,6 @@ <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> @@ -56,6 +55,8 @@ <paragraph id="par_id135761606425300" role="paragraph"><item type="input">=SUMIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id30574750215839" role="paragraph">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"/> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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" localize="false"> diff --git a/source/text/scalc/01/func_time.xhp b/source/text/scalc/01/func_time.xhp index a44214dffc..e55714abaa 100644 --- a/source/text/scalc/01/func_time.xhp +++ b/source/text/scalc/01/func_time.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3154073"><variable id="time"><link href="text/scalc/01/func_time.xhp">TIME</link> </variable></h1> <paragraph role="paragraph" id="par_id3145762" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEIT">TIME returns the current time value from values for hours, minutes and seconds.</ahelp> This function can be used to convert a time based on these three elements to a decimal time value.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3154584" xml-lang="en-US">TIME(Hour; Minute; Second)</paragraph> <paragraph role="paragraph" id="par_id3152904" xml-lang="en-US">Use an integer to set the <emph>Hour</emph>.</paragraph> @@ -41,6 +40,8 @@ <item type="input">=TIME(0;0;0)</item> returns 00:00:00</paragraph> <paragraph role="paragraph" id="par_id3156090" xml-lang="en-US"> <item type="input">=TIME(4;20;4)</item> returns 04:20:04</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp index 0366760705..d4ab5fa875 100644 --- a/source/text/scalc/01/func_timevalue.xhp +++ b/source/text/scalc/01/func_timevalue.xhp @@ -30,7 +30,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEITWERT" id="bm_id3146767" localize="false"/> <h1 id="hd_id3146755"><variable id="timevalue"><link href="text/scalc/01/func_timevalue.xhp">TIMEVALUE</link></variable></h1> <paragraph id="par_id3148502" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEITWERT">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp></paragraph> - <embed href="text/scalc/01/ODFF.xhp#odff"/> <paragraph id="par_id3150794" role="paragraph" xml-lang="en-US">The internal number indicated as a decimal is the result of the date system used under $[officename] to calculate date entries.</paragraph> <paragraph id="par_id011920090347118" role="paragraph" xml-lang="en-US">If the text string also includes a year, month, or day, TIMEVALUE only returns the fractional part of the conversion.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> @@ -39,6 +38,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_today.xhp b/source/text/scalc/01/func_today.xhp index 46f2b96beb..316a037d9c 100644 --- a/source/text/scalc/01/func_today.xhp +++ b/source/text/scalc/01/func_today.xhp @@ -31,13 +31,14 @@ </variable></h1> <paragraph role="paragraph" id="par_id3153759" xml-lang="en-US"><ahelp hid="HID_FUNC_HEUTE">Returns the current computer system date.</ahelp> The value is updated when you reopen the document or modify the values of the document.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_volatile"/> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3153154" xml-lang="en-US">TODAY()</paragraph> <paragraph role="paragraph" id="par_id3154741" xml-lang="en-US"> TODAY is a function without arguments.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3156106" xml-lang="en-US"> <item type="input">TODAY()</item> returns the current computer system date.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_weekday.xhp b/source/text/scalc/01/func_weekday.xhp index 7094574d56..2ce41951c9 100644 --- a/source/text/scalc/01/func_weekday.xhp +++ b/source/text/scalc/01/func_weekday.xhp @@ -35,7 +35,6 @@ <h1 id="hd_id3154925"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></h1> <paragraph id="par_id3154228" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WOCHENTAG">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below.</paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3149033" role="code" xml-lang="en-US">WEEKDAY(Number [; Type])</paragraph> <paragraph id="par_id3149046" role="paragraph" xml-lang="en-US"> <emph>Number</emph>, as a date value, is a decimal for which the weekday is to be returned.</paragraph> @@ -143,6 +142,8 @@ <paragraph id="par_id050220170616006699" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("2017-05-02";14)</item> returns 6 (the Type parameter is 14, therefore Thursday is day number 1. May 2, 2017 was a Tuesday and therefore day number 6)</paragraph> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp index 340d6f96b1..b35804a6de 100644 --- a/source/text/scalc/01/func_weeknum.xhp +++ b/source/text/scalc/01/func_weeknum.xhp @@ -57,7 +57,6 @@ </tablecell> </tablerow> </table> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3147236">WEEKNUM(Number [; Mode])</paragraph> <paragraph role="paragraph" id="par_id3147511"> @@ -178,6 +177,8 @@ <paragraph role="paragraph" id="par_id3149792"><item type="input">=WEEKNUM(DATE(1995;1;1);2)</item> returns 1. Using System 1, the week containing January 1 is the first week of the year.</paragraph> <paragraph role="paragraph" id="par_id3149793"><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"><item type="input">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_workday.xhp b/source/text/scalc/01/func_workday.xhp index 9b3e142ed6..c4f54adccb 100644 --- a/source/text/scalc/01/func_workday.xhp +++ b/source/text/scalc/01/func_workday.xhp @@ -29,7 +29,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WORKDAY" id="bm_id3150028" localize="false"/> <h1 id="hd_id3149012"><variable id="workday"><link href="text/scalc/01/func_workday.xhp">WORKDAY</link></variable></h1> <paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_WORKDAY"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp></paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3154844" xml-lang="en-US">WORKDAY(StartDate; Days [; Holidays])</paragraph> <paragraph role="paragraph" id="par_id3147469" xml-lang="en-US"> @@ -50,6 +50,8 @@ <embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> <paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph> </section> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_year.xhp b/source/text/scalc/01/func_year.xhp index be09c371eb..879ec07284 100644 --- a/source/text/scalc/01/func_year.xhp +++ b/source/text/scalc/01/func_year.xhp @@ -30,7 +30,6 @@ <h1 id="hd_id3153982"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link> </variable></h1> <paragraph role="paragraph" id="par_id3147496"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the <link href="text/scalc/01/04060102.xhp#datebase">internal calculation rules</link>.</ahelp></paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3154304">YEAR(Number)</paragraph> <paragraph role="paragraph" id="par_id3156013"> @@ -44,7 +43,8 @@ <paragraph role="paragraph" id="par_id3150115"> <item type="input">=YEAR(33333.33)</item> returns 1991</paragraph> <paragraph role="paragraph" id="par_id141577548861101"><input>=YEAR(DATEVALUE("2010-09-28"))</input> returns 2010.</paragraph> - + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <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"/> diff --git a/source/text/scalc/01/func_yearfrac.xhp b/source/text/scalc/01/func_yearfrac.xhp index ca7277fd57..2962e5b103 100644 --- a/source/text/scalc/01/func_yearfrac.xhp +++ b/source/text/scalc/01/func_yearfrac.xhp @@ -29,7 +29,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/> <h1 id="hd_id3148735"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link></variable></h1> <paragraph role="paragraph" id="par_id3150899" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_YEARFRAC">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp></paragraph> -<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3155823" xml-lang="en-US">YEARFRAC(StartDate; EndDate [; Basis])</paragraph> <paragraph role="paragraph" id="par_id3145144" xml-lang="en-US"> @@ -93,6 +92,8 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3149007" xml-lang="en-US">What fraction of the year 2008 lies between 2008-01-01 and 2008-07-01?</paragraph> <paragraph role="paragraph" id="par_id3154632" xml-lang="en-US"><item type="input">=YEARFRAC("2008-01-01"; "2008-07-01";0)</item> returns 0.50.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="relatedtopics"> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section>
