source/text/scalc/01/ful_func.xhp | 6 +++---
source/text/scalc/01/func_aggregate.xhp | 4 ++--
source/text/scalc/01/func_averageif.xhp | 4 ++--
source/text/scalc/01/func_averageifs.xhp | 4 ++--
source/text/scalc/01/func_ceiling.xhp | 22 +++++++++++-----------
source/text/scalc/01/func_concat.xhp | 2 +-
source/text/scalc/01/func_convert.xhp | 4 ++--
source/text/scalc/01/func_countifs.xhp | 2 +-
source/text/scalc/01/func_date.xhp | 8 ++++----
source/text/scalc/01/func_datedif.xhp | 6 +++---
source/text/scalc/01/func_datevalue.xhp | 4 ++--
source/text/scalc/01/func_day.xhp | 8 ++++----
source/text/scalc/01/func_days.xhp | 8 ++++----
source/text/scalc/01/func_days360.xhp | 8 ++++----
source/text/scalc/01/func_eastersunday.xhp | 8 ++++----
source/text/scalc/01/func_edate.xhp | 9 +++++----
source/text/scalc/01/func_eomonth.xhp | 11 ++++++-----
source/text/scalc/01/func_error_type.xhp | 12 ++++++------
source/text/scalc/01/func_floor.xhp | 18 +++++++++---------
source/text/scalc/01/func_forecastetsadd.xhp | 2 +-
source/text/scalc/01/func_forecastetsmult.xhp | 2 +-
source/text/scalc/01/func_forecastetspiadd.xhp | 2 +-
source/text/scalc/01/func_forecastetspimult.xhp | 2 +-
source/text/scalc/01/func_forecastetsseason.xhp | 2 +-
source/text/scalc/01/func_forecastetsstatadd.xhp | 2 +-
source/text/scalc/01/func_forecastetsstatmult.xhp | 2 +-
source/text/scalc/01/func_fourier.xhp | 2 +-
source/text/scalc/01/func_hour.xhp | 9 +++++----
source/text/scalc/01/func_ifs.xhp | 2 +-
source/text/scalc/01/func_imcos.xhp | 4 ++--
source/text/scalc/01/func_imcosh.xhp | 4 ++--
source/text/scalc/01/func_imcot.xhp | 4 ++--
source/text/scalc/01/func_imcsc.xhp | 4 ++--
source/text/scalc/01/func_imcsch.xhp | 4 ++--
source/text/scalc/01/func_imsec.xhp | 4 ++--
source/text/scalc/01/func_imsech.xhp | 4 ++--
source/text/scalc/01/func_imsin.xhp | 4 ++--
source/text/scalc/01/func_imsinh.xhp | 4 ++--
source/text/scalc/01/func_imtan.xhp | 4 ++--
source/text/scalc/01/func_isoweeknum.xhp | 9 +++++----
source/text/scalc/01/func_maxifs.xhp | 2 +-
source/text/scalc/01/func_minifs.xhp | 2 +-
source/text/scalc/01/func_minute.xhp | 9 +++++----
source/text/scalc/01/func_month.xhp | 9 +++++----
source/text/scalc/01/func_networkdays.intl.xhp | 6 +++---
source/text/scalc/01/func_networkdays.xhp | 6 +++---
source/text/scalc/01/func_now.xhp | 9 +++++----
source/text/scalc/01/func_numbervalue.xhp | 4 ++--
source/text/scalc/01/func_opt_barrier.xhp | 6 +++---
source/text/scalc/01/func_opt_prob_hit.xhp | 6 +++---
source/text/scalc/01/func_opt_prob_inmoney.xhp | 6 +++---
source/text/scalc/01/func_opt_touch.xhp | 6 +++---
source/text/scalc/01/func_rawsubtract.xhp | 4 ++--
source/text/scalc/01/func_rounddown.xhp | 4 ++--
source/text/scalc/01/func_second.xhp | 9 +++++----
source/text/scalc/01/func_skewp.xhp | 2 +-
source/text/scalc/01/func_style.xhp | 6 +++---
source/text/scalc/01/func_sum.xhp | 4 ++--
source/text/scalc/01/func_sumifs.xhp | 2 +-
source/text/scalc/01/func_switch.xhp | 2 +-
source/text/scalc/01/func_textjoin.xhp | 2 +-
source/text/scalc/01/func_time.xhp | 9 +++++----
source/text/scalc/01/func_timevalue.xhp | 4 ++--
source/text/scalc/01/func_today.xhp | 9 +++++----
source/text/scalc/01/func_trunc.xhp | 4 ++--
source/text/scalc/01/func_webservice.xhp | 14 +++++++-------
source/text/scalc/01/func_weekday.xhp | 6 +++---
source/text/scalc/01/func_weeknum.xhp | 9 +++++----
source/text/scalc/01/func_weeknum_ooo.xhp | 9 +++++----
source/text/scalc/01/func_weeknumadd.xhp | 9 +++++----
source/text/scalc/01/func_workday.intl.xhp | 6 +++---
source/text/scalc/01/func_workday.xhp | 6 +++---
source/text/scalc/01/func_year.xhp | 9 +++++----
source/text/scalc/01/func_yearfrac.xhp | 6 +++---
74 files changed, 222 insertions(+), 208 deletions(-)
New commits:
commit 36d7838ecf321f5053559878d0b922cb384af1ad
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Feb 21 12:25:33 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Feb 22 11:08:22 2023 +0000
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.hal...@libreoffice.org>
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>
... etc. - the rest is truncated
