source/text/scalc/01/05120000.xhp | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
New commits:
commit 5d3d7401d26288e8bc7eb984dcd714590bc72e82
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Thu Jan 13 01:01:29 2022 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jan 13 13:11:09 2022 +0100
tdf#91230 Improve description of Conditional Formatting
Change-Id: I536c959bec3ad94deb5e9893b956755d64f438f2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128337
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 ae62356fa..b5fac35f1 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -32,12 +32,12 @@
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog"
id="bm_id3152518" localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/@@nowidget@@"
id="bm_id3152518" localize="false"/>
<h1 id="hd_id3155132">Conditional Formatting</h1>
- <paragraph xml-lang="en-US" id="par_id3163710"
role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Choose
<emph>Conditional Formatting</emph> to define format styles depending on
certain conditions.</ahelp>
-</variable> If a style was already assigned to a cell, it remains unchanged.
The style entered here is then evaluated. There are several types of
conditional formatting that can be used.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can
enter several conditions that query the contents of cell values or formulas.
The conditions are evaluated from the first to the last. If the condition 1
matches the condition, the defined style will be used. Otherwise, condition 2
is evaluated, and its defined style is used. If this style does not match, then
the next condition is evaluated and so on.</paragraph>
- <section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#bedingte"/>
- </section>
+ <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><variable
id="bedingtetext"><ahelp hid=".">Use <emph>Conditional Formatting</emph> to
define range-based conditions that determine which cell style will be applied
to each cell in a given range based on its contents.</ahelp></variable> The
cell style corresponding to the first condition that evaluates to
<emph>true</emph> is applied. Cell styles applied through Conditional
Formatting override cell styles applied manulally using the <link
href="text/scalc/main0202.xhp" name="FormattingBar_link"><emph>Formatting
Bar</emph></link> or the <emph>Styles</emph> sidebar.</paragraph>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#bedingte"/>
+ </section>
+ <paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can
enter several conditions that query the cell values or results of formulas. The
conditions are evaluated from first to the last. If <emph>Condition 1</emph> is
true based on the current cell contents, the corresponding cell style is
applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its
corresponding style will be applied. If none of the conditions match cell
contents, then no changes are made to the cell format.</paragraph>
+ <paragraph role="paragraph" id="par_id431642031216368">Conditional
formats do no overwrite cell styles and direct formatting applied manually.
They remain saved as cell properties and are applied when the cell matches no
conditions or when you remove all conditional formats.</paragraph>
<warning id="par_id2414014">To apply conditional formatting,
AutoCalculate must be enabled. Choose <emph>Data - Calculate -
AutoCalculate</emph> (you see a check mark next to the command when
AutoCalculate is enabled).</warning>
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153189"><bookmark_value>conditional formatting;
conditions</bookmark_value>
</bookmark>
