[Libreoffice-commits] help.git: source/text

[Balaharipreetha Muthu (via logerrit)]

 source/text/scalc/01/05120000.xhp |   17 +++++++++++++++++
 1 file changed, 17 insertions(+)

New commits:
commit 225876e1e8422e640c8ac8439d040376e058a097
Author:     Balaharipreetha Muthu <balaharipreetha at gmail.com>
AuthorDate: Mon Jan 4 19:06:28 2021 +0100
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Tue Jan 5 21:38:19 2021 +0100

    tdf#86525 - Add 'Data Bar' section in conditional formatting
    
    Change-Id: Ia5baaa064a49ae80732399cc93e73f8c32e4bc8c
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108697
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp
index 9b8db4727..7aae88576 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -91,6 +91,23 @@ Apply a color scale to a range consist of displaying a bicolor or tricolor gradi
       <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>
 
+<paragraph id="par_id991609782427459" role="heading" level="2">Data Bar</paragraph>
+      <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>
+      <list type="unordered">
+          <listitem>
+              <paragraph id="par_id271609781812913" role="listitem">change colors</paragraph>
+          </listitem>
+          <listitem>
+              <paragraph id="par_id921609781838551" role="listitem"> change position of vertical axis within the cell</paragraph>
+          </listitem>
+          <listitem>
+              <paragraph id="par_id631609781859971" role="listitem"> the bar's minimum and maximum length in percentage</paragraph>
+          </listitem>
+      </list>
+
 <paragraph xml-lang="en-US" id="hd_id3153709" role="heading" level="2">Icon Set</paragraph>
       <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">It is desired to plot the position of a value relative to the thresholds. The set of icons will help to indicate the thresholds and choose the type of icons. Available icon sets are:</paragraph>
 <list type="unordered">