source/text/scalc/01/05120000.xhp | 143 +++++++++++++++-------
source/text/scalc/guide/cellstyle_conditional.xhp | 4
2 files changed, 102 insertions(+), 45 deletions(-)
New commits:
commit 39a7e6c2242bbe9050f4b7a408d95f06dcfd7a02
Author: Andras Timar <ati...@suse.com>
Date: Tue Aug 27 13:05:14 2013 +0200
fdo#55618 update help for CALC Conditional Formatting
Change-Id: I409e6bd6452eda75dd0319adcd07b3f9a4603255
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index aafe0bc..b0bb03c 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -28,60 +28,117 @@
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog"
id="bm_id5008046" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog"
id="bm_id3147428" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/sc:ModalDialog:RID_SCDLG_CONDFORMAT"
id="bm_id3152518" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1"
l10n="U" oldref="1">Conditional Formatting</paragraph>
<paragraph xml-lang="en-US" id="par_id3163710" role="paragraph" l10n="U"
oldref="2"><variable id="bedingtetext"><ahelp
hid=".uno:ConditionalFormatDialog">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. You can enter three conditions that
query the contents of cell values or formulas. The conditions are evaluated
from 1 to 3. If the condition 1 matches the condition, the defined style will
be used. Otherwise, condition 2 is evaluated, and its defined style used. If
this style does not match, condition 3 is evaluated.</paragraph>
+</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_id2414014" role="warning"
l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled.
Choose Tools - Cell Contents - AutoCalculate (you see a check mark next to the
command when AutoCalculate is enabled).</paragraph>
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153189"><bookmark_value>conditional formatting;
conditions</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND1" id="bm_id3152598"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND2" id="bm_id3154490"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND3" id="bm_id3155415"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153189" role="heading" level="2" l10n="U"
- oldref="18">Condition 1/2/3</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149413" role="paragraph" l10n="U"
oldref="4"><ahelp hid="SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND3">Mark the
boxes corresponding to each condition and enter the corresponding
condition.</ahelp> To close the dialog, click <emph>OK</emph>.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_1" id="bm_id3149581"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_1" id="bm_id3153158"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_1" id="bm_id3149379"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147394" role="heading" level="2"
l10n="U" oldref="5">Cell Value / Formula</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155602" role="paragraph" l10n="U"
oldref="6"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_1">Specifies if
conditional formatting is dependent on a cell value or a formula.</ahelp> If
you select a formula as a reference, the <emph>Cell Value Condition</emph> box
is displayed to the right of the <emph>Cell value/Formula</emph> field. If the
condition is "Formula is", enter a cell reference. If the cell reference is a
value other than zero, the condition matches.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_2" id="bm_id3153712"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_2" id="bm_id3145641"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_2" id="bm_id3154755"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153709" role="heading" level="2"
l10n="U" oldref="7">Cell Value Condition</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph" l10n="U"
oldref="8"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_2">Choose a
condition for the format to be applied to the selected
cells.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_TEMPLATE"
id="bm_id3147345" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_TEMPLATE"
id="bm_id3146918" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE"
id="bm_id3149257" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156384" role="heading" level="2"
l10n="U" oldref="9">Cell Style</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145228" role="paragraph" l10n="U"
oldref="10"><ahelp
hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE">Choose the style to be
applied if the specified condition matches.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND1_NEW" id="bm_id3149267"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND2_NEW" id="bm_id3149367"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND3_NEW" id="bm_id3249267"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id0509200913175331" role="heading"
level="2" l10n="NEW">New Style</paragraph>
- <paragraph xml-lang="en-US" id="par_id0509200913175368" role="paragraph"
l10n="NEW"><ahelp hid=".">If you haven't already defined a style to be used,
you can click New Style to open the Organizer tab page of the Cell Style
dialog. Define a new style there and click OK.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND2_2" id="bm_id3150298"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND1_1" id="bm_id3147001"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND1_2" id="bm_id3154020"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND2_1" id="bm_id3159236"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND3_1" id="bm_id3149207"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND3_2" id="bm_id3158212"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3146316" role="heading" level="2" l10n="U"
- oldref="11">Parameter field</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155114" role="paragraph" l10n="U"
oldref="12"><ahelp hid="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2"
visibility="hidden">Enter a reference, value or formula.</ahelp> Enter a
reference, value or formula in the parameter field, or in both parameter fields
if you have selected a condition that requires two parameters. You can also
enter formulas containing relative references.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145257" role="paragraph" l10n="U"
oldref="13">Once the parameters have been defined, the condition is complete.
It may appear as:</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150784" role="paragraph" l10n="U"
oldref="14">Cell value is equal 0: Cell style Null value (You must have already
defined a cell style with this name before assigning it to a
condition).</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150365" role="paragraph"
l10n="CHG" oldref="15">Cell value is between $B$20 and $B$21: Cell style Result
(The corresponding value limits must already exist in cells B20 and
B21).</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152992" role="paragraph"
l10n="CHG" oldref="16">Formula is SUM($A$1:$A$5)=10: Cell style Result (The
selected cells are formatted with the Result style if the sum of the contents
in cells A1 to A5 is equal to 10).</paragraph>
- <embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
+<paragraph xml-lang="en-US" id="hd_id31531891" role="heading"
level="2">Condition</paragraph>
+ <paragraph xml-lang="en-US" id="par_id31494131" role="paragraph">You can
define as many conditions as you want.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id31494132" role="paragraph">Specify
if conditional formatting is dependent on one of the entry listed on the drop
down box:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494133" role="listitem">If
you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set
+ explanations below, depending on which visual representation the
conditional formatting should be represented.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494134" role="listitem">If
you select <emph>Cell value is</emph>:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494135"
role="listitem">Select a condition in the drop down list for the format to be
applied to the selected cells and enter the value.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494136"
role="listitem">In front of <emph>Apply Styles</emph>, select the desired style
in the list or chose <emph>New Style</emph> to create one.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494137"
role="listitem">Click the <emph>Add</emph> button to add another condition,
click the <emph>Remove</emph> button to remove a condition.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494138"
role="listitem">In the <emph>Range</emph> field, define the range of cells
concerned by the conditional formatting. Click on the <emph>Shrink</emph>
button to minimize the dialog box. Click again on the button to come back to
the dialog box once the range is selected.</paragraph>
+ </listitem>
+ </list>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id31494139" role="listitem">If you
select <emph>Formula is</emph> as a reference, enter a cell reference.
+ If the cell reference is a value other than zero, the condition
matches.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id3149413a" role="listitem">If you
select <emph>Date is</emph>, see below explanations for Date.</paragraph>
+ </listitem>
+ </list>
+
+<paragraph xml-lang="en-US" id="hd_id3147394" role="heading" level="2">Color
Scale</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155602" role="paragraph">This is
the same dialog box as if you select <emph>All cells</emph> in the first sub
menu entry <emph>Condition</emph>.
+Apply a color scale to a range consist of displaying a bicolor or tricolor
gradient on this range depending on the value of each cell. A typical example
might be an array of temperatures, lower blue colored, warmer red with a
gradient nuances to the intermediate values.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155603" role="paragraph">You must
choose the two "extreme" colors indicate the method of calculation. The
calculation of the color applied will be made in relation to: Min - Max -
Percentile - Value - Percent - Formula.</paragraph>
+ <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="http://wiki.documentfoundation.org/Faq/Calc/142";>How to apply a Color
Scale Conditional Formatting page in TDF Wiki</link>.</paragraph>
+
+<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">
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494140" role="listitem">3, 4 or
5 - arrows</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494141" role="listitem">3, 4 or
5 - gray arrows</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494142" role="listitem">3 -
flags</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494143" role="listitem">3 -
traffic lights 1 and 2 (two different designs)</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494144" role="listitem">3 -
symbols (square, triangle, circle)</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494145" role="listitem">4 -
circles from red to black</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494146" role="listitem">4 or 5 -
ratings</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494147" role="ilistitem">5 -
quarters</paragraph>
+</listitem>
+</list>
+ <paragraph xml-lang="en-US" id="par_id3153765"
role="paragraph">Conditions to display each icon can be specified relative to a
value (Value), a percentage of the number of values in the range (Percentage)
as a percentage of range values (Percentile) or formula (Formula).</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155606" role="paragraph">For a
detailed explanation and examples, please visit <link
href="http://wiki.documentfoundation.org/Faq/Calc/141";>How to use Icon Set
Conditional Formating page in TDF Wiki</link>.</paragraph>
+
+<paragraph xml-lang="en-US" id="hd_id3156384" role="heading"
level="2">Dates</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3145228" role="paragraph">This
option will apply a defined style depending on a date that you choose in the
drop down box: Today - Yesterday - Tomorrow - Last 7 days - This week - Last
week.</paragraph>
+<list type="unordered">
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494157" role="listitem">In front
of <emph>Apply Styles</emph>, select the desired style in the list or chose
<emph>New Style</emph> to create one.</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494167" role="listitem">Click
the <emph>Add</emph> button to add another condition, click the
<emph>Remove</emph> button to remove a condition.</paragraph>
+</listitem>
+<listitem>
+ <paragraph xml-lang="en-US" id="par_id31494177" role="listitem">In the
<emph>Range</emph> field, define the range of cells concerned by the
conditional formatting. Click on the <emph>Shrink</emph> button to minimize the
dialog box. Click again on the button to come back to the dialog box once the
range is selected.</paragraph>
+</listitem>
+</list>
+
+<bookmark xml-lang="en-US"
branch="hid/sc:ModalDialog:RID_SCDLG_COND_FORMAT_MANAGER" id="bm_id3152598"
localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id3153384" role="heading" level="2">Manage
Conditional Formatting</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155906" role="paragraph">This dialog
allows you to see all the conditional formatting defined in the
spreadsheet.</paragraph>
+
+ <section id="howtoget">
+ <paragraph role="paragraph" id="par_id31546818"
xml-lang="en-US">Choose <emph>Format - Conditional Formatting -
Manage</emph></paragraph>
+ </section>
+<paragraph xml-lang="en-US" id="par_id3155907" role="paragraph">The
<emph>Manage Conditional Formatting</emph> dialog box opens. Here you can add,
edit or remove one or several conditional formattings.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155908" role="paragraph">If you have
defined a conditional formatting on a cell range and you try now to define a
new conditional formatting on a part of this range, a warning message will be
displayed, asking if you want to edit the existing conditional formatting (on
the whole range) or define a new conditional formatting overlapping it (on the
selected range).</paragraph>
+
<section id="relatedtopics">
<paragraph xml-lang="en-US" id="par_idN107E1" role="paragraph"
l10n="NEW">
<embedvar
href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/>
</paragraph>
</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp
b/source/text/scalc/guide/cellstyle_conditional.xhp
index 535ce71..69510ab 100644
--- a/source/text/scalc/guide/cellstyle_conditional.xhp
+++ b/source/text/scalc/guide/cellstyle_conditional.xhp
@@ -40,7 +40,7 @@
<paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="1" l10n="U"
oldref="24"><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" l10n="U"
oldref="25">Using the menu command <emph>Format - Conditional
formatting</emph>, the dialog allows you to define up to three 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 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_id8039796" role="warning"
l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled.
Choose <emph>Tools - Cell Contents - 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" l10n="U"
oldref="26">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"
l10n="NEW">To Define the Conditions</paragraph>
@@ -142,4 +142,4 @@
<paragraph xml-lang="en-US" id="par_id3159123" role="paragraph"
l10n="U" oldref="68"><link href="text/scalc/01/05120000.xhp" name="Format -
Conditional formatting">Format - Conditional formatting</link></paragraph>
</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
