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.hallot@libreoffice.org>

6 files changed, 111 insertions, 8 deletions

diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index 13ee92fbe6..35a9350202 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 47731d53fb..6e413af55f 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 d31425090d..6e500c3af0 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 451cd09957..3ed829c795 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 56d1f6ecca..ac3c4a2215 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 b65cf8a6f8..6706c1c2f8 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>