tdf#155876 UI cmds Calc-Format menu (22)

+ Conditional formatting
+ refactoring

Change-Id: I4fcca025ec2d4091f5a7afacf1adcc41e10826b0
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160005
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

6 files changed, 197 insertions, 169 deletions

diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index 9b9d33525f..197c0f8984 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -207,9 +207,9 @@
   </table>
 </section>
 <section id="editprintrange">
-<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <paragraph role="paragraph" id="par_id3153307"><variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
-    <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
   <paragraph role="paragraph" id="par_id161700525483226">Choose <menuitem>Layout - Edit</menuitem> tab.</paragraph>
   <paragraph role="paragraph" id="par_id381700525487691">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Print Ranges - Edit</menuitem>.</paragraph>
   <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
@@ -225,8 +225,11 @@
   </table>
 </section>
 <section id="s_conditionalcondition">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <paragraph role="paragraph" id="par_id3154618"><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>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id741700682477729">Choose <menuitem>Home - Conditional - Condition</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
   <table id="tab_id771663540244129">
     <tablerow>
       <tablecell>
@@ -242,8 +245,11 @@
 </section>
 
 <section id="s_conditionalcolorscale">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <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>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id201700683098791">Choose <menuitem>Home - Conditional - Color Scale</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
   <table id="tab_id281663540719712">
     <tablerow>
       <tablecell>
@@ -259,8 +265,11 @@
 </section>
 
 <section id="s_conditionaldatabar">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <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>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id631700683863203">Choose <menuitem>Home - Conditional - Data Bar</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
   <table id="tab_id441663541161942">
     <tablerow>
       <tablecell>
@@ -276,8 +285,11 @@
 </section>
 
 <section id="s_conditionaliconset">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <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>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id951700683459372">Choose <menuitem>Home - Conditional - Icon Set</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
   <table id="tab_id621663541228727">
     <tablerow>
       <tablecell>
@@ -293,8 +305,11 @@
 </section>
 
 <section id="s_conditionaldate">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <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>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id291700683578336">Choose <menuitem>Home - Conditional - Date</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
   <table id="tab_id951663541317146">
     <tablerow>
       <tablecell>
@@ -310,7 +325,10 @@
 </section>
 
 <section id="s_conditionalmanage">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
   <paragraph role="paragraph" id="par_id641663542045446"><variable id="conditionalmanage">Choose <menuitem>Format - Conditional - Manage</menuitem></variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id801700683657730">Choose <menuitem>Home - Conditional - Manage</menuitem>.</paragraph>
 </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05120100.xhp b/source/text/scalc/01/05120100.xhp
index bd604b64b7..e76527b9d3 100644
--- a/source/text/scalc/01/05120100.xhp
+++ b/source/text/scalc/01/05120100.xhp
@@ -11,14 +11,20 @@
 
     <meta>
         <topic id="conditionalformattingcellis" indexer="include" status="PUBLISH">
-            <title id="tit" xml-lang="en-US">Conditional Formatting - Cell value is</title>
+            <title id="tit">Conditional Formatting - Cell value is</title>
             <filename>/text/scalc/01/05120100.xhp</filename>
         </topic>
     </meta>
     <body>
 
-    <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalentry/typeis" id="bm_id941662938267119" localize="false"/>
-    <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalentry/val1" id="bm_id811662938541882" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/conditionalentry/typeis" id="bm_id941662938267119" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/conditionalentry/val1" id="bm_id811662938541882" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=2" id="bm_id971700678703173" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=1" id="bm_id41700678927606" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=0" id="bm_id201700678931809" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=6" id="bm_id341700678935943" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=23" id="bm_id171700678939833" localize="false"/>
+
     <section id="cellvalueis">
         <h1 id="hd_id431662935550205"><variable id="h1"><link href="text/scalc/01/05120100.xhp">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>
@@ -30,58 +36,58 @@
     <table id="tab_id211662913907277">
         <tablerow>
             <tablecell>
-                <paragraph id="par_id181662913907279" role="tablehead" xml-lang="en-US">Condition</paragraph>
+                <paragraph id="par_id181662913907279" role="tablehead">Condition</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id941662913907280" role="tablehead" xml-lang="en-US">Description</paragraph>
+                <paragraph id="par_id941662913907280" role="tablehead">Description</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id31662913907282" role="tablecontent" xml-lang="en-US">is equal to</paragraph>
+                <paragraph id="par_id31662913907282" role="tablecontent">is equal to</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id881662913907284" role="tablecontent" xml-lang="en-US">The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values.</paragraph>
+                <paragraph id="par_id881662913907284" role="tablecontent">The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id831662914760085" role="tablecontent" xml-lang="en-US" >is not equal to</paragraph>
+                <paragraph id="par_id831662914760085" role="tablecontent">is not equal to</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id301662914760087" role="tablecontent" xml-lang="en-US" >The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values.</paragraph>
+                <paragraph id="par_id301662914760087" role="tablecontent">The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id151662920861587" role="tablecontent" xml-lang="en-US" >begins with</paragraph>
+                <paragraph id="par_id151662920861587" role="tablecontent">begins with</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id341662920861588" role="tablecontent" xml-lang="en-US" >The cell contents begins with the text or number defined in the text box on the right.</paragraph>
+                <paragraph id="par_id341662920861588" role="tablecontent">The cell contents begins with the text or number defined in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id361662922600585" role="tablecontent" xml-lang="en-US" >ends with</paragraph>
+                <paragraph id="par_id361662922600585" role="tablecontent">ends with</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id801662922600586" role="tablecontent" xml-lang="en-US" >The cell contents ends with the text or number defined in the right text box.</paragraph>
+                <paragraph id="par_id801662922600586" role="tablecontent">The cell contents ends with the text or number defined in the right text box.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id151662922939292" role="tablecontent" xml-lang="en-US" >contains</paragraph>
+                <paragraph id="par_id151662922939292" role="tablecontent">contains</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id251662922939293" role="tablecontent" xml-lang="en-US" >The cell contents contains the text or number defined in the right text box.</paragraph>
+                <paragraph id="par_id251662922939293" role="tablecontent">The cell contents contains the text or number defined in the right text box.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id291662923021542" role="tablecontent" xml-lang="en-US" >does not contain</paragraph>
+                <paragraph id="par_id291662923021542" role="tablecontent">does not contain</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id541662923021543" role="tablecontent" xml-lang="en-US" >The cell content does not contain the text or number defined in the text box on the right.</paragraph>
+                <paragraph id="par_id541662923021543" role="tablecontent">The cell content does not contain the text or number defined in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
     </table>
@@ -99,133 +105,133 @@
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id271662914239763" role="tablecontent" xml-lang="en-US" >is less than</paragraph>
+                <paragraph id="par_id271662914239763" role="tablecontent">is less than</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id501662914239764" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id501662914239764" role="tablecontent">The cell value is strictly less than the user defined value in the text box in the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id701662914433053" role="tablecontent" xml-lang="en-US" >is greater than</paragraph>
+                <paragraph id="par_id701662914433053" role="tablecontent">is greater than</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id461662914433054" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id461662914433054" role="tablecontent">The cell value is strictly greater than the user defined value in the text box in the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id421662914480517" role="tablecontent" xml-lang="en-US" >is less than or equal to</paragraph>
+                <paragraph id="par_id421662914480517" role="tablecontent">is less than or equal to</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id631662914480518" role="tablecontent" xml-lang="en-US" >The cell value is less than or equal to the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id631662914480518" role="tablecontent">The cell value is less than or equal to the user defined value in the text box in the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id651662914713102" role="tablecontent" xml-lang="en-US" >is greater than or equal to</paragraph>
+                <paragraph id="par_id651662914713102" role="tablecontent">is greater than or equal to</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id251662914713103" role="tablecontent" xml-lang="en-US" >The cell value is greater than or equal to the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id251662914713103" role="tablecontent">The cell value is greater than or equal to the user defined value in the text box in the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id81662914901503" role="tablecontent" xml-lang="en-US" >is between</paragraph>
+                <paragraph id="par_id81662914901503" role="tablecontent">is between</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id21662914901504" role="tablecontent" xml-lang="en-US" >The cell value is between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves.</paragraph>
+                <paragraph id="par_id21662914901504" role="tablecontent">The cell value is between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id411662915178872" role="tablecontent" xml-lang="en-US" >is not between</paragraph>
+                <paragraph id="par_id411662915178872" role="tablecontent">is not between</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id861662915178873" role="tablecontent" xml-lang="en-US" >The cell value is not between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves.</paragraph>
+                <paragraph id="par_id861662915178873" role="tablecontent">The cell value is not between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id731662915275926" role="tablecontent" xml-lang="en-US" >is duplicate</paragraph>
+                <paragraph id="par_id731662915275926" role="tablecontent">is duplicate</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id881662915275927" role="tablecontent" xml-lang="en-US" >The cell and at least one other cell in the range have equal contents.</paragraph>
+                <paragraph id="par_id881662915275927" role="tablecontent">The cell and at least one other cell in the range have equal contents.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id381662915857686" role="tablecontent" xml-lang="en-US" >is not duplicate</paragraph>
+                <paragraph id="par_id381662915857686" role="tablecontent">is not duplicate</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id341662915857687" role="tablecontent" xml-lang="en-US" >The cell contents is unique in the range.</paragraph>
+                <paragraph id="par_id341662915857687" role="tablecontent">The cell contents is unique in the range.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id1001662915996409" role="tablecontent" xml-lang="en-US" >is in top N  elements</paragraph>
+                <paragraph id="par_id1001662915996409" role="tablecontent">is in top N  elements</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id571662915996410" role="tablecontent" xml-lang="en-US" >The cell value is between the maximum value in the range and the N<sup>th</sup> greater element of the same. Enter the value of N in the text box on the right.</paragraph>
+                <paragraph id="par_id571662915996410" role="tablecontent">The cell value is between the maximum value in the range and the N<sup>th</sup> greater element of the same. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id341662916338175" role="tablecontent" xml-lang="en-US" >is in bottom N  elements</paragraph>
+                <paragraph id="par_id341662916338175" role="tablecontent">is in bottom N  elements</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id11662916338177" role="tablecontent" xml-lang="en-US" >The cell value is between the minimum value in the range and the N<sup>th</sup> lower element of the same. Enter the value of N in the text box on the right.</paragraph>
+                <paragraph id="par_id11662916338177" role="tablecontent">The cell value is between the minimum value in the range and the N<sup>th</sup> lower element of the same. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id181662916407095" role="tablecontent" xml-lang="en-US" >is in top N percent</paragraph>
+                <paragraph id="par_id181662916407095" role="tablecontent">is in top N percent</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id911662916407097" role="tablecontent" xml-lang="en-US" >The <emph>cell range index value is in the top N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 last cells of the range. Enter the value of N in the text box on the right.</paragraph>
+                <paragraph id="par_id911662916407097" role="tablecontent">The <emph>cell range index value is in the top N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 last cells of the range. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id421662917285432" role="tablecontent" xml-lang="en-US" >is in bottom N percent</paragraph>
+                <paragraph id="par_id421662917285432" role="tablecontent">is in bottom N percent</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id111662917285433" role="tablecontent" xml-lang="en-US" >The <emph>cell range index value is in the bottom N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 first cells of the range. Enter the value of N in the text box on the right.</paragraph>
+                <paragraph id="par_id111662917285433" role="tablecontent">The <emph>cell range index value is in the bottom N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 first cells of the range. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id861662917382735" role="tablecontent" xml-lang="en-US" >is above average</paragraph>
+                <paragraph id="par_id861662917382735" role="tablecontent">is above average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id811662917382736" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the average of the cell range values.</paragraph>
+                <paragraph id="par_id811662917382736" role="tablecontent">The cell value is strictly greater than the average of the cell range values.</paragraph>
                 <paragraph role="paragraph" id="par_id701665407334603"><variable id="seenotebelow">See note below.</variable></paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id421662919561954" role="tablecontent" xml-lang="en-US" >is below average</paragraph>
+                <paragraph id="par_id421662919561954" role="tablecontent">is below average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id661662919561956" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the average of the cell range values.</paragraph>
+                <paragraph id="par_id661662919561956" role="tablecontent">The cell value is strictly less than the average of the cell range values.</paragraph>
                 <paragraph role="paragraph" id="par_id871665407380004" localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow" markup="ignore"/></paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id831662919693474" role="tablecontent" xml-lang="en-US" >is above or equal average</paragraph>
+                <paragraph id="par_id831662919693474" role="tablecontent">is above or equal average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id71662919693475" role="tablecontent" xml-lang="en-US" >The cell value is greater or equal than the average of the cell range values.</paragraph>
+                <paragraph id="par_id71662919693475" role="tablecontent">The cell value is greater or equal than the average of the cell range values.</paragraph>
                 <paragraph role="paragraph" id="par_id871665407380005" localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow" markup="ignore"/></paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id521662919771410" role="tablecontent" xml-lang="en-US" >is below or equal average</paragraph>
+                <paragraph id="par_id521662919771410" role="tablecontent">is below or equal average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id131662919771411" role="tablecontent" xml-lang="en-US" >The cell value is less or equal than the average of the cell range values.</paragraph>
+                <paragraph id="par_id131662919771411" role="tablecontent">The cell value is less or equal than the average of the cell range values.</paragraph>
                 <paragraph role="paragraph" id="par_id871665407380006" localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow" markup="ignore"/></paragraph>
 
             </tablecell>
@@ -245,18 +251,18 @@
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id451662919849856" role="tablecontent" xml-lang="en-US" >is error</paragraph>
+                <paragraph id="par_id451662919849856" role="tablecontent">is error</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id911662919849857" role="tablecontent" xml-lang="en-US" >The cell is in the error condition defined in the text box on the right. See <link href="text/scalc/05/02140000.xhp">List of Calc errors</link>.</paragraph>
+                <paragraph id="par_id911662919849857" role="tablecontent">The cell is in the error condition defined in the text box on the right. See <link href="text/scalc/05/02140000.xhp">List of Calc errors</link>.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id961662920774180" role="tablecontent" xml-lang="en-US" >is not error</paragraph>
+                <paragraph id="par_id961662920774180" role="tablecontent">is not error</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id381662920774181" role="tablecontent" xml-lang="en-US" >The cell is not in the error condition defined in the text box on the right. See <link href="text/scalc/05/02140000.xhp">List of Calc errors</link></paragraph>
+                <paragraph id="par_id381662920774181" role="tablecontent">The cell is not in the error condition defined in the text box on the right. See <link href="text/scalc/05/02140000.xhp">List of Calc errors</link></paragraph>
             </tablecell>
         </tablerow>
     </table>
diff --git a/source/text/scalc/01/05120300.xhp b/source/text/scalc/01/05120300.xhp
index b51d3f15a0..41b9346c8b 100644
--- a/source/text/scalc/01/05120300.xhp
+++ b/source/text/scalc/01/05120300.xhp
@@ -16,6 +16,7 @@
         </topic>
     </meta>
     <body>
+    <bookmark branch="hid/.uno:CondDateFormatDialog" id="bm_id811700684279931" localize="false"/>
     <section id="dateis">
         <h1 id="hd_id321662936831682"><variable id="h1"><link href="text/scalc/01/05120300.xhp">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>
diff --git a/source/text/scalc/01/05120400.xhp b/source/text/scalc/01/05120400.xhp
index 660b3d46c5..9e6cddf417 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -11,19 +11,19 @@
 
     <meta>
         <topic id="conditionalformattingallcells" indexer="include" status="PUBLISH">
-            <title id="tit" xml-lang="en-US">Conditional Formatting - All cells</title>
+            <title id="tit">Conditional Formatting - All cells</title>
             <filename>/text/scalc/01/05120400.xhp</filename>
         </topic>
     </meta>
     <body>
-
+    <bookmark branch="hid/.uno:ColorScaleFormatDialog" id="bm_id631700682986631" localize="false"/>
     <section id="allcells">
         <h1 id="hd_id861662937013389"><variable id="h1"><link href="text/scalc/01/05120400.xhp">Condition - All cells</link></variable></h1>
         <paragraph role="paragraph" id="par_id31662915586650">Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range.</paragraph>
     </section>
     <section id="colorscale">
         <h2 id="hd_id3147394"><link href="text/scalc/01/05120400.xhp#colorscale">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>
+        <paragraph 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"/>
@@ -33,26 +33,27 @@
     <paragraph role="paragraph" id="par_id231663598294535">The calculation of the color scale depends on 2 or 3 conditions, defined as follows:</paragraph>
     <list type="unordered">
         <listitem>
-            <paragraph id="par_id701864449697771"  role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
+            <paragraph id="par_id701864449697771" role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
         </listitem>
     </list>
     <section id="commonconditions">
         <list type="unordered">
         <listitem>
-            <paragraph id="par_id321663440728295"  role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text box.</paragraph>
+            <paragraph id="par_id321663440728295" role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text box.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id611663440697270"  role="listitem"><emph>Percentile</emph>: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.</paragraph>
+            <paragraph id="par_id611663440697270" role="listitem"><emph>Percentile</emph>: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id211663440834104"  role="listitem"><emph>Percent</emph>: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.</paragraph>
+            <paragraph id="par_id211663440834104" role="listitem"><emph>Percent</emph>: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id961663440848168"  role="listitem"><emph>Formula</emph>: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.</paragraph>
+            <paragraph id="par_id961663440848168" role="listitem"><emph>Formula</emph>: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.</paragraph>
         </listitem>
         </list>
     </section>
     <embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
+    <bookmark branch="hid/.uno:DataBarFormatDialog" id="bm_id631700683284747" localize="false"/>
     <section id="databar">
         <h2 id="par_id991609782427459"><link href="text/scalc/01/05120400.xhp#databar">Data Bar</link></h2>
         <paragraph role="paragraph" id="par_id41609780964157">Data bar option fills the cell with solid or gradient color corresponding to the numeric value in the cell.</paragraph>
@@ -64,10 +65,10 @@
     <paragraph role="paragraph" id="par_id931609781970981">The calculation of the bar area fill is based on the conditions below:</paragraph>
     <list type="unordered">
         <listitem>
-            <paragraph id="par_id281663449673792"  role="listitem"><emph>Automatic</emph>: calculates using the minimum and maximum values in the range.</paragraph>
+            <paragraph id="par_id281663449673792" role="listitem"><emph>Automatic</emph>: calculates using the minimum and maximum values in the range.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id701663449697771"  role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
+            <paragraph id="par_id701663449697771" role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
         </listitem>
     </list>
     <embed href="text/scalc/01/05120400.xhp#commonconditions"/>
@@ -80,10 +81,10 @@
     <h4 id="hd_id891663453607961">Fill</h4>
     <list type="unordered">
         <listitem>
-            <paragraph id="par_id671663453639829"  role="listitem"><emph>Gradient</emph>: set a color scale between the color of positive (negative) values and white.</paragraph>
+            <paragraph id="par_id671663453639829" role="listitem"><emph>Gradient</emph>: set a color scale between the color of positive (negative) values and white.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id551663453647462"  role="listitem"><emph>Color</emph>: use the positive (negative) color for the entire data bar, no fade out gradient.</paragraph>
+            <paragraph id="par_id551663453647462" role="listitem"><emph>Color</emph>: use the positive (negative) color for the entire data bar, no fade out gradient.</paragraph>
         </listitem>
     </list>
     <h4 id="hd_id701663453750779">Axis</h4>
@@ -91,13 +92,13 @@
     <list type="unordered">
 
         <listitem>
-            <paragraph id="par_id381663453792294"  role="listitem"><emph>Automatic:</emph> position the vertical axis in the middle of the maximum and minimum values.</paragraph>
+            <paragraph id="par_id381663453792294" role="listitem"><emph>Automatic:</emph> position the vertical axis in the middle of the maximum and minimum values.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id791663453800602"  role="listitem"><emph>Middle:</emph> set the vertical axis in the middle of the column.</paragraph>
+            <paragraph id="par_id791663453800602" role="listitem"><emph>Middle:</emph> set the vertical axis in the middle of the column.</paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id461663453808288"  role="listitem"><emph>None:</emph> do not display a vertical axis.</paragraph>
+            <paragraph id="par_id461663453808288" role="listitem"><emph>None:</emph> do not display a vertical axis.</paragraph>
         </listitem>
     </list>
     <h4 id="hd_id511663453851599">Bar Lengths</h4>
@@ -105,9 +106,10 @@
     <h4 id="hd_id211663453914830">Display bars only</h4>
     <paragraph role="paragraph" id="par_id561663453936590">Do not display values in the cell, only the data bars.</paragraph>
     <embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
+    <bookmark branch="hid/.uno:IconSetFormatDialog" id="bm_id61700683386598" localize="false"/>
     <section id="iconset">
         <h2 id="hd_id3153709"><link href="text/scalc/01/05120400.xhp#iconset">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>
+        <paragraph 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"/>
@@ -115,129 +117,129 @@
     <h3 id="hd_id191663440362309">Available Icon Sets</h3>
     <list type="unordered">
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494140" role="listitem">3, 4 or 5 - arrows</paragraph>
-            <paragraph role="paragraph" id="par_id91663429174806" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-colorarrows-up.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id81663429174808">Color arrow up</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id81663529174808">Color arrow slightly up</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-colorarrows-same.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id81663529174808">Color arrow same</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id81663729174808">Color arrow slightly down</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-colorarrows-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id81663329174808">Color arrow down</alt></image>
+            <paragraph id="par_id31494140" role="listitem">3, 4 or 5 - arrows</paragraph>
+            <paragraph role="paragraph" id="par_id91663429174806">
+                <image src="media/icon-themes/sc/res/icon-set-colorarrows-up.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id81663429174808">Color arrow up</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id81663529174808">Color arrow slightly up</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-colorarrows-same.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id81663529174808">Color arrow same</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id81663729174808">Color arrow slightly down</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-colorarrows-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id81663329174808">Color arrow down</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494141" role="listitem">3, 4 or 5 - gray arrows</paragraph>
-            <paragraph role="paragraph" id="par_id91661429174806" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-grayarrows-up.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Gray arrow up</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Gray arrow slightly up</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-grayarrows-same.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Gray arrow same</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663729174808">Gray arrow slightly down</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-grayarrows-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663329174808">Gray arrow down</alt></image>
+            <paragraph id="par_id31494141" role="listitem">3, 4 or 5 - gray arrows</paragraph>
+            <paragraph role="paragraph" id="par_id91661429174806">
+                <image src="media/icon-themes/sc/res/icon-set-grayarrows-up.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Gray arrow up</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Gray arrow slightly up</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-grayarrows-same.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Gray arrow same</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663729174808">Gray arrow slightly down</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-grayarrows-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663329174808">Gray arrow down</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494142" role="listitem">3 - flags</paragraph>
-            <paragraph role="paragraph" id="par_id101663433624185" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-flags-yellow.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Yellow flag</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-flags-red.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Red flag</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-flags-green.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Green flag</alt></image>
+            <paragraph id="par_id31494142" role="listitem">3 - flags</paragraph>
+            <paragraph role="paragraph" id="par_id101663433624185">
+                <image src="media/icon-themes/sc/res/icon-set-flags-yellow.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Yellow flag</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-flags-red.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Red flag</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-flags-green.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Green flag</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494143" role="listitem">3 - traffic lights 1 and 2 (two different designs)</paragraph>
-            <paragraph role="paragraph" id="par_id721663433917655" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-circles1-yellow.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Yellow traffic light 1</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-circles1-red.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Red traffic light 1</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-circles1-green.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Green traffic light 1</alt></image>
+            <paragraph id="par_id31494143" role="listitem">3 - traffic lights 1 and 2 (two different designs)</paragraph>
+            <paragraph role="paragraph" id="par_id721663433917655">
+                <image src="media/icon-themes/sc/res/icon-set-circles1-yellow.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Yellow traffic light 1</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-circles1-red.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Red traffic light 1</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-circles1-green.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Green traffic light 1</alt></image>
             </paragraph>
-            <paragraph role="paragraph" id="par_id501663433925207" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Yellow traffic light 2</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-trafficlights-red.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Red traffic light 2</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-trafficlights-green.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Green traffic light 2</alt></image>
+            <paragraph role="paragraph" id="par_id501663433925207">
+                <image src="media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Yellow traffic light 2</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-trafficlights-red.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Red traffic light 2</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-trafficlights-green.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Green traffic light 2</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id701663438522480"  role="listitem">3 - Smileys 1 and 2</paragraph>
+            <paragraph id="par_id701663438522480" role="listitem">3 - Smileys 1 and 2</paragraph>
             <paragraph role="paragraph" id="par_id991663438568052">
-                <image src="media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Yellow positive smiley</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Yellow neutral smiley</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Yellow negative smiley</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Yellow positive smiley</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Yellow neutral smiley</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Yellow negative smiley</alt></image>
             </paragraph>
-            <paragraph role="paragraph" id="par_id991663438966721" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-positive-green-smilie.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Green positive smiley</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Yellow neutral smiley</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-negative-red-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Red negative smiley</alt></image>
+            <paragraph role="paragraph" id="par_id991663438966721">
+                <image src="media/icon-themes/sc/res/icon-set-positive-green-smilie.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Green positive smiley</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Yellow neutral smiley</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-negative-red-smilie.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Red negative smiley</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494144" role="listitem">3 - symbols </paragraph>
-            <paragraph role="paragraph" id="par_id421663434453517" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-shapes-triangle.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Shape triangle</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-shapes-diamond.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Shape diamond</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-shapes-circle.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Shape circle</alt></image>
+            <paragraph id="par_id31494144" role="listitem">3 - symbols </paragraph>
+            <paragraph role="paragraph" id="par_id421663434453517">
+                <image src="media/icon-themes/sc/res/icon-set-shapes-triangle.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Shape triangle</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-shapes-diamond.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Shape diamond</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-shapes-circle.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Shape circle</alt></image>
             </paragraph>
-            <paragraph role="paragraph" id="par_id961663439450424" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Exclamation mark</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-symbols1-cross.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Cross</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-symbols1-check.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Check mark</alt></image>
+            <paragraph role="paragraph" id="par_id961663439450424">
+                <image src="media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Exclamation mark</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-symbols1-cross.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Cross</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-symbols1-check.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Check mark</alt></image>
             </paragraph>
-            <paragraph role="paragraph" id="par_id1001663439805133" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-stars-empty.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Empty star</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-stars-half.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Half star</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-stars-full.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Full star</alt></image>
+            <paragraph role="paragraph" id="par_id1001663439805133">
+                <image src="media/icon-themes/sc/res/icon-set-stars-empty.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Empty star</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-stars-half.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Half star</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-stars-full.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Full star</alt></image>
             </paragraph>
-            <paragraph role="paragraph" id="par_id171663440020964" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-triangles-up.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Triangle up</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-triangles-same.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Same</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-triangles-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663529174808">Triangle down</alt></image>
+            <paragraph role="paragraph" id="par_id171663440020964">
+                <image src="media/icon-themes/sc/res/icon-set-triangles-up.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Triangle up</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-triangles-same.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Same</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-triangles-down.svg" id="img_id261663429176807" width="1cm" height="1cm"><alt id="alt_id91663529174808">Triangle down</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494145" role="listitem">4 - circles from red to black</paragraph>
-            <paragraph role="paragraph" id="par_id481663434995022" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-circles2-dark-red.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Dark red</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-circles2-light-red.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Light red</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-circles2-light-gray.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Light gray</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Dark gray</alt></image>
+            <paragraph id="par_id31494145" role="listitem">4 - circles from red to black</paragraph>
+            <paragraph role="paragraph" id="par_id481663434995022">
+                <image src="media/icon-themes/sc/res/icon-set-circles2-dark-red.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Dark red</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-circles2-light-red.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Light red</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-circles2-light-gray.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Light gray</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Dark gray</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494146" role="listitem">4 or 5 - ratings</paragraph>
-            <paragraph role="paragraph" id="par_id631663435728155" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-bars-empty.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Empty bars</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-bars-one-quarter.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">One quarters bars</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-bars-half.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Half bars</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-bars-three-quarters.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Three quarters bars</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-bars-full.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Full bars</alt></image>
+            <paragraph id="par_id31494146" role="listitem">4 or 5 - ratings</paragraph>
+            <paragraph role="paragraph" id="par_id631663435728155">
+                <image src="media/icon-themes/sc/res/icon-set-bars-empty.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Empty bars</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-bars-one-quarter.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">One quarters bars</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-bars-half.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Half bars</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-bars-three-quarters.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Three quarters bars</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-bars-full.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Full bars</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph xml-lang="en-US" id="par_id31494147" role="ilistitem">5 - quarters</paragraph>
-            <paragraph role="paragraph" id="par_id741663436015689" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-pies-empty.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Empty</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-pies-one-quarter.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">One quarter</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-pies-half.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Half</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-pies-three-quarters.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Three quarters</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-pies-full.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Full</alt></image>
+            <paragraph id="par_id31494147" role="ilistitem">5 - quarters</paragraph>
+            <paragraph role="paragraph" id="par_id741663436015689">
+                <image src="media/icon-themes/sc/res/icon-set-pies-empty.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Empty</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-pies-one-quarter.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">One quarter</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-pies-half.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Half</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-pies-three-quarters.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Three quarters</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-pies-full.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Full</alt></image>
             </paragraph>
         </listitem>
         <listitem>
-            <paragraph id="par_id821663436639070"  role="listitem">5 - boxes</paragraph>
-            <paragraph role="paragraph" id="par_id811663438472751" xml-lang="en-US">
-                <image src="media/icon-themes/sc/res/icon-set-squares-empty.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Empty</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-squares-one-quarter.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">One quarter</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-squares-half.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Half</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-squares-three-quarters.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Three quarters</alt></image>
-                <image src="media/icon-themes/sc/res/icon-set-squares-full.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id91663429174808">Full</alt></image>
+            <paragraph id="par_id821663436639070" role="listitem">5 - boxes</paragraph>
+            <paragraph role="paragraph" id="par_id811663438472751">
+                <image src="media/icon-themes/sc/res/icon-set-squares-empty.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Empty</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-squares-one-quarter.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">One quarter</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-squares-half.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Half</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-squares-three-quarters.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Three quarters</alt></image>
+                <image src="media/icon-themes/sc/res/icon-set-squares-full.svg" id="img_id261663429174807" width="1cm" height="1cm"><alt id="alt_id91663429174808">Full</alt></image>
             </paragraph>
         </listitem>
     </list>
     <h3 id="hd_id621663440395987">Conditions for thresholds</h3>
-    <paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions to set the thresholds for each icon can be specified as follows</paragraph>
+    <paragraph id="par_id3153765" role="paragraph">Conditions to set the thresholds for each icon can be specified as follows</paragraph>
     <embed href="text/scalc/01/05120400.xhp#commonconditions"/>
     <embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
     <section id="relatedtopics">
-        <paragraph role="paragraph" id="par_id471665407993996"  localize="false"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
-        <paragraph xml-lang="en-US" id="par_id3155606" role="paragraph"><link href="https://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formatting page</link> in TDF Wiki.</paragraph>
+        <paragraph role="paragraph" id="par_id471665407993996" localize="false"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
+        <paragraph id="par_id3155606" role="paragraph"><link href="https://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formatting page</link> in TDF Wiki.</paragraph>
         <paragraph role="paragraph" id="par_id651663598549283"><link href="https://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki.</paragraph>
     </section>
 </body>
diff --git a/source/text/scalc/01/05120500.xhp b/source/text/scalc/01/05120500.xhp
index 3b2eed4723..ec36ea06ef 100644
--- a/source/text/scalc/01/05120500.xhp
+++ b/source/text/scalc/01/05120500.xhp
@@ -11,26 +11,27 @@
 
     <meta>
         <topic id="conditionalformattingmanage" indexer="include" status="PUBLISH">
-            <title id="tit" xml-lang="en-US">Conditional Formatting - Manage Conditions</title>
+            <title id="tit">Conditional Formatting - Manage Conditions</title>
             <filename>/text/scalc/01/05120500.xhp</filename>
         </topic>
     </meta>
     <body>
-    <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/CondFormatManager" id="bm_id3152598" localize="false"/>
-    <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/@@nowidget@@" id="bm_id3152598" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/condformatmanager/CondFormatManager" id="bm_id3152598" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/condformatmanager/@@nowidget@@" id="bm_id3152598" localize="false"/>
+    <bookmark branch="hid/.uno:ConditionalFormatManagerDialog" id="bm_id141700683748690" localize="false"/>
     <section id="manageconditions">
         <h1 id="hd_id391662937414401"><variable id="h1"><link href="text/scalc/01/05120500.xhp">Manage Conditions</link></variable></h1>
-        <paragraph xml-lang="en-US" id="par_id3155906" role="paragraph">Manage all the conditional formatting defined in the spreadsheet.</paragraph>
+        <paragraph id="par_id3155906" role="paragraph">Manage all the conditional formatting defined in the spreadsheet.</paragraph>
     </section>
     <section id="howtoget">
         <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>
+    <paragraph 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>
 
-    <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/CONTAINER" id="bm_id3152603" localize="false"/>
-    <paragraph xml-lang="en-US" id="par_id3155909" role="paragraph">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet. Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range.</paragraph>
+    <bookmark branch="hid/modules/scalc/ui/condformatmanager/CONTAINER" id="bm_id3152603" localize="false"/>
+    <paragraph id="par_id3155909" role="paragraph">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet. Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range.</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>
+    <paragraph 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 role="paragraph" localize="false" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
     </section>
diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp
index 0f35fdf2e2..f37dfd6e4c 100644
--- a/source/text/scalc/main0105.xhp
+++ b/source/text/scalc/main0105.xhp
@@ -46,11 +46,11 @@
 <embed href="text/scalc/01/05070000.xhp#pagestyle"/>
 <embed href="text/scalc/01/05080000.xhp#printranges"/>
 
-<h2 id="hd_id3157980"><link href="text/shared/01/AutoFormat.xhp">AutoFormat</link></h2>
-<embed href="text/shared/01/AutoFormat.xhp#autoformattext"/>
 
 <h2 id="hd_id3159206"><link href="text/scalc/01/05120000.xhp">Conditional Formatting</link></h2>
 <embed href="text/scalc/01/05120000.xhp#bedingtetext"/>
+<h2 id="hd_id3157980"><link href="text/shared/01/AutoFormat.xhp">AutoFormat</link></h2>
+<embed href="text/shared/01/AutoFormat.xhp#autoformattext"/>
 <embed href="text/shared/01/05260000.xhp#anchoring"/>
 <embed href="text/shared/01/05070000.xhp#alignment"/>
 <embed href="text/shared/01/05080000.xhp#alignment"/>