diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-02-20 17:44:18 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-02-20 21:46:35 +0100 |
| commit | 810e6f87237633190dd9a674abe8a1177025cf1f (patch) | |
| tree | 7f54e762d5fe86788d065b4235d0c172a5737550 /source/text/scalc | |
| parent | tdf#115440 Help page for ROUNDSIG function in Calc (diff) | |
| download | help-810e6f87237633190dd9a674abe8a1177025cf1f.tar.gz help-810e6f87237633190dd9a674abe8a1177025cf1f.zip | |
Normalize heading in selected help pages
Change-Id: I42aa8fb12247645d40e29f61f235b4a22a197385
Reviewed-on: https://gerrit.libreoffice.org/50062
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/func_aggregate.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/01/func_color.xhp | 30 | ||||
| -rw-r--r-- | source/text/scalc/01/func_rawsubtract.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/01/func_sumifs.xhp | 2 |
4 files changed, 17 insertions, 19 deletions
diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index 9fba2167b2..2c68be5ab2 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 4eebeae032..7b631e9178 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 f501c1a0bd..f60e33dd2f 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 7ff426d7dd..280358d71d 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> |