tdf#122753 Calc AutoFormat Styles update

Change-Id: I7b099f3b94f901af1885b942ce71c5815c1a4918
Reviewed-on: https://gerrit.libreoffice.org/74711
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

3 files changed, 19 insertions, 17 deletions

diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index 5ba4aedd60..beedce6e75 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -58,21 +58,20 @@
 <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="foatfo">
-<paragraph role="paragraph" id="par_id3153916" xml-lang="en-US">Choose <emph>Format - AutoFormat</emph>.</paragraph>
+<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>
 <section id="syautoformat">
 <table id="tbl_id3148605">
 <tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
 <paragraph role="paragraph" id="par_id3149332" xml-lang="en-US">
-<image id="img_id3156020" src="cmd/sc_autoformat.png" width="0.222inch" height="0.222inch"><alt id="alt_id3156020" xml-lang="en-US">Icon</alt></image></paragraph>
+<image id="img_id3156020" src="cmd/sc_autoformat.svg" width="1cm" height="1cm"><alt id="alt_id3156020" xml-lang="en-US">AutoFormat Styles Icon</alt></image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
 <paragraph role="paragraph" id="par_id3154060" xml-lang="en-US">AutoFormat</paragraph>
 </tablecell>
 </tablerow>
 </table>
-
 </section>
 </section>
 <paragraph role="paragraph" id="par_id3154618" xml-lang="en-US"><variable id="bedingte">Choose <emph>Format - Conditional</emph>.</variable></paragraph>
diff --git a/source/text/scalc/01/05110000.xhp b/source/text/scalc/01/05110000.xhp
index 01e03571d9..b80905e066 100644
--- a/source/text/scalc/01/05110000.xhp
+++ b/source/text/scalc/01/05110000.xhp
@@ -73,5 +73,8 @@
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/autofitcb" id="bm_id3152892" localize="false"/>
 <paragraph role="heading" id="hd_id3155811" xml-lang="en-US" level="3">AutoFit width and height</paragraph>
 <paragraph role="paragraph" id="par_id3148703" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/autofitcb">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp></paragraph>
+<section id="relatedtopics">
+    <embed href="text/scalc/guide/autoformat.xhp#autoformat"/>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/guide/autoformat.xhp b/source/text/scalc/guide/autoformat.xhp
index 7148e2be27..186ed9a756 100644
--- a/source/text/scalc/guide/autoformat.xhp
+++ b/source/text/scalc/guide/autoformat.xhp
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,8 +18,8 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalcguideautoformatxml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Using AutoFormat for Tables</title>
@@ -43,10 +43,10 @@
             <paragraph xml-lang="en-US" id="par_idN106CE" role="listitem">Select the cells, including the column and row headers, that you want to format.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_idN106D5" role="listitem">Choose <item type="menuitem">Format - AutoFormat</item>.</paragraph>
+            <paragraph xml-lang="en-US" id="par_idN106D5" role="listitem">Choose <item type="menuitem">Format - AutoFormat Styles</item>.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3151242" role="listitem">To select which properties to include in an AutoFormat, click <emph>More</emph>.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3151242" role="listitem">Select which properties to include in an AutoFormat.</paragraph>
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_idN10715" role="listitem">Click <emph>OK</emph>.</paragraph>
@@ -54,17 +54,17 @@
          </listitem>
       </list>
       <paragraph xml-lang="en-US" id="par_id3149210" role="note">If you do not see any change in color of the cell contents, choose <item type="menuitem">View - Value Highlighting</item>.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3155379" role="heading" level="2">To Define an AutoFormat for Spreadsheets</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3148868" role="paragraph">You can define a new AutoFormat that is available to all spreadsheets.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3155379" role="heading" level="2">To Define an AutoFormat for Spreadsheets or Ranges</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3148868" role="paragraph">You can define a new AutoFormat that is available to all spreadsheets and ranges.</paragraph>
       <list type="ordered">
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3152985" role="listitem">Format a sheet.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3152985" role="listitem">Format a sheet or range.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3145384" role="listitem">Choose <item type="menuitem">Edit - Select All</item>.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3145384" role="listitem">Choose <item type="menuitem">Edit - Select All</item> or select the formatted range.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3153815" role="listitem">Choose <item type="menuitem">Format - AutoFormat</item>.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3153815" role="listitem">Choose <item type="menuitem">Format - AutoFormat Styles</item>.</paragraph>
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_idN107A9" role="listitem">Click <emph>Add</emph>.</paragraph>
@@ -77,7 +77,7 @@
          </listitem>
       </list>
       <section id="relatedtopics">
-         <paragraph xml-lang="en-US" id="par_id3159203" role="paragraph"><link href="text/scalc/01/05110000.xhp" name="Format - AutoFormat">Format - AutoFormat</link></paragraph>
+         <paragraph xml-lang="en-US" id="par_id3159203" role="paragraph"><link href="text/scalc/01/05110000.xhp" name="Format - AutoFormat">Format - AutoFormat Styles</link></paragraph>
       </section>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>