source/text/scalc/guide/cellstyle_conditional.xhp | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)
New commits:
commit 85aba709f71b6d1443db98fbacb22d9b47a71123
Author: Roman Kuznetsov <antilibreoff...@gmail.com>
AuthorDate: Sat Jan 16 20:46:59 2021 +0100
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Mon Jan 18 08:34:19 2021 +0100
tdf#139616 Updating a conditional formatting help page
Change-Id: Id34c8e5e003802635e30a7e038d9f413625f1306
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109404
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp
b/source/text/scalc/guide/cellstyle_conditional.xhp
index 0b7b0de31..c52d748d7 100644
--- a/source/text/scalc/guide/cellstyle_conditional.xhp
+++ b/source/text/scalc/guide/cellstyle_conditional.xhp
@@ -39,7 +39,7 @@
</bookmark><comment>mw deleted "formats;"</comment>
<paragraph xml-lang="en-US" id="hd_id3149263" role="heading"
level="1"><variable id="cellstyle_conditional"><link
href="text/scalc/guide/cellstyle_conditional.xhp" name="Applying Conditional
Formatting">Applying Conditional Formatting</link>
</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph">Using
the menu command <emph>Format - Conditional formatting</emph>, the dialog
allows you to define conditions per cell, which must be met in order for the
selected cells to have a particular format.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph">Using
the menu command <emph>Format - Conditional - Condition</emph>, the dialog
allows you to define conditions per cell, which must be met in order for the
selected cells to have a particular format.</paragraph>
<paragraph xml-lang="en-US" id="par_id8039796" role="warning">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).</paragraph>
<paragraph xml-lang="en-US" id="par_id3154944" role="paragraph">With
conditional formatting, you can, for example, highlight the totals that exceed
the average value of all totals. If the totals change, the formatting changes
correspondingly, without having to apply other styles manually.</paragraph>
<paragraph xml-lang="en-US" id="hd_id4480727" role="heading"
level="2">To Define the Conditions</paragraph>
@@ -48,7 +48,7 @@
<paragraph xml-lang="en-US" id="par_id3154490"
role="listitem">Select the cells to which you want to apply a conditional
style.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3155603"
role="listitem">Choose <emph>Format - Conditional Formatting</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155603"
role="listitem">Choose <emph>Format - Conditional -
Condition</emph>.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3146969"
role="listitem">Enter the condition(s) into the dialog box. The dialog is
described in detail in <link href="text/scalc/01/05120000.xhp"
name="$[officename] Help">$[officename] Help</link>, and an example is provided
below:</paragraph>
@@ -59,7 +59,7 @@
<paragraph xml-lang="en-US" id="par_id3150043" role="paragraph">You want
to give certain values in your tables particular emphasis. For example, in a
table of turnovers, you can show all the values above the average in green and
all those below the average in red. This is possible with conditional
formatting.</paragraph>
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id3155337"
role="listitem">First of all, write a table in which a few different values
occur. For your test you can create tables with any random numbers:</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155337"
role="listitem">First of all, create a table in which a few different values
occur. For your test you can create tables with any random numbers:</paragraph>
<paragraph xml-lang="en-US" id="par_id3149565" role="listitem">In
one of the cells enter the formula =RAND(), and you will obtain a random number
between 0 and 1. If you want integers of between 0 and 50, enter the formula
=INT(RAND()*50).</paragraph>
</listitem>
<listitem>
@@ -76,10 +76,10 @@
<paragraph xml-lang="en-US" id="par_id3150883"
role="listitem">Click in a blank cell and select the command <emph>Format
Cells</emph> in the context menu.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3155529" role="listitem">In
the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, select
a background color. Click <emph>OK</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155529" role="listitem">In
the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, click
the <emph>Color</emph> button and then select a background color. Click
<emph>OK</emph>.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3154484" role="listitem">In
the Styles window, click the <emph>New Style from Selection</emph> icon. Enter
the name of the new style. For this example, name the style "Above".</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154484" role="listitem">In
the Styles deck of the Sidebar, click the <emph>New Style from Selection</emph>
icon. Enter the name of the new style. For this example, name the style
"Above".</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3152889" role="listitem">To
define a second style, click again in a blank cell and proceed as described
above. Assign a different background color for the cell and assign a name (for
this example, "Below").</paragraph>
@@ -92,7 +92,7 @@
<paragraph xml-lang="en-US" id="par_id3144768" role="listitem">Set
the cursor in a blank cell, for example, J14, and choose <emph>Insert -
Function</emph>.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3156016"
role="listitem">Select the AVERAGE function. Use the mouse to select all your
random numbers. If you cannot see the entire range, because the Function Wizard
is obscuring it, you can temporarily shrink the dialog using the <link
href="text/shared/00/00000001.xhp#eingabesymbol" name="Shrink or
Maximize"><item type="menuitem">Shrink / Maximize</item></link>
icon.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3156016"
role="listitem">Select the AVERAGE function. Use the mouse to select all your
random numbers. If you cannot see the entire range, because the Function Wizard
is obscuring it, you can temporarily shrink the dialog using the <link
href="text/shared/00/00000001.xhp#eingabesymbol" name="Shrink or
Maximize"><item type="menuitem">Shrink</item></link> icon.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3153246"
role="listitem">Close the Function Wizard with <item
type="menuitem">OK</item>.</paragraph>
@@ -105,7 +105,7 @@
<paragraph xml-lang="en-US" id="par_id3150049"
role="listitem">Select all cells with the random numbers.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3153801"
role="listitem">Choose the <emph>Format - Conditional Formatting</emph> command
to open the corresponding dialog.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153801"
role="listitem">Choose the <emph>Format - Conditional - Condition</emph>
command to open the corresponding dialog.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3153013"
role="listitem">Define the condition as follows: If cell value is less than
J14, format with cell style "Below", and if cell value is greater than or equal
to J14, format with cell style "Above".</paragraph>
@@ -124,16 +124,16 @@
<paragraph xml-lang="en-US" id="par_id3150436"
role="listitem">Select the cells that are to receive this same
formatting.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3147298"
role="listitem">Choose <emph>Edit - Paste Special</emph>. The <emph>Paste
Special</emph> dialog appears.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147298"
role="listitem">Choose <emph>Edit - Paste Special - Paste Special</emph>. The
<emph>Paste Special</emph> dialog appears.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3166465" role="listitem">In
the <emph>Selection</emph> area, check only the <emph>Formats</emph> box. All
other boxes must be unchecked. Click <emph>OK</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3166465" role="listitem">In
the <emph>Paste</emph> area, check only the <emph>Formats</emph> box. All other
boxes must be unchecked. Click <emph>OK</emph>. Or you can click the
<emph>Formats only</emph> button instead.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<embed
href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/>
<embed
href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/>
- <paragraph xml-lang="en-US" id="par_id3159123" role="paragraph"><link
href="text/scalc/01/05120000.xhp" name="Format - Conditional formatting">Format
- Conditional formatting</link></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159123" role="paragraph"><link
href="text/scalc/01/05120000.xhp" name="Format - Conditional formatting">Format
- Conditional - Condition</link></paragraph>
</section>
</body>
</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
