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.hallot@libreoffice.org>

2 files changed, 71 insertions, 30 deletions

diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp
index 28d08990c8..47731d53fb 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 ab288871e2..56d1f6ecca 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>