source/text/scalc/01/05120000.xhp | 17 +++++++++++++++++
1 file changed, 17 insertions(+)
New commits:
commit 225876e1e8422e640c8ac8439d040376e058a097
Author: Balaharipreetha Muthu <balaharipree...@gmail.com>
AuthorDate: Mon Jan 4 19:06:28 2021 +0100
Commit: Olivier Hallot <olivier.hal...@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.hal...@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">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
