source/text/scalc/01/func_aggregate.xhp | 2 +-
source/text/scalc/01/func_color.xhp | 30 ++++++++++++++----------------
source/text/scalc/01/func_rawsubtract.xhp | 2 +-
source/text/scalc/01/func_sumifs.xhp | 2 +-
4 files changed, 17 insertions(+), 19 deletions(-)
New commits:
commit 810e6f87237633190dd9a674abe8a1177025cf1f
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Tue Feb 20 17:44:18 2018 -0300
Normalize heading in selected help pages
Change-Id: I42aa8fb12247645d40e29f61f235b4a22a197385
Reviewed-on: https://gerrit.libreoffice.org/50062
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_aggregate.xhp
b/source/text/scalc/01/func_aggregate.xhp
index 9fba2167b..2c68be5ab 100644
--- a/source/text/scalc/01/func_aggregate.xhp
+++ b/source/text/scalc/01/func_aggregate.xhp
@@ -25,7 +25,7 @@
</bookmark>
-<paragraph id="hd_id3154073" role="heading" level="2"
xml-lang="en-US"><variable id="aggregate_head"><link
href="text/scalc/01/func_aggregate.xhp">AGGREGATE</link></variable>
function</paragraph>
+<paragraph id="hd_id3154073" role="heading" level="1"
xml-lang="en-US"><variable id="aggregate_head"><link
href="text/scalc/01/func_aggregate.xhp">AGGREGATE</link></variable>
function</paragraph>
<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>
<paragraph id="par_id2209201514174453" role="note" xml-lang="en-US">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. </paragraph>
diff --git a/source/text/scalc/01/func_color.xhp
b/source/text/scalc/01/func_color.xhp
index 4eebeae03..7b631e917 100644
--- a/source/text/scalc/01/func_color.xhp
+++ b/source/text/scalc/01/func_color.xhp
@@ -21,31 +21,29 @@
<meta>
<topic id="textscalc01func_colorxml">
<title id="tit" xml-lang="en-US">COLOR function</title>
- <filename>/text/scalc/01/func_color.xhp</filename>
+ <filename>/text/scalc/01/func_color.xhp</filename>
</topic>
</meta>
<body>
- <section id="color_function">
+ <section id="func_color">
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COLOR"
id="bm_id1102201617042146" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id1102201617201921">
<bookmark_value>colors;numerical values</bookmark_value>
<bookmark_value>colors;calculating in spreadsheets</bookmark_value>
<bookmark_value>COLOR function</bookmark_value>
</bookmark>
- <section id="func_color">
- <paragraph id="hd_id456845684568" role="heading" level="2"
xml-lang="en-US"><variable id="color_head"><link
href="text/scalc/01/func_color.xhp">COLOR</link></variable></paragraph>
- <paragraph id="par_id1102201617001848" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Return a numeric value calculated by a
combination of three colors (red, green and blue) and the alpha channel, in the
RGBA color system.</ahelp> The result depends on the color system used by your
computer.</paragraph>
- </section>
- <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
- <paragraph id="par_id27421466710275" role="code"
xml-lang="en-US">COLOR(Red; Green; Blue; Alpha)</paragraph>
- <paragraph id="par_id242131304318587" role="paragraph"
xml-lang="en-US"><emph>Red, Green and Blue</emph> – required arguments. The
value for the red, green and blue components of the color. The values must be
between 0 and 255. Zero means no color component and 255 means full color
component.</paragraph>
- <paragraph id="par_id242131304315587" role="paragraph"
xml-lang="en-US"><emph>Alpha</emph> – optional argument. The value for the
alpha channel or alpha composite. Alpha is a integer value between 0 and 255.
The value of zero for alpha means the color is fully transparent, whereas a
value of 255 in the alpha channel gives a fully opaque color.</paragraph>
- <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
- <paragraph id="par_id1102201617001888" role="paragraph"
xml-lang="en-US"><item type="literal">COLOR(255;255;255;1)</item> returns
33554431</paragraph>
- <paragraph id="par_id1102201618185378" role="paragraph"
xml-lang="en-US"><item type="literal">COLOR(0;0;255;0)</item> returns 255
</paragraph>
- <paragraph id="par_id1102201618185326" role="paragraph"
xml-lang="en-US"><item type="literal">COLOR(0;0;255;255)</item> returns
4278190335 </paragraph>
- <paragraph id="par_id1102201618188326" role="paragraph"
xml-lang="en-US"><item type="literal">COLOR(0;0;400;0)</item> returns Err:502
(Invalid argument) because the blue value is greater than 255.
- </paragraph>
+ <paragraph id="hd_id456845684568" role="heading" level="1"
xml-lang="en-US"><variable id="color_head"><link
href="text/scalc/01/func_color.xhp">COLOR</link></variable></paragraph>
+ <paragraph id="par_id1102201617001848" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Return a numeric value calculated by a
combination of three colors (red, green and blue) and the alpha channel, in the
RGBA color system.</ahelp> The result depends on the color system used by your
computer.</paragraph>
</section>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+ <paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COLOR(Red;
Green; Blue; Alpha)</paragraph>
+ <paragraph id="par_id242131304318587" role="paragraph"
xml-lang="en-US"><emph>Red, Green and Blue</emph> – required arguments. The
value for the red, green and blue components of the color. The values must be
between 0 and 255. Zero means no color component and 255 means full color
component.</paragraph>
+ <paragraph id="par_id242131304315587" role="paragraph"
xml-lang="en-US"><emph>Alpha</emph> – optional argument. The value for the
alpha channel or alpha composite. Alpha is a integer value between 0 and 255.
The value of zero for alpha means the color is fully transparent, whereas a
value of 255 in the alpha channel gives a fully opaque color.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <paragraph id="par_id1102201617001888" role="paragraph"
xml-lang="en-US"><item type="input">COLOR(255;255;255;1)</item> returns
33554431</paragraph>
+ <paragraph id="par_id1102201618185378" role="paragraph"
xml-lang="en-US"><item type="input">COLOR(0;0;255;0)</item> returns 255
</paragraph>
+ <paragraph id="par_id1102201618185326" role="paragraph"
xml-lang="en-US"><item type="input">COLOR(0;0;255;255)</item> returns
4278190335 </paragraph>
+ <paragraph id="par_id1102201618188326" role="paragraph"
xml-lang="en-US"><item type="input">COLOR(0;0;400;0)</item> returns Err:502
(Invalid argument) because the blue value is greater than 255.
+ </paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_rawsubtract.xhp
b/source/text/scalc/01/func_rawsubtract.xhp
index f501c1a0b..f60e33dd2 100644
--- a/source/text/scalc/01/func_rawsubtract.xhp
+++ b/source/text/scalc/01/func_rawsubtract.xhp
@@ -22,7 +22,7 @@
<bookmark_value>RAWSUBTRACT function</bookmark_value>
</bookmark>
<section id="func_rawsubtract">
- <paragraph id="hd_2016112109231" role="heading" level="2"
xml-lang="en-US"><link
href="text/scalc/01/func_rawsubtract.xhp">RAWSUBTRACT</link></paragraph>
+ <paragraph id="hd_2016112109231" role="heading" level="1"
xml-lang="en-US"><link
href="text/scalc/01/func_rawsubtract.xhp">RAWSUBTRACT</link></paragraph>
<paragraph id="par_2016112109232" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Subtracts a set of numbers and gives the result
without eliminating small roundoff errors.</ahelp></paragraph>
</section>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
diff --git a/source/text/scalc/01/func_sumifs.xhp
b/source/text/scalc/01/func_sumifs.xhp
index 7ff426d7d..280358d71 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -23,7 +23,7 @@
<bookmark_value>SUMIFS function</bookmark_value>
<bookmark_value>sum;satisfying conditions</bookmark_value>
</bookmark>
-<paragraph id="hd_id658866588665886" role="heading" level="2"
xml-lang="en-US"><variable id="sumifs_head"><link
href="text/scalc/01/func_sumifs.xhp">SUMIFS</link></variable>
function</paragraph>
+<paragraph id="hd_id658866588665886" role="heading" level="1"
xml-lang="en-US"><variable id="sumifs_head"><link
href="text/scalc/01/func_sumifs.xhp">SUMIFS</link></variable>
function</paragraph>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="sumifs_des">Returns the sum of the values of cells in a
range that meets multiple criteria in multiple
ranges.</variable></ahelp></paragraph>
</section>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
