source/text/scalc/00/00000405.xhp | 92 +++++++++++++++++++++++++++++++++++++-
source/text/scalc/01/05120000.xhp | 8 +--
source/text/scalc/01/05120100.xhp | 4 +
source/text/scalc/01/05120300.xhp | 4 +
source/text/scalc/01/05120400.xhp | 9 +++
source/text/scalc/01/05120500.xhp | 2
6 files changed, 111 insertions(+), 8 deletions(-)
New commits:
commit 9abe3f66a8951fef89d79b5125931773778cda22
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun Sep 18 20:27:30 2022 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Sep 19 18:33:59 2022 +0200
tdf#119421 Enchancements to Conditional Format pages
Add icons and how-to-get
Change-Id: I1fb78ac737bc37745ee76d4508116edadd283938
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140130
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000405.xhp
b/source/text/scalc/00/00000405.xhp
index 13ee92fbe..35a935020 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -60,6 +60,97 @@
<paragraph role="paragraph" id="par_id3156290" xml-lang="en-US"><variable
id="fodrhin">Choose <emph>Format - Print Ranges -
Add</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US"><variable
id="fodbah">Choose <emph>Format - Print Ranges -
Clear</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3153307" xml-lang="en-US"><variable
id="fodbbe">Choose <emph>Format - Print Ranges -
Edit</emph>.</variable></paragraph>
+
+
+<section id="s_conditionalcondition">
+ <paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable
id="bedingte">Choose <menuitem>Format - Conditional -
Condition</menuitem>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id141663543112100">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <table id="tab_id771663540244129">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001663540244130" role="paragraph">
+ <image src="cmd/lc_conditionalformatdialog.svg"
id="img_id461663540244131" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id201663540244132">Icon Conditional Format - Condition</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151663540244134" role="paragraph"
xml-lang="en-US">Conditional Format</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="s_conditionalcolorscale">
+ <paragraph role="paragraph" id="par_id31663542115011"><variable
id="conditionalcolorscale">Choose <menuitem>Format - Conditional - Color
Scale</menuitem></variable></paragraph>
+ <paragraph role="paragraph" id="par_id211663543104186">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <table id="tab_id281663540719712">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id431663540719713" role="paragraph">
+ <image src="cmd/lc_colorscaleformatdialog.svg"
id="img_id551663540719714" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id381663540719715">Icon Color Scale</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id841663540719717" role="paragraph"
xml-lang="en-US">Color Scale</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="s_conditionaldatabar">
+ <paragraph role="paragraph" id="par_id491663542108169"><variable
id="conditionaldatabar">Choose <menuitem>Format - Conditional - Data
Bar</menuitem></variable></paragraph>
+ <paragraph role="paragraph" id="par_id81663543094977">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <table id="tab_id441663541161942">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id301663541161943" role="paragraph">
+ <image src="cmd/lc_databarformatdialog.svg"
id="img_id601663541161944" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id21663541161945">Icon Data Bar</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101663541161947" role="paragraph"
xml-lang="en-US">Data Bar</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="s_conditionaliconset">
+ <paragraph role="paragraph" id="par_id851663542093712"><variable
id="conditionaliconset">Choose <menuitem>Format - Conditional - Icon
Set</menuitem></variable></paragraph>
+ <paragraph role="paragraph" id="par_id501663543087343">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <table id="tab_id621663541228727">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id51663541228728" role="paragraph">
+ <image src="cmd/lc_iconsetformatdialog.svg"
id="img_id511663541228729" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id261663541228730">Icon Icon Set</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61663541228732" role="paragraph"
xml-lang="en-US">Icon Set</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="s_conditionaldate">
+ <paragraph role="paragraph" id="par_id391663542070705"><variable
id="conditionaldate">Choose <menuitem>Format - Conditional -
Date</menuitem></variable></paragraph>
+ <paragraph role="paragraph" id="par_id351663543077670">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <table id="tab_id951663541317146">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id371663541317147" role="paragraph">
+ <image src="cmd/lc_conddateformatdialog.svg"
id="img_id61663541317148" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id641663541317149">Icon Date</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121663541317151" role="paragraph"
xml-lang="en-US">Date</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="s_conditionalmanage">
+ <paragraph role="paragraph" id="par_id641663542045446"><variable
id="conditionalmanage">Choose <menuitem>Format - Conditional -
Manage</menuitem></variable></paragraph>
+</section>
+
<section id="autoformat">
<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US">Choose
<emph>Format - AutoFormat Styles</emph>.</paragraph>
<paragraph role="paragraph" id="par_id3154532" xml-lang="en-US">On the
<emph>Tools</emph> bar, click</paragraph>
@@ -77,6 +168,5 @@
</table>
</section>
</section>
-<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable
id="bedingte">Choose <emph>Format - Conditional</emph>.</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index 47731d53f..6e413af55 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -32,14 +32,14 @@
<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=".">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 manually 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>
+ <paragraph role="paragraph" id="par_id431642031216368">Conditional
formats do not 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>
<h2 id="hd_id961662926287139">Cell range</h2>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#s_conditionalcondition"/>
+ </section>
<h3 id="hd_id431662926282555">Range</h3>
<paragraph xml-lang="en-US" id="par_id31494138" role="paragraph">Defines
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>
diff --git a/source/text/scalc/01/05120100.xhp
b/source/text/scalc/01/05120100.xhp
index d31425090..6e500c3af 100644
--- a/source/text/scalc/01/05120100.xhp
+++ b/source/text/scalc/01/05120100.xhp
@@ -23,7 +23,9 @@
<h1 id="hd_id431662935550205"><variable id="h1"><link
href="text/scalc/01/05120100.xhp" name="Cell Value">Condition - Cell value
is</link></variable></h1>
<paragraph role="paragraph" id="par_id11662915615351">Applies a cell
style on the cell or cell range controlled by the condition set in the drop
down list. The formatting is applied to each cell individually and the
condition may depend on other cells values of the selected range.</paragraph>
</section>
-
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#s_conditionalcondition"/>
+ </section>
<table id="tab_id211662913907277">
<tablerow>
<tablecell>
diff --git a/source/text/scalc/01/05120300.xhp
b/source/text/scalc/01/05120300.xhp
index 451cd0995..3ed829c79 100644
--- a/source/text/scalc/01/05120300.xhp
+++ b/source/text/scalc/01/05120300.xhp
@@ -20,7 +20,9 @@
<h1 id="hd_id321662936831682"><variable id="h1"><link
href="text/scalc/01/05120300.xhp" name="Date is">Condition - Date
is</link></variable></h1>
<paragraph role="paragraph" id="par_id31662934883939">Applies the
selected style to the cell when the cell contents is formatted as date and the
condition is one of the available date interval in the dropdown
list.</paragraph>
</section>
-
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#s_conditionaldate"/>
+ </section>
<list type="unordered">
<listitem>
<paragraph id="par_id231662933568615"
role="listitem"><emph>Today</emph>: applies the cell style if the cell date
contents is today.</paragraph>
diff --git a/source/text/scalc/01/05120400.xhp
b/source/text/scalc/01/05120400.xhp
index 56d1f6ecc..ac3c4a221 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -25,6 +25,9 @@
<h2 id="hd_id3147394"><link
href="text/scalc/01/05120400.xhp#colorscale" name="Color Scale">Color
Scale</link></h2>
<paragraph xml-lang="en-US" id="par_id3155602"
role="paragraph">Applies a color scale to a range consisting of displaying a
bicolor or tricolor gradient on this range depending on the value of each
cell.</paragraph>
</section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#s_conditionalcolorscale"/>
+ </section>
<paragraph role="paragraph" id="par_id341663448456472">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>
@@ -34,6 +37,9 @@
<h2 id="par_id991609782427459"><link
href="text/scalc/01/05120400.xhp#databar" name="Data Bar">Data Bar</link></h2>
<paragraph role="paragraph" id="par_id41609780964157">Data bar option
will fill the cell with solid or gradient color corresponding to the numeric
value in the cell.</paragraph>
</section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#s_conditionaldatabar"/>
+ </section>
<h3 id="hd_id631663449553346">Conditions</h3>
<paragraph role="paragraph" id="par_id931609781970981">The calculation of
the bar area fill is based on the conditions below:</paragraph>
<list type="unordered">
@@ -99,6 +105,9 @@
<h2 id="hd_id3153709"><link href="text/scalc/01/05120400.xhp#iconset"
name="Icon Set">Icon Set</link></h2>
<paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">Add an
icon to the cell based on the value relative to the specified thresholds.
Several icon sets are available.</paragraph>
</section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#s_conditionaliconset"/>
+ </section>
<h3 id="hd_id191663440362309">Available Icon Sets</h3>
<list type="unordered">
<listitem>
diff --git a/source/text/scalc/01/05120500.xhp
b/source/text/scalc/01/05120500.xhp
index b65cf8a6f..6706c1c2f 100644
--- a/source/text/scalc/01/05120500.xhp
+++ b/source/text/scalc/01/05120500.xhp
@@ -23,7 +23,7 @@
<paragraph xml-lang="en-US" id="par_id3155906" role="paragraph">Manage
all the conditional formatting defined in the spreadsheet.</paragraph>
</section>
<section id="howtoget">
- <paragraph role="paragraph" id="par_id31546818"
xml-lang="en-US">Choose <menuitem>Format - Conditional Formatting -
Manage</menuitem>.</paragraph>
+ <embed href="text/scalc/00/00000405.xhp#s_conditionalmanage"/>
</section>
<paragraph xml-lang="en-US" id="par_id3155907" role="paragraph">The
<emph>Manage Conditional Formatting</emph> dialog is where you can add, edit or
delete one or several conditional formattings.</paragraph>
