summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-09-07 19:45:50 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-09-08 11:58:50 +0200
commitba616b2299e419762f2eca9ba5b55ed5a4f31c9f (patch)
treeb264c019485846eb2d711a7c6470a1641f0addf6
parent8daa94aa1ff1135d3d2552182c7f2d23cc21d6f2 (diff)
tdf#155875 UI cmds Writer/Table in Help(35)
+ refactoring + Table - AutoFormat Styles (part 35) + uno:AutoFormat refers to similar dialogs in Calc and Writer + but each on its module + merged in shared/01/AutoFormat.xhp with app switch + removed obsolete files (merged) Change-Id: I9324c517f19934027311c297d012397650b60cf4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/156685 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--AllLangHelp_scalc.mk1
-rw-r--r--AllLangHelp_shared.mk1
-rw-r--r--AllLangHelp_swriter.mk1
-rw-r--r--source/text/scalc/00/00000405.xhp82
-rw-r--r--source/text/scalc/01/05110000.xhp78
-rw-r--r--source/text/shared/00/00040503.xhp31
-rw-r--r--source/text/shared/01/AutoFormat.xhp160
-rw-r--r--source/text/shared/01/Protect.xhp7
-rw-r--r--source/text/swriter/01/05150101.xhp103
-rw-r--r--source/text/swriter/main0110.xhp3
10 files changed, 232 insertions, 235 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index f69425a60f..04a1ba353b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -111,7 +111,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/05080300 \
helpcontent2/source/text/scalc/01/05080400 \
helpcontent2/source/text/scalc/01/05100000 \
- helpcontent2/source/text/scalc/01/05110000 \
helpcontent2/source/text/scalc/01/05120000 \
helpcontent2/source/text/scalc/01/05120100 \
helpcontent2/source/text/scalc/01/05120200 \
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index d19ddefb7c..f6779849d3 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -336,6 +336,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
helpcontent2/source/text/shared/01/07080000 \
helpcontent2/source/text/shared/01/about_meta_tags \
helpcontent2/source/text/shared/01/addsignatureline \
+ helpcontent2/source/text/shared/01/AutoFormat \
helpcontent2/source/text/shared/01/certificatepath \
helpcontent2/source/text/shared/01/classificationbar \
helpcontent2/source/text/shared/01/classificationdialog \
diff --git a/AllLangHelp_swriter.mk b/AllLangHelp_swriter.mk
index 0fcd7e2805..c93efbc5f7 100644
--- a/AllLangHelp_swriter.mk
+++ b/AllLangHelp_swriter.mk
@@ -144,7 +144,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,swriter,\
helpcontent2/source/text/swriter/01/05140000 \
helpcontent2/source/text/swriter/01/05150000 \
helpcontent2/source/text/swriter/01/05150100 \
- helpcontent2/source/text/swriter/01/05150101 \
helpcontent2/source/text/swriter/01/05150104 \
helpcontent2/source/text/swriter/01/05150200 \
helpcontent2/source/text/swriter/01/05150300 \
diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index cf3956717f..fb6506f971 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -20,7 +20,7 @@
<meta>
<topic id="textscalc0000000405xml" indexer="exclude" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Format Menu</title>
+ <title id="tit">Format Menu</title>
<filename>/text/scalc/00/00000405.xhp</filename>
</topic>
<history>
@@ -30,50 +30,50 @@
<body>
<h1 id="hd_id3150769">Format Menu</h1>
<section id="format_cells">
- <paragraph role="paragraph" id="par_id3154685" xml-lang="en-US">Choose <menuitem>Format - Cells</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id3154685">Choose <menuitem>Format - Cells</menuitem>.</paragraph>
<paragraph role="paragraph" id="par_id61593556839601">Press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+1</keycode>.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><variable id="fozelstz">Choose <emph>Format - Cells - Cell Protection</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US"><variable id="fozei">Choose <emph>Format - Rows</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US"><variable id="fozeiophoe">Choose <emph>Format - Rows - Optimal Height</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153194"><variable id="fozelstz">Choose <emph>Format - Cells - Cell Protection</emph> tab.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155854"><variable id="fozei">Choose <emph>Format - Rows</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150012"><variable id="fozeiophoe">Choose <emph>Format - Rows - Optimal Height</emph>.</variable></paragraph>
<section id="hide">
-<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US">Choose <emph>Format - Rows - Hide</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3153728" xml-lang="en-US">Choose <emph>Format - Columns - Hide</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US">Choose <emph>Sheet - Hide Sheet</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3148645">Choose <emph>Format - Rows - Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3153728">Choose <emph>Format - Columns - Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3151114">Choose <emph>Sheet - Hide Sheet</emph>.</paragraph>
</section>
<section id="show">
-<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US">Choose <emph>Format - Rows - Show</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US">Choose <emph>Format - Columns - Show</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3148576">Choose <emph>Format - Rows - Show</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3156286">Choose <emph>Format - Columns - Show</emph>.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3145645" xml-lang="en-US"><variable id="fospa">Choose <emph>Format - Columns</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145645"><variable id="fospa">Choose <emph>Format - Columns</emph>.</variable></paragraph>
<section id="optimal_column_width">
-<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US">Choose <emph>Format - Columns - Optimal Width</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US">Double-click right column separator in column headers.</paragraph>
+<paragraph role="paragraph" id="par_id3145252">Choose <emph>Format - Columns - Optimal Width</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3146971">Double-click right column separator in column headers.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US"><variable id="fot">Choose <emph>Sheet</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3147362"><variable id="fot">Choose <emph>Sheet</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_idN1077A" xml-lang="en-US"><variable id="foste">Choose <emph>Format - Page Style</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155508" xml-lang="en-US"><variable id="fostel">Choose <emph>Format - Page Style - Sheet</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150883" xml-lang="en-US"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
-<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>
+<paragraph role="paragraph" id="par_idN1077A"><variable id="foste">Choose <emph>Format - Page Style</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155508"><variable id="fostel">Choose <emph>Format - Page Style - Sheet</emph> tab.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150883"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156448"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3156290"><variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3155812"><variable id="fodbah">Choose <emph>Format - Print Ranges - Clear</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153307"><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_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>
<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>
+ <image src="cmd/lc_conditionalformatdialog.svg" id="img_id461663540244131" width="1cm" height="1cm"><alt 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>
+ <paragraph id="par_id151663540244134" role="paragraph">Conditional Format</paragraph>
</tablecell>
</tablerow>
</table>
@@ -86,11 +86,11 @@
<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>
+ <image src="cmd/lc_colorscaleformatdialog.svg" id="img_id551663540719714" width="1cm" height="1cm"><alt id="alt_id381663540719715">Icon Color Scale</alt></image>
</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id841663540719717" role="paragraph" xml-lang="en-US">Color Scale</paragraph>
+ <paragraph id="par_id841663540719717" role="paragraph">Color Scale</paragraph>
</tablecell>
</tablerow>
</table>
@@ -103,11 +103,11 @@
<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>
+ <image src="cmd/lc_databarformatdialog.svg" id="img_id601663541161944" width="1cm" height="1cm"><alt id="alt_id21663541161945">Icon Data Bar</alt></image>
</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id101663541161947" role="paragraph" xml-lang="en-US">Data Bar</paragraph>
+ <paragraph id="par_id101663541161947" role="paragraph">Data Bar</paragraph>
</tablecell>
</tablerow>
</table>
@@ -120,11 +120,11 @@
<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>
+ <image src="cmd/lc_iconsetformatdialog.svg" id="img_id511663541228729" width="1cm" height="1cm"><alt id="alt_id261663541228730">Icon Icon Set</alt></image>
</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id61663541228732" role="paragraph" xml-lang="en-US">Icon Set</paragraph>
+ <paragraph id="par_id61663541228732" role="paragraph">Icon Set</paragraph>
</tablecell>
</tablerow>
</table>
@@ -137,11 +137,11 @@
<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>
+ <image src="cmd/lc_conddateformatdialog.svg" id="img_id61663541317148" width="1cm" height="1cm"><alt id="alt_id641663541317149">Icon Date</alt></image>
</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id121663541317151" role="paragraph" xml-lang="en-US">Date</paragraph>
+ <paragraph id="par_id121663541317151" role="paragraph">Date</paragraph>
</tablecell>
</tablerow>
</table>
@@ -150,23 +150,5 @@
<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>
-<section id="syautoformat">
-<table id="tbl_id3148605">
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3149332" xml-lang="en-US">
-<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>
-<paragraph role="paragraph" id="par_id3154060" xml-lang="en-US">AutoFormat</paragraph>
-</tablecell>
-</tablerow>
-</table>
-</section>
-</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05110000.xhp b/source/text/scalc/01/05110000.xhp
deleted file mode 100644
index 074b7f2c2a..0000000000
--- a/source/text/scalc/01/05110000.xhp
+++ /dev/null
@@ -1,78 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed
- * with this work for additional information regarding copyright
- * ownership. The ASF licenses this file to you under the Apache
- * License, Version 2.0 (the "License"); you may not use this file
- * 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="textscalc0105110000xml" indexer="include">
- <title id="tit" xml-lang="en-US">AutoFormat</title>
- <filename>/text/scalc/01/05110000.xhp</filename>
- </topic>
-</meta>
-
-<body>
- <bookmark xml-lang="en-US" branch="hid/.uno:AutoFormat" id="bm_id9247611" localize="false"/>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/AutoFormatTableDialog" id="bm_id2998138" localize="false"/>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/@@nowidget@@" id="bm_id2998138" localize="false"/>
- <h1 id="hd_id3149666"><variable id="autoformat"><link href="text/scalc/01/05110000.xhp">AutoFormat</link></variable></h1>
- <paragraph role="paragraph" id="par_id3145367" xml-lang="en-US"><variable id="autoformattext"><ahelp hid=".">Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.</ahelp></variable></paragraph>
- <section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#autoformat"/>
- </section>
- <note id="par_id181630332690300">The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu.</note>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/formatlb" id="bm_id3145645" localize="false"/>
-<h2 id="hd_id3148455">Format</h2>
-<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/formatlb">Choose a predefined AutoFormat to apply to a selected area in your sheet.</ahelp></paragraph>
-<embed href="text/shared/00/00000001.xhp#preview_field"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/add" id="bm_id3155600" localize="false"/>
-<h2 id="hd_id3149410">Add</h2>
-<paragraph role="paragraph" id="par_id3154017" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/add">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <emph>Add AutoFormat</emph> dialog then appears.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_AUTOFMT_NAME" id="bm_id3153713" localize="false"/>
-<paragraph role="paragraph" id="par_id3153708" xml-lang="en-US"><ahelp hid=".">Enter a name and click <emph>OK</emph>. </ahelp></paragraph>
-<embed href="text/shared/00/00000001.xhp#delete"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/rename" id="bm_id3153309" localize="false"/>
-<h2 id="hd_id3159223">Rename</h2>
-<paragraph role="paragraph" id="par_id3153064" xml-lang="en-US"><ahelp hid=".">Opens a dialog where you can change the name of the selected AutoFormat.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_REN_AFMT_NAME" id="bm_id3148608" localize="false"/>
-<paragraph role="paragraph" id="par_id3153912" xml-lang="en-US">The <emph>Rename AutoFormat</emph> dialog opens.<ahelp hid="."> Enter the new name of the AutoFormat here.</ahelp></paragraph>
-
-<h3 id="hd_id3155961">Formatting</h3>
-<paragraph role="paragraph" id="par_id3153965" xml-lang="en-US">In this section you can select or deselect the available formatting options. If you want to keep any of the settings currently in your spreadsheet, deselect the corresponding option.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/numformatcb" id="bm_id3149210" localize="false"/>
-<h3 id="hd_id3154021">Number format</h3>
-<paragraph role="paragraph" id="par_id3159239" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/numformatcb">When marked, specifies that you want to retain the number format of the selected format.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/bordercb" id="bm_id3150206" localize="false"/>
-<h3 id="hd_id3149530">Borders</h3>
-<paragraph role="paragraph" id="par_id3145259" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/bordercb">When marked, specifies that you want to retain the border of the selected format.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/fontcb" id="bm_id3150364" localize="false"/>
-<h3 id="hd_id3154657">Font</h3>
-<paragraph role="paragraph" id="par_id3152990" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/fontcb">When marked, specifies that you want to retain the font of the selected format.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/patterncb" id="bm_id3150515" localize="false"/>
-<h3 id="hd_id3155379">Pattern</h3>
-<paragraph role="paragraph" id="par_id3150368" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/patterncb">When marked, specifies that you want to retain the pattern of the selected format.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/alignmentcb" id="bm_id3146978" localize="false"/>
-<h3 id="hd_id3146115">Alignment</h3>
-<paragraph role="paragraph" id="par_id3156445" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/alignmentcb">When marked, specifies that you want to retain the alignment of the selected format.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/autofitcb" id="bm_id3152892" localize="false"/>
-<h3 id="hd_id3155811">AutoFit width and height</h3>
-<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/shared/00/00040503.xhp b/source/text/shared/00/00040503.xhp
index 46cf148428..9d246936ed 100644
--- a/source/text/shared/00/00040503.xhp
+++ b/source/text/shared/00/00040503.xhp
@@ -30,6 +30,37 @@
<body>
<comment>This listing is split over the files 00040500, 00040501, 00040502 and 00040503.</comment>
<h1 id="hd_id3155757">Format Menu</h1>
+<section id="autoformat">
+ <switch select="appl">
+ <case select="WRITER">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id111694117986265">Choose <menuitem>Table - AutoFormat Styles</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id311694117990040">Choose <menuitem>Table - Table Styles</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sidebar"/>
+ <paragraph role="paragraph" id="par_id581694117004494">Open the <menuitem>Styles</menuitem> panel (<keycode>F11</keycode>), choose <menuitem>Table</menuitem> styles, double click a style.</paragraph>
+ </case>
+ <case select="CALC">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153916">Choose <menuitem>Format - AutoFormat Styles</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id511694111284753">Choose <menuitem>Layout - Table Styles</menuitem>.</paragraph>
+ </case>
+ </switch>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <section id="syautoformat">
+ <table id="tbl_id3148605">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149332"><image id="img_id3156020" src="cmd/lc_autoformat.svg" width="1cm" height="1cm"><alt id="alt_id3156020">AutoFormat Styles Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3154060">AutoFormat</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+</section>
<section id="row_height">
<paragraph role="paragraph" id="par_id3147294">Choose <emph>Format - Rows - Height</emph>.</paragraph>
<paragraph role="paragraph" id="par_id3149551">Open context menu of a row header in an open database table - choose <emph>Row Height</emph>.</paragraph>
diff --git a/source/text/shared/01/AutoFormat.xhp b/source/text/shared/01/AutoFormat.xhp
new file mode 100644
index 0000000000..5d1ccdbb81
--- /dev/null
+++ b/source/text/shared/01/AutoFormat.xhp
@@ -0,0 +1,160 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * 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="textscalc0105110000xml" indexer="include">
+ <title id="tit">AutoFormat</title>
+ <filename>/text/shared/01/AutoFormat.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+<bookmark branch="hid/.uno:AutoFormat" id="bm_id9247611" localize="false"/>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/AutoFormatTableDialog" id="bm_id2998138" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/autoformattable/@@nowidget@@" id="bm_id2998138" localize="false"/>
+
+<bookmark branch="hid/modules/swriter/ui/autoformattable/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/AutoFormatTableDialog" id="bm_id3150249" localize="false"/>
+
+<bookmark branch="index" id="bm_id2655415">
+<bookmark_value>tables;AutoFormat function</bookmark_value>
+<bookmark_value>sheet table;AutoFormat function</bookmark_value>
+<bookmark_value>styles;table styles</bookmark_value>
+<bookmark_value>AutoFormat function for tables</bookmark_value>
+</bookmark>
+
+<section id="autoformat">
+ <h1 id="hd_id3149666"><variable id="autoformat"><link href="text/shared/01/AutoFormat.xhp">AutoFormat Styles</link></variable></h1>
+ <paragraph role="paragraph" id="par_id3145367"><variable id="autoformattext"><ahelp hid=".">Use this command to apply an AutoFormat to a selected <switchinline select="appl"><caseinline select="CALC">sheet area</caseinline><defaultinline>table area</defaultinline></switchinline> or to define your own AutoFormats.</ahelp></variable></paragraph>
+</section>
+
+<section id="howtoget">
+ <embed href="text/shared/00/00040503.xhp#autoformat"/>
+</section>
+
+<switch select="appl">
+ <case select="CALC">
+ <note id="par_id181630332690300">The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu.</note>
+ </case>
+</switch>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/formatlb" id="bm_id3145645" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/formatlb" id="bm_id3148770" localize="false"/>
+<h2 id="hd_id3148455">Format</h2>
+<switch select="appl">
+ <case select="WRITER">
+ <paragraph role="paragraph" id="par_id501694123100254">Choose a predefined AutoFormat to apply to the table.</paragraph>
+ </case>
+ <case select="CALC">
+ <paragraph role="paragraph" id="par_id3145799">Choose a predefined AutoFormat to apply to a selected area in your sheet.</paragraph>
+ </case>
+</switch>
+
+<embed href="text/shared/00/00000001.xhp#preview_field"/>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/add" id="bm_id3155600" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/add" id="bm_id3147174" localize="false"/>
+<h2 id="hd_id3149410">Add</h2>
+<switch select="appl">
+ <case select="WRITER">
+ <paragraph id="par_id3151185" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/add">Adds a new table style to the list.</ahelp></paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph id="par_id3154646" role="listitem">Format a table in your document.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id3156320" role="listitem">Select the table, and then choose <emph>Table - AutoFormat Styles</emph>.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id3153156" role="listitem">Click <emph>Add</emph>.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id3151168" role="listitem">In the <emph>Add AutoFormat</emph> dialog, enter a name, and then click <emph>OK</emph>.</paragraph>
+ </listitem>
+ </list>
+ <bookmark branch="hid/modules/swriter/ui/stringinput/edit" id="bm_id3150278" localize="false"/>
+ <paragraph role="paragraph" id="par_id3153391"><ahelp visibility="hidden" hid="modules/swriter/ui/stringinput/edit">Enter a name for the new AutoFormat, and then click<emph> OK</emph>.</ahelp></paragraph>
+ </case>
+ <case select="CALC">
+ <paragraph role="paragraph" id="par_id3154017">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats. The <emph>Add AutoFormat</emph> dialog then appears.</paragraph>
+ <bookmark branch="hid/SC_HID_SC_AUTOFMT_NAME" id="bm_id3153713" localize="false"/>
+ <paragraph role="paragraph" id="par_id3153708"><ahelp hid=".">Enter a name and click <emph>OK</emph>. </ahelp></paragraph>
+ </case>
+</switch>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/remove" id="bm_id3154280" localize="false"/>
+<h2 id="hd_id3147516">Delete</h2>
+<paragraph id="par_id3150707" role="paragraph">Deletes the selected style. You cannot delete the default style.</paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/rename" id="bm_id3153309" localize="false"/>
+<h2 id="hd_id3159223">Rename</h2>
+<paragraph role="paragraph" id="par_id3153064"><ahelp hid=".">Opens a dialog where you can change the name of the selected AutoFormat.</ahelp></paragraph>
+
+<bookmark branch="hid/SC_HID_SC_REN_AFMT_NAME" id="bm_id3148608" localize="false"/>
+<paragraph role="paragraph" id="par_id3153912">The <emph>Rename AutoFormat</emph> dialog opens.<ahelp hid="."> Enter the new name of the AutoFormat here.</ahelp></paragraph>
+
+<h2 id="hd_id3155961">Formatting</h2>
+<paragraph id="par_id3149022" role="paragraph">Lists the available formatting styles for tables. Click the format that you want to apply, and then click <emph>OK</emph>.</paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/numformatcb" id="bm_id3149210" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/numformatcb" id="bm_id3147526" localize="false"/>
+<h3 id="hd_id3154021">Number format</h3>
+<paragraph id="par_id3150970" role="paragraph">Includes numbering formats in the selected style.</paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/bordercb" id="bm_id3150206" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/bordercb" id="bm_id3154193" localize="false"/>
+<h3 id="hd_id3149530">Borders</h3>
+<paragraph id="par_id3154200" role="paragraph">Includes border styles in the selected style.</paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/fontcb" id="bm_id3150364" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/fontcb" id="bm_id3152954" localize="false"/>
+<h3 id="hd_id3150350">Font</h3>
+<paragraph id="par_id3152961" role="paragraph">Includes font formatting in the selected style.</paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/patterncb" id="bm_id3150515" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/patterncb" id="bm_id3155184" localize="false"/>
+<h3 id="hd_id3155379">Pattern</h3>
+<paragraph id="par_id3151325" role="paragraph">Includes background styles in the selected style.</paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/alignmentcb" id="bm_id3146978" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/alignmentcb" id="bm_id3153675" localize="false"/>
+<h3 id="hd_id3146115">Alignment</h3>
+<paragraph id="par_id3155896" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/alignmentcb">Includes alignment settings in the selected style.</ahelp></paragraph>
+
+<bookmark branch="hid/modules/scalc/ui/autoformattable/autofitcb" id="bm_id3152892" localize="false"/>
+<switch select="appl">
+ <case select="CALC">
+ <h3 id="hd_id3155811">AutoFit width and height</h3>
+ <paragraph role="paragraph" id="par_id3148703"><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>
+ </case>
+</switch>
+
+<section id="relatedtopics">
+ <switch select="appl">
+ <case select="CALC">
+ <embed href="text/scalc/guide/autoformat.xhp#autoformat"/>
+ </case>
+ <case select="WRITER">
+ <embed href="text/swriter/main0110.xhp#h1"/>
+ </case>
+ </switch>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/shared/01/Protect.xhp b/source/text/shared/01/Protect.xhp
index d58232c169..c479ee1373 100644
--- a/source/text/shared/01/Protect.xhp
+++ b/source/text/shared/01/Protect.xhp
@@ -133,5 +133,12 @@
<default>
</default>
</switch>
+ <section id="relatedtopics">
+ <switch select="appl">
+ <case select="WRITER">
+ <embed href="text/swriter/main0110.xhp#h1"/>
+ </case>
+ </switch>
+</section>
</body>
</helpdocument>
diff --git a/source/text/swriter/01/05150101.xhp b/source/text/swriter/01/05150101.xhp
deleted file mode 100644
index 717c091fc5..0000000000
--- a/source/text/swriter/01/05150101.xhp
+++ /dev/null
@@ -1,103 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed
- * with this work for additional information regarding copyright
- * ownership. The ASF licenses this file to you under the Apache
- * License, Version 2.0 (the "License"); you may not use this file
- * 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="textswriter0105150101xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">AutoFormat for Tables</title>
-<filename>/text/swriter/01/05150101.xhp</filename>
-</topic>
-</meta>
-<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:AutoFormat" id="bm_id3150343" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/AutoFormatTableDialog" id="bm_id3150249" localize="false"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id2655415"><bookmark_value>tables;AutoFormat function</bookmark_value>
- <bookmark_value>styles;table styles</bookmark_value>
- <bookmark_value>AutoFormat function for tables</bookmark_value>
-</bookmark>
-<h1 xml-lang="en-US" id="hd_id3148485">AutoFormat for Tables</h1>
- <paragraph xml-lang="en-US" id="par_id3149500" role="paragraph"><variable id="autoformattabelle"><ahelp hid=".">Automatically applies formats to the current table, including fonts, shading, and borders.</ahelp>
-</variable></paragraph>
- <section id="howtoget">
- <embed href="text/swriter/00/00000405.xhp#autoformattab"/>
- </section>
- <h2 xml-lang="en-US" id="hd_id3151388">Applying an AutoFormat to a Table</h2>
- <list type="ordered">
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3145828" role="listitem">Click in a table cell, or select the cells that you want to format.</paragraph>
- </listitem>
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3153006" role="listitem">Choose <emph>Table - AutoFormat Styles</emph>, and then click the format that you to want to apply.</paragraph>
- </listitem>
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3145585" role="listitem">Click <emph>OK</emph>.</paragraph>
- </listitem>
- </list>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/formatlb" id="bm_id3148770" localize="false"/>
-<h2 xml-lang="en-US" id="hd_id3148386">Format</h2>
- <paragraph xml-lang="en-US" id="par_id3149022" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/formatlb">Lists the available formatting styles for tables. Click the format that you want to apply, and then click <emph>OK</emph>.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/add" id="bm_id3147174" localize="false"/>
-<h2 xml-lang="en-US" id="hd_id3153722">Add</h2>
- <paragraph xml-lang="en-US" id="par_id3151185" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/add">Adds a new table style to the list.</ahelp></paragraph>
- <list type="ordered">
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3154646" role="listitem">Format a table in your document.</paragraph>
- </listitem>
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3156320" role="listitem">Select the table, and then choose <emph>Table - AutoFormat Styles</emph>.</paragraph>
- </listitem>
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3153156" role="listitem">Click <emph>Add</emph>.</paragraph>
- </listitem>
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3151168" role="listitem">In the <emph>Add AutoFormat</emph> dialog, enter a name, and then click <emph>OK</emph>.</paragraph>
- </listitem>
- </list>
-
- <bookmark branch="hid/modules/swriter/ui/stringinput/edit" xml-lang="en-US" id="bm_id3150278" localize="false"/>
- <paragraph role="paragraph" id="par_id3153391" xml-lang="en-US"><ahelp visibility="hidden" hid="modules/swriter/ui/stringinput/edit">Enter a name for the new AutoFormat, and then click<emph> OK</emph>.</ahelp></paragraph>
-
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/remove" id="bm_id3154280" localize="false"/>
-<h2 xml-lang="en-US" id="hd_id3147516">Delete</h2>
- <paragraph xml-lang="en-US" id="par_id3150707" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/remove">Deletes the selected table style. You cannot delete "Default Table Style".</ahelp></paragraph>
-<h2 xml-lang="en-US" id="hd_id3149302">Rename</h2>
- <paragraph xml-lang="en-US" id="par_id3149490" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/rename">Changes the name of the selected table style. You cannot rename "Default Table Style".</ahelp></paragraph>
-<h2 xml-lang="en-US" id="hd_id3153534">Formatting</h2>
- <paragraph xml-lang="en-US" id="par_id3154477" role="paragraph">Select the formatting attributes to include in the selected table style.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/numformatcb" id="bm_id3147526" localize="false"/>
-<h3 xml-lang="en-US" id="hd_id3151317">Number format</h3>
- <paragraph xml-lang="en-US" id="par_id3150970" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/numformatcb">Includes numbering formats in the selected table style.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/fontcb" id="bm_id3152954" localize="false"/>
-<h3 xml-lang="en-US" id="hd_id3150350">Font</h3>
- <paragraph xml-lang="en-US" id="par_id3152961" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/fontcb">Includes font formatting in the selected table style.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/alignmentcb" id="bm_id3153675" localize="false"/>
-<h3 xml-lang="en-US" id="hd_id3154575">Alignment</h3>
- <paragraph xml-lang="en-US" id="par_id3155896" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/alignmentcb">Includes alignment settings in the selected table style.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/bordercb" id="bm_id3154193" localize="false"/>
-<h3 xml-lang="en-US" id="hd_id3149690">Borders</h3>
- <paragraph xml-lang="en-US" id="par_id3154200" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/bordercb">Includes border styles in the selected table style.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/patterncb" id="bm_id3155184" localize="false"/>
-<h3 xml-lang="en-US" id="hd_id3159201">Pattern</h3>
- <paragraph xml-lang="en-US" id="par_id3151325" role="paragraph"><ahelp hid="modules/swriter/ui/autoformattable/patterncb">Includes background styles in the selected table style.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/rename" id="bm_id3149483" localize="false"/>
- </body>
-</helpdocument>
diff --git a/source/text/swriter/main0110.xhp b/source/text/swriter/main0110.xhp
index bb9a9fc9b4..476e5924ce 100644
--- a/source/text/swriter/main0110.xhp
+++ b/source/text/swriter/main0110.xhp
@@ -54,8 +54,7 @@
<embed href="text/shared/01/Protect.xhp#protect"/>
<embed href="text/swriter/01/05100400.xhp#unprotect"/>
-<h2 id="par_idN105F7"><link href="text/swriter/01/05150101.xhp">AutoFormat Styles</link></h2>
-<embed href="text/swriter/01/05150101.xhp#autoformattabelle"/>
+<embed href="text/shared/01/AutoFormat.xhp#autoformat"/>
<h2 id="par_idN1060F">Number Format</h2>
<paragraph id="par_idN107AC" role="paragraph">Opens <link href="text/shared/optionen/01040500.xhp">a dialog</link> where you can specify the format of numbers in the table.</paragraph>