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.hal...@libreoffice.org>
AuthorDate: Sun Jul 18 13:16:29 2021 -0300
Commit: Olivier Hallot <olivier.hal...@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.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
