diff options
| author | Balaharipreetha Muthu <balaharipreetha@gmail.com> | 2021-01-13 19:25:55 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-01-14 15:18:47 +0100 |
| commit | d3699ebe29792a680cc965f5bdaa5b8a9432b8aa (patch) | |
| tree | 78e045ef663a85171e1d218a8ae1c0046374257c | |
| parent | Fix typos (diff) | |
| download | help-d3699ebe29792a680cc965f5bdaa5b8a9432b8aa.tar.gz help-d3699ebe29792a680cc965f5bdaa5b8a9432b8aa.zip | |
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.hallot@libreoffice.org>
| -rw-r--r-- | AllLangHelp_scalc.mk | 1 | ||||
| -rw-r--r-- | source/text/scalc/01/databar_more_options.xhp | 73 |
2 files changed, 74 insertions, 0 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 4c730d72a1..9ce1909e48 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 0000000000..f76ded4142 --- /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 |