[Libreoffice-commits] help.git: source/text
Olivier Hallot
olivier.hallot at libreoffice.org
Tue Feb 20 20:47:02 UTC 2018
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.hallot at 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.hallot at libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot at 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>
More information about the Libreoffice-commits
mailing list