AllLangHelp_scalc.mk | 1
source/text/scalc/01/databar_more_options.xhp | 73 ++++++++++++++++++++++++++
2 files changed, 74 insertions(+)
New commits:
commit d3699ebe29792a680cc965f5bdaa5b8a9432b8aa
Author: Balaharipreetha Muthu <balaharipree...@gmail.com>
AuthorDate: Wed Jan 13 19:25:55 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jan 14 15:18:47 2021 +0100
tdf#139436 Add Help page for Format - Conditional - Data bar - More Options
dialog
Change-Id: I83faa2d1edb8f5cba08a7b1054bd66fc17f835b9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109129
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 4c730d72a..9ce1909e4 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -184,6 +184,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/cell_styles \
helpcontent2/source/text/scalc/01/data_form \
helpcontent2/source/text/scalc/01/data_provider \
+ helpcontent2/source/text/scalc/01/databar_more_options \
helpcontent2/source/text/scalc/01/ex_data_stat_func \
helpcontent2/source/text/scalc/01/format_graphic \
helpcontent2/source/text/scalc/01/ful_func \
diff --git a/source/text/scalc/01/databar_more_options.xhp
b/source/text/scalc/01/databar_more_options.xhp
new file mode 100644
index 000000000..f76ded414
--- /dev/null
+++ b/source/text/scalc/01/databar_more_options.xhp
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at https://mozilla.org/MPL/2.0/.
+ *
+-->
+
+<meta>
+ <topic id="Databar-MoreOptions" indexer="include" status="PUBLISH">
+ <title id="Databar-Moreoptions" xml-lang="en-US">Databar More
Options</title>
+ <filename>/text/scalc/01/databar_more_options.xhp</filename>
+ </topic>
+</meta>
+<body>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/databaroptions/DatBarOptions"
id="bm_id111610564351873" localize="false"/>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/databaroptions/@@nowidget@@"
id="bm_id121610564351873" localize="false"/>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id651610566601713">
+<bookmark_value>conditional formatting;data bar options</bookmark_value>
+<bookmark_value>data bar formatting;data bar options</bookmark_value>
+<bookmark_value>data bar options;conditional formatting</bookmark_value>
+</bookmark>
+ <h1 id="hd_id631610470827523"><variable id="databaroptions"><link
href="/text/scalc/01/databar_more_options.xhp" name="More Options for
Databar">Databar More Options</link></variable></h1>
+<h2 id="hd_id531610472930609">Entry Values</h2>
+ <h3 id="hd_id661610569199542">Minimum:</h3><paragraph role="paragraph"
id="par_id861610473146895"> Set the minimum value for which the databar does
not start filling.</paragraph>
+ <h3 id="hd_id501610569361264">Maximum:</h3><paragraph role="paragraph"
id="par_id461610473163880"> Set the maximum value for which the databar gets
completely filled.</paragraph>
+ <paragraph role="paragraph" id="par_id791610556114310">The options for
setting the minimum and maximum are:</paragraph><list type="unordered">
<listitem>
+ <paragraph id="par_id621610556164264"
role="listitem"><emph>Automatic:</emph> Automatically sets the minimum and
maximum value based on the values in the data set.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id591610556220990"
role="listitem"><emph>Minimum:</emph> Automatically sets the minimum value in
the data set as minimum.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id951610556245716"
role="listitem"><emph>Maximum:</emph> Automatically sets the maximum value in
the data set for maximum.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id901610556259738"
role="listitem"><emph>Percentile:</emph> Set the minimum and maximum as
percentile value.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id621610556295743"
role="listitem"><emph>Value:</emph> Set the minimum and maximum as a specific
value.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id331610556326466"
role="listitem"><emph>Formula:</emph> Set the minimum and maximum as a
formula.</paragraph>
+ </listitem>
+</list>
+ <h2 id="hd_id551610558198954">Bar Colors</h2>
+ <h3 id="hd_id391610569504555">Positive:</h3><paragraph role="paragraph"
id="par_id611610558381528"> Set the color for positive values. It is set to
blue be default.</paragraph>
+ <h3 id="hd_id161610569508370">Negative:</h3><paragraph role="paragraph"
id="par_id451610558525398"> Set the color for negative values. It is set to red
by default.</paragraph>
+ <h3 id="hd_id261610569510818">Fill:</h3><paragraph role="paragraph"
id="par_id221610558585001"> Choose between color and gradient to fill with
solid color or gradient.</paragraph>
+ <h2 id="hd_id711610558701623">Axis</h2>
+ <h3 id="hd_id731610569777368">Position of vertical axis:</h3><paragraph
role="paragraph" id="par_id901610558734975"> Set the position of vertical axis
in the cell.</paragraph>
+<list type="unordered">
+ <listitem>
+ <paragraph id="par_id591610558837411"
role="listitem"><emph>Automatic:</emph> Set the axis automatically</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id991610558892435"
role="listitem"><emph>Middle:</emph> Set the vertical position to be in the
middle of the cell.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id971610558965550"
role="listitem"><emph>None:</emph> Set the data bar to have no visible vertical
axis</paragraph>
+ </listitem>
+ </list>
+ <h3 id="hd_id591610569865757">Color of vertical axis:</h3><paragraph
role="paragraph" id="par_id601610560622213"> Choose the color of the vertical
axis.</paragraph>
+ <h2 id="hd_id631610560675220">Bar Lengths</h2>
+ <h3 id="hd_id651610569932338">Minimum bar length(%):</h3><paragraph
role="paragraph" id="par_id381610560706116"> Set the minimum length of the
databar in percentage with respect to the cell length.</paragraph>
+ <h3 id="hd_id151610569983195">Maximum bar length(%):</h3><paragraph
role="paragraph" id="par_id511610560783506"> Set the maximum length of the
databar in percentage with respect to the cell length. </paragraph>
+ <h2 id="hd_id821610560955981">Display bar only</h2>
+ <paragraph role="paragraph" id="par_id501610560981306">Only databar is
shown. Value becomes hidden.</paragraph>
+</body>
+</helpdocument>
\ No newline at end of file
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
