diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-02-21 12:25:33 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-02-22 11:08:22 +0000 |
| commit | 36d7838ecf321f5053559878d0b922cb384af1ad (patch) | |
| tree | 27e7e2e3af57f373e8bf39c10cb8c3a64fd08ed3 /source/text/scalc | |
| parent | e9cbd8e356084c3d4b384315b6687b94080dd79b (diff) | |
Refactor headings of calc functions files
* Adjust headings
* reduce clutter of embeds (WIP)
* Note: this patch should not trigger retranslation
Change-Id: I4c87f59ebc1377ea4f487bcf0efc98f83caf64cb
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147409
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
74 files changed, 222 insertions, 208 deletions
diff --git a/source/text/scalc/01/ful_func.xhp b/source/text/scalc/01/ful_func.xhp index 1a1f2a3a59..1d37e191e6 100644 --- a/source/text/scalc/01/ful_func.xhp +++ b/source/text/scalc/01/ful_func.xhp @@ -16,13 +16,13 @@ <body> <comment> Title in descriptions of functions </comment> <section id="func_head_syntax"> - <h3 id="hd_id126511265112651">Syntax</h3> + <h2 id="hd_id126511265112651">Syntax</h2> </section> <section id="func_head_example"> - <h3 id="hd_id980889808898088">Examples</h3> + <h2 id="hd_id980889808898088">Examples</h2> </section> <section id="func_head_returns"> - <h3 id="hd_id980889808897165">Returns</h3> + <h2 id="hd_id980889808897165">Returns</h2> </section> <comment> Yes or No paragraphs to be used in description tables </comment> diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index c914b00739..656baaa9ae 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -24,7 +24,7 @@ <paragraph id="par_id2209201514174373" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="aggregate_des">This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.</variable></ahelp></paragraph> </section> <note id="par_id2209201514174453">AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row. </note> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id200801176228491" role="code" xml-lang="en-US">AGGREGATE(Function; Option; Number 1[; Number 2][; ... ;[Number 253]])</paragraph> <paragraph id="par_id2309201516102726" role="paragraph" xml-lang="en-US">or</paragraph> <paragraph id="par_id30181907128680" role="code" xml-lang="en-US">AGGREGATE(Function; Option; Array[; k])</paragraph> @@ -277,7 +277,7 @@ <note id="par_id2309201515555812">For using column labels “Automatically find columns and rows labels” function needs to be enabled.</note> <paragraph id="par_id2209201514174370" role="paragraph" xml-lang="en-US"><emph>k</emph> – required argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <table id="Table_example_aggregate"> <tablerow> diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index 5d41712ccb..5fbfb61f55 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -23,11 +23,11 @@ <bookmark_value>AVERAGEIF function</bookmark_value> <bookmark_value>arithmetic mean;satisfying condition</bookmark_value> </bookmark> -<h2 id="hd_id16852304621982"><variable id="averageif_head"><link href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable> function</h2> +<h1 id="hd_id16852304621982"><variable id="averageif_head"><link href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable> function</h1> <paragraph id="par_id7281266615152" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="averageif_des">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id200801176228491" role="code" xml-lang="en-US">AVERAGEIF(Range; Criterion [; Average_Range ])</paragraph> <paragraph id="par_id15226321619829" role="paragraph" xml-lang="en-US"><emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/> diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index e94dc7bea1..2e28b34118 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -23,11 +23,11 @@ <bookmark_value>AVERAGEIFS function</bookmark_value> <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value> </bookmark> -<h2 id="hd_id537445374453744"><variable id="averageifs_head"><link href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable> function</h2> +<h1 id="hd_id537445374453744"><variable id="averageifs_head"><link href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable> function</h1> <paragraph id="par_id538405384053840" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id21050267713178" role="code" xml-lang="en-US">AVERAGEIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> <paragraph id="par_id165832700711773" role="paragraph" xml-lang="en-US"><emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean.</paragraph> diff --git a/source/text/scalc/01/func_ceiling.xhp b/source/text/scalc/01/func_ceiling.xhp index 86a92fc771..37d0060162 100644 --- a/source/text/scalc/01/func_ceiling.xhp +++ b/source/text/scalc/01/func_ceiling.xhp @@ -23,18 +23,18 @@ </bookmark> <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/> - <h2 id="hd_id3152518"><variable id="CEILINGh1"><link href="text/scalc/01/func_ceiling.xhp#ceiling">CEILING</link></variable></h2> + <h1 id="hd_id3152518"><variable id="CEILINGh1"><link href="text/scalc/01/func_ceiling.xhp#ceiling">CEILING</link></variable></h1> <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> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3153454" role="code" xml-lang="en-US">CEILING(Number [; Significance [; Mode]])</paragraph> <section id="argnumber"> <paragraph id="par_id3153467" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number.</paragraph> </section> <paragraph id="par_id3155000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>.</paragraph> <paragraph id="par_id3155020" role="paragraph" xml-lang="en-US"><emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero).</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id281586208138400"><input>=CEILING(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id921586208142416"><input>=CEILING(3.45; 3)</input> returns 6.</paragraph> <paragraph role="paragraph" id="par_id921586208146984"><input>=CEILING(-1.234)</input> returns -1.</paragraph> @@ -54,11 +54,11 @@ <paragraph id="par_id2953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id151586642494759">For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.</paragraph> <note id="par_id631586642933797">This function calculates identical results to the <link href="text/scalc/01/func_ceiling.xhp#isoceiling">ISO.CEILING</link> function.</note> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id2953454" role="code" xml-lang="en-US">CEILING.PRECISE(Number [; Significance])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> <paragraph id="par_id2955000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id201586213398634"><input>=CEILING.PRECISE(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586213406243"><input>=CEILING.PRECISE(-45.67; 2)</input> returns -44.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> @@ -77,12 +77,12 @@ <paragraph role="paragraph" id="par_id81516997342088" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MATH">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id911586642319078">For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.</paragraph> <warning id="par_id291516998575663">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id841516997669932" xml-lang="en-US">CEILING.MATH(Number [; Significance [; Mode]])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> <paragraph role="paragraph" id="par_id491516997725772" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> <paragraph role="paragraph" id="par_id451516997742909" xml-lang="en-US"><emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero).</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id331586208590009"><input>=CEILING.MATH(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id481586208595809"><input>=CEILING.MATH(3.45; -3)</input> returns 6.</paragraph> <paragraph role="paragraph" id="par_id641586208600665"><input>=CEILING.MATH(-1.234)</input> returns -1.</paragraph> @@ -102,11 +102,11 @@ <paragraph role="paragraph" id="par_id811516998845826" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id361586213828675">For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative.</paragraph> <warning id="par_id881586213934118">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function.</warning> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id251516998856873" xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> <paragraph role="paragraph" id="par_id151516998882622" xml-lang="en-US"><emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id421586214128242"><input>=CEILING.XCL(3.45,2)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586214132234"><input>=CEILING.XCL(-45.67; 2)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id811586214136666"><input>=CEILING.XCL(-45.67; -2)</input> returns -46.</paragraph> @@ -127,11 +127,11 @@ <paragraph id="par_id8953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_ISO">Rounds a number up to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id101586214229587">For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.</paragraph> <note id="par_id821586214265060">This function calculates identical results to the <link href="text/scalc/01/func_ceiling.xhp#ceilingprecise">CEILING.PRECISE</link> function.</note> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id8953454" role="code" xml-lang="en-US">ISO.CEILING(Number [; Significance])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> <paragraph id="par_id8955000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id801586214431463"><input>=ISO.CEILING(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id181586214438808"><input>=ISO.CEILING(-45.67; 2)</input> returns -44.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_concat.xhp b/source/text/scalc/01/func_concat.xhp index 8b4e8c4ac9..a352297f99 100644 --- a/source/text/scalc/01/func_concat.xhp +++ b/source/text/scalc/01/func_concat.xhp @@ -21,7 +21,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id741556228031712"> <bookmark_value>CONCAT function</bookmark_value> </bookmark> - <h2 id="hd_id471556226436779"><variable id="concatfunct"><link href="text/scalc/01/func_concat.xhp">CONCAT</link></variable></h2> + <h1 id="hd_id471556226436779"><variable id="concatfunct"><link href="text/scalc/01/func_concat.xhp">CONCAT</link></variable></h1> <paragraph id="par_id891556226436781" role="paragraph" xml-lang="en-US"><variable id="concatfunction"><ahelp hid=".">Concatenates one or more strings</ahelp></variable></paragraph> </section> <paragraph role="paragraph" id="par_id701556226865876">CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M.</paragraph> diff --git a/source/text/scalc/01/func_convert.xhp b/source/text/scalc/01/func_convert.xhp index 567cd61eb7..b7cad69a30 100644 --- a/source/text/scalc/01/func_convert.xhp +++ b/source/text/scalc/01/func_convert.xhp @@ -19,11 +19,11 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148446"> <bookmark_value>CONVERT function</bookmark_value> </bookmark> - <h2 id="hd_id9522389625800"> + <h1 id="hd_id9522389625800"> <variable id="convert_head"> <link href="text/scalc/01/func_convert.xhp">CONVERT</link> </variable> function - </h2> + </h1> <paragraph xml-lang="en-US" id="par_id3154902" role="paragraph"> <ahelp hid="HID_AAI_FUNC_CONVERT"><variable id="convert_desc">Converts a value from one unit of measurement to the corresponding value in another unit of measurement.</variable></ahelp> Enter the units of measurement directly as text in quotation marks or as a reference. The units of measurement specified through the arguments must match the supported unit symbols, which are case-sensitive. For example, the symbol for the unit "newton" is the uppercase "N".</paragraph> <paragraph role="paragraph" id="par_id761620414839890">The measurement units recognized by <literal>CONVERT</literal> fall into 13 groups, which are listed <link href="text/scalc/01/func_convert.xhp#Unit_Groups">below</link>. CONVERT will perform conversions between any two units within one group but reject any request to convert between units in different groups.</paragraph> diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index d2af44ba1f..a395c48bb4 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -28,7 +28,7 @@ <paragraph id="par_id462646264626" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="countifs_des">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> diff --git a/source/text/scalc/01/func_date.xhp b/source/text/scalc/01/func_date.xhp index bb05e1f800..9d67547b04 100644 --- a/source/text/scalc/01/func_date.xhp +++ b/source/text/scalc/01/func_date.xhp @@ -26,11 +26,11 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3155511"><bookmark_value>DATE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><h2 id="hd_id3155511"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link> -</variable></h2> +<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/common_func.xhp#sectionsyntax"/> +<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"> <emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99.</paragraph> @@ -40,7 +40,7 @@ <paragraph role="paragraph" id="par_id3153183" xml-lang="en-US"> <emph>Day</emph> is an integer indicating the day of the month.</paragraph> <paragraph role="paragraph" id="par_id3156260" xml-lang="en-US">If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type="input">=DATE(00;12;31)</item> the result will be 2000-12-31. If, on the other hand, you enter <item type="input">=DATE(00;13;31)</item> the result will be 2001-01-31.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<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 1/31/00 if the cell format setting is MM/DD/YY.</paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_datedif.xhp b/source/text/scalc/01/func_datedif.xhp index c8dae66be9..ea722d5833 100644 --- a/source/text/scalc/01/func_datedif.xhp +++ b/source/text/scalc/01/func_datedif.xhp @@ -18,11 +18,11 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3155511"><bookmark_value>DATEDIF function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022" localize="false"/> -<h2 id="hd_id3155511"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link></variable></h2> +<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/common_func.xhp#sectionsyntax"/> +<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> </paragraph> @@ -93,7 +93,7 @@ </tablerow> </table> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3152589" xml-lang="en-US"> Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13.</paragraph> <paragraph role="paragraph" id="par_id3252589" xml-lang="en-US"><item type="input">=DATEDIF("1974-04-17";"2012-06-13";"y")</item> yields 38.</paragraph> diff --git a/source/text/scalc/01/func_datevalue.xhp b/source/text/scalc/01/func_datevalue.xhp index 963c859269..b51253d5f3 100644 --- a/source/text/scalc/01/func_datevalue.xhp +++ b/source/text/scalc/01/func_datevalue.xhp @@ -36,12 +36,12 @@ <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/common_func.xhp#sectionsyntax"/> + <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> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <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> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_day.xhp b/source/text/scalc/01/func_day.xhp index 33804020ef..a407680530 100644 --- a/source/text/scalc/01/func_day.xhp +++ b/source/text/scalc/01/func_day.xhp @@ -26,16 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3147317"><bookmark_value>DAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h2 id="hd_id3147317"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> -</variable></h2> +<bookmark xml-lang="en-US" 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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3149430" xml-lang="en-US">DAY(Number)</paragraph> <paragraph role="paragraph" id="par_id3149443" xml-lang="en-US"><emph>Number</emph> is the internal date number.</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3151200" xml-lang="en-US"><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" 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> diff --git a/source/text/scalc/01/func_days.xhp b/source/text/scalc/01/func_days.xhp index fb50701a76..fe5e71a328 100644 --- a/source/text/scalc/01/func_days.xhp +++ b/source/text/scalc/01/func_days.xhp @@ -26,17 +26,17 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3151328"><bookmark_value>DAYS function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/><h2 id="hd_id3151328"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link> -</variable></h2> +<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> The result returns the number of days between the two days.</paragraph> <embed href="text/scalc/01/ODFF.xhp#odff"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<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"> <emph>Date1</emph> is the start date, <emph>Date2</emph> is the end date. If <emph>Date2</emph> is an earlier date than <emph>Date1</emph> the result is a negative number.</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <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"> diff --git a/source/text/scalc/01/func_days360.xhp b/source/text/scalc/01/func_days360.xhp index 822d7f44f8..e7c5a8e30d 100644 --- a/source/text/scalc/01/func_days360.xhp +++ b/source/text/scalc/01/func_days360.xhp @@ -26,17 +26,17 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3148555"><bookmark_value>DAYS360 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE360" id="bm_id3155906" localize="false"/><h2 id="hd_id3148555"><variable id="days360"><link href="text/scalc/01/func_days360.xhp">DAYS360</link> -</variable></h2> +<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/common_func.xhp#sectionsyntax"/> +<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> <paragraph role="paragraph" id="par_id3151064" xml-lang="en-US">The optional argument <emph>Type</emph> determines the type of difference calculation. If Type = 0 or if the argument is missing, the US method (NASD, National Association of Securities Dealers) is used. If Type <> 0, the European method is used.</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<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"> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> diff --git a/source/text/scalc/01/func_eastersunday.xhp b/source/text/scalc/01/func_eastersunday.xhp index 8227311c4f..d93d4047d5 100644 --- a/source/text/scalc/01/func_eastersunday.xhp +++ b/source/text/scalc/01/func_eastersunday.xhp @@ -26,10 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3152960"><bookmark_value>EASTERSUNDAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OSTERSONNTAG" id="bm_id3156270" localize="false"/><h2 id="hd_id3152960"><variable id="eastersunday"><link href="text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OSTERSONNTAG" id="bm_id3156270" localize="false"/><h1 id="hd_id3152960"><variable id="eastersunday"><link href="text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY</link> +</variable></h1> <paragraph role="paragraph" id="par_id3154570" xml-lang="en-US"><ahelp hid="HID_FUNC_OSTERSONNTAG">Returns the date of Easter Sunday for the entered year.</ahelp></paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id2113711" xml-lang="en-US">EASTERSUNDAY(Year)</paragraph> <paragraph role="paragraph" id="par_id3938413" xml-lang="en-US"> <emph>Year</emph> is an integer between 1583 and 9956 or 0 and 99. You can also calculate other holidays by simple addition with this date.</paragraph> @@ -37,7 +37,7 @@ <paragraph role="paragraph" id="par_id3147521" xml-lang="en-US">Good Friday = EASTERSUNDAY(Year) - 2</paragraph> <paragraph role="paragraph" id="par_id3146072" xml-lang="en-US">Pentecost Sunday = EASTERSUNDAY(Year) + 49</paragraph> <paragraph role="paragraph" id="par_id3149553" xml-lang="en-US">Pentecost Monday = EASTERSUNDAY(Year) + 50</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3154472" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)</item> returns 2000-04-23.</paragraph> <paragraph role="paragraph" id="par_id3150940" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)+49</item> returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_edate.xhp b/source/text/scalc/01/func_edate.xhp index 14b050236f..a9937748c0 100644 --- a/source/text/scalc/01/func_edate.xhp +++ b/source/text/scalc/01/func_edate.xhp @@ -26,11 +26,12 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3151184"><bookmark_value>EDATE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/><h2 id="hd_id3151184"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/> +<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/common_func.xhp#sectionsyntax"/> +<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"> <emph>StartDate</emph> is a date.</paragraph> @@ -38,7 +39,7 @@ <emph>Months</emph> is the number of months before (negative) or after (positive) the start date.</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <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> diff --git a/source/text/scalc/01/func_eomonth.xhp b/source/text/scalc/01/func_eomonth.xhp index 74d3af5929..a3f8abc8bf 100644 --- a/source/text/scalc/01/func_eomonth.xhp +++ b/source/text/scalc/01/func_eomonth.xhp @@ -26,23 +26,24 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150991"><bookmark_value>EOMONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/><h2 id="hd_id3150991"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/> +<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/common_func.xhp#sectionsyntax"/> +<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"> <emph>StartDate</emph> is a date (the starting point of the calculation).</paragraph> <paragraph role="paragraph" id="par_id3155615" xml-lang="en-US"> <emph>Months</emph> is the number of months before (negative) or after (positive) the start date.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3154829" xml-lang="en-US">What is the last day of the month that falls 6 months after September 14 2001?</paragraph> <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> + <paragraph role="paragraph" id="par_id681621540307527"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH">EOMONTH wiki page</link></paragraph> <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 501888964a..59d526430b 100644 --- a/source/text/scalc/01/func_error_type.xhp +++ b/source/text/scalc/01/func_error_type.xhp @@ -25,11 +25,11 @@ <bookmark_value>index of the Error type</bookmark_value> </bookmark> -<paragraph id="hd_id348223482234822" role="heading" level="2" xml-lang="en-US"><variable id="error_type_head"><link href="text/scalc/01/func_error_type.xhp">ERROR.TYPE</link></variable> function</paragraph> +<h1 id="hd_id348223482234822"><variable id="error_type_head"><link href="text/scalc/01/func_error_type.xhp">ERROR.TYPE</link></variable> function</h1> <paragraph id="par_id350283502835028" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="error_type_des">Returns a number representing a specific Error type, or the error value #N/A, if there is no error. </variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#5.0"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id1861223540440" role="code" xml-lang="en-US">ERROR.TYPE(Error_value)</paragraph> <paragraph id="par_id217737315" role="paragraph" xml-lang="en-US"><emph>Error_value</emph> – required argument. The error value or a reference to a cell, whose value needs to be processed.</paragraph> @@ -109,17 +109,17 @@ </table> <embed href="text/scalc/01/ODFF.xhp#odff"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="hd_id182972884627444" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<h4 id="hd_id182972884627444">Simple usage</h4> <paragraph id="par_id15812966716957" role="paragraph" xml-lang="en-US"><item type="input">=ERROR.TYPE(#N/A)</item></paragraph> <paragraph id="par_id280533214928308" role="paragraph" xml-lang="en-US">Returns 7, because 7 is the index number of the error value #N/A.</paragraph> <paragraph id="par_id1047088636291" role="paragraph" xml-lang="en-US"><item type="input">=ERROR.TYPE(A3)</item></paragraph> <paragraph id="par_id24308515918391" role="paragraph" xml-lang="en-US">If A3 contains an expression equivalent to the division by zero, the function returns 2, because 2 is the index number of the error value #DIV/0!</paragraph> -<paragraph id="hd_id9842206115046" role="heading" level="4" xml-lang="en-US">More advanced way</paragraph> +<h4 id="hd_id9842206115046">More advanced way</h4> <paragraph id="par_id90121141327448" role="paragraph" xml-lang="en-US">If in division A1 by A2, A2 can turn to zero, you can handle the situation as follows:</paragraph> <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> -<paragraph id="par_id26251175451270" role="warning" xml-lang="en-US">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.</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"> <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> diff --git a/source/text/scalc/01/func_floor.xhp b/source/text/scalc/01/func_floor.xhp index 1e4dc67cbd..f60e5b3012 100644 --- a/source/text/scalc/01/func_floor.xhp +++ b/source/text/scalc/01/func_floor.xhp @@ -23,21 +23,21 @@ </bookmark> <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/> - <h2 id="hd_id3157404"><variable id="FLOORh1"><link href="text/scalc/01/func_floor.xhp#floor">FLOOR</link></variable></h2> + <h1 id="hd_id3157404"><variable id="FLOORh1"><link href="text/scalc/01/func_floor.xhp#floor">FLOOR</link></variable></h1> <paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id661586285977707">For a positive number and a positive significance value, the function rounds down (towards 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> <section id="floor_warn"> <warning id="par_id3163894">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions.</warning> </section> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3157464" role="code" xml-lang="en-US">FLOOR(Number[; Significance[; Mode]])</paragraph> <section id="argnumber"> <paragraph id="par_id3153467" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number.</paragraph> </section> <paragraph id="par_id3157497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>.</paragraph> <paragraph id="par_id3157517" role="paragraph" xml-lang="en-US"><emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero).</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id761586287595376"><input>=FLOOR(3.45)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id311586287600048"><input>=FLOOR(3.45, 3)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id661586287604519"><input>=FLOOR(-1.234)</input> returns -2.</paragraph> @@ -55,12 +55,12 @@ <paragraph role="paragraph" id="par_id721586287302689">Rounds a number to the nearest multiple of a significance value.</paragraph> <paragraph role="paragraph" id="par_id311586287323417">For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.</paragraph> <warning id="par_id851586287535879">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id161586287421523">FLOOR.MATH(Number[; Significance[; Mode]])</paragraph> <embed href="text/scalc/01/func_floor.xhp#argnumber"/> <paragraph role="paragraph" id="par_id231586287448716"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> <paragraph role="paragraph" id="par_id261586287494401"><emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero).</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id101586287621816"><input>=FLOOR.MATH(3.45)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id771586287627784"><input>=FLOOR.MATH(3.45,-3)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id981586287632392"><input>=FLOOR.MATH(-1.234)</input> returns -2.</paragraph> @@ -85,12 +85,12 @@ <paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id261586641501175">For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored.</paragraph> <embed href="text/scalc/01/func_floor.xhp#floor_warn"/> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id2957464" role="code" xml-lang="en-US">FLOOR.PRECISE(Number[; Significance])</paragraph> <embed href="text/scalc/01/func_floor.xhp#argnumber"/> <paragraph id="par_id2957497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id981586291388900"><input>=FLOOR.PRECISE(3.45)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id831586291395477"><input>=FLOOR.PRECISE(-45.67,2)</input> returns -46.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> @@ -108,11 +108,11 @@ <paragraph role="paragraph" id="par_id521586291476023">Rounds a number to the nearest multiple of a significance value.</paragraph> <paragraph role="paragraph" id="par_id401586291488768">For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative.</paragraph> <warning id="par_id231586291503319">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function.</warning> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id491586291532177">FLOOR.XCL(Number; Significance)</paragraph> <embed href="text/scalc/01/func_floor.xhp#argnumber"/> <paragraph role="paragraph" id="par_id761586291578755"><emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id531586291622306"><input>=FLOOR.XCL(3.45,2)</input> returns 2.</paragraph> <paragraph role="paragraph" id="par_id361586291628003"><input>=FLOOR.XCL(-45.67,2)</input> returns -46.</paragraph> <paragraph role="paragraph" id="par_id801586291641099"><input>=FLOOR.XCL(-45.67,-2)</input> returns -44.</paragraph> diff --git a/source/text/scalc/01/func_forecastetsadd.xhp b/source/text/scalc/01/func_forecastetsadd.xhp index bc981239e7..75d66554ff 100644 --- a/source/text/scalc/01/func_forecastetsadd.xhp +++ b/source/text/scalc/01/func_forecastetsadd.xhp @@ -28,7 +28,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.ADD calculates with the model</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0403201618594544" role="code" xml-lang="en-US">FORECAST.ETS.ADD(targets, values, timeline, [period_length], [data_completion], [aggregation]) </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#target"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> diff --git a/source/text/scalc/01/func_forecastetsmult.xhp b/source/text/scalc/01/func_forecastetsmult.xhp index 49ea19fd57..014b5d2ed1 100644 --- a/source/text/scalc/01/func_forecastetsmult.xhp +++ b/source/text/scalc/01/func_forecastetsmult.xhp @@ -29,7 +29,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.MULT calculates with the model </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0403201618594544" role="code" xml-lang="en-US">FORECAST.ETS.MULT(targets, values, timeline, [period_length], [data_completion], [aggregation]) </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#target"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> diff --git a/source/text/scalc/01/func_forecastetspiadd.xhp b/source/text/scalc/01/func_forecastetspiadd.xhp index 4c3b6f0ab2..633b99b810 100644 --- a/source/text/scalc/01/func_forecastetspiadd.xhp +++ b/source/text/scalc/01/func_forecastetspiadd.xhp @@ -29,7 +29,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201610005998" role="paragraph" xml-lang="en-US">FORECAST.ETS.PI.ADD calculates with the model</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0603201610010044" role="code" xml-lang="en-US">FORECAST.ETS.PI.ADD(target, values, timeline, [confidence_level], [period_length], [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#target"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> diff --git a/source/text/scalc/01/func_forecastetspimult.xhp b/source/text/scalc/01/func_forecastetspimult.xhp index b5d5c1eb99..3419231172 100644 --- a/source/text/scalc/01/func_forecastetspimult.xhp +++ b/source/text/scalc/01/func_forecastetspimult.xhp @@ -29,7 +29,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201610005998" role="paragraph" xml-lang="en-US">FORECAST.ETS.PI.MULT calculates with the model</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0603201610010044" role="code" xml-lang="en-US">FORECAST.ETS.PI.MULT(target, values, timeline, [confidence_level], [period_length], [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#target"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> diff --git a/source/text/scalc/01/func_forecastetsseason.xhp b/source/text/scalc/01/func_forecastetsseason.xhp index 6fead6db6c..a747be5e91 100644 --- a/source/text/scalc/01/func_forecastetsseason.xhp +++ b/source/text/scalc/01/func_forecastetsseason.xhp @@ -29,7 +29,7 @@ <paragraph id="par_id0603201617510446" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_SEA">Returns the number of samples in period as calculated by Calc in case of FORECAST.ETS functions when argument <emph>period_length</emph> equals 1. </ahelp></paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0403201618595132" role="paragraph" xml-lang="en-US">The same result is returned with FORECAST.ETS.STAT functions when argument <emph>stat_type</emph> equals 9 (and <emph>period_length</emph> equals 1).</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0603201618013796" role="code" xml-lang="en-US">FORECAST.ETS.SEASONALITY (values, timeline, [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/> diff --git a/source/text/scalc/01/func_forecastetsstatadd.xhp b/source/text/scalc/01/func_forecastetsstatadd.xhp index 0d7d62bb1e..51170e3d38 100644 --- a/source/text/scalc/01/func_forecastetsstatadd.xhp +++ b/source/text/scalc/01/func_forecastetsstatadd.xhp @@ -31,7 +31,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.STAT.ADD calculates with the model </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0603201610005728" role="code" xml-lang="en-US">FORECAST.ETS.STAT.ADD (values, timeline, stat_type, [period_length], [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/> diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp b/source/text/scalc/01/func_forecastetsstatmult.xhp index 4c818cb675..2601deedf2 100644 --- a/source/text/scalc/01/func_forecastetsstatmult.xhp +++ b/source/text/scalc/01/func_forecastetsstatmult.xhp @@ -30,7 +30,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.STAT.MULT calculates with the model </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id0603201610005728" role="code" xml-lang="en-US">FORECAST.ETS.STAT.MULT (values, timeline, stat_type, [period_length], [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/> diff --git a/source/text/scalc/01/func_fourier.xhp b/source/text/scalc/01/func_fourier.xhp index 56aec00474..bf08ae9320 100644 --- a/source/text/scalc/01/func_fourier.xhp +++ b/source/text/scalc/01/func_fourier.xhp @@ -21,7 +21,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id581556228060864"> <bookmark_value>FOURIER function</bookmark_value> </bookmark> - <h2 id="hd_id551556227727946"><variable id="fourierfunct"><link href="text/scalc/01/func_fourier.xhp">FOURIER</link></variable></h2> + <h1 id="hd_id551556227727946"><variable id="fourierfunct"><link href="text/scalc/01/func_fourier.xhp">FOURIER</link></variable></h1> <paragraph id="par_id121556227727948" role="paragraph"><variable id="textjoinfunction"><ahelp hid=".">Computes the Discrete Fourier Transform [DFT] of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp></variable> The function is an <link href="text/scalc/01/04060107.xhp">array formula</link>.</paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> diff --git a/source/text/scalc/01/func_hour.xhp b/source/text/scalc/01/func_hour.xhp index 9936d29149..73c7d75ad8 100644 --- a/source/text/scalc/01/func_hour.xhp +++ b/source/text/scalc/01/func_hour.xhp @@ -26,15 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/><h2 id="hd_id3154725"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/> +<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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3150637" xml-lang="en-US">HOUR(Number)</paragraph> <paragraph role="paragraph" id="par_id3147547" xml-lang="en-US"> <emph>Number</emph>, as a time value, is a decimal, for which the hour is to be returned.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3159215" xml-lang="en-US"> <item type="input">=HOUR(NOW())</item> returns the current hour</paragraph> <paragraph role="paragraph" id="par_id3145152" xml-lang="en-US"> diff --git a/source/text/scalc/01/func_ifs.xhp b/source/text/scalc/01/func_ifs.xhp index cbb0b35b40..e01672ed3c 100644 --- a/source/text/scalc/01/func_ifs.xhp +++ b/source/text/scalc/01/func_ifs.xhp @@ -21,7 +21,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id901556242230198"> <bookmark_value>IFS function</bookmark_value> </bookmark> - <h2 id="hd_id271556234923654"><variable id="ifsfunct"><link href="text/scalc/01/func_ifs.xhp">IFS</link></variable></h2> + <h1 id="hd_id271556234923654"><variable id="ifsfunct"><link href="text/scalc/01/func_ifs.xhp">IFS</link></variable></h1> <paragraph id="par_id171556234923655" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">IFS is a multiple IF-function.</ahelp></variable></paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> diff --git a/source/text/scalc/01/func_imcos.xhp b/source/text/scalc/01/func_imcos.xhp index c2a4e7fdb7..e8e7afa165 100644 --- a/source/text/scalc/01/func_imcos.xhp +++ b/source/text/scalc/01/func_imcos.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMCOS function</bookmark_value> <bookmark_value>cosine;complex number</bookmark_value> </bookmark> - <h2 id="hd_id90361032228870"> + <h1 id="hd_id90361032228870"> <variable id="imcos_head"> <link href="text/scalc/01/func_imcos.xhp">IMCOS</link> </variable> function - </h2> + </h1> <paragraph id="par_id1066273182723" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imcos_des">Returns the cosine of a complex number.</variable> The cosine of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imcosh.xhp b/source/text/scalc/01/func_imcosh.xhp index 718b490db4..e09da9b477 100644 --- a/source/text/scalc/01/func_imcosh.xhp +++ b/source/text/scalc/01/func_imcosh.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMCOSH function</bookmark_value> <bookmark_value>hyperbolic cosine;complex number</bookmark_value> </bookmark> - <h2 id="hd_id124691246912469"> + <h1 id="hd_id124691246912469"> <variable id="imcosh_head"> <link href="text/scalc/01/func_imcosh.xhp">IMCOSH</link> </variable> function - </h2> + </h1> <paragraph id="par_id125881258812588" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imcosh_des">Returns the hyperbolic cosine of a complex number.</variable> The hyperbolic cosine of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imcot.xhp b/source/text/scalc/01/func_imcot.xhp index 20d572a62c..d0c4c6c6ce 100644 --- a/source/text/scalc/01/func_imcot.xhp +++ b/source/text/scalc/01/func_imcot.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMCOT function</bookmark_value> <bookmark_value>cotangent;complex number</bookmark_value> </bookmark> - <h2 id="hd_id763567635676356"> + <h1 id="hd_id763567635676356"> <variable id="imcot_head"> <link href="text/scalc/01/func_imcot.xhp">IMCOT</link> </variable> function - </h2> + </h1> <paragraph id="par_id764617646176461" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imcot_des">Returns the cotangent of a complex number.</variable> The cotangent of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imcsc.xhp b/source/text/scalc/01/func_imcsc.xhp index ac1504080c..aedded0b1b 100644 --- a/source/text/scalc/01/func_imcsc.xhp +++ b/source/text/scalc/01/func_imcsc.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMCSC function</bookmark_value> <bookmark_value>cosecant;complex number</bookmark_value> </bookmark> - <h2 id="hd_id931679316793167"> + <h1 id="hd_id931679316793167"> <variable id="imcsc_head"> <link href="text/scalc/01/func_imcsc.xhp">IMCSC</link> </variable> function - </h2> + </h1> <paragraph id="par_id932329323293232" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imcsc_des">Returns the cosecant of a complex number. </variable> The cosecant of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imcsch.xhp b/source/text/scalc/01/func_imcsch.xhp index cd854aae43..ba6980fc76 100644 --- a/source/text/scalc/01/func_imcsch.xhp +++ b/source/text/scalc/01/func_imcsch.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMCSCH function</bookmark_value> <bookmark_value>hyperbolic cosecant;complex number</bookmark_value> </bookmark> - <h2 id="hd_id977779777797777"> + <h1 id="hd_id977779777797777"> <variable id="imcsch_head"> <link href="text/scalc/01/func_imcsch.xhp">IMCSCH</link> </variable> function - </h2> + </h1> <paragraph id="par_id979369793697936" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imcsch_des">Returns the hyperbolic cosecant of a complex number.</variable> The hyperbolic cosecant of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imsec.xhp b/source/text/scalc/01/func_imsec.xhp index ccf6b8f2ba..eb91979f5f 100644 --- a/source/text/scalc/01/func_imsec.xhp +++ b/source/text/scalc/01/func_imsec.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMSEC function</bookmark_value> <bookmark_value>secant;complex number</bookmark_value> </bookmark> - <h2 id="hd_id29384186273495"> + <h1 id="hd_id29384186273495"> <variable id="imsec_head"> <link href="text/scalc/01/func_imsec.xhp">IMSEC</link> </variable> function - </h2> + </h1> <paragraph id="par_id23292284928998" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imsec_des">Returns the secant of a complex number. </variable> The secant of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imsech.xhp b/source/text/scalc/01/func_imsech.xhp index fc5155fd2d..52adb76dfa 100644 --- a/source/text/scalc/01/func_imsech.xhp +++ b/source/text/scalc/01/func_imsech.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMSECH function</bookmark_value> <bookmark_value>hyperbolic secant;complex number</bookmark_value> </bookmark> - <h2 id="hd_id258933143113817"> + <h1 id="hd_id258933143113817"> <variable id="imsech_head"> <link href="text/scalc/01/func_imsech.xhp">IMSECH</link> </variable> function - </h2> + </h1> <paragraph id="par_id116441182314950" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imsech_des">Returns the hyperbolic secant of a complex number. </variable> The hyperbolic secant of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imsin.xhp b/source/text/scalc/01/func_imsin.xhp index 3fb20db2fe..c45d8d9e93 100644 --- a/source/text/scalc/01/func_imsin.xhp +++ b/source/text/scalc/01/func_imsin.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMSIN function</bookmark_value> <bookmark_value>sine;complex number</bookmark_value> </bookmark> - <h2 id="hd_id3192388765304"> + <h1 id="hd_id3192388765304"> <variable id="imsin_head"> <link href="text/scalc/01/func_imsin.xhp">IMSIN</link> </variable> function - </h2> + </h1> <paragraph id="par_id1955633330277" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imsin_des">Returns the sine of a complex number. </variable> The sine of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imsinh.xhp b/source/text/scalc/01/func_imsinh.xhp index 058c31927b..64b5e1f3af 100644 --- a/source/text/scalc/01/func_imsinh.xhp +++ b/source/text/scalc/01/func_imsinh.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMSINH function</bookmark_value> <bookmark_value>hyperbolic sine;complex number</bookmark_value> </bookmark> - <h2 id="hd_id3192388765304"> + <h1 id="hd_id3192388765304"> <variable id="imsinh_head"> <link href="text/scalc/01/func_imsinh.xhp">IMSINH</link> </variable> function - </h2> + </h1> <paragraph id="par_id1955633330277" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imsinh_des">Returns the hyperbolic sine of a complex number.</variable> The hyperbolic sine of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_imtan.xhp b/source/text/scalc/01/func_imtan.xhp index edabfe86ce..7902a49ad1 100644 --- a/source/text/scalc/01/func_imtan.xhp +++ b/source/text/scalc/01/func_imtan.xhp @@ -20,11 +20,11 @@ <bookmark_value>IMTAN function</bookmark_value> <bookmark_value>tangent;complex number</bookmark_value> </bookmark> - <h2 id="hd_id9522389621160"> + <h1 id="hd_id9522389621160"> <variable id="imtan_head"> <link href="text/scalc/01/func_imtan.xhp">IMTAN</link> </variable> function - </h2> + </h1> <paragraph id="par_id5700137827273" role="paragraph" xml-lang="en-US"> <ahelp hid="."> <variable id="imtan_des">Returns the tangent of a complex number.</variable> The tangent of a complex number can be expressed by: diff --git a/source/text/scalc/01/func_isoweeknum.xhp b/source/text/scalc/01/func_isoweeknum.xhp index 96f58c8666..51ae0e8847 100644 --- a/source/text/scalc/01/func_isoweeknum.xhp +++ b/source/text/scalc/01/func_isoweeknum.xhp @@ -26,19 +26,20 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>ISOWEEKNUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISOWEEKNUM" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISOWEEKNUM" id="bm_id3158403" localize="false"/> +<h1 id="hd_id3159161"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> +</variable></h1> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_ISOWEEKNUM">ISOWEEKNUM calculates the week number of the year for the internal date value.</ahelp></paragraph> <note id="par_idN105E4">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</note> <embed href="text/scalc/00/avail_release.xhp#5.1"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">ISOWEEKNUM(Number)</paragraph> <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> <emph>Number</emph> is the internal date number.</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <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"> diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp index ec778f57de..697e2d7a0a 100644 --- a/source/text/scalc/01/func_maxifs.xhp +++ b/source/text/scalc/01/func_maxifs.xhp @@ -26,7 +26,7 @@ <h1 id="hd_id658866588665886"><variable id="maxifs_head"><link href="text/scalc/01/func_maxifs.xhp">MAXIFS</link></variable> function</h1> <paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="maxifs_des">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MAXIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> <paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum.</paragraph> diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index c5ddde101d..9b78328dd2 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -26,7 +26,7 @@ <h1 id="hd_id658866588665886"><variable id="minifs_head"><link href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable> function</h1> <paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MINIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> <paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum.</paragraph> diff --git a/source/text/scalc/01/func_minute.xhp b/source/text/scalc/01/func_minute.xhp index 1bea6607f4..ea48c1fae7 100644 --- a/source/text/scalc/01/func_minute.xhp +++ b/source/text/scalc/01/func_minute.xhp @@ -26,15 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><h2 id="hd_id3149803"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/> +<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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3148660" xml-lang="en-US">MINUTE(Number)</paragraph> <paragraph role="paragraph" id="par_id3154611" xml-lang="en-US"> <emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3148463" xml-lang="en-US"> <item type="input">=MINUTE(8.999)</item> returns 58</paragraph> <paragraph role="paragraph" id="par_id3149419" xml-lang="en-US"> diff --git a/source/text/scalc/01/func_month.xhp b/source/text/scalc/01/func_month.xhp index 9ae8ce5f5e..ba38c14918 100644 --- a/source/text/scalc/01/func_month.xhp +++ b/source/text/scalc/01/func_month.xhp @@ -26,17 +26,18 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/><h2 id="hd_id3149936"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/> +<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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3145602" xml-lang="en-US">MONTH(Number)</paragraph> <paragraph role="paragraph" id="par_id3149485" xml-lang="en-US"> <emph>Number</emph> is the internal date number.</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <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"> diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 4a5e6d7b6f..87223e0233 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -31,10 +31,10 @@ <bookmark_value>NETWORKDAYS.INTL function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NETWORKDAYS_MS" id="bm_id231020162214032558" localize="false"/> -<h2 id="hd_id231020162211573602"><variable id="networkdaysintl"><link href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></h2> +<h1 id="hd_id231020162211573602"><variable id="networkdaysintl"><link href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></h1> <paragraph id="par_id231020162213393086" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.</ahelp></paragraph> </section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id231020162249539143" role="code" xml-lang="en-US">NETWORKDAYS.INTL(StartDate; EndDate [; [ Weekend ] [; Holidays ] ])</paragraph> <paragraph id="par_id231020162249533010" role="paragraph" xml-lang="en-US"><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> <paragraph id="par_id231020162249536398" role="paragraph" xml-lang="en-US"><emph>EndDate</emph> is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation.</paragraph> @@ -42,7 +42,7 @@ <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_id231020162249554032" role="paragraph" xml-lang="en-US">How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017.</paragraph> <paragraph id="par_id231020162249551234" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days.</paragraph> <paragraph id="par_id231020162249553109" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> returns 24 workdays with Sunday only weekends.</paragraph> diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp index dc5681d14e..bda19031db 100644 --- a/source/text/scalc/01/func_networkdays.xhp +++ b/source/text/scalc/01/func_networkdays.xhp @@ -34,11 +34,11 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_NETWORKDAYS" id="bm_id3153696" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NETWORKDAYS_MS" id="bm_id3152396" localize="false"/> -<h2 id="hd_id3151254"><variable id="networkdays"><link href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></variable></h2> +<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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3145775" role="code" xml-lang="en-US">NETWORKDAYS(StartDate; EndDate [; [ Holidays ] [; Workdays ] ])</paragraph> <paragraph id="par_id3153885" role="paragraph" xml-lang="en-US"><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> <paragraph id="par_id3151110" role="paragraph" xml-lang="en-US"><emph>EndDate</emph> is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation.</paragraph> @@ -47,7 +47,7 @@ <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_id3154661" role="paragraph" xml-lang="en-US">How many workdays fall between 2001-12-15 and 2002-01-15? The start date is located in C3 and the end date in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: "2001-12-24", "2001-12-25", "2001-12-26", "2001-12-31", "2002-01-01".</paragraph> <paragraph id="par_id3147328" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS(C3;D3;F3:J3)</item> returns 17 workdays.</paragraph> <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> diff --git a/source/text/scalc/01/func_now.xhp b/source/text/scalc/01/func_now.xhp index 45227d2886..2cb7f55afa 100644 --- a/source/text/scalc/01/func_now.xhp +++ b/source/text/scalc/01/func_now.xhp @@ -26,15 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150521"><bookmark_value>NOW function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/><h2 id="hd_id3150521"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/> +<h1 id="hd_id3150521"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link> +</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/common_func.xhp#sectionsyntax"/> +<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/common_func.xhp#sectionexample"/> +<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> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_numbervalue.xhp b/source/text/scalc/01/func_numbervalue.xhp index 0367e90fa4..50524c4c4c 100644 --- a/source/text/scalc/01/func_numbervalue.xhp +++ b/source/text/scalc/01/func_numbervalue.xhp @@ -37,12 +37,12 @@ <paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">The input text may be in a locale-dependent or other bespoke format.</paragraph> <paragraph role="paragraph" id="par_id381625600941159">The output number is formatted as a valid floating point value and shown using the current cell's number format.</paragraph> <tip id="par_id351625601754290">Refer to the <link href="text/shared/01/05020300.xhp">Numbers / Format</link> help page to learn how to change the format of numbers in a cell.</tip> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id721625602228575">NUMBERVALUE(Text[; Decimal Separator[; Group Separator]])</paragraph> <paragraph xml-lang="en-US" id="par_id3154819" role="paragraph"><emph>Text</emph> is a string that contains the number to be converted.</paragraph> <paragraph xml-lang="en-US" id="par_id3154820" role="paragraph"><emph>Decimal Separator</emph> is a single character that specifies the decimal separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any decimal or group separators.</paragraph> <paragraph xml-lang="en-US" id="par_id3154821" role="paragraph"><emph>Group Separator</emph> is a string that specifies the character(s) used as the group separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any group separators. The <emph>Decimal Separator</emph> character should not be used in <emph>Group Separator</emph>.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexamples"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_examples"/> <paragraph xml-lang="en-US" id="par_id3155841" role="paragraph"> <input>=NUMBERVALUE("1.234.567,89"; ","; ".")</input> returns 1234567.89 (considering en-US locale). The function removes the two group separators and changes the decimal separator from a comma to a full stop.</paragraph> <paragraph role="paragraph" id="par_id721625603302860"> diff --git a/source/text/scalc/01/func_opt_barrier.xhp b/source/text/scalc/01/func_opt_barrier.xhp index 159892d2d9..7e4dfa1ccc 100644 --- a/source/text/scalc/01/func_opt_barrier.xhp +++ b/source/text/scalc/01/func_opt_barrier.xhp @@ -21,11 +21,11 @@ <bookmark_value>OPT_BARRIER function</bookmark_value> </bookmark> <bookmark id="bm_id941575063871993" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_BARRIER" localize="false"/> - <h2 id="hd_id241575063871994"><variable id="optbrarrierh1"><link href="text/scalc/01/func_opt_barrier.xhp">OPT_BARRIER</link></variable></h2> + <h1 id="hd_id241575063871994"><variable id="optbrarrierh1"><link href="text/scalc/01/func_opt_barrier.xhp">OPT_BARRIER</link></variable></h1> <paragraph id="par_id121575063871995" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable></paragraph> </section> <embed href="text/scalc/01/func_opt_touch.xhp#opttip"/> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id371575067051846">OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring [; Greek])</paragraph> <paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id731575073617425" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optvolat" markup="keep"/></paragraph> @@ -40,7 +40,7 @@ <paragraph role="paragraph" id="par_id11575073641257" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optinout" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id211575073645423" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optbarmon" markup="keep"/></paragraph> <embed href="text/scalc/01/func_opt_touch.xhp#optgreek"/> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id651575073773761"><input>=OPT_BARRIER(30;0.2;0.06;0;1;40;25;0;0;"c";"o";"c")</input> returns the value 0.4243.</paragraph> <paragraph role="paragraph" id="par_id401575073777593"><input>=OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;"p";"o";"c";"e")</input> returns the value 10.1585.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_opt_prob_hit.xhp b/source/text/scalc/01/func_opt_prob_hit.xhp index 97a978a05c..b18d3c1a39 100644 --- a/source/text/scalc/01/func_opt_prob_hit.xhp +++ b/source/text/scalc/01/func_opt_prob_hit.xhp @@ -21,7 +21,7 @@ <bookmark_value>OPT_PROB_HIT function</bookmark_value> </bookmark> <bookmark id="bm_id391575063908362" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_PROB_HIT" localize="false"/> - <h2 id="hd_id71575063908363"><variable id="optprobhith1"><link href="text/scalc/01/func_opt_prob_hit.xhp">OPT_PROB_HIT</link></variable></h2> + <h1 id="hd_id71575063908363"><variable id="optprobhith1"><link href="text/scalc/01/func_opt_prob_hit.xhp">OPT_PROB_HIT</link></variable></h1> <paragraph id="par_id591575063908364" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the probability that an asset hits a predetermined barrier price, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows.</paragraph> <paragraph role="paragraph" id="par_id21575078735992" xml-lang="en-US"> <image src="media/helpimg/sc_func_opt01.svg" id="img_id211575078735993" width="197.38334px" height="51.2125px"><alt xml-lang="en-US" id="alt_id401575078735994">OPT_PROB_HIT equation</alt></image> @@ -29,7 +29,7 @@ <paragraph role="paragraph" id="par_id821575074114118"><literal>µ</literal> is the asset’s percentage drift, <literal>vol</literal> is the percentage volatility of the stock, and <literal>dW</literal> is a random sample drawn from a normal distribution with a zero mean. <literal>W</literal> is a Wiener process or Brownian motion.</paragraph> </section> <embed href="text/scalc/01/func_opt_touch.xhp#opttip"/> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id211575074192954">OPT_PROB_HIT(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier)</paragraph> <paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id731575073617425" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optvolat" markup="keep"/></paragraph> @@ -38,7 +38,7 @@ <paragraph role="paragraph" id="par_id681575073426941"><variable id="optstrike"><emph>Strike</emph> is the strike price of the option and should be non-negative.</variable></paragraph> <paragraph role="paragraph" id="par_id321575073632473" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optlowbar" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id541575073636017" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optupbar" markup="keep"/></paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id971575074431070"><input>=OPT_PROB_HIT(30;0.2;0.3;1;0;40)</input> returns the value 0.6119.</paragraph> <paragraph role="paragraph" id="par_id171575074434932"><input>=OPT_PROB_HIT(70;0.3;0.1;0.5;60;0)</input> returns the value 0.4239.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_opt_prob_inmoney.xhp b/source/text/scalc/01/func_opt_prob_inmoney.xhp index 35392ebc4a..66bc374167 100644 --- a/source/text/scalc/01/func_opt_prob_inmoney.xhp +++ b/source/text/scalc/01/func_opt_prob_inmoney.xhp @@ -21,7 +21,7 @@ <bookmark_value>OPT_PROB_INMONEY function</bookmark_value> </bookmark> <bookmark id="bm_id971575063929082" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_PROB_INMONEY" localize="false"/> - <h2 id="hd_id941575063929082"><variable id="optprobinmoneyh1"><link href="text/scalc/01/func_opt_prob_inmoney.xhp">OPT_PROB_INMONEY</link></variable></h2> + <h1 id="hd_id941575063929082"><variable id="optprobinmoneyh1"><link href="text/scalc/01/func_opt_prob_inmoney.xhp">OPT_PROB_INMONEY</link></variable></h1> <paragraph id="par_id941575063929083" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the probability that an asset will end up between two barrier levels at maturity, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows.</paragraph> <paragraph role="paragraph" id="par_id21575078735992" xml-lang="en-US"> <image src="media/helpimg/sc_func_opt01.svg" id="img_id211575078735993" width="197.38334px" height="51.2125px"><alt xml-lang="en-US" id="alt_id401575078735994">OPT_PROB_INMONEY equation</alt></image> @@ -39,7 +39,7 @@ <paragraph role="paragraph" id="par_id191575075304900">The function ignores the possibility of knock-out before maturity.</paragraph> </section> <embed href="text/scalc/01/func_opt_touch.xhp#opttip"/> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id761575075027094">OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier [; Strike [; PutCall]])</paragraph> <paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id731575073617425" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optvolat" markup="keep"/></paragraph> @@ -47,7 +47,7 @@ <paragraph role="paragraph" id="par_id541575073629073" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optmaturity" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id851575079506442" localize="false"><embedvar href="text/scalc/01/func_opt_prob_hit.xhp#optstrike" markup="keep"/></paragraph> <paragraph role="paragraph" id="par_id861575082252126" localize="false"><embedvar href="text/scalc/01/func_opt_barrier.xhp#optputcall" markup="keep"/></paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id601575074993334"><input>=OPT_PROB_INMONEY(30;0.2;0.1;1;0;50)</input> returns the value 0.9844.</paragraph> <paragraph role="paragraph" id="par_id261575074997216"><input>=OPT_PROB_INMONEY(70;0.3;0.15;1;60;0;80;"p")</input> returns the value 0.3440.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_opt_touch.xhp b/source/text/scalc/01/func_opt_touch.xhp index c2f0345550..f688c4db8d 100644 --- a/source/text/scalc/01/func_opt_touch.xhp +++ b/source/text/scalc/01/func_opt_touch.xhp @@ -21,14 +21,14 @@ <bookmark_value>OPT_TOUCH function</bookmark_value> </bookmark> <bookmark id="bm_id971575062825963" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_TOUCH" localize="false"/> - <h2 id="hd_id41575062825964"><variable id="opttouchh1"><link href="text/scalc/01/func_opt_touch.xhp">OPT_TOUCH</link></variable></h2> + <h1 id="hd_id41575062825964"><variable id="opttouchh1"><link href="text/scalc/01/func_opt_touch.xhp">OPT_TOUCH</link></variable></h1> <paragraph id="par_id531575062825965" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the pricing of a touch / no-touch option, calculated using the Black-Scholes option pricing model.</ahelp></paragraph> </section> <section id="opttip"> <tip id="par_id371575066515276">For relevant background information, visit the <link href="https://en.wikipedia.org/wiki/Option_(finance)">Options (finance)</link> and <link href="https://en.wikipedia.org/wiki/Black–Scholes_model">Black-Scholes</link> model Wikipedia pages.</tip> </section> <paragraph role="paragraph" id="par_id571575080642652">Further information about touch / no-touch options may be found on many financial websites.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id151575063296819">OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring [; Greek])</paragraph> <paragraph role="paragraph" id="par_id321575066304659"><variable id="optspot"><emph>Spot</emph> is the price / value of the underlying asset and should be greater than 0.0.</variable></paragraph> @@ -70,7 +70,7 @@ </listitem> </list> </section> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id181575063666675"><input>=OPT_TOUCH(50;0.25;0.05;0;1;0;55;"d";"i";"c")</input> returns the value 0.6876.</paragraph> <paragraph role="paragraph" id="par_id811575063677250"><input>=OPT_TOUCH(80;0.2;0.05;0;0.5;60;0;"f";"o";"c";"r")</input> returns the value 15.5516.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_rawsubtract.xhp b/source/text/scalc/01/func_rawsubtract.xhp index 6d59f956f6..72fd4b050c 100644 --- a/source/text/scalc/01/func_rawsubtract.xhp +++ b/source/text/scalc/01/func_rawsubtract.xhp @@ -25,13 +25,13 @@ <h1 id="hd_2016112109231"><variable id="rawsubtracth1"><link href="text/scalc/01/func_rawsubtract.xhp">RAWSUBTRACT</link></variable></h1> <paragraph id="par_2016112109232" role="paragraph" xml-lang="en-US"><ahelp hid=".">Subtracts a set of numbers and gives the result without eliminating small roundoff errors.</ahelp></paragraph> </section> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_2016112109233" role="code" xml-lang="en-US">RAWSUBTRACT(Minuend; Subtrahend 1[; Subtrahend 2][; … ;[ Subtrahend 254]])</paragraph> <paragraph id="par_2016112109234" role="paragraph" xml-lang="en-US"><emph>Minuend</emph> is a number or a reference to a cell containing a number.</paragraph> <paragraph id="par_id241585352178687" role="paragraph" xml-lang="en-US"><emph>Subtrahend 1[; Subtrahend 2][; ... ;[ Subtrahend 254]]</emph> are numbers or references to cells containing numbers.</paragraph> <paragraph id="par_2016112109235" role="paragraph" xml-lang="en-US">The function should be called with at least two parameters.</paragraph> <paragraph role="paragraph" id="par_id271624030692893">RAWSUBTRACT() processes arguments from left to right. For example, RAWSUBTRACT(1;2;3;4) calculates 1-2-3-4 or ((1-2)-3)-4 in "natural" order.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_2016112109236" role="paragraph" xml-lang="en-US"><input>=RAWSUBTRACT(0.987654321098765, 0.9876543210987)</input> returns 6.53921361504217E-14</paragraph> <paragraph id="par_2016112109237" role="paragraph" xml-lang="en-US"><input>=RAWSUBTRACT(0.987654321098765)</input> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers. </paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_rounddown.xhp b/source/text/scalc/01/func_rounddown.xhp index 6b9e23e0ad..091d73669a 100644 --- a/source/text/scalc/01/func_rounddown.xhp +++ b/source/text/scalc/01/func_rounddown.xhp @@ -28,7 +28,7 @@ </section> <paragraph role="paragraph" id="par_id701642530512560">This function is equivalent to the <link href="text/scalc/01/func_trunc.xhp">TRUNC function</link>.</paragraph> <embed href="text/scalc/01/func_trunc.xhp#trunc_tip"/> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="paragraph" id="par_id341641927560587"> <input>ROUNDDOWN(Number [; Count])</input> </paragraph> @@ -38,7 +38,7 @@ <paragraph role="paragraph" id="par_id911641928545976">Use negative values for <emph>Count</emph> to round the integer part of the original <emph>Number</emph>. For example, -1 will round down the first integer number before the decimal separator, -2 will round down the two integer numbers before the decimal separator, and so forth.</paragraph> </section> <note id="par_id181641929609906">In %PRODUCTNAME, the <emph>Count</emph> parameter is optional, whereas in Microsoft Excel this parameter is mandatory. When an ODS file contains a call to ROUNDDOWN without the <emph>Count</emph> parameter and the file is exported to XLS or XLSX formats, the missing argument will automatically be added with value zero to maintain compatibility.</note> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id901641928192870"><input>=ROUNDDOWN(21.89)</input> returns 21. Note that this example uses the default value for <emph>Count</emph> which is 0.</paragraph> <paragraph role="paragraph" id="par_id901641928192110"><input>=ROUNDDOWN(103.37,1)</input> returns 103.3.</paragraph> <paragraph role="paragraph" id="par_id171641928456743"><input>=ROUNDDOWN(0.664,2)</input> returns 0.66.</paragraph> diff --git a/source/text/scalc/01/func_second.xhp b/source/text/scalc/01/func_second.xhp index 0baee1eed5..56246f0519 100644 --- a/source/text/scalc/01/func_second.xhp +++ b/source/text/scalc/01/func_second.xhp @@ -26,15 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/><h2 id="hd_id3159390"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/> +<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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3148407" xml-lang="en-US">SECOND(Number)</paragraph> <paragraph role="paragraph" id="par_id3155904" xml-lang="en-US"> <emph>Number</emph>, as a time value, is a decimal, for which the second is to be returned.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3153350" xml-lang="en-US"> <item type="input">=SECOND(NOW())</item> returns the current second</paragraph> <paragraph role="paragraph" id="par_id3150831" xml-lang="en-US"> diff --git a/source/text/scalc/01/func_skewp.xhp b/source/text/scalc/01/func_skewp.xhp index 5a9cf51ae4..9ed2804c3b 100644 --- a/source/text/scalc/01/func_skewp.xhp +++ b/source/text/scalc/01/func_skewp.xhp @@ -31,7 +31,7 @@ <bookmark_value>skewness;population</bookmark_value> <bookmark_value>SKEWP function</bookmark_value> </bookmark> -<h2 id="hd_id456845684568"><variable id="skewp_head"><link href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></h2> +<h1 id="hd_id456845684568"><variable id="skewp_head"><link href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></h1> <paragraph id="par_id1102201617001848" role="paragraph" xml-lang="en-US"><ahelp hid=".">Calculates the skewness of a distribution using the population of a random variable.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.1"/> diff --git a/source/text/scalc/01/func_style.xhp b/source/text/scalc/01/func_style.xhp index 2a4608ad20..e6d62ca8a8 100644 --- a/source/text/scalc/01/func_style.xhp +++ b/source/text/scalc/01/func_style.xhp @@ -22,12 +22,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id346793467934121"> <bookmark_value>STYLE function</bookmark_value> </bookmark> - <h2 id="hd_id321673374992325"><variable id="func_style_header"><link href="text/scalc/01/func_style.xhp">STYLE</link></variable> function</h2> + <h1 id="hd_id321673374992325"><variable id="func_style_header"><link href="text/scalc/01/func_style.xhp">STYLE</link></variable> function</h1> <paragraph role="paragraph" id="par_id441673375101757"><ahelp hid="HID_FUNC_VORLAGE"><variable id="func_style_desc">Applies a style to the cell containing the formula.</variable></ahelp> After a set amount of time, another style can be applied.</paragraph> </section> <paragraph role="paragraph" id="par_id681673375365338">This function always returns the numeric value 0, which allows to use it by adding the <emph>STYLE</emph> function to other functions in the same cell without changing its value.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="paragraph" id="par_id961673376106137"> <input>STYLE("Style" [; Time [; "Style2"]])</input> </paragraph> @@ -42,7 +42,7 @@ </paragraph> <note id="par_id971673376620554"><embedvar href="text/scalc/00/00000004.xhp#optional"/></note> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id491673376748686"> <input>=10+STYLE("Good",60,"Neutral")</input> </paragraph> diff --git a/source/text/scalc/01/func_sum.xhp b/source/text/scalc/01/func_sum.xhp index 4d4d902af1..a421e588c3 100644 --- a/source/text/scalc/01/func_sum.xhp +++ b/source/text/scalc/01/func_sum.xhp @@ -26,11 +26,11 @@ <paragraph id="par_id491636401806866" role="paragraph"><variable id="func_sum_desc"><ahelp hid=".">Adds a set of numbers.</ahelp></variable></paragraph> </section> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3163656" role="code" xml-lang="en-US">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/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_id3163704" role="paragraph" xml-lang="en-US"><input>=SUM(2;3;4)</input> returns 9.</paragraph> <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> diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp index 924fa85b63..f742293fff 100644 --- a/source/text/scalc/01/func_sumifs.xhp +++ b/source/text/scalc/01/func_sumifs.xhp @@ -27,7 +27,7 @@ <paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="sumifs_des">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id11655988824213" role="code" xml-lang="en-US">SUMIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> <paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum.</paragraph> diff --git a/source/text/scalc/01/func_switch.xhp b/source/text/scalc/01/func_switch.xhp index 215aaaea15..5cb72fb9f5 100644 --- a/source/text/scalc/01/func_switch.xhp +++ b/source/text/scalc/01/func_switch.xhp @@ -21,7 +21,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id571556244875552"> <bookmark_value>SWITCH function</bookmark_value> </bookmark> - <h2 id="hd_id21556242313791"><variable id="switchfunct"><link href="text/scalc/01/func_switch.xhp">SWITCH</link></variable></h2> + <h1 id="hd_id21556242313791"><variable id="switchfunct"><link href="text/scalc/01/func_switch.xhp">SWITCH</link></variable></h1> <paragraph id="par_id361556242313793" role="paragraph" xml-lang="en-US"><variable id="functionswitch"><ahelp hid=".">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.</ahelp></variable></paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> diff --git a/source/text/scalc/01/func_textjoin.xhp b/source/text/scalc/01/func_textjoin.xhp index 11d885ef34..ee01389fbb 100644 --- a/source/text/scalc/01/func_textjoin.xhp +++ b/source/text/scalc/01/func_textjoin.xhp @@ -21,7 +21,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id581556228060864"> <bookmark_value>TEXTJOIN function</bookmark_value> </bookmark> - <h2 id="hd_id551556227727946"><variable id="textjoinfunct"><link href="text/scalc/01/func_textjoin.xhp">TEXTJOIN</link></variable></h2> + <h1 id="hd_id551556227727946"><variable id="textjoinfunct"><link href="text/scalc/01/func_textjoin.xhp">TEXTJOIN</link></variable></h1> <paragraph id="par_id121556227727948" role="paragraph"><variable id="textjoinfunction"><ahelp hid=".">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable></paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> diff --git a/source/text/scalc/01/func_time.xhp b/source/text/scalc/01/func_time.xhp index 1aac1737ce..43a95dd076 100644 --- a/source/text/scalc/01/func_time.xhp +++ b/source/text/scalc/01/func_time.xhp @@ -26,16 +26,17 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154073"><bookmark_value>TIME function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEIT" id="bm_id3150289" localize="false"/><h2 id="hd_id3154073"><variable id="time"><link href="text/scalc/01/func_time.xhp">TIME</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEIT" id="bm_id3150289" localize="false"/> +<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/common_func.xhp#sectionsyntax"/> +<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> <paragraph role="paragraph" id="par_id3151346" xml-lang="en-US">Use an integer to set the <emph>Minute</emph>.</paragraph> <paragraph role="paragraph" id="par_id3151366" xml-lang="en-US">Use an integer to set the <emph>Second</emph>.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3156076" xml-lang="en-US"> <item type="input">=TIME(0;0;0)</item> returns 00:00:00</paragraph> <paragraph role="paragraph" id="par_id3156090" xml-lang="en-US"> diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp index 87bd8da08e..28f83cf9a4 100644 --- a/source/text/scalc/01/func_timevalue.xhp +++ b/source/text/scalc/01/func_timevalue.xhp @@ -33,10 +33,10 @@ <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/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id3150823" role="code" xml-lang="en-US">TIMEVALUE("Text")</paragraph> <paragraph id="par_id3152556" role="paragraph" xml-lang="en-US"><emph>Text</emph> is a valid time expression and must be entered in quotation marks.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <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> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_today.xhp b/source/text/scalc/01/func_today.xhp index e4214238d4..df71f6a9ab 100644 --- a/source/text/scalc/01/func_today.xhp +++ b/source/text/scalc/01/func_today.xhp @@ -26,15 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3145659"><bookmark_value>TODAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/><h2 id="hd_id3145659"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/> +<h1 id="hd_id3145659"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link> +</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/common_func.xhp#sectionsyntax"/> +<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/common_func.xhp#sectionexample"/> +<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> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_trunc.xhp b/source/text/scalc/01/func_trunc.xhp index 62d87efab1..6da86e12a9 100644 --- a/source/text/scalc/01/func_trunc.xhp +++ b/source/text/scalc/01/func_trunc.xhp @@ -31,7 +31,7 @@ <section id="trunc_tip"> <tip id="par_id321641927458888">The rounding method used by this function is known as <emph>rounding towards zero</emph>. The resulting number will always be smaller than or equal to the original number.</tip> </section> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="paragraph" id="par_id341641927560587"> <input>TRUNC(Number [; Count])</input> </paragraph> @@ -40,7 +40,7 @@ <paragraph role="paragraph" id="par_id861641927715672"><emph>Count:</emph> Optional parameter that defines the number of decimal places to be kept. The default value is 0 (zero).</paragraph> <paragraph role="paragraph" id="par_id911641928545976">Use negative values for <emph>Count</emph> to round the integer part of the original <emph>Number</emph>. For example, -1 will round down the first integer number before the decimal separator, -2 will round down the two integer numbers before the decimal separator, and so forth.</paragraph> </section> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id901641928192870"><input>=TRUNC(21.89)</input> returns 21. Note that this example uses the default value for <emph>Count</emph> which is 0.</paragraph> <paragraph role="paragraph" id="par_id901641928192110"><input>=TRUNC(103.37,1)</input> returns 103.3.</paragraph> <paragraph role="paragraph" id="par_id171641928456743"><input>=TRUNC(0.664,2)</input> returns 0.66.</paragraph> diff --git a/source/text/scalc/01/func_webservice.xhp b/source/text/scalc/01/func_webservice.xhp index 6ba032ab61..ca1b378463 100644 --- a/source/text/scalc/01/func_webservice.xhp +++ b/source/text/scalc/01/func_webservice.xhp @@ -21,14 +21,14 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEBSERVICE" id="bm_id3150028" localize="false"/> <section id="webservicefuncheader"> - <h2 id="hd_id3149012"><variable id="webservicefuncname"><link href="text/scalc/01/func_webservice.xhp#webservice">WEBSERVICE</link></variable></h2> + <h1 id="hd_id3149012"><variable id="webservicefuncname"><link href="text/scalc/01/func_webservice.xhp#webservice">WEBSERVICE</link></variable></h1> <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> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3154844" xml-lang="en-US">WEBSERVICE(URI)</paragraph> <paragraph role="paragraph" id="par_id3147469" xml-lang="en-US"><emph>URI: </emph> URI text of the web service.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3146142" xml-lang="en-US"><item type="input">=WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss")</item></paragraph> <paragraph role="paragraph" id="par_id3146143" xml-lang="en-US">Returns the web page content of "https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss".</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> @@ -45,11 +45,11 @@ <h2 id="hd_id2949012"><variable id="filterxmlfuncname"><link href="text/scalc/01/func_webservice.xhp#filterxml">FILTERXML</link></variable></h2> <paragraph role="paragraph" id="par_id2949893" xml-lang="en-US"><ahelp hid="HID_FUNC_FILTERXML">Apply a XPath expression to a XML document.</ahelp></paragraph> </section> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id2954844" xml-lang="en-US">FILTERXML(XML Document; XPath expression)</paragraph> <paragraph role="paragraph" id="par_id2947469" xml-lang="en-US"><emph>XML Document (required):</emph> String containing a valid XML stream.</paragraph> <paragraph role="paragraph" id="par_id2847469" xml-lang="en-US"><emph>XPath expression (required):</emph> String containing a valid XPath expression.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id2946142" xml-lang="en-US"><item type="input">=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")</item></paragraph> <paragraph role="paragraph" id="par_id2946143" xml-lang="en-US"> Returns information on the last build date of the wiki.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> @@ -67,10 +67,10 @@ <paragraph id="par_id51517132649769" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded string.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id721517134647880" xml-lang="en-US">Use this function to transform text with symbols of national alphabets (for example accented characters, non-ASCII alphabets or Asian words) to a string of URL-standard symbols.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id351517132879400" xml-lang="en-US">ENCODEURL(Text)</paragraph> <paragraph role="paragraph" id="par_id921517132924079" xml-lang="en-US"><emph>Text</emph>: String to encode to a sequence of URL-standard symbols.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id651517132994921" xml-lang="en-US">If cell A1 contains the Cyrillic text "автомобиль", <item type="input">=ENCODEURL(A1)</item> returns %D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word "автомобиль" means car in Russian).</paragraph> <paragraph role="paragraph" id="par_id991517133057478" xml-lang="en-US">If cell B1 contains the text "車", <item type="input">=ENCODEURL(B1)</item> returns %E8%BB%8A ("車" means car in Japanese).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_weekday.xhp b/source/text/scalc/01/func_weekday.xhp index f000d5fe77..486409bd82 100644 --- a/source/text/scalc/01/func_weekday.xhp +++ b/source/text/scalc/01/func_weekday.xhp @@ -33,10 +33,10 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WOCHENTAG" id="bm_id3152359" localize="false"/> -<h2 id="hd_id3154925"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></h2> +<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/common_func.xhp#sectionsyntax"/> +<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> <paragraph id="par_id3154394" role="paragraph" xml-lang="en-US"> <emph>Type</emph> is optional and determines the type of calculation. </paragraph> @@ -136,7 +136,7 @@ </caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</note> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_id3150317" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("2000-06-14")</item> returns 4 (the Type parameter is missing, therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000 was a Wednesday and therefore day number 4).</paragraph> <paragraph id="par_id3153174" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("1996-07-24";2)</item> returns 3 (the Type parameter is 2, therefore Monday is day number 1. July 24, 1996 was a Wednesday and therefore day number 3).</paragraph> <paragraph id="par_id3153525" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("1996-07-24";1)</item> returns 4 (the Type parameter is 1, therefore Sunday is day number 1. July 24, 1996 was a Wednesday and therefore day number 4).</paragraph> diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp index 99a089af3d..4ccf703381 100644 --- a/source/text/scalc/01/func_weeknum.xhp +++ b/source/text/scalc/01/func_weeknum.xhp @@ -26,8 +26,9 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/> +<h1 id="hd_id3159161"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> +</variable></h1> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value as defined in ODF OpenFormula and compatible with other spreadsheet applications.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3147220" xml-lang="en-US">Supported are two week numbering systems:</paragraph> <table id="tab_id481535122363435"> @@ -57,7 +58,7 @@ </tablerow> </table> <embed href="text/scalc/01/ODFF.xhp#odff"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM(Number [; Mode])</paragraph> <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> <emph>Number</emph> is the internal date number.</paragraph> @@ -172,7 +173,7 @@ </table> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3150704" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1</paragraph> <paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><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" 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> diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp b/source/text/scalc/01/func_weeknum_ooo.xhp index 28519d22a4..875ac05174 100644 --- a/source/text/scalc/01/func_weeknum_ooo.xhp +++ b/source/text/scalc/01/func_weeknum_ooo.xhp @@ -26,11 +26,12 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM_OOO function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEEKNUM_OOO" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEEKNUM_OOO" id="bm_id3158403" localize="false"/> +<h1 id="hd_id3159161"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link> +</variable></h1> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_WEEKNUM_OOO">WEEKNUM_OOO calculates the week number of the year for the internal date value.</ahelp></paragraph> <note id="par_idN105E4">This function exists for interoperability with %PRODUCTNAME releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function instead.</note> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM_OOO(Number; Mode)</paragraph> <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> <emph>Number</emph> is the internal date number.</paragraph> @@ -41,7 +42,7 @@ <paragraph role="paragraph" id="par_id3154281" xml-lang="en-US">any other value = Monday (ISO 8601)</paragraph> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3150704" xml-lang="en-US"><item type="input">=WEEKNUM_OOO(DATE(1995;1;1);1)</item> returns 1</paragraph> <paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM_OOO(DATE(1995;1;1);2)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/func_weeknumadd.xhp b/source/text/scalc/01/func_weeknumadd.xhp index 57f838d9a1..c74b3d1191 100644 --- a/source/text/scalc/01/func_weeknumadd.xhp +++ b/source/text/scalc/01/func_weeknumadd.xhp @@ -26,17 +26,18 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3166443"><bookmark_value>WEEKNUM_EXCEL2003 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><h2 id="hd_id3166443"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/> +<h1 id="hd_id3166443"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link> +</variable></h1> <paragraph role="paragraph" id="par_id3152945" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_WEEKNUM">The result indicates the number of the calendar week for a date.</ahelp></paragraph> <tip id="par_idN105DD">The WEEKNUM_EXCEL2003 function is designed to calculate week numbers exactly as Microsoft Excel 2003 did. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function for ODF OpenFormula and Excel 2010 compatibility, or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function when you just need ISO 8601 week numbers. In releases prior to $[officename] 5.1 WEEKNUM_EXCEL2003 was named WEEKNUM_ADD.</tip> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3153685" xml-lang="en-US">WEEKNUM_EXCEL2003(Date; ReturnType)</paragraph> <paragraph role="paragraph" id="par_id3159277" xml-lang="en-US"> <emph>Date</emph> is the date within the calendar week.</paragraph> <paragraph role="paragraph" id="par_id3154098" xml-lang="en-US"> <emph>ReturnType</emph> is 1 for week beginning on a Sunday, 2 for week beginning on a Monday.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3149973" xml-lang="en-US">In which week number does 2001-12-24 fall?</paragraph> <paragraph role="paragraph" id="par_id3149914" xml-lang="en-US"> <item type="input">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns 52.</paragraph> diff --git a/source/text/scalc/01/func_workday.intl.xhp b/source/text/scalc/01/func_workday.intl.xhp index f41a62d870..140c9b4660 100644 --- a/source/text/scalc/01/func_workday.intl.xhp +++ b/source/text/scalc/01/func_workday.intl.xhp @@ -32,17 +32,17 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WORKDAY_MS" id="bm_id231020162348499245" localize="false"/> -<h2 id="hd_id231020162348002143"><variable id="workdaysintl"><link href="text/scalc/01/func_workday.intl.xhp">WORKDAY.INTL</link></variable></h2> +<h1 id="hd_id231020162348002143"><variable id="workdaysintl"><link href="text/scalc/01/func_workday.intl.xhp">WORKDAY.INTL</link></variable></h1> <paragraph id="par_id23102016234837285" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.</ahelp></paragraph> </section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id241020160008306838" role="code" xml-lang="en-US">WORKDAY.INTL(StartDate; Days [; Weekend [; Holidays]])</paragraph> <paragraph id="par_id241020160008308885" role="paragraph" xml-lang="en-US"><emph>StartDate</emph>: is the date from when the calculation is carried out.</paragraph> <paragraph id="par_id241020160008305329" role="paragraph" xml-lang="en-US"><emph>Days</emph> is the number of workdays. Positive value for a result after the start date, negative value for a result before the start date.</paragraph> <embed href="text/scalc/01/common_func_workdaysintl.xhp#embed_workdays_intl"/> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph id="par_id241020160012177196" role="paragraph" xml-lang="en-US">What date comes 20 workdays after December 13, 2016? Enter the start date in C3 and the number of workdays in D3.</paragraph> <paragraph id="par_id241020160012178429" role="paragraph" xml-lang="en-US">The weekend parameter (number) may be left blank or defined as 1 for default weekend (non-working days) – Saturday and Sunday.</paragraph> <paragraph id="par_id241020160012172125" role="paragraph" xml-lang="en-US">Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017.</paragraph> diff --git a/source/text/scalc/01/func_workday.xhp b/source/text/scalc/01/func_workday.xhp index 95b1f9510c..bc0afd3454 100644 --- a/source/text/scalc/01/func_workday.xhp +++ b/source/text/scalc/01/func_workday.xhp @@ -27,10 +27,10 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3149012"><bookmark_value>WORKDAY function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WORKDAY" id="bm_id3150028" localize="false"/> -<h2 id="hd_id3149012"><variable id="workday"><link href="text/scalc/01/func_workday.xhp">WORKDAY</link></variable></h2> +<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/common_func.xhp#sectionsyntax"/> +<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"> <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> @@ -41,7 +41,7 @@ <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3152782" xml-lang="en-US">What date came 17 workdays after 1 December 2001? Enter the start date "2001-12-01" in C3 and the number of workdays in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: "2001-12-24", "2001-12-25", "2001-12-26", "2001-12-31", "2002-01-01".</paragraph> <paragraph role="paragraph" id="par_id3146142" xml-lang="en-US"><item type="input">=WORKDAY(C3;D3;F3:J3)</item> returns 2001-12-28. Format the serial date number as a date, for example in the format YYYY-MM-DD.<comment>UFI: fixed #i30213#</comment></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_year.xhp b/source/text/scalc/01/func_year.xhp index aa59bbc1d5..65544fe66d 100644 --- a/source/text/scalc/01/func_year.xhp +++ b/source/text/scalc/01/func_year.xhp @@ -26,15 +26,16 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3153982"><bookmark_value>YEAR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/><h2 id="hd_id3153982"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link> -</variable></h2> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/> +<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" xml-lang="en-US"><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/common_func.xhp#sectionsyntax"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3154304" xml-lang="en-US">YEAR(Number)</paragraph> <paragraph role="paragraph" id="par_id3156013" xml-lang="en-US"> <emph>Number</emph> shows the internal date value for which the year is to be returned.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3145668" xml-lang="en-US"> <item type="input">=YEAR(1)</item> returns 1899</paragraph> <paragraph role="paragraph" id="par_id3151168" xml-lang="en-US"> diff --git a/source/text/scalc/01/func_yearfrac.xhp b/source/text/scalc/01/func_yearfrac.xhp index 52cb40c5c6..ca7277fd57 100644 --- a/source/text/scalc/01/func_yearfrac.xhp +++ b/source/text/scalc/01/func_yearfrac.xhp @@ -27,10 +27,10 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148735"><bookmark_value>YEARFRAC function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/> -<h2 id="hd_id3148735"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link></variable></h2> +<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/common_func.xhp#sectionsyntax"/> +<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"> <emph>StartDate</emph> and <emph>EndDate</emph> are two date values.</paragraph> @@ -90,7 +90,7 @@ </section> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<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> <section id="relatedtopics"> |