source/text/scalc/01/05120000.xhp | 3 +
source/text/scalc/01/05120400.xhp | 98 ++++++++++++++++++++++++++------------
2 files changed, 71 insertions(+), 30 deletions(-)
New commits:
commit bd2deec2da512a3630cdadfd81cb553fb158b14a
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Sep 17 19:53:12 2022 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Sep 18 12:03:44 2022 +0200
tdf#119421 Add details on conditional formatting data bars
Change-Id: I1215e909e73dfd9707299ed98f794eea689423d9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140111
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index 28d08990c..47731d53f 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -70,6 +70,9 @@
<embed href="text/scalc/01/05120200.xhp#formulais"/>
<embed href="text/scalc/01/05120300.xhp#dateis"/>
<embed href="text/scalc/01/05120400.xhp#allcells"/>
+ <embed href="text/scalc/01/05120400.xhp#colorscale"/>
+ <embed href="text/scalc/01/05120400.xhp#databar"/>
+ <embed href="text/scalc/01/05120400.xhp#iconset"/>
<bookmark xml-lang="en-US"
branch="modules/scalc/ui/conditionalentry/style" id="bm_id241662938779751"
localize="false"/>
<h2 id="hd_id431662938949798">Apply Style</h2>
<paragraph role="paragraph" id="par_id971662939043786">Select the cell
style to apply when the condition is verified. Select <emph>New Style</emph> to
open the <link href="text/scalc/01/cell_styles.xhp" name="cellstyledialog">Cell
Style dialog</link> and define the style properties.</paragraph>
diff --git a/source/text/scalc/01/05120400.xhp
b/source/text/scalc/01/05120400.xhp
index ab288871e..56d1f6ecc 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -21,31 +21,84 @@
<h1 id="hd_id861662937013389"><variable id="h1"><link
href="text/scalc/01/05120400.xhp" name="All cells">Condition - All
cells</link></variable></h1>
<paragraph role="paragraph" id="par_id31662915586650">Applies the
conditional formatting to the set of cells defined in the selected range. The
formatting is applied based on the contents of the whole range.</paragraph>
</section>
- <h2 id="hd_id3147394">Color Scale</h2>
- <paragraph xml-lang="en-US" id="par_id3155602" role="paragraph">Applies a
color scale to a range consisting of displaying a bicolor or tricolor gradient
on this range depending on the value of each cell. A typical example might be
an array of temperatures, lower blue colored, warmer red with a gradient
nuances to the intermediate values.</paragraph>
+ <section id="colorscale">
+ <h2 id="hd_id3147394"><link
href="text/scalc/01/05120400.xhp#colorscale" name="Color Scale">Color
Scale</link></h2>
+ <paragraph xml-lang="en-US" id="par_id3155602"
role="paragraph">Applies a color scale to a range consisting of displaying a
bicolor or tricolor gradient on this range depending on the value of each
cell.</paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id341663448456472">A typical example
might be an array of temperatures, lower blue colored, warmer red with a
gradient nuances to the intermediate values.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155603" role="paragraph">You must
choose the two "extreme" colors indicate the method of calculation. The
calculation of the color applied will be made in relation to: Min - Max -
Percentile - Value - Percent - Formula.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155604" role="paragraph">The
choices Min and Max are sufficient to themselves as found in the range. Other
options need to be specified by a value (Percentile, Value, Percentage) or a
cell reference or formula (Formula).</paragraph>
<paragraph xml-lang="en-US" id="par_id3155605" role="paragraph">For a
detailed explanation and examples, please visit <link
href="https://wiki.documentfoundation.org/Faq/Calc/142";>How to apply a Color
Scale Conditional Formatting page</link> in TDF Wiki.</paragraph>
- <h2 id="par_id991609782427459">Data Bar</h2>
- <paragraph role="paragraph" id="par_id41609780964157">Data bar option will
fill the cell with solid or gradient color corresponding to the numeric value
in the cell. Default is blue for positive and red for negative. </paragraph>
- <paragraph role="paragraph" id="par_id931609781970981">The calculation of
the area of fill is based on Min - Max - Percentile - Value - Percent -
Formula.</paragraph>
- <paragraph role="paragraph" id="par_id981609782003841">The choices Min and
Max are sufficient to themselves as found in the range. Other options need to
be specified by a value (Percentile, Value, Percentage) or a cell reference or
formula (Formula).</paragraph>
- <paragraph role="paragraph" id="par_id281609781729359"><emph>More
Options...</emph> opens a dialog to: </paragraph>
+ <section id="databar">
+ <h2 id="par_id991609782427459"><link
href="text/scalc/01/05120400.xhp#databar" name="Data Bar">Data Bar</link></h2>
+ <paragraph role="paragraph" id="par_id41609780964157">Data bar option
will fill the cell with solid or gradient color corresponding to the numeric
value in the cell.</paragraph>
+ </section>
+ <h3 id="hd_id631663449553346">Conditions</h3>
+ <paragraph role="paragraph" id="par_id931609781970981">The calculation of
the bar area fill is based on the conditions below:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id281663449673792"
role="listitem"><emph>Automatic</emph>: calculates using the minimum and
maximum values in the range.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id701663449697771"
role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum)
values in the range.</paragraph>
+ </listitem>
+ </list>
+ <section id="commonconditions">
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id321663440728295"
role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text
box.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id611663440697270"
role="listitem"><emph>Percentile</emph>: A percentile is each of the 99 values
which divide the sorted data in 100 equal parts, so that each part represents
1/100 of the sample population. A percentile return the value for a data series
going from the smallest to the largest value in a set of data. For P = 25, the
percentile means the first quartile. P = 50 is also the MEDIAN of the data set.
Enter the percentile value in the text box. Valid values are from 0 to
100.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id211663440834104"
role="listitem"><emph>Percent</emph>: a fixed value representing the percentage
of the minimum (maximum) of the length defined by minimum and maximum values in
the range. A minimum of 10% selects the values below 10% of the segment
[Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max].
Valid values are from 0 (zero) to 100. Do not enter a percent (%)
sign.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id961663440848168"
role="listitem"><emph>Formula</emph>: A formula expression starting with the
equal sign (=) that calculates a numeric value. Values can be numbers, dates or
time. Enter the formula expression in the text box.</paragraph>
+ </listitem>
+ </list>
+ </section>
+
+ <h3 id="par_id281609781729359">More Options</h3>
+ <paragraph role="paragraph" id="par_id501663454998977">The Data Bar dialog
opens to add details on the display of data bars.</paragraph>
+ <h4 id="hd_id221663453502042">Entry values</h4>
+ <paragraph role="paragraph" id="par_id891663453681870">Same as the
conditions above.</paragraph>
+ <h4 id="hd_id511663453530293">Bar Colors</h4>
+ <paragraph role="paragraph" id="par_id371663453564807">Choose the color
for positive and negative values.</paragraph>
+ <h4 id="hd_id891663453607961">Fill</h4>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id671663453639829"
role="listitem"><emph>Gradient</emph>: set a color scale between the color of
positive (negative) values and white.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id551663453647462"
role="listitem"><emph>Color</emph>: use the positive (negative) color for the
entire data bar, no fade out gradient.</paragraph>
+ </listitem>
+ </list>
+ <h4 id="hd_id701663453750779">Axis</h4>
+ <paragraph role="paragraph" id="par_id691663453763746">Set the position of
the vertical axis for the data bar. Values are</paragraph>
<list type="unordered">
+
<listitem>
- <paragraph id="par_id271609781812913" role="listitem">change
colors</paragraph>
+ <paragraph id="par_id381663453792294"
role="listitem"><emph>Automatic:</emph> position the vertical axis in the
middle of the maximum and minimum values.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id921609781838551" role="listitem"> change
position of vertical axis within the cell</paragraph>
+ <paragraph id="par_id791663453800602"
role="listitem"><emph>Middle:</emph> set the vertical axis in the middle of the
column.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id631609781859971" role="listitem"> the bar's
minimum and maximum length in percentage</paragraph>
+ <paragraph id="par_id461663453808288"
role="listitem"><emph>None:</emph> do not display a vertical axis.</paragraph>
</listitem>
</list>
+ <h4 id="hd_id511663453851599">Bar Lengths</h4>
+ <paragraph role="paragraph" id="par_id601663453865023">Sets the minimum
(maximum) length of the data bars, as a percentage of the column
width.</paragraph>
+ <h4 id="hd_id211663453914830">Display bars only</h4>
+ <paragraph role="paragraph" id="par_id561663453936590">Do not display
values in the cell, only the data bars.</paragraph>
- <h2 id="hd_id3153709">Icon Set</h2>
- <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">Add an
icon to the cell based on the value relative to the specified thresholds.
Several icon sets are available.</paragraph>
+ <section id="iconset">
+ <h2 id="hd_id3153709"><link href="text/scalc/01/05120400.xhp#iconset"
name="Icon Set">Icon Set</link></h2>
+ <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">Add an
icon to the cell based on the value relative to the specified thresholds.
Several icon sets are available.</paragraph>
+ </section>
<h3 id="hd_id191663440362309">Available Icon Sets</h3>
<list type="unordered">
<listitem>
@@ -165,24 +218,9 @@
</paragraph>
</listitem>
</list>
- <h3 id="hd_id621663440395987">Conditions</h3>
- <paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions
to set the thresholds for each icon can be specified as</paragraph>
-
- <list type="unordered">
- <listitem>
- <paragraph id="par_id321663440728295"
role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text
box on the left.</paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id611663440697270"
role="listitem"><emph>Percentile</emph>: A percentile is each of the 99 values
which divide the sorted data in 100 equal parts, so that each part represents
1/100 of the sample population. A percentile return the value for a data series
going from the smallest to the largest value in a set of data. For P = 25, the
percentile means the first quartile. P = 50 is also the MEDIAN of the data set.
Enter the percentile value in the text box on the left. Valid values are from 0
to 100.</paragraph>
- </listitem>
-
- <listitem>
- <paragraph id="par_id211663440834104"
role="listitem"><emph>Percent</emph>: a fixed value representing the percentage
of the minimum (maximum) of the length defined by minimum and maximum values in
the range. A minimum of 10% selects the values below 10% of the segment
[Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max].
Valid values are from 0 (zero) to 100. Do not enter a percent (%)
sign.</paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id961663440848168"
role="listitem"><emph>Formula</emph>: A formula expression starting with the
equal sign (=) that calculates the numeric value for the threshold. Values can
be numbers, dates or time. Enter the formula expression in the text box on the
left.</paragraph>
- </listitem>
- </list>
+ <h3 id="hd_id621663440395987">Conditions for thresholds</h3>
+ <paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions
to set the thresholds for each icon can be specified as follows</paragraph>
+ <embed href="text/scalc/01/05120400.xhp#commonconditions"/>
<section id="relatedtopics">
<paragraph xml-lang="en-US" id="par_id3155606" role="paragraph"><link
href="https://wiki.documentfoundation.org/Faq/Calc/141";>How to use Icon Set
Conditional Formatting page</link> in TDF Wiki.</paragraph>
</section>
