[Libreoffice-commits] help.git: source/text

Olivier Hallot (via logerrit) logerrit at kemper.freedesktop.org
Sun Jul 18 16:18:28 UTC 2021


 source/text/scalc/01/12040201.xhp |   18 +++++++++---------
 source/text/scalc/main0000.xhp    |   13 ++++---------
 source/text/scalc/main0100.xhp    |    7 ++-----
 source/text/scalc/main0101.xhp    |    2 +-
 source/text/scalc/main0102.xhp    |    6 +++---
 source/text/scalc/main0106.xhp    |   10 +++++-----
 source/text/scalc/main0107.xhp    |    4 ++--
 source/text/scalc/main0116.xhp    |   18 +++++++++---------
 source/text/scalc/main0200.xhp    |    7 ++-----
 source/text/scalc/main0203.xhp    |   13 +++++--------
 source/text/scalc/main0205.xhp    |   29 +++++++++++++----------------
 source/text/scalc/main0206.xhp    |    5 +----
 source/text/scalc/main0208.xhp    |    6 +++---
 source/text/scalc/main0214.xhp    |    5 +----
 source/text/scalc/main0218.xhp    |   19 ++++++++-----------
 source/text/scalc/main0503.xhp    |   17 +++++++----------
 16 files changed, 75 insertions(+), 104 deletions(-)

New commits:
commit 8e69592bb5095501ace05f4d231781d1bf420706
Author:     Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Sun Jul 18 13:16:29 2021 -0300
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Sun Jul 18 18:18:07 2021 +0200

    Refactor Help pages
    
    Change-Id: I4e08e55d279f48e59b2274e33d92aae7747f2eb4
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/119129
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/12040201.xhp b/source/text/scalc/01/12040201.xhp
index 46d17d5b5..c7361dce4 100644
--- a/source/text/scalc/01/12040201.xhp
+++ b/source/text/scalc/01/12040201.xhp
@@ -26,7 +26,7 @@
   </topic>
 </meta>
 <body>
-<paragraph role="heading" id="hd_id3148492" xml-lang="en-US" level="1"><link href="text/scalc/01/12040201.xhp" name="Options">Options</link></paragraph>
+<h1 id="hd_id3148492"><link href="text/scalc/01/12040201.xhp" name="Options">Options</link></h1>
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/more" id="bm_id3152350" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/more" id="bm_id3156023" localize="false"/>
 <paragraph role="paragraph" id="par_id3159400" xml-lang="en-US"><variable id="zusaetzetext"><ahelp hid="modules/scalc/ui/advancedfilterdialog/more">Shows additional filter options.</ahelp>
@@ -34,15 +34,15 @@
 <section id="howtoget">
   <embed href="text/scalc/00/00000412.xhp#filterzus"/>
 </section>
-  <paragraph role="heading" id="hd_id3150791" xml-lang="en-US" level="2">Options</paragraph>
+  <h2 id="hd_id3150791">Options</h2>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/case" id="bm_id3151210" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/case" id="bm_id3150871" localize="false"/>
 <section id="FilterOptions_Pt1">
-  <paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="3">Case sensitive</paragraph>
+  <h3 id="hd_id3154138">Case sensitive</h3>
   <paragraph role="paragraph" id="par_id3147228" xml-lang="en-US"><ahelp hid="modules/scalc/ui/advancedfilterdialog/case">Distinguishes between uppercase and lowercase letters when filtering the data.</ahelp></paragraph>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/header" id="bm_id3153968" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/header" id="bm_id3145173" localize="false"/>
-  <paragraph role="heading" id="hd_id3154908" xml-lang="en-US" level="3">Range contains column labels</paragraph>
+  <h3 id="hd_id3154908">Range contains column labels</h3>
   <paragraph role="paragraph" id="par_id3153768" xml-lang="en-US"><ahelp hid="modules/scalc/ui/advancedfilterdialog/header">Includes the column labels in the first row of a cell range.</ahelp></paragraph>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/copyresult" id="bm_id3147426" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/copyresult" id="bm_id3148576" localize="false"/>
@@ -50,26 +50,26 @@
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/lbcopyarea" id="bm_id3147349" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/edcopyarea" id="bm_id3147348" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/edcopyarea" id="bm_id3153093" localize="false"/>
-  <paragraph role="heading" id="hd_id3155306" xml-lang="en-US" level="3">Copy results to</paragraph>
+  <h3 id="hd_id3155306">Copy results to</h3>
   <paragraph role="paragraph" id="par_id3154319" xml-lang="en-US"><ahelp hid="modules/scalc/ui/advancedfilterdialog/edcopyarea">Select the check box, and then select the cell range where you want to display the filter results.</ahelp> You can also select a named range from the list.</paragraph>
 </section>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
 <section id="FilterOptions_Pt2">
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/regexp" id="bm_id3153726" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/regexp" id="bm_id3153144" localize="false"/>
-  <paragraph role="heading" id="hd_id3145272" xml-lang="en-US" level="3">Regular expression</paragraph>
+  <h3 id="hd_id3145272">Regular expression</h3>
   <paragraph role="paragraph" id="par_id3152576" xml-lang="en-US"><ahelp hid="modules/scalc/ui/advancedfilterdialog/regexp">Allows you to use regular expressions in the filter definition.</ahelp> For a list of the regular expressions that $[officename] supports, click <link href="text/shared/01/02100001.xhp" name="here">here</link>.</paragraph>
   <paragraph role="paragraph" id="par_id3149377" xml-lang="en-US">If the <emph>Regular Expressions</emph> check box is selected, you can use regular expressions in the Value field if the Condition list box is set to '=' EQUAL or '<>' UNEQUAL. This also applies to the respective cells that you reference for an advanced filter.</paragraph>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/unique" id="bm_id3149410" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/unique" id="bm_id3147126" localize="false"/>
-  <paragraph role="heading" id="hd_id3149958" xml-lang="en-US" level="3">No duplication</paragraph>
+  <h3 id="hd_id3149958">No duplication</h3>
   <paragraph role="paragraph" id="par_id3153876" xml-lang="en-US"><ahelp hid="modules/scalc/ui/advancedfilterdialog/unique">Excludes duplicate rows in the list of filtered data.</ahelp></paragraph>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/destpers" id="bm_id3149403" localize="false"/>
   <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/destpers" id="bm_id3149402" localize="false"/>
-  <paragraph role="heading" id="hd_id3154018" xml-lang="en-US" level="3">Keep filter criteria</paragraph>
+  <h3 id="hd_id3154018">Keep filter criteria</h3>
   <paragraph role="paragraph" id="par_id3149123" xml-lang="en-US"><ahelp hid="modules/scalc/ui/standardfilterdialog/destpers">Select the <emph>Copy results to</emph> check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under <emph>Data - Define range</emph> as a database range.</ahelp> Following this, you can reapply the defined filter at any time as follows: click into the source range, then choose <emph>Data - Refresh Range</emph>.</paragraph>
 </section>
-<paragraph role="heading" id="hd_id3149018" xml-lang="en-US" level="2">Data range</paragraph>
+<h2 id="hd_id3149018">Data range</h2>
 <paragraph role="paragraph" id="par_id3150042" xml-lang="en-US">Displays the cell range or the name of the cell range that you want to filter.</paragraph>
 <embed href="text/shared/00/00000001.xhp#options"/>
 </body>
diff --git a/source/text/scalc/main0000.xhp b/source/text/scalc/main0000.xhp
index ab1504912..41e14e8d9 100644
--- a/source/text/scalc/main0000.xhp
+++ b/source/text/scalc/main0000.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,9 +16,7 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-		<helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0000xml" indexer="include" status="PUBLISH">
 <title id="tit" xml-lang="en-US">Welcome to the $[officename] Calc Help</title>
@@ -30,14 +25,14 @@
 </meta>
 <body>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_WIN_GRIDWIN" id="bm_id3155335" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/HID_GLOBAL_FALLBACK" id="bm_id3149255" localize="false"/><paragraph role="heading" id="hd_id3147338" xml-lang="en-US" level="1">Welcome to the $[officename] Calc Help</paragraph>
+<bookmark xml-lang="en-US" branch="hid/HID_GLOBAL_FALLBACK" id="bm_id3149255" localize="false"/><h1 id="hd_id3147338">Welcome to the $[officename] Calc Help</h1>
 <embed href="text/shared/06/youtubevideos.xhp#whatisit"/>
-<paragraph role="heading" id="hd_id3153965" xml-lang="en-US" level="3">How to Work With $[officename] Calc</paragraph>
+<h3 id="hd_id3153965">How to Work With $[officename] Calc</h3>
 <embed href="text/scalc/guide/main.xhp#main"/>
 <embed href="text/scalc/main0503.xhp#main0503"/>
 <paragraph role="paragraph" id="par_id3147004" xml-lang="en-US"><link href="text/scalc/01/04060100.xhp" name="List of Functions by Category">List of Functions by Category</link></paragraph>
 <embed href="text/schart/main0000.xhp#chart_main"/>
-<paragraph role="heading" id="hd_id3154659" xml-lang="en-US" level="3">$[officename] Calc Menus, Toolbars, and Keys</paragraph>
+<h3 id="hd_id3154659">$[officename] Calc Menus, Toolbars, and Keys</h3>
 <embed href="text/scalc/main0100.xhp#main0100"/>
 <embed href="text/scalc/main0200.xhp#main0200"/>
 <embed href="text/scalc/04/01020000.xhp#calc_keys"/>
diff --git a/source/text/scalc/main0100.xhp b/source/text/scalc/main0100.xhp
index 26018043e..d0eced59e 100644
--- a/source/text/scalc/main0100.xhp
+++ b/source/text/scalc/main0100.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0100xml" indexer="include" status="PUBLISH">
@@ -31,8 +28,8 @@
 </meta>
 <body>
 <section id="menus">
-<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="1"><variable id="main0100"><link href="text/scalc/main0100.xhp" name="Menus">Menus</link>
-</variable></paragraph>
+<h1 id="hd_id3156023"><variable id="main0100"><link href="text/scalc/main0100.xhp" name="Menus">Menus</link>
+</variable></h1>
 <paragraph role="paragraph" id="par_id3154760" xml-lang="en-US">The following menu commands are available for spreadsheets.</paragraph>
 </section>
 <embed href="text/shared/00/00000011.xhp#menu_commands_text"/>
diff --git a/source/text/scalc/main0101.xhp b/source/text/scalc/main0101.xhp
index 6784adaea..dd1517741 100644
--- a/source/text/scalc/main0101.xhp
+++ b/source/text/scalc/main0101.xhp
@@ -31,7 +31,7 @@
 <section id="file">
 <bookmark xml-lang="en-US" branch="hid/.uno:FileMenu" id="bm_id3151341" localize="false"/>
 
-<paragraph id="hd_id3156023" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/main0101.xhp" name="File">File</link></paragraph>
+<h1 id="hd_id3156023"><link href="text/scalc/main0101.xhp" name="File">File</link></h1>
 <paragraph id="par_id3151112" role="paragraph" xml-lang="en-US"><ahelp hid=".">These commands apply to the current document, open a new document, or close the application.</ahelp></paragraph>
 </section>
 <embed href="text/shared/01/01010000.xhp#new"/>
diff --git a/source/text/scalc/main0102.xhp b/source/text/scalc/main0102.xhp
index 9fd6c54fe..338eb7378 100644
--- a/source/text/scalc/main0102.xhp
+++ b/source/text/scalc/main0102.xhp
@@ -31,7 +31,7 @@
 <section id="edit">
 <bookmark xml-lang="en-US" branch="hid/.uno:EditMenu" id="bm_id1586962" localize="false"/>
 
-<paragraph id="hd_id3156023" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/main0102.xhp" name="Edit">Edit</link></paragraph>
+<h1 id="hd_id3156023"><link href="text/scalc/main0102.xhp" name="Edit">Edit</link></h1>
 <paragraph id="par_id3154758" role="paragraph" xml-lang="en-US"><ahelp hid=".">This menu contains commands for editing the contents of the current document.</ahelp></paragraph>
 </section>
 <embed href="text/shared/01/02010000.xhp#undo"/>
@@ -48,10 +48,10 @@
 <embed href="text/shared/01/02240000.xhp#compare_document"/>
 <embed href="text/shared/01/02230500.xhp#merge_documents"/>
 
-<paragraph id="hd_id3146919" role="heading" level="2" xml-lang="en-US"><link href="text/shared/01/02180000.xhp" name="Links">Links</link></paragraph>
+<h2 id="hd_id3146919"><link href="text/shared/01/02180000.xhp" name="Links">Links</link></h2>
 <embed href="text/shared/01/02180000.xhp#links_text"/>
 
-<paragraph id="hd_id0914201502131542" role="heading" level="2" xml-lang="en-US"><link href="text/shared/01/02200000.xhp" name="Object">Object</link></paragraph>
+<h2 id="hd_id0914201502131542"><link href="text/shared/01/02200000.xhp" name="Object">Object</link></h2>
 <embed href="text/shared/01/02200000.xhp#object_text"/>
 <embed href="text/shared/02/07070000.xhp#edit_mode"/>
 </body>
diff --git a/source/text/scalc/main0106.xhp b/source/text/scalc/main0106.xhp
index e69936c96..57c69ec0c 100644
--- a/source/text/scalc/main0106.xhp
+++ b/source/text/scalc/main0106.xhp
@@ -27,32 +27,32 @@
 <body>
 <section id="tools">
 <bookmark xml-lang="en-US" branch="hid/.uno:ToolsMenu" id="bm_id9563890" localize="false"/>
-<paragraph id="hd_id3150769" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/main0106.xhp" name="Tools">Tools</link></paragraph>
+<h1 id="hd_id3150769"><link href="text/scalc/main0106.xhp" name="Tools">Tools</link></h1>
 <paragraph id="par_id3150440" role="paragraph" xml-lang="en-US"><ahelp hid=".">The <emph>Tools</emph> menu contains commands to check spelling, to trace sheet references, to find mistakes and to define scenarios.</ahelp></paragraph>
 </section>
 <paragraph id="par_id3152576" role="paragraph" xml-lang="en-US">You can also create and assign macros and configure the look and feel of toolbars, menus, keyboard, and set the default options for $[officename] applications.</paragraph>
 <embed href="text/shared/01/06990000.xhp#spelling"/>
 <embed href="text/shared/01/06010500.xhp#language"/>
 
-<paragraph id="hd_id3154015" role="heading" level="2" xml-lang="en-US"><link href="text/shared/01/06040000.xhp" name="AutoCorrect">AutoCorrect Options</link></paragraph>
+<h2 id="hd_id3154015"><link href="text/shared/01/06040000.xhp" name="AutoCorrect">AutoCorrect Options</link></h2>
 <embed href="text/shared/01/06040000.xhp#autoko"/>
 
 <h2 id="hd_id3148488"><link href="text/shared/01/02220000.xhp" name="ImageMap">ImageMap</link></h2>
 <embed href="text/shared/01/02220000.xhp#imagemaptext"/>
 
-<paragraph id="hd_id3149122" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></paragraph>
+<h2 id="hd_id3149122"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></h2>
 <embed href="text/scalc/01/06040000.xhp#zielwertsuchetext"/>
 <embed href="text/scalc/01/solver.xhp#solverhead"/>
 <embed href="text/scalc/01/06030000.xhp#detektiv"/>
 
-<paragraph id="hd_id3155768" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/06050000.xhp" name="Scenarios">Scenarios</link></paragraph>
+<h2 id="hd_id3155768"><link href="text/scalc/01/06050000.xhp" name="Scenarios">Scenarios</link></h2>
 <embed href="text/scalc/01/06050000.xhp#szenariotext"/>
 <embed href="text/scalc/01/06060000.xhp#dokumentschuetzen"/>
 <embed href="text/shared/01/06130001.xhp#macro"/>
 <embed href="text/shared/01/packagemanager.xhp#packagemanager"/>
 <embed href="text/shared/01/06150000.xhp#xmlfilter"/>
 
-<paragraph id="hd_id3150086" role="heading" level="2" xml-lang="en-US"><link href="text/shared/01/06140000.xhp" name="Customize">Customize</link></paragraph>
+<h2 id="hd_id3150086"><link href="text/shared/01/06140000.xhp" name="Customize">Customize</link></h2>
 <embed href="text/shared/01/06140000.xhp#anpassen"/>
 <embed href="text/shared/optionen/01000000.xhp#options"/>
 </body>
diff --git a/source/text/scalc/main0107.xhp b/source/text/scalc/main0107.xhp
index 98cc202d2..5f766eecd 100644
--- a/source/text/scalc/main0107.xhp
+++ b/source/text/scalc/main0107.xhp
@@ -31,7 +31,7 @@
 <section id="window">
 <bookmark xml-lang="en-US" branch="hid/.uno:WindowList" id="bm_id6907559" localize="false"/>
 
-<paragraph id="hd_id3154758" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/main0107.xhp" name="Window">Window</link></paragraph>
+<h1 id="hd_id3154758"><link href="text/scalc/main0107.xhp" name="Window">Window</link></h1>
 <paragraph id="par_id3150398" role="paragraph" xml-lang="en-US"><ahelp hid=".">Contains commands for manipulating and displaying document windows.</ahelp></paragraph>
 </section>
 <embed href="text/shared/01/07010000.xhp#newwindow"/>
@@ -39,4 +39,4 @@
 <embed href="text/shared/01/07080000.xhp#document_list"/>
 </body>
 
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index 63be6127b..84036c545 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -31,12 +31,12 @@
 <section id="sheet">
 <bookmark xml-lang="en-US" branch="hid/.uno:SheetMenu" id="bm_id0906201507425254" localize="false"/>
 
-<paragraph id="hd_id0906201507390173" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/main0116.xhp">Sheet</link></paragraph>
+<h1 id="hd_id0906201507390173"><link href="text/scalc/main0116.xhp">Sheet</link></h1>
 <paragraph id="par_id0906201507414091" role="paragraph" xml-lang="en-US"><ahelp hid=".">This menu contains commands to modify and manage a sheet and its elements.</ahelp></paragraph>
 </section>
-<paragraph id="par_id0906201507414191"  role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/04030000.xhp" name="Insert Rows">Insert Rows</link></paragraph>
+<h2 id="par_id0906201507414191"><link href="text/scalc/01/04030000.xhp" name="Insert Rows">Insert Rows</link></h2>
 <embed href="text/scalc/01/04030000.xhp#sheet_insert_rows"/>
-<paragraph id="par_id0906201507414192"  role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/04040000.xhp" name="Insert Columns">Insert Columns</link></paragraph>
+<h2 id="par_id0906201507414192"><link href="text/scalc/01/04040000.xhp" name="Insert Columns">Insert Columns</link></h2>
 <embed href="text/scalc/01/04040000.xhp#sheet_insert_columns"/>
 <embed href="text/scalc/01/04010000.xhp#ins_page_break"/>
 
@@ -45,20 +45,20 @@
 <embed href="text/scalc/01/02140000.xhp#fill"/>
 <embed href="text/scalc/01/02150000.xhp#del_contents"/>
 
-<paragraph id="hd_id3150792" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/02180000.xhp" name="Move/Copy">Move or Copy Sheet</link></paragraph>
+<h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp" name="Move/Copy">Move or Copy Sheet</link></h2>
 <embed href="text/scalc/01/02180000.xhp#tabelleverschiebenkopierentext"/>
 
-<paragraph id="hd_id3153968" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/05050300.xhp" name="Show">Show Sheet</link></paragraph>
+<h2 id="hd_id3153968"><link href="text/scalc/01/05050300.xhp" name="Show">Show Sheet</link></h2>
 <embed href="text/scalc/01/05050300.xhp#tabeintext"/>
 
-<paragraph id="hd_id3163708" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/02170000.xhp" name="Delete">Delete Sheet</link></paragraph>
+<h2 id="hd_id3163708"><link href="text/scalc/01/02170000.xhp" name="Delete">Delete Sheet</link></h2>
 <embed href="text/scalc/01/02170000.xhp#tabelleloeschentext"/>
 
-<paragraph id="hd_id3163735308" role="heading" level="2" xml-lang="en-US">Sheet Tab Color</paragraph>
+<h2 id="hd_id3163735308">Sheet Tab Color</h2>
 <embed href="text/scalc/guide/multitables.xhp#sheettabcolor"/>
 
-<paragraph id="hd_id3163733308" role="heading" level="2" xml-lang="en-US"><link href="text/shared/01/06140500.xhp" name="Events">Sheet Events</link></paragraph>
+<h2 id="hd_id3163733308"><link href="text/shared/01/06140500.xhp" name="Events">Sheet Events</link></h2>
 <embed href="text/shared/01/06140500.xhp#assignaction"/>
 </body>
 
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/main0200.xhp b/source/text/scalc/main0200.xhp
index 38426a02e..9c975a8d7 100644
--- a/source/text/scalc/main0200.xhp
+++ b/source/text/scalc/main0200.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0200xml" indexer="include" status="PUBLISH">
@@ -31,8 +28,8 @@
 </meta>
 <body>
 <section id="toolbars">
-<paragraph role="heading" id="hd_id3154758" xml-lang="en-US" level="1"><variable id="main0200"><link href="text/scalc/main0200.xhp" name="Toolbars">Toolbars</link>
-</variable></paragraph>
+<h1 id="hd_id3154758"><variable id="main0200"><link href="text/scalc/main0200.xhp" name="Toolbars">Toolbars</link>
+</variable></h1>
 <paragraph role="paragraph" id="par_id3148798" xml-lang="en-US">This submenu lists the toolbars that are available in spreadsheets.<embedvar href="text/shared/00/00000007.xhp#symbolleistenneu"/>
 </paragraph>
 </section>
diff --git a/source/text/scalc/main0203.xhp b/source/text/scalc/main0203.xhp
index c23d23a9f..816353fe2 100644
--- a/source/text/scalc/main0203.xhp
+++ b/source/text/scalc/main0203.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0203xml" indexer="include" status="PUBLISH">
@@ -32,25 +29,25 @@
 <body>
 <section id="beiselektiertemobjekt">
 <bookmark xml-lang="en-US" branch="hid/HID_SC_TOOLBOX_DRAW" id="bm_id3150400" localize="false"/>
-<paragraph role="heading" id="hd_id3154346" xml-lang="en-US" level="1"><link href="text/scalc/main0203.xhp" name="Drawing Object Properties Bar">Drawing Object Properties Bar</link></paragraph>
+<h1 id="hd_id3154346"><link href="text/scalc/main0203.xhp" name="Drawing Object Properties Bar">Drawing Object Properties Bar</link></h1>
 <paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp hid="HID_SC_TOOLBOX_DRAW">The <emph>Drawing Object Properties</emph> Bar for objects that you select in the sheet contains formatting and alignment commands.</ahelp></paragraph>
 </section>
 <embed href="text/shared/01/05200000.xhp#line"/>
 <embed href="text/shared/00/00040502.xhp#syline"/>
 <embed href="text/shared/02/05020000.xhp#arrow_style"/>
 <embed href="text/shared/02/05020000.xhp#syarrow_style"/>
-<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2"><link href="text/shared/01/05200100.xhp" name="Line Style">Line Style</link></paragraph>
+<h2 id="hd_id3145748"><link href="text/shared/01/05200100.xhp" name="Line Style">Line Style</link></h2>
 <embed href="text/shared/01/05200100.xhp#stiltext"/>
 <embed href="text/shared/00/00000004.xhp#syline_style"/>
-<paragraph role="heading" id="hd_id3151073" xml-lang="en-US" level="2"><link href="text/shared/01/05200100.xhp" name="Line Width">Line Width</link></paragraph>
+<h2 id="hd_id3151073"><link href="text/shared/01/05200100.xhp" name="Line Width">Line Width</link></h2>
 <embed href="text/shared/01/05200100.xhp#breitetext"/>
 <embed href="text/shared/00/00000004.xhp#syline_width"/>
-<paragraph role="heading" id="hd_id3153417" xml-lang="en-US" level="2"><link href="text/shared/01/05200100.xhp" name="Line Color">Line Color</link></paragraph>
+<h2 id="hd_id3153417"><link href="text/shared/01/05200100.xhp" name="Line Color">Line Color</link></h2>
 <embed href="text/shared/01/05200100.xhp#farbetext"/>
 <embed href="text/shared/00/00000004.xhp#syline_color"/>
 <embed href="text/shared/01/05210000.xhp#area"/>
 <embed href="text/shared/00/00040502.xhp#syarea"/>
-<paragraph role="heading" id="hd_id3147338" xml-lang="en-US" level="2"><link href="text/shared/01/05210100.xhp" name="Background Color">Background Color</link></paragraph>
+<h2 id="hd_id3147338"><link href="text/shared/01/05210100.xhp" name="Background Color">Background Color</link></h2>
 <embed href="text/shared/01/05210100.xhp#sytext"/>
 <embed href="text/shared/00/00000004.xhp#syarea_style"/>
 <embed href="text/shared/02/05090000.xhp#rotate"/>
diff --git a/source/text/scalc/main0205.xhp b/source/text/scalc/main0205.xhp
index ca538ea04..22d11c2d4 100644
--- a/source/text/scalc/main0205.xhp
+++ b/source/text/scalc/main0205.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0205xml" indexer="include" status="PUBLISH">
@@ -32,7 +29,7 @@
 <body>
 <section id="beitextcursorinobjekt">
 <bookmark xml-lang="en-US" branch="hid/HID_SC_TOOLBOX_DRTEXT" id="bm_id3147265" localize="false"/>
-<paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="1"><link href="text/scalc/main0205.xhp" name="Text Formatting Bar">Text Formatting Bar</link></paragraph>
+<h1 id="hd_id3156330"><link href="text/scalc/main0205.xhp" name="Text Formatting Bar">Text Formatting Bar</link></h1>
 <paragraph role="paragraph" id="par_id3151112" xml-lang="en-US"><ahelp hid="HID_SC_TOOLBOX_DRTEXT">The <emph>Text Formatting</emph> Bar that is displayed when the cursor is in a text object, such as a text box or a drawing object, contains formatting and alignment commands.</ahelp></paragraph>
 </section>
 <embed href="text/shared/02/02020000.xhp#font_name"/>
@@ -45,40 +42,40 @@
 <embed href="text/shared/00/00040502.xhp#syitalic"/>
 <embed href="text/shared/01/05110300.xhp#underline"/>
 <embed href="text/shared/00/00040502.xhp#syunderline"/>
-<paragraph role="heading" id="hd_id3148575" xml-lang="en-US" level="2"><link href="text/shared/01/05020200.xhp" name="Font Color">Font Color</link></paragraph>
+<h2 id="hd_id3148575"><link href="text/shared/01/05020200.xhp" name="Font Color">Font Color</link></h2>
 <embed href="text/shared/01/05020200.xhp#textfarbe"/>
 <embed href="text/shared/00/00000004.xhp#syfont_color"/>
-<paragraph role="heading" id="hd_id3154944" xml-lang="en-US" level="2"><link href="text/shared/01/05030100.xhp" name="Line Spacing: 1">Line Spacing: 1</link></paragraph>
+<h2 id="hd_id3154944"><link href="text/shared/01/05030100.xhp" name="Line Spacing: 1">Line Spacing: 1</link></h2>
 <embed href="text/shared/01/05030100.xhp#einzeiligtext"/>
 <embed href="text/shared/00/00000004.xhp#sysingle_line"/>
-<paragraph role="heading" id="hd_id3146969" xml-lang="en-US" level="2"><link href="text/shared/01/05030100.xhp" name="Line Spacing: 1.5">Line Spacing: 1.5</link></paragraph>
+<h2 id="hd_id3146969"><link href="text/shared/01/05030100.xhp" name="Line Spacing: 1.5">Line Spacing: 1.5</link></h2>
 <embed href="text/shared/01/05030100.xhp#eineinhalbzeiligtext"/>
 <embed href="text/shared/00/00000004.xhp#syone_point_five_lines"/>
-<paragraph role="heading" id="hd_id3153711" xml-lang="en-US" level="2"><link href="text/shared/01/05030100.xhp" name="Line Spacing: 2">Line Spacing: 2</link></paragraph>
+<h2 id="hd_id3153711"><link href="text/shared/01/05030100.xhp" name="Line Spacing: 2">Line Spacing: 2</link></h2>
 <embed href="text/shared/01/05030100.xhp#zweizeiligtext"/>
 <embed href="text/shared/00/00000004.xhp#sydouble_line"/>
-<paragraph role="heading" id="hd_id3147345" xml-lang="en-US" level="2"><link href="text/shared/01/05030700.xhp" name="Align Left">Align Left</link></paragraph>
+<h2 id="hd_id3147345"><link href="text/shared/01/05030700.xhp" name="Align Left">Align Left</link></h2>
 <embed href="text/shared/01/05030700.xhp#linkstext"/>
 <embed href="text/shared/00/00040502.xhp#syalign_left"/>
-<paragraph role="heading" id="hd_id3155337" xml-lang="en-US" level="2"><link href="text/shared/01/05030700.xhp" name="Centered">Centered</link></paragraph>
+<h2 id="hd_id3155337"><link href="text/shared/01/05030700.xhp" name="Centered">Centered</link></h2>
 <embed href="text/shared/01/05030700.xhp#zentrierttext"/>
 <embed href="text/shared/00/00040502.xhp#sycenter"/>
-<paragraph role="heading" id="hd_id3147001" xml-lang="en-US" level="2"><link href="text/shared/01/05030700.xhp" name="Align Right">Align Right</link></paragraph>
+<h2 id="hd_id3147001"><link href="text/shared/01/05030700.xhp" name="Align Right">Align Right</link></h2>
 <embed href="text/shared/01/05030700.xhp#rechtstext"/>
 <embed href="text/shared/00/00040502.xhp#syalign_right"/>
-<paragraph role="heading" id="hd_id3155115" xml-lang="en-US" level="2"><link href="text/shared/01/05030700.xhp" name="Justify">Justify</link></paragraph>
+<h2 id="hd_id3155115"><link href="text/shared/01/05030700.xhp" name="Justify">Justify</link></h2>
 <embed href="text/shared/01/05030700.xhp#blocksatztext"/>
 <embed href="text/shared/00/00040502.xhp#syblocksatz"/>
-<paragraph role="heading" id="hd_id3150202" xml-lang="en-US" level="2"><link href="text/shared/01/05020500.xhp" name="Superscript">Superscript</link></paragraph>
+<h2 id="hd_id3150202"><link href="text/shared/01/05020500.xhp" name="Superscript">Superscript</link></h2>
 <embed href="text/shared/01/05020500.xhp#hochtext"/>
 <embed href="text/shared/00/00000004.xhp#sysuperscript"/>
-<paragraph role="heading" id="hd_id3155531" xml-lang="en-US" level="2"><link href="text/shared/01/05020500.xhp" name="Subscript">Subscript</link></paragraph>
+<h2 id="hd_id3155531"><link href="text/shared/01/05020500.xhp" name="Subscript">Subscript</link></h2>
 <embed href="text/shared/01/05020500.xhp#tieftext"/>
 <embed href="text/shared/00/00000004.xhp#sysubscript"/>
-<paragraph role="heading" id="hd_id3145387" xml-lang="en-US" level="2"><link href="text/shared/01/05020000.xhp" name="Character">Character</link></paragraph>
+<h2 id="hd_id3145387"><link href="text/shared/01/05020000.xhp" name="Character">Character</link></h2>
 <embed href="text/shared/01/05020000.xhp#zeichentext"/>
 <embed href="text/shared/00/00040500.xhp#sycharacter"/>
-<paragraph role="heading" id="hd_id3153067" xml-lang="en-US" level="2"><link href="text/shared/01/05030000.xhp" name="Paragraph">Paragraph</link></paragraph>
+<h2 id="hd_id3153067"><link href="text/shared/01/05030000.xhp" name="Paragraph">Paragraph</link></h2>
 <embed href="text/shared/01/05030000.xhp#absatztext"/>
 <embed href="text/shared/00/00040500.xhp#syparagraph"/>
 <embed href="text/shared/00/00000007.xhp#asia"/>
diff --git a/source/text/scalc/main0206.xhp b/source/text/scalc/main0206.xhp
index b399939a7..d5f058227 100644
--- a/source/text/scalc/main0206.xhp
+++ b/source/text/scalc/main0206.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0206xml" indexer="include" status="PUBLISH">
@@ -33,7 +30,7 @@
 <section id="rechenleiste">
 <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_INPUTWIN" id="bm_id3154347" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/.uno:FocusInputLine" id="bm_id7657094" localize="false"/>
-<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1"><link href="text/scalc/main0206.xhp" name="Formula Bar">Formula Bar</link></paragraph>
+<h1 id="hd_id3147264"><link href="text/scalc/main0206.xhp" name="Formula Bar">Formula Bar</link></h1>
 <paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp hid="HID_SC_INPUTWIN">Use this bar to enter formulas.</ahelp></paragraph>
 </section>
 <embed href="text/scalc/02/06010000.xhp#tabellenbereich"/>
diff --git a/source/text/scalc/main0208.xhp b/source/text/scalc/main0208.xhp
index cc4d70d5c..fffcdb237 100644
--- a/source/text/scalc/main0208.xhp
+++ b/source/text/scalc/main0208.xhp
@@ -28,7 +28,7 @@
    </meta>
    <body>
       <section id="statusleiste">
-         <paragraph xml-lang="en-US" id="hd_id3151385" role="heading" level="1"><link href="text/scalc/main0208.xhp" name="Status Bar">Status Bar</link></paragraph>
+         <h1 id="hd_id3151385"><link href="text/scalc/main0208.xhp" name="Status Bar">Status Bar</link></h1>
          <paragraph xml-lang="en-US" id="par_id3149669" role="paragraph">The <emph>Status Bar</emph> displays information about the current sheet.</paragraph>
       </section>
       <embed href="text/scalc/02/08010000.xhp#position_in_document"/>
@@ -37,8 +37,8 @@
       <embed href="text/shared/02/20040000.xhp#insert_mode"/>
       <embed href="text/shared/02/20050000.xhp#selection_mode"/>
       <embed href="text/shared/02/20060000.xhp#document_modification"/>
-      <paragraph xml-lang="en-US" id="hd_id0821200911024321" role="heading" level="2">Digital Signature</paragraph>
+      <h2 id="hd_id0821200911024321">Digital Signature</h2>
       <paragraph xml-lang="en-US" id="par_id0821200911024344" role="paragraph">See also <link href="text/shared/guide/digital_signatures.xhp">Digital Signatures</link>.</paragraph>
       <embed href="text/scalc/02/08080000.xhp#date_time"/>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/main0214.xhp b/source/text/scalc/main0214.xhp
index 75fe53fb5..6aaa57760 100644
--- a/source/text/scalc/main0214.xhp
+++ b/source/text/scalc/main0214.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0214xml" indexer="include" status="PUBLISH">
@@ -31,7 +28,7 @@
 </meta>
 <body>
 <section id="imagebar">
-<paragraph role="heading" id="hd_id3153088" xml-lang="en-US" level="1"><link href="text/scalc/main0214.xhp" name="Image Bar">Image Bar</link></paragraph>
+<h1 id="hd_id3153088"><link href="text/scalc/main0214.xhp" name="Image Bar">Image Bar</link></h1>
 <paragraph role="paragraph" id="par_id3153896" xml-lang="en-US"><ahelp hid=".">The <emph>Image</emph> bar is displayed when you insert or select an image in a sheet.</ahelp></paragraph>
 </section>
 <embed href="text/shared/02/24010000.xhp#filter"/>
diff --git a/source/text/scalc/main0218.xhp b/source/text/scalc/main0218.xhp
index 8466c1329..69a7c7b33 100644
--- a/source/text/scalc/main0218.xhp
+++ b/source/text/scalc/main0218.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0218xml" indexer="include" status="PUBLISH">
@@ -32,7 +29,7 @@
 <body>
 <section id="toolsbar">
 <!-- removed HID HID_SC_TOOLBOX_TOOLS -->
-<paragraph role="heading" id="hd_id3143268" xml-lang="en-US" level="1"><link href="text/scalc/main0218.xhp" name="Tools Bar">Tools Bar</link></paragraph>
+<h1 id="hd_id3143268"><link href="text/scalc/main0218.xhp" name="Tools Bar">Tools Bar</link></h1>
 <paragraph role="paragraph" id="par_id3151112" xml-lang="en-US"><ahelp hid="HID_SC_TOOLBOX_TOOLS">Use the Tools bar to access commonly used commands.</ahelp></paragraph>
 </section>
 <embed href="text/scalc/02/18010000.xhp#insert"/>
@@ -40,28 +37,28 @@
 <embed href="text/scalc/02/18020000.xhp#zelleneinfuegen"/>
 <embed href="text/scalc/00/00000404.xhp#syzelleneinfuegen"/>
 <bookmark xml-lang="en-US" branch="hid/.uno:InsObjCtrl" id="bm_id2513504" localize="false"/>
-<paragraph role="heading" id="par_idN10610" xml-lang="en-US" level="2"><link href="text/shared/02/01170000.xhp" name="Controls">Controls</link></paragraph>
+<h2 id="par_idN10610"><link href="text/shared/02/01170000.xhp" name="Controls">Controls</link></h2>
 <embed href="text/shared/02/01170000.xhp#formulartext"/>
 <embed href="text/shared/02/01170000.xhp#syform_controls"/>
 <embed href="text/scalc/01/05110000.xhp#autoformat"/>
 <embed href="text/scalc/01/05110000.xhp#autoformattext"/>
 <embed href="text/scalc/00/00000405.xhp#syautoformat"/>
-<paragraph role="heading" id="hd_id3154730" xml-lang="en-US" level="2"><link href="text/scalc/02/06080000.xhp" name="Choose Themes">Choose Themes</link></paragraph>
+<h2 id="hd_id3154730"><link href="text/scalc/02/06080000.xhp" name="Choose Themes">Choose Themes</link></h2>
 <embed href="text/scalc/02/06080000.xhp#thementext"/>
 <embed href="text/scalc/02/06080000.xhp#sythemen"/>
 <embed href="text/scalc/01/12040100.xhp#autofilter"/>
 <embed href="text/scalc/00/00000412.xhp#syautofilter"/>
 <embed href="text/shared/02/12090000.xhp#standardfilter1"/>
 <embed href="text/shared/02/12090000.xhp#systandardfilter"/>
-<paragraph role="heading" id="par_idN10690" xml-lang="en-US" level="2"><link href="text/scalc/01/12040300.xhp" name="Advanced Filter">Advanced Filter</link></paragraph>
+<h2 id="par_idN10690"><link href="text/scalc/01/12040300.xhp" name="Advanced Filter">Advanced Filter</link></h2>
 <embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
-<paragraph role="heading" id="par_idN106A8" xml-lang="en-US" level="2"><link href="text/scalc/01/12090100.xhp">Start</link></paragraph>
+<h2 id="par_idN106A8"><link href="text/scalc/01/12090100.xhp">Start</link></h2>
 <embed href="text/scalc/01/12090100.xhp#datenpilot"/>
-<paragraph role="heading" id="par_idN106C0" xml-lang="en-US" level="2"><link href="text/shared/autopi/01150000.xhp" name="Euro Converter">Euro Converter</link></paragraph>
+<h2 id="par_idN106C0"><link href="text/shared/autopi/01150000.xhp" name="Euro Converter">Euro Converter</link></h2>
 <embed href="text/shared/autopi/01150000.xhp#eurokonv"/>
-<paragraph role="heading" id="par_idN106D8" xml-lang="en-US" level="2"><link href="text/scalc/01/04070100.xhp">Define</link></paragraph>
+<h2 id="par_idN106D8"><link href="text/scalc/01/04070100.xhp">Define</link></h2>
 <embed href="text/scalc/01/04070100.xhp#namenfestlegentext"/>
-<paragraph role="heading" id="par_idN106F0" xml-lang="en-US" level="2"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></paragraph>
+<h2 id="par_idN106F0"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></h2>
 <embed href="text/scalc/01/06040000.xhp#zielwertsuchetext"/>
 <embed href="text/scalc/01/12080300.xhp#group"/>
 <embed href="text/scalc/01/12080300.xhp#gruppierung"/>
diff --git a/source/text/scalc/main0503.xhp b/source/text/scalc/main0503.xhp
index 6176b31a1..27e04b5f8 100644
--- a/source/text/scalc/main0503.xhp
+++ b/source/text/scalc/main0503.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcmain0503xml" indexer="include" status="PUBLISH">
@@ -33,22 +30,22 @@
   
   
   <section id="features">
-  <paragraph id="hd_id3154758" role="heading" level="1" xml-lang="en-US"><variable id="main0503"><link href="text/scalc/main0503.xhp" name="$[officename] Calc Features">$[officename] Calc Features</link></variable></paragraph>
+  <h1 id="hd_id3154758"><variable id="main0503"><link href="text/scalc/main0503.xhp" name="$[officename] Calc Features">$[officename] Calc Features</link></variable></h1>
   <paragraph role="paragraph" id="par_id3149457" xml-lang="en-US">$[officename] Calc is a spreadsheet application that you can use to calculate, analyze, and manage your data. You can also import and modify Microsoft Excel spreadsheets.</paragraph>
   </section>
-  <paragraph role="heading" level="2" id="hd_id3148797" xml-lang="en-US">Calculations</paragraph>
+  <h2 id="hd_id3148797">Calculations</h2>
   <paragraph xml-lang="en-US" role="paragraph" id="par_id3145172">$[officename] Calc provides you with <link href="text/scalc/01/04060100.xhp" name="functions">functions</link>, including statistical and banking functions, that you can use to create formulas to perform complex calculations on your data.</paragraph>
   <paragraph xml-lang="en-US" role="paragraph" id="par_id3145271">You can also use the <link href="text/scalc/01/04060000.xhp" name="AutoPilots">Function Wizard</link> to help you create your formulas.</paragraph>
-  <paragraph role="heading" level="2" id="hd_id3152596" xml-lang="en-US">What-If Calculations</paragraph>
+  <h2 id="hd_id3152596">What-If Calculations</h2>
   <paragraph role="paragraph" id="par_id3156444" xml-lang="en-US">An interesting feature is to be able to immediately view the results of changes made to one factor of calculations that are composed of several factors. For instance, you can see how changing the time period in a loan calculation affects the interest rates or repayment amounts. Furthermore, you can manage larger tables by using different predefined scenarios.</paragraph>
-  <paragraph role="heading" level="2" id="hd_id3148576" xml-lang="en-US">Database Functions</paragraph>
+  <h2 id="hd_id3148576">Database Functions</h2>
   <paragraph role="paragraph" id="par_id3154011" xml-lang="en-US">Use spreadsheets to arrange, store, and filter your data.</paragraph>
   <paragraph role="paragraph" id="par_id3154942" xml-lang="en-US">$[officename] Calc lets you drag-and-drop tables from databases, or lets you use a spreadsheet as a data source for creating form letters in $[officename] Writer.</paragraph>
-  <paragraph role="heading" level="2" id="hd_id3145800" xml-lang="en-US">Arranging Data</paragraph>
+  <h2 id="hd_id3145800">Arranging Data</h2>
   <paragraph role="paragraph" id="par_id3154490" xml-lang="en-US">With a few mouse-clicks, you can reorganize your spreadsheet to show or hide certain data ranges, or to format ranges according to special conditions, or to quickly calculate subtotals and totals.</paragraph>
-  <paragraph role="heading" level="2" id="hd_id3155601" xml-lang="en-US">Dynamic Charts</paragraph>
+  <h2 id="hd_id3155601">Dynamic Charts</h2>
   <paragraph role="paragraph" id="par_id3149121" xml-lang="en-US">$[officename] Calc lets you present spreadsheet data in dynamic charts that update automatically when the data changes.</paragraph>
-  <paragraph role="heading" level="2" id="hd_id3153707" xml-lang="en-US">Opening and Saving Microsoft Files</paragraph>
+  <h2 id="hd_id3153707">Opening and Saving Microsoft Files</h2>
   <paragraph xml-lang="en-US" role="paragraph" id="par_id3157867">Use the $[officename] filters to convert Excel files, or to open and save in a variety of other <link href="text/shared/00/00000020.xhp" name="formats">formats</link>.</paragraph>
  </body>
 </helpdocument>


More information about the Libreoffice-commits mailing list