summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2020-03-20 11:01:08 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-03-20 15:16:11 +0100
commit562631aa3b0f0a6055e899e8b36491bee52fcb73 (patch)
treef5d3868ab496a5edd32df4be654af0d5264cb3ba /source/text/scalc
parentea72cf580abb767685e2fa6d9e5b9ef895eed06b (diff)
Review, refactor Calc Data Menu Help pages
- update to latest menu entries - embed headings from individual Help files - WIP: Statistics menu entry will come later Change-Id: I66a2627b7bea65945210b6dcc2d1c3ed8783aec9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90796 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/00/00000412.xhp324
-rw-r--r--source/text/scalc/01/06070000.xhp5
-rw-r--r--source/text/scalc/01/06080000.xhp6
-rw-r--r--source/text/scalc/01/12010000.xhp18
-rw-r--r--source/text/scalc/01/12020000.xhp14
-rw-r--r--source/text/scalc/01/12030000.xhp9
-rw-r--r--source/text/scalc/01/12030100.xhp25
-rw-r--r--source/text/scalc/01/12040000.xhp13
-rw-r--r--source/text/scalc/01/12040100.xhp9
-rw-r--r--source/text/scalc/01/12050000.xhp14
-rw-r--r--source/text/scalc/01/12060000.xhp20
-rw-r--r--source/text/scalc/01/12070000.xhp21
-rw-r--r--source/text/scalc/01/12090000.xhp7
-rw-r--r--source/text/scalc/01/12100000.xhp9
-rw-r--r--source/text/scalc/01/12120000.xhp9
-rw-r--r--source/text/scalc/01/calculate.xhp31
-rw-r--r--source/text/scalc/01/data_form.xhp26
-rw-r--r--source/text/scalc/01/data_provider.xhp7
-rw-r--r--source/text/scalc/01/live_data_stream.xhp6
-rw-r--r--source/text/scalc/01/text2columns.xhp22
-rw-r--r--source/text/scalc/01/xml_source.xhp23
-rw-r--r--source/text/scalc/guide/autofilter.xhp5
-rw-r--r--source/text/scalc/main0112.xhp47
23 files changed, 345 insertions, 325 deletions
diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp
index 476ce5e28..c6de85323 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -1,162 +1,172 @@
<?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 .
- -->
+ <!--
+ * 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="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Data Menu</title>
- <filename>/text/scalc/00/00000412.xhp</filename>
- </topic>
-</meta>
-<body>
-<paragraph role="heading" id="hd_id3145136" xml-lang="en-US" level="1">Data Menu</paragraph>
-<paragraph role="paragraph" id="par_id8366954" xml-lang="en-US"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150443" xml-lang="en-US"><variable id="dnsrt">Choose <emph>Data - Sort...</emph>.</variable></paragraph>
-<section id="dnsosk">
-<paragraph role="paragraph" id="par_id3148491" xml-lang="en-US">Choose <emph>Data - Sort - Sort Criteria</emph> tab.</paragraph>
- <paragraph role="paragraph" id="par_id3154516" xml-lang="en-US">On <emph>Standard</emph> bar, click</paragraph>
-<section id="sysortieren">
-<table id="tbl_id3156023">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US">
-<image id="img_id3150543" src="cmd/sc_sortup.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3150543" xml-lang="en-US">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">Sort Ascending</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US">
-<image id="img_id3125863" src="cmd/sc_sortdown.png" width="0.1701inch" height="0.1701inch"><alt id="alt_id3125863" xml-lang="en-US">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US">Sort Descending</paragraph>
-</tablecell>
-</tablerow>
-</table>
-</section>
-</section>
-<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155308" xml-lang="en-US"><variable id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph>
-<section id="dnfiafi">
-<paragraph role="paragraph" id="par_id3148646" xml-lang="en-US">Choose <emph>Data - AutoFilter</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US">On <emph>Tools</emph> bar or <emph>Table Data</emph> bar, click</paragraph>
-<section id="syautofilter">
-<table id="tbl_id3155418">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US">
-<image id="img_id3149413" src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US">AutoFilter</paragraph>
-</tablecell>
-</tablerow>
-</table>
-</section>
-</section>
-<paragraph role="paragraph" id="par_id3156278" xml-lang="en-US"><variable id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph> .</variable></paragraph>
-<section id="filterzus">
-<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US">Choose <emph>Data - More Filters - Standard Filter... - Options</emph> label.</paragraph>
-<paragraph role="paragraph" id="par_id3155444" xml-lang="en-US">Choose <emph>Data - More Filters - Advanced Filter... - Options</emph> label.</paragraph>
-</section>
-<section id="dnfief">
-<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US">Choose <emph>Data - More Filters - Reset Filter</emph>.</paragraph>
- <paragraph role="paragraph" id="par_id3155961" xml-lang="en-US">On <emph>Table Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph>
-<table id="tbl_id3146919">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US">
-<image id="img_id3145792" src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149207" xml-lang="en-US">Reset Filter/Sort</paragraph>
-</tablecell>
-</tablerow>
-</table>
-</section>
-<paragraph role="paragraph" id="par_id3152778" xml-lang="en-US"><variable id="dnaftas">Choose <emph>Data - More Filter - Hide AutoFilter</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3166424" xml-lang="en-US"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154574" xml-lang="en-US"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3145133" xml-lang="en-US"><variable id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150367" xml-lang="en-US"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3146978" xml-lang="en-US"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3148701" xml-lang="en-US"><variable id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3159223" xml-lang="en-US"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph>
-<section id="dnglgr">
-<paragraph role="paragraph" id="par_id3146870" xml-lang="en-US">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US">F12</paragraph>
-<paragraph role="paragraph" id="par_id3144772" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph>
-<section id="sygruppieren">
-<table id="tbl_id3154532">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149438" xml-lang="en-US">
-<image id="img_id3153287" src="cmd/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Group</paragraph>
-</tablecell>
-</tablerow>
-</table>
-</section>
-</section>
-<section id="dnglgra">
-<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US">Choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3150892" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
-<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph>
-<section id="sygruppierungaufheben">
-<table id="tbl_id3143223">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US">
-<image id="img_id3155914" src="cmd/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3153555" xml-lang="en-US">Ungroup</paragraph>
-</tablecell>
-</tablerow>
-</table>
-</section>
-</section>
-<paragraph role="paragraph" id="par_id3153008" xml-lang="en-US"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154709" xml-lang="en-US"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove Outline</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id1774346" xml-lang="en-US"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables).</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US"><variable id="dndpa">Choose <emph>Insert - Pivot Table</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147558" xml-lang="en-US"><variable id="dndq">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>.</variable></paragraph>
-<section id="dndpaz">
-<paragraph role="paragraph" id="par_id3153297" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Current selection</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3145118" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph>
-</section>
-<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150397" xml-lang="en-US"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph>
+ <meta>
+ <topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Data Menu</title>
+ <filename>/text/scalc/00/00000412.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <h1 id="hd_id3145136">Data Menu</h1>
+ <paragraph role="paragraph" id="par_id8366954" xml-lang="en-US"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3147399" xml-lang="en-US"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3145345" xml-lang="en-US"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3150443" xml-lang="en-US"><variable id="dnsrt">Choose <emph>Data - Sort...</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id641584647437810"><variable id="datasortascending">Choose <menuitem>Data - Sort Ascending</menuitem></variable></paragraph>
+ <paragraph role="paragraph" id="par_id711584647447316"><variable id="datasortdescending">Choose <menuitem>Data - Sort Descending</menuitem></variable></paragraph>
+ <section id="dnsosk">
+ <paragraph role="paragraph" id="par_id3148491" xml-lang="en-US">Choose <emph>Data - Sort - Sort Criteria</emph> tab.</paragraph>
+ <paragraph role="paragraph" id="par_id3154516" xml-lang="en-US"><variable id="onthestandardbar">On <emph>Standard</emph> bar, click</variable></paragraph>
+ <section id="sysortieren">
+ <section id="sortascending">
+ <table id="tbl_id3156023">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3148663" xml-lang="en-US">
+ <image id="img_id3150543" src="cmd/sc_sortup.png" width="1cm" height="1cm"><alt id="alt_id3150543" xml-lang="en-US">Icon Sort Ascending</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">Sort Ascending</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <section id="sortdescending">
+ <table id="tbl_id3256023">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US">
+ <image id="img_id3125863" src="cmd/sc_sortdown.png" width="1cm" height="1cm"><alt id="alt_id3125863" xml-lang="en-US">Icon Sort Descending</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3145364" xml-lang="en-US">Sort Descending</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ </section>
+ <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3155308" xml-lang="en-US"><variable id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph>
+ <section id="dnfiafi">
+ <paragraph role="paragraph" id="par_id3148646" xml-lang="en-US">Choose <emph>Data - AutoFilter</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3151113" xml-lang="en-US">On <emph>Tools</emph> bar or <emph>Table Data</emph> bar, click</paragraph>
+ <section id="syautofilter">
+ <table id="tbl_id3155418">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3145799" xml-lang="en-US">
+ <image id="img_id3149413" src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149401" xml-lang="en-US">AutoFilter</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ <paragraph role="paragraph" id="par_id3156278" xml-lang="en-US"><variable id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph> .</variable></paragraph>
+ <section id="filterzus">
+ <paragraph role="paragraph" id="par_id3153764" xml-lang="en-US">Choose <emph>Data - More Filters - Standard Filter... - Options</emph> label.</paragraph>
+ <paragraph role="paragraph" id="par_id3155444" xml-lang="en-US">Choose <emph>Data - More Filters - Advanced Filter... - Options</emph> label.</paragraph>
+ </section>
+ <section id="dnfief">
+ <paragraph role="paragraph" id="par_id3156382" xml-lang="en-US">Choose <emph>Data - More Filters - Reset Filter</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3155961" xml-lang="en-US">On <emph>Table Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph>
+ <table id="tbl_id3146919">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3148485" xml-lang="en-US">
+ <image id="img_id3145792" src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149207" xml-lang="en-US">Reset Filter/Sort</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <paragraph role="paragraph" id="par_id3152778" xml-lang="en-US"><variable id="dnaftas">Choose <emph>Data - More Filter - Hide AutoFilter</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3166424" xml-lang="en-US"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154574" xml-lang="en-US"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3151277" xml-lang="en-US"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3145133" xml-lang="en-US"><variable id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3152992" xml-lang="en-US"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3150367" xml-lang="en-US"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154486" xml-lang="en-US"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3146978" xml-lang="en-US"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3148701" xml-lang="en-US"><variable id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3159223" xml-lang="en-US"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph>
+ <section id="dnglgr">
+ <paragraph role="paragraph" id="par_id3146870" xml-lang="en-US">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3144507" xml-lang="en-US">F12</paragraph>
+ <paragraph role="paragraph" id="par_id3144772" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph>
+ <section id="sygruppieren">
+ <table id="tbl_id3154532">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3149438" xml-lang="en-US">
+ <image id="img_id3153287" src="cmd/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Group</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ <section id="dnglgra">
+ <paragraph role="paragraph" id="par_id3146781" xml-lang="en-US">Choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3150892" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
+ <paragraph role="paragraph" id="par_id3155097" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph>
+ <section id="sygruppierungaufheben">
+ <table id="tbl_id3143223">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150048" xml-lang="en-US">
+ <image id="img_id3155914" src="cmd/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153555" xml-lang="en-US">Ungroup</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </section>
+ <paragraph role="paragraph" id="par_id3153008" xml-lang="en-US"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154709" xml-lang="en-US"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove Outline</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id1774346" xml-lang="en-US"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3155759" xml-lang="en-US"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3154625" xml-lang="en-US"><variable id="dndpa">Choose <emph>Insert - Pivot Table</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3147558" xml-lang="en-US"><variable id="dndq">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>.</variable></paragraph>
+ <section id="dndpaz">
+ <paragraph role="paragraph" id="par_id3153297" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Current selection</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id3145118" xml-lang="en-US">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id3153294" xml-lang="en-US"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3151344" xml-lang="en-US"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3150397" xml-lang="en-US"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06070000.xhp b/source/text/scalc/01/06070000.xhp
index 4c3bf3ee2..cfd99329d 100644
--- a/source/text/scalc/01/06070000.xhp
+++ b/source/text/scalc/01/06070000.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="textscalc0106070000xml" indexer="include" status="PUBLISH">
@@ -37,7 +34,7 @@
<bookmark_value>cell contents;AutoCalculate function</bookmark_value>
</bookmark><comment>mw added "recalculating;..." </comment>
<bookmark xml-lang="en-US" branch="hid/.uno:AutomaticCalculation" id="bm_id6626340" localize="false"/>
-<paragraph role="heading" id="hd_id3145673" xml-lang="en-US" level="1"><link href="text/scalc/01/06070000.xhp" name="AutoCalculate">AutoCalculate</link></paragraph>
+<h1 id="hd_id3145673"><link href="text/scalc/01/06070000.xhp" name="AutoCalculate">AutoCalculate</link></h1>
<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US"><ahelp hid=".uno:AutomaticCalculation">Automatically recalculates all formulas in the document.</ahelp></paragraph>
</section>
<paragraph role="paragraph" id="par_id3145173" xml-lang="en-US">All cells are recalculated after a sheet cell has been modified. Any charts in the sheet will also be refreshed.</paragraph>
diff --git a/source/text/scalc/01/06080000.xhp b/source/text/scalc/01/06080000.xhp
index a699234c1..ddc72f6f2 100644
--- a/source/text/scalc/01/06080000.xhp
+++ b/source/text/scalc/01/06080000.xhp
@@ -19,7 +19,6 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<meta>
<topic id="textscalc0106080000xml" indexer="include">
<title id="tit" xml-lang="en-US">Recalculate</title>
@@ -34,7 +33,10 @@
<bookmark_value>cell contents; recalculating</bookmark_value>
</bookmark><comment>mw changed "recalculating;...", "formulas;..." and "cell..." entries and deleted "recalculating formulas"</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:Calculate" id="bm_id2661876" localize="false"/>
-<paragraph role="heading" id="hd_id3157909" xml-lang="en-US" level="1"><link href="text/scalc/01/06080000.xhp" name="Recalculate">Recalculate</link></paragraph>
+<section id="recalculateheader">
+<h1 id="hd_id3157909"><link href="text/scalc/01/06080000.xhp" name="Recalculate">Recalculate</link></h1>
+<paragraph role="paragraph" id="par_id951584669541929">Recalculates formula cells.</paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#exnb"/>
</section>
diff --git a/source/text/scalc/01/12010000.xhp b/source/text/scalc/01/12010000.xhp
index 32e295b4b..4706e8b58 100644
--- a/source/text/scalc/01/12010000.xhp
+++ b/source/text/scalc/01/12010000.xhp
@@ -30,26 +30,28 @@
<bookmark xml-lang="en-US" branch="hid/.uno:DefineDBName" id="bm_id6632476" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/DefineDatabaseRangeDialog" id="bm_id3147335" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/@@nowidget@@" id="bm_id3147335" localize="false"/>
-<paragraph role="heading" id="hd_id3157909" xml-lang="en-US" level="1">Define Database Range</paragraph>
-<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><variable id="bereichtext"><ahelp hid=".uno:DefineDBName">Defines a database range based on the selected cells in your sheet.</ahelp>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US">You can only select a rectangular cell range.</paragraph>
+<section id="defineDBrangeheader">
+<h1 id="hd_id3157909"><link href="text/scalc/01/12010000.xhp" name="Define Database Range">Define Range</link></h1>
+<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><variable id="bereichtext"><ahelp hid=".uno:DefineDBName">Defines a database range based on the selected cells in your sheet.</ahelp></variable></paragraph>
+</section>
+
+<note id="par_id3149456">You can only select a rectangular cell range.</note>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dbrbf"/>
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/entry" id="bm_id3150868" localize="false"/>
-<paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="2">Name</paragraph>
+<h2 id="hd_id3156422">Name</h2>
<paragraph role="paragraph" id="par_id3150770" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/entry">Enter a name for the database range that you want to define, or select an existing name from the list.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/assign" id="bm_id3155133" localize="false"/>
-<paragraph role="heading" id="hd_id3147228" xml-lang="en-US" level="2">Range</paragraph>
+<h2 id="hd_id3147228">Range</h2>
<paragraph role="paragraph" id="par_id3150441" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/assign">Displays the selected cell range.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/add" id="bm_id3153951" localize="false"/>
-<paragraph role="heading" id="hd_id3153188" xml-lang="en-US" level="2">Add/Modify</paragraph>
+<h2 id="hd_id3153188">Add/Modify</h2>
<paragraph role="paragraph" id="par_id3153726" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/add">Adds the selected cell range to the database range list, or modifies an existing database range.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#loeschen"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/more" id="bm_id3152596" localize="false"/>
-<paragraph role="heading" id="hd_id3150010" xml-lang="en-US" level="2">More &gt;&gt;</paragraph>
+<h2 id="hd_id3150010">More &gt;&gt;</h2>
<paragraph role="paragraph" id="par_id3153144" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/more">Shows additional <link href="text/scalc/01/12010100.xhp" name="options">options</link>.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12020000.xhp b/source/text/scalc/01/12020000.xhp
index 1e9241d7e..50b18d46c 100644
--- a/source/text/scalc/01/12020000.xhp
+++ b/source/text/scalc/01/12020000.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="textscalc0112020000xml" indexer="include" status="PUBLISH">
@@ -35,14 +32,17 @@
<bookmark xml-lang="en-US" branch="hid/.uno:SelectDB" id="bm_id2131630" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/SelectRangeDialog" id="bm_id3148946" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/@@nowidget@@" id="bm_id3148946" localize="false"/>
-<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1">Select Database Range</paragraph>
-<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp" name="Data - Define Range">Data - Define Range</link>.</ahelp>
-</variable></paragraph>
+
+<section id="selectDBheader">
+<h1 id="hd_id3145068"><link href="text/scalc/01/12020000.xhp" name="Select Database Range">Select Range</link></h1>
+<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp" name="Data - Define Range">Data - Define Range</link>.</ahelp></variable></paragraph>
+</section>
+
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dbrba"/>
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/treeview" id="bm_id3125865" localize="false"/>
-<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="2">Ranges</paragraph>
+<h2 id="hd_id3153192">Ranges</h2>
<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US"><ahelp hid="modules/scalc/ui/selectrange/treeview">Lists the available database ranges. To select a database range, click its name, and then click <emph>OK</emph>.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12030000.xhp b/source/text/scalc/01/12030000.xhp
index ceb97c8ac..2ec45561c 100644
--- a/source/text/scalc/01/12030000.xhp
+++ b/source/text/scalc/01/12030000.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="textscalc0112030000xml" indexer="include" status="PUBLISH">
@@ -31,10 +28,12 @@
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:DataSort" id="bm_id3150084" localize="false"/>
-<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1">Sort</paragraph>
+<section id="sortheader">
+<h1 id="hd_id3150275"><link href="text/scalc/01/12030000.xhp" name="">Sort</link></h1>
<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><variable id="sorttext"><ahelp hid=".uno:DataSort">Sorts the selected rows according to the conditions that you specify.</ahelp>
</variable> $[officename] automatically recognizes and selects database ranges.</paragraph>
-<paragraph role="note" id="par_id3147428" xml-lang="en-US">You cannot sort data if the <link href="text/shared/01/02230000.xhp" name="Record changes">Record changes</link> options is enabled.</paragraph>
+</section>
+<note id="par_id3147428">You cannot sort data if the <link href="text/shared/01/02230000.xhp" name="Record changes">Record changes</link> options is enabled.</note>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnsrt"/>
</section>
diff --git a/source/text/scalc/01/12030100.xhp b/source/text/scalc/01/12030100.xhp
index 6aa6a3dfd..6f7ec9908 100644
--- a/source/text/scalc/01/12030100.xhp
+++ b/source/text/scalc/01/12030100.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="textscalc0112030100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sort Criteria</title>
@@ -34,31 +29,31 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortcriteriapage/SortCriteriaPage" id="bm_id3156326" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortcriteriapage/@@nowidget@@" id="bm_id3156326" localize="false"/>
-<paragraph role="heading" id="hd_id3152350" xml-lang="en-US" level="1"><link href="text/scalc/01/12030100.xhp" name="Sort Criteria">Sort Criteria</link></paragraph>
+<h1 id="hd_id3152350"><link href="text/scalc/01/12030100.xhp" name="Sort Criteria">Sort Criteria</link></h1>
<paragraph role="paragraph" id="par_id3151385" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortcriteriapage/SortCriteriaPage">Specify the sorting options for the selected range.</ahelp></paragraph>
</section>
-<paragraph role="note" id="par_id3152462" xml-lang="en-US">Ensure that you include any row and column titles in the selection.</paragraph>
+<note id="par_id3152462">Ensure that you include any row and column titles in the selection.</note>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnsosk"/>
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/@@nowidget@@" id="bm_id3147434" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/SortKeyFrame" id="bm_id3147434" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/sortlb" id="bm_id3147434" localize="false"/>
-<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2">Sort by</paragraph>
+<h2 id="hd_id3147428">Sort by</h2>
<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortkey/sortlb">Select the column that you want to use as the primary sort key.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/up" id="bm_id3153142" localize="false"/><paragraph role="heading" id="hd_id3146121" xml-lang="en-US" level="3">Ascending</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/up" id="bm_id3153142" localize="false"/><h3 id="hd_id3146121">Ascending</h3>
<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortkey/up">Sorts the selection from the lowest value to the highest value. The sorting rules are given by the locale. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language Settings - Languages.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/down" id="bm_id3149377" localize="false"/><paragraph role="heading" id="hd_id3155411" xml-lang="en-US" level="3">Descending</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/down" id="bm_id3149377" localize="false"/><h3 id="hd_id3155411">Descending</h3>
<paragraph role="paragraph" id="par_id3151075" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortkey/down">Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language Settings - Languages.</paragraph>
-<paragraph role="heading" id="hd_id3154492" xml-lang="en-US" level="2">Then by</paragraph>
+<h2 id="hd_id3154492">Then by</h2>
<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US">Select the column that you want to use as the secondary sort key.</paragraph>
-<paragraph role="heading" id="hd_id3149413" xml-lang="en-US" level="3">Ascending</paragraph>
+<h3 id="hd_id3149413">Ascending</h3>
<paragraph role="paragraph" id="par_id3154018" xml-lang="en-US">Sorts the selection from the lowest value to the highest value. You can define the sort rules on Data - Sort - Options. You define the default on <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language settings - Languages.</paragraph>
-<paragraph role="heading" id="hd_id3146972" xml-lang="en-US" level="3">Descending</paragraph>
+<h3 id="hd_id3146972">Descending</h3>
<paragraph role="paragraph" id="par_id3145640" xml-lang="en-US">Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language settings - Languages.</paragraph>
<bookmark xml-lang="en-US" branch="hid/.uno:SortAscending" id="bm_id1196545" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:SortDescending" id="bm_id1104741" localize="false"/>
-<paragraph role="heading" id="hd_id3150300" xml-lang="en-US" level="2">Sort Ascending/Descending</paragraph>
+<h2 id="hd_id3150300">Sort Ascending/Descending</h2>
<paragraph role="paragraph" id="par_id3158212" xml-lang="en-US"><ahelp hid="."><variable id="sytext">Sorts the selection from the highest to the lowest value, or from the lowest to the highest value. Number fields are sorted by size and text fields by the order of the characters. You can define the sort rules on Data - Sort - Options.</variable></ahelp> You define the default on <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language settings - Languages.</paragraph>
<paragraph role="paragraph" id="par_id3159236" xml-lang="en-US">Icons on the <emph>Standard</emph> toolbar</paragraph>
<embed href="text/scalc/00/00000412.xhp#sysortieren"/>
diff --git a/source/text/scalc/01/12040000.xhp b/source/text/scalc/01/12040000.xhp
index b58ccb571..437f2b984 100644
--- a/source/text/scalc/01/12040000.xhp
+++ b/source/text/scalc/01/12040000.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,8 +18,8 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
+
+
<meta>
<topic id="textscalc0112040000xml" indexer="include">
<title id="tit" xml-lang="en-US">Filter</title>
@@ -29,7 +29,7 @@
<body>
<section id="filter">
<bookmark xml-lang="en-US" branch="hid/.uno:FilterMenu" id="bm_id102920080228246" localize="false"/>
-<paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="1"><link href="text/scalc/01/12040000.xhp" name="Filter">Filter</link></paragraph>
+<h1 id="hd_id3150767"><link href="text/scalc/01/12040000.xhp" name="Filter">Filters</link></h1>
<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid=".">Shows commands to filter your data.</ahelp></paragraph>
</section>
<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US">$[officename] automatically recognizes predefined database ranges.</paragraph>
@@ -37,10 +37,9 @@
<embed href="text/scalc/00/00000412.xhp#dnftr"/>
</section>
<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US">The following filtering options are available:</paragraph>
-<embed href="text/scalc/01/12040100.xhp#autofilter"/>
-<paragraph role="heading" id="hd_id3153728" xml-lang="en-US" level="2"><link href="text/shared/02/12090000.xhp" name="Standard filter">Standard filter</link></paragraph>
+<h2 id="hd_id3153728"><link href="text/shared/02/12090000.xhp" name="Standard filter">Standard filter</link></h2>
<embed href="text/shared/02/12090000.xhp#standardfilter"/>
-<paragraph role="heading" id="hd_id3159153" xml-lang="en-US" level="2"><link href="text/scalc/01/12040300.xhp" name="Advanced filter">Advanced filter</link></paragraph>
+<h2 id="hd_id3159153"><link href="text/scalc/01/12040300.xhp" name="Advanced filter">Advanced filter</link></h2>
<embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
<embed href="text/scalc/01/12040400.xhp#filterentfernen"/>
<embed href="text/scalc/01/12040500.xhp#autofilterausblenden"/>
diff --git a/source/text/scalc/01/12040100.xhp b/source/text/scalc/01/12040100.xhp
index 3b6ddf52e..81e11c3b4 100644
--- a/source/text/scalc/01/12040100.xhp
+++ b/source/text/scalc/01/12040100.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="textscalc0112040100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">AutoFilter</title>
@@ -31,7 +26,7 @@
<body>
<section id="autofilter">
<bookmark xml-lang="en-US" branch="hid/.uno:DataFilterAutoFilter" id="bm_id5427750" localize="false"/>
-<paragraph role="heading" id="hd_id3153541" xml-lang="en-US" level="1"><link href="text/scalc/01/12040100.xhp" name="AutoFilter">AutoFilter</link></paragraph>
+<h1 id="hd_id3153541"><link href="text/scalc/01/12040100.xhp" name="AutoFilter">AutoFilter</link></h1>
<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:DataFilterAutoFilter">Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.</ahelp></paragraph>
</section>
<section id="howtoget">
diff --git a/source/text/scalc/01/12050000.xhp b/source/text/scalc/01/12050000.xhp
index d709900ac..f9a1f947f 100644
--- a/source/text/scalc/01/12050000.xhp
+++ b/source/text/scalc/01/12050000.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="textscalc0112050000xml" indexer="include" status="PUBLISH">
@@ -30,11 +27,12 @@
</history>
</meta>
<body>
-
-
+
<bookmark branch="hid/.uno:DataSubTotals" xml-lang="en-US" id="bm_id3154515" localize="false"/>
-<paragraph role="heading" level="1" id="hd_id3153822" xml-lang="en-US">Subtotals</paragraph>
+<section id="subtotalheader">
+<h1 id="hd_id3153822"><link href="text/scalc/01/12050000.xhp" name="subtotals">Subtotals</link></h1>
<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><variable id="teilergebnisse"><ahelp hid=".uno:DataSubTotals" visibility="visible">Calculates subtotals for the columns that you select.</ahelp></variable> $[officename] uses the SUM function to automatically calculate the subtotal and grand total values in a labeled range. You can also use other functions to perform the calculation. $[officename] automatically recognizes a defined database area when you place the cursor in it.</paragraph>
+ </section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dntegs"/>
</section>
@@ -42,8 +40,8 @@
<embed href="text/scalc/01/12050100.xhp#gruppe"/>
<embed href="text/scalc/01/12050200.xhp#optionen"/>
<embed href="text/shared/00/00000001.xhp#zurueck"/>
- <paragraph role="heading" level="2" id="hd_id3163708" xml-lang="en-US">Delete</paragraph>
+ <h2 id="hd_id3163708">Delete</h2>
<paragraph role="paragraph" id="par_id3154125" xml-lang="en-US">Deletes the subtotal rows in the selected area.</paragraph>
-
+
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12060000.xhp b/source/text/scalc/01/12060000.xhp
index 3118e332a..5c44eb65c 100644
--- a/source/text/scalc/01/12060000.xhp
+++ b/source/text/scalc/01/12060000.xhp
@@ -30,24 +30,26 @@
<bookmark xml-lang="en-US" branch="hid/.uno:TableOperationDialog" id="bm_id9116957" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/MultipleOperationsDialog" id="bm_id3151210" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/@@nowidget@@" id="bm_id3151210" localize="false"/>
-<paragraph role="heading" id="hd_id3153381" xml-lang="en-US" level="1">Multiple Operations</paragraph>
-<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US"><variable id="mehrfachoperationen"><ahelp hid=".uno:TableOperationDialog">Applies the same formula to different cells, but with different parameter values.</ahelp>
-</variable></paragraph>
+<section id="multopheader">
+<h1 id="hd_id3153381"><link href="text/scalc/01/12060000.xhp" name="multiple operations">Multiple Operations</link></h1>
+<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US"><variable id="mehrfachoperationen"><ahelp hid=".uno:TableOperationDialog">Applies the same formula to different cells, but with different parameter values.</ahelp></variable></paragraph>
+</section>
+
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnmfo"/>
</section>
<embed href="text/scalc/guide/multioperation.xhp#multioperation"/>
-<paragraph role="note" id="par_id3152598" xml-lang="en-US">The <emph>Row</emph> or <emph>Column</emph> box must contain a reference to the first cell of the selected range.</paragraph>
-<paragraph role="note" id="par_id3154011" xml-lang="en-US">If you export a spreadsheet containing multiple operations to Microsoft Excel, the location of the cells containing the formula must be fully defined relative to the data range.</paragraph>
-<paragraph role="heading" id="hd_id3156441" xml-lang="en-US" level="2">Defaults</paragraph>
+<note id="par_id3152598">The <emph>Row</emph> or <emph>Column</emph> box must contain a reference to the first cell of the selected range.</note>
+<note id="par_id3154011">If you export a spreadsheet containing multiple operations to Microsoft Excel, the location of the cells containing the formula must be fully defined relative to the data range.</note>
+<h2 id="hd_id3156441">Defaults</h2>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/formulas" id="bm_id3149581" localize="false"/>
-<paragraph role="heading" id="hd_id3154492" xml-lang="en-US" level="3">Formulas</paragraph>
+<h3 id="hd_id3154492">Formulas</h3>
<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US"><ahelp hid="modules/scalc/ui/multipleoperationsdialog/formulas">Enter the cell references for the cells containing the formulas that you want to use in the multiple operation.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/row" id="bm_id3156286" localize="false"/>
-<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="3">Row</paragraph>
+<h3 id="hd_id3154729">Row</h3>
<paragraph role="paragraph" id="par_id3148456" xml-lang="en-US"><ahelp hid="modules/scalc/ui/multipleoperationsdialog/row">Enter the input cell reference that you want to use as a variable for the rows in the data table.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/col" id="bm_id3149123" localize="false"/>
-<paragraph role="heading" id="hd_id3150718" xml-lang="en-US" level="3">Column</paragraph>
+<h3 id="hd_id3150718">Column</h3>
<paragraph role="paragraph" id="par_id3150327" xml-lang="en-US"><ahelp hid="modules/scalc/ui/multipleoperationsdialog/col">Enter the input cell reference that you want to use as a variable for the columns in the data table.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
</body>
diff --git a/source/text/scalc/01/12070000.xhp b/source/text/scalc/01/12070000.xhp
index 296d6958e..6b99ab45f 100644
--- a/source/text/scalc/01/12070000.xhp
+++ b/source/text/scalc/01/12070000.xhp
@@ -30,33 +30,36 @@
<bookmark xml-lang="en-US" branch="hid/.uno:DataConsolidate" id="bm_id4927741" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/ConsolidateDialog" id="bm_id3148664" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/@@nowidget@@" id="bm_id3148664" localize="false"/>
-<paragraph role="heading" id="hd_id3148946" xml-lang="en-US" level="1">Consolidate</paragraph>
-<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US"><variable id="konsolidieren"><ahelp hid=".uno:DataConsolidate">Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.</ahelp>
-</variable></paragraph>
+
+<section id="consolidateheader">
+<h1 id="hd_id3148946"><link href="text/scalc/01/12070000.xhp" name="Consolidate">Consolidate</link></h1>
+<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US"><variable id="konsolidieren"><ahelp hid=".uno:DataConsolidate">Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.</ahelp></variable></paragraph>
+</section>
+
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnksd"/>
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/func" id="bm_id3149958" localize="false"/>
-<paragraph role="heading" id="hd_id3150010" xml-lang="en-US" level="2">Function</paragraph>
+<h2 id="hd_id3150010">Function</h2>
<paragraph role="paragraph" id="par_id3149377" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/func">Select the function that you want to use to consolidate the data.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/consareas" id="bm_id3144764" localize="false"/>
-<paragraph role="heading" id="hd_id3147127" xml-lang="en-US" level="2">Consolidation ranges</paragraph>
+<h2 id="hd_id3147127">Consolidation ranges</h2>
<paragraph role="paragraph" id="par_id3151075" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/consareas">Displays the cell ranges that you want to consolidate.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/lbdataarea" id="bm_id3149400" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/eddataarea" id="bm_id3154018" localize="false"/>
-<paragraph role="heading" id="hd_id3147397" xml-lang="en-US" level="2">Source data range</paragraph>
+<h2 id="hd_id3147397">Source data range</h2>
<paragraph role="paragraph" id="par_id3153836" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/eddataarea">Specifies the cell range that you want to consolidate with the cell ranges listed in the <emph>Consolidation ranges </emph>box. Select a cell range in a sheet, and then click <emph>Add</emph>. You can also select the name of a predefined cell from the <emph>Source data range </emph>list.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/lbdestarea" id="bm_id3156383" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/eddestarea" id="bm_id3156382" localize="false"/>
-<paragraph role="heading" id="hd_id3155768" xml-lang="en-US" level="2">Copy results to</paragraph>
+<h2 id="hd_id3155768">Copy results to</h2>
<paragraph role="paragraph" id="par_id3147341" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/eddestarea">Displays the first cell in the range where the consolidation results will be displayed.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#loeschen1"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/add" id="bm_id3145228" localize="false"/>
-<paragraph role="heading" id="hd_id3147345" xml-lang="en-US" level="2">Add</paragraph>
+<h2 id="hd_id3147345">Add</h2>
<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/add">Adds the cell range specified in the <emph>Source data range</emph> box to the <emph>Consolidation ranges </emph>box.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/more" id="bm_id3159102" localize="false"/>
-<paragraph role="heading" id="hd_id3148630" xml-lang="en-US" level="2">Options</paragraph>
+<h2 id="hd_id3148630">Options</h2>
<paragraph role="paragraph" id="par_id3159239" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/more">Shows additional <link href="text/scalc/01/12070100.xhp" name="options">options</link>.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12090000.xhp b/source/text/scalc/01/12090000.xhp
index 5a648893b..37e131412 100644
--- a/source/text/scalc/01/12090000.xhp
+++ b/source/text/scalc/01/12090000.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="textscalc0112090000xml" indexer="include" status="PUBLISH">
@@ -28,14 +25,14 @@
</meta>
<body>
<section id="datenpilot">
-<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1"><link href="text/scalc/01/12090000.xhp" name="Pivot Table">Pivot Table</link></paragraph>
+<h1 id="hd_id3150275"><link href="text/scalc/01/12090000.xhp" name="Pivot Table">Pivot Table</link></h1>
<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US">A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dndtpt"/>
</section>
<embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
-<paragraph role="heading" id="hd_id3155923" xml-lang="en-US" level="2"><link href="text/scalc/01/12090100.xhp" name="Create">Create</link></paragraph>
+<h2 id="hd_id3155923"><link href="text/scalc/01/12090100.xhp" name="Create">Create</link></h2>
<embed href="text/scalc/01/12090100.xhp#datenpilot"/>
<embed href="text/scalc/01/12090200.xhp#aktualisieren"/>
<embed href="text/scalc/01/12090300.xhp#loeschen"/>
diff --git a/source/text/scalc/01/12100000.xhp b/source/text/scalc/01/12100000.xhp
index d5a4332d0..d5bf15765 100644
--- a/source/text/scalc/01/12100000.xhp
+++ b/source/text/scalc/01/12100000.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="textscalc0112100000xml" indexer="include" status="PUBLISH">
@@ -30,13 +27,13 @@
</history>
</meta>
<body>
-
-
<bookmark xml-lang="en-US" branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark>
<bookmark branch="hid/.uno:DataReImport" xml-lang="en-US" id="bm_id3153880" localize="false"/>
<bookmark branch="hid/.uno:DataAreaRefresh" xml-lang="en-US" id="bm_id3149166" localize="false"/>
-<paragraph id="hd_id3153662" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></paragraph>
+<section id="refreshrangehead">
+<h1 id="hd_id3153662"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></h1>
<paragraph role="paragraph" id="par_id3153088" xml-lang="en-US"><variable id="aktualisieren"><ahelp hid=".">Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dndakt"/>
</section>
diff --git a/source/text/scalc/01/12120000.xhp b/source/text/scalc/01/12120000.xhp
index 1812b7bc5..e101beb39 100644
--- a/source/text/scalc/01/12120000.xhp
+++ b/source/text/scalc/01/12120000.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="textscalc0112120000xml" indexer="include" status="PUBLISH">
@@ -31,13 +28,15 @@
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:Validation" id="bm_id3153880" localize="false"/>
-<paragraph role="heading" id="hd_id3156347" xml-lang="en-US" level="1">Validity</paragraph>
+<section id="validityheader">
+<h1 id="hd_id3156347"><link href="text/scalc/01/12120000.xhp" name="validity">Validity</link></h1>
<paragraph role="paragraph" id="par_id3153252" xml-lang="en-US"><variable id="gueltigkeit"><ahelp hid=".uno:Validation">Defines what data is valid for a selected cell or cell range.</ahelp>
</variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#datengueltig"/>
</section>
-<paragraph role="tip" id="par_idN105D1" xml-lang="en-US">You can also insert a list box from the Controls toolbar and link the list box to a cell. This way you can specify the valid values on the <link href="text/shared/02/01170102.xhp">Data</link> page of the list box properties window.</paragraph>
+<tip id="par_idN105D1">You can also insert a list box from the Controls toolbar and link the list box to a cell. This way you can specify the valid values on the <link href="text/shared/02/01170102.xhp">Data</link> page of the list box properties window.</tip>
<embed href="text/scalc/01/12120100.xhp#werte"/>
<embed href="text/scalc/01/12120200.xhp#eingabehilfe"/>
<embed href="text/scalc/01/12120300.xhp#fehlermeldung"/>
diff --git a/source/text/scalc/01/calculate.xhp b/source/text/scalc/01/calculate.xhp
new file mode 100644
index 000000000..b61d22229
--- /dev/null
+++ b/source/text/scalc/01/calculate.xhp
@@ -0,0 +1,31 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="menudatacalculate" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Calculate</title>
+ <filename>/text/scalc/01/calculate.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="calculateheader">
+ <bookmark id="bm_id931584668179315" xml-lang="en-US" branch="hid/uno:CellContentsMenu" localize="false"/>
+ <h1 id="hd_id621584668179317"><link href="text/scalc/01/calculate.xhp" name="Calculate">Calculate</link></h1>
+ <paragraph id="par_id241584668179318" role="paragraph" xml-lang="en-US"><ahelp hid=".">Commands to calculate formula cells.</ahelp></paragraph>
+ </section>
+ <section id="howtoget">
+
+ </section>
+ <embed href="text/scalc/01/06080000.xhp#recalculateheader"/>
+ <embed href="text/scalc/01/06070000.xhp#automatisch"/>
+
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/data_form.xhp b/source/text/scalc/01/data_form.xhp
index ab2105408..9c299714f 100644
--- a/source/text/scalc/01/data_form.xhp
+++ b/source/text/scalc/01/data_form.xhp
@@ -17,8 +17,6 @@
</meta>
<body>
-
- <section id="data_form">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/dataform/DataFormDialog" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/dataform/@@nowidget@@" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
@@ -27,30 +25,30 @@
<bookmark_value>insert data;data entry forms for spreadsheets</bookmark_value>
<bookmark_value>spreadsheet;form for inserting data</bookmark_value>
</bookmark>
-
- <paragraph id="hd_id240920171003006302" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/data_form.xhp">Data Entry Forms for Spreadsheets</link></paragraph>
- <paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Data Entry Form is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.</paragraph>
+ <section id="data_form">
+ <h1 id="hd_id240920171003006302"><link href="text/scalc/01/data_form.xhp">Form</link></h1>
+ <paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid="."><emph>Data Entry Form</emph> is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.</paragraph>
</section>
<section id="howtoget">
<paragraph id="par_id240920171007389295" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Data – Form...</item></paragraph>
</section>
- <paragraph role="heading" id="hd_id291512503277077" level="2" xml-lang="en-US">Preparing the data entry form</paragraph>
+ <h2 id="hd_id291512503277077">Preparing the data entry form</h2>
<paragraph role="paragraph" id="par_id221512503284514" xml-lang="en-US">To be effective, the Calc data table should have a header row, where each cell contents is the label of the column. The header cells contents become the label of each data field in the form.</paragraph>
- <paragraph role="heading" id="hd_id531512503300666" level="2" xml-lang="en-US">Activating the form</paragraph>
+ <h2 id="hd_id531512503300666">Activating the form</h2>
<list type="ordered">
<listitem>
- <paragraph id="par_id551512503358101" role="listitem" xml-lang="en-US">Place the cursor in the header row of the table.</paragraph>
+ <paragraph id="par_id551512503358101" role="listitem" xml-lang="en-US">Place the cursor in the header row of the table.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id11512503369875" role="listitem" xml-lang="en-US">Choose <item type="menuitem">Data - Form...</item>.</paragraph>
+ <paragraph id="par_id11512503369875" role="listitem" xml-lang="en-US">Choose <item type="menuitem">Data - Form...</item>.</paragraph>
</listitem>
</list>
- <paragraph role="heading" id="hd_id361512503457039" level="2" xml-lang="en-US">Filling the form with data</paragraph>
+ <h2 id="hd_id361512503457039">Filling the form with data</h2>
<paragraph role="pargraph" id="par_id361512503457039" xml-lang="en-US">Enter the data in the text fields. Press Enter or click <item type="literal">New</item> to add it to the table.</paragraph>
- <paragraph role="heading" id="hd_id111512507319306" level="2" xml-lang="en-US">Form dialog buttons</paragraph>
+ <h2 id="hd_id111512507319306">Form dialog buttons</h2>
<paragraph role="paragraph" id="par_id981512503964001" xml-lang="en-US"><emph>New</emph>: fill the record (table row cells) with the form fields contents and jump to the next record or add a new record in the bottom of the table.</paragraph>
<paragraph role="paragraph" id="par_id91512503864256" xml-lang="en-US"><emph>Delete</emph>: deletes the current record.</paragraph>
<paragraph role="paragraph" id="par_id11512503887586" xml-lang="en-US"><emph>Restore</emph>: when a form field is edited, restore the record contents to its initial state.</paragraph>
@@ -62,9 +60,9 @@
<alt xml-lang="en-US" id="alt_id951512509971073">The form dialog box and header row cells as field labels</alt>
</image>
</paragraph>
- <paragraph role="tip" id="par_id351512558748321" xml-lang="en-US">Use the <item type="input">Tab</item> and <item type="input">Shift-Tab</item> keys to jump forth and back between text boxes of the form dialog.</paragraph>
- <paragraph role="tip" id="par_id731512558741034" xml-lang="en-US">You also can use the form scroll bar to move between text boxes.</paragraph>
- <paragraph role="heading" id="hd_id701512558977465" level="2" xml-lang="en-US">Reopening the form dialog</paragraph>
+ <tip id="par_id351512558748321">Use the <item type="input">Tab</item> and <item type="input">Shift-Tab</item> keys to jump forth and back between text boxes of the form dialog.</tip>
+ <tip id="par_id731512558741034">You also can use the form scroll bar to move between text boxes.</tip>
+ <h2 id="hd_id701512558977465">Reopening the form dialog</h2>
<paragraph role="paragraph" id="par_id181512558987528" xml-lang="en-US">To reopen the form dialog, place the cursor on the header row and open the form. The displayed record in the form dialog is the first data record. Move to the last record before entering new data otherwise the current record will be edited.</paragraph>
<section id="relatedtopics">
<paragraph id="par_id240920171007419799" role="paragraph" xml-lang="en-US"><link href="text/shared/guide/data_forms.xhp" name="Forms">Document Forms</link></paragraph>
diff --git a/source/text/scalc/01/data_provider.xhp b/source/text/scalc/01/data_provider.xhp
index f1948be68..b7714b2d9 100644
--- a/source/text/scalc/01/data_provider.xhp
+++ b/source/text/scalc/01/data_provider.xhp
@@ -28,15 +28,14 @@
<body>
-<section id="data_form">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/dataprovider/DataProviderDialog" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/dataprovider/@@nowidget@@" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
- <bookmark_value>data provider;for spreadsheets</bookmark_value>
+<bookmark_value>data provider;for spreadsheets</bookmark_value>
</bookmark>
-
-<paragraph id="hd_id240920171003006302" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/data_provider.xhp">Data Provider for Spreadsheets</link></paragraph>
+<section id="data_provider">
+<h1 id="hd_id240920171003006302"><link href="text/scalc/01/data_provider.xhp">Data Provider for Spreadsheets</link></h1>
<paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Data Provider for Spreadsheets</ahelp></paragraph>
</section>
diff --git a/source/text/scalc/01/live_data_stream.xhp b/source/text/scalc/01/live_data_stream.xhp
index 6f26c9a02..545a166b5 100644
--- a/source/text/scalc/01/live_data_stream.xhp
+++ b/source/text/scalc/01/live_data_stream.xhp
@@ -28,15 +28,15 @@
<body>
-<section id="live_data_stream">
+
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datastreams/DataStreamDialog" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datastreams/@@nowidget@@" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
<bookmark_value>Data Stream;Live data stream</bookmark_value>
</bookmark>
-
-<paragraph id="hd_id240920171003006302" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/live_data_stream.xhp">Live Data Stream</link></paragraph>
+<section id="live_data_stream">
+<h1 id="hd_id240920171003006302"><link href="text/scalc/01/live_data_stream.xhp">Live Data Stream</link></h1>
<paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Live data stream for spreadsheets</ahelp></paragraph>
</section>
diff --git a/source/text/scalc/01/text2columns.xhp b/source/text/scalc/01/text2columns.xhp
index 40195960d..dec39b985 100644
--- a/source/text/scalc/01/text2columns.xhp
+++ b/source/text/scalc/01/text2columns.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,25 +18,27 @@
* 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="textscalc01text2columnsxml" indexer="include">
<title xml-lang="en-US" id="tit">Text to Columns</title>
<filename>/text/scalc/01/text2columns.xhp</filename>
</topic>
- </meta>
- <body>
+</meta>
+<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id8004394"><bookmark_value>text to columns</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:TextToColumns" id="bm_id1029200802260951" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2300180" role="heading" level="1"><link href="text/scalc/01/text2columns.xhp">Text to Columns</link></paragraph>
- <paragraph xml-lang="en-US" id="par_id655232" role="paragraph"><variable id="text2columns">Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells.
-</variable></paragraph>
+
+<section id="t2cheader">
+<h1 id="hd_id2300180"><link href="text/scalc/01/text2columns.xhp">Text to Columns</link></h1>
+<paragraph xml-lang="en-US" id="par_id655232" role="paragraph"><variable id="text2columns">Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells.</variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#text2columns"/>
</section>
- <paragraph xml-lang="en-US" id="hd_id9599597" role="heading" level="2">To expand cell contents to multiple cells</paragraph>
+ <h2 id="hd_id9599597">To expand cell contents to multiple cells</h2>
<paragraph xml-lang="en-US" id="par_id2021546" role="paragraph">You can expand cells that contain comma separated values (CSV) into multiple cells in the same row. </paragraph>
<paragraph xml-lang="en-US" id="par_id2623981" role="paragraph">For example, cell A1 contains the comma separated values <item type="literal">1,2,3,4</item>, and cell A2 contains the text <item type="literal">A,B,C,D</item>. </paragraph>
<list type="ordered">
@@ -59,4 +61,4 @@
<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/>
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/xml_source.xhp b/source/text/scalc/01/xml_source.xhp
index 6250ef7f7..05541b187 100644
--- a/source/text/scalc/01/xml_source.xhp
+++ b/source/text/scalc/01/xml_source.xhp
@@ -26,13 +26,14 @@
</meta>
<body>
- <section id="xml_source">
+
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/xmlsourcedialog/@@nowidget@@" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
<bookmark_value>XML Source;load XML data in spreadsheets</bookmark_value>
</bookmark>
- <paragraph id="hd_id240920171003006302" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/xml_source.xhp">XML Source</link></paragraph>
+ <section id="xml_source">
+ <h1 id="hd_id240920171003006302"><link href="text/scalc/01/xml_source.xhp">XML Source</link></h1>
<paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Import XML data in a spreadsheet.</ahelp></paragraph>
</section>
<paragraph role="paragraph" id="par_id861521496523519" xml-lang="en-US">The XML Source feature allows to import data from arbitrarily structured XML content into cells in an existing spreadsheet document. It allows XML content to be imported either partially or in full, depending on the structure of the XML content and the map definitions that the user defines. The user can specify multiple non-overlapping sub-structures to be mapped to different cell positions within the same document. The user can import either element contents, attribute values or both.</paragraph>
@@ -40,27 +41,27 @@
<section id="howtoget">
<paragraph id="par_id240920171007389295" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Data - XML Source</item>.</paragraph>
</section>
- <paragraph role="heading" id="hd_id801521494731764" level="2" xml-lang="en-US">XML Source Dialog</paragraph>
- <paragraph id="par_id2521" role="paragraph"><image id="img_id35279" src="media/screenshots/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog.png" width="16cm" height="13cm"><alt id="alt_id55711">XML Source Dialog</alt></image></paragraph>
+ <h2 id="hd_id801521494731764">XML Source Dialog</h2>
+ <paragraph id="par_id2521" role="paragraph"><image id="img_id35279" src="media/screenshots/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog.png" width="16cm" height="13cm"><alt id="alt_id55711">XML Source Dialog</alt></image></paragraph>
<paragraph role="paragraph" id="par_id291521494762812" xml-lang="en-US">The dialog consists of four parts.</paragraph>
- <paragraph role="heading" id="hd_id601521494755603" level="3" xml-lang="en-US">Source file</paragraph>
+ <h3 id="hd_id601521494755603">Source file</h3>
<paragraph role="paragraph" id="par_id161521494769832" xml-lang="en-US">This lets you specify the path to the XML file that you wish to import into your document.</paragraph>
- <paragraph role="heading" id="hd_id491521494788029" level="3" xml-lang="en-US">Map to Document</paragraph>
+ <h3 id="hd_id491521494788029">Map to Document</h3>
<paragraph role="paragraph" id="par_id211521494776007" xml-lang="en-US">This pane shows the structure of the source XML content as a tree. This is initially empty, and gets populated when you specify the source file.</paragraph>
<paragraph role="paragraph" id="par_id161521494796604" xml-lang="en-US">Each element in the tree can be one of three types:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id931521494810426" role="listitem" xml-lang="en-US">attribute, represented by the symbol <emph>@</emph></paragraph>
+ <paragraph id="par_id931521494810426" role="listitem" xml-lang="en-US">attribute, represented by the symbol <emph>@</emph></paragraph>
</listitem>
<listitem>
- <paragraph id="par_id521521494825665" role="listitem" xml-lang="en-US">single non-recurring element, represented by the symbol <emph>&lt;/&gt;</emph>, and</paragraph>
+ <paragraph id="par_id521521494825665" role="listitem" xml-lang="en-US">single non-recurring element, represented by the symbol <emph>&lt;/&gt;</emph>, and</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id691521494844848" role="listitem" xml-lang="en-US">recurring element, represented by the symbol <emph>&lt;//&gt;</emph>.</paragraph>
+ <paragraph id="par_id691521494844848" role="listitem" xml-lang="en-US">recurring element, represented by the symbol <emph>&lt;//&gt;</emph>.</paragraph>
</listitem>
</list>
@@ -68,9 +69,9 @@
<paragraph role="paragraph" id="par_id361521494872103" xml-lang="en-US">A recurring element is an element that can appear multiple times under the same parent. It serves as an enclosing parent of a single record entry of multiple record entries. These entries are imported into a range those height equals the number of entries plus one additional header row.</paragraph>
- <paragraph role="heading" id="hd_id581521494885433" level="3" xml-lang="en-US">Mapped cell</paragraph>
+ <h3 id="hd_id581521494885433">Mapped cell</h3>
<paragraph role="paragraph" id="par_id661521494897796" xml-lang="en-US">This field specifies the position of a cell in the document that an element or an attribute is linked to. If it is a non-recurring element or an attribute, it simply points to the cell where the value of the linked element/attribute will get imported. If it is a recurring element, it points to the top-left cell of the range where the whole record entries plus header will get imported.</paragraph>
- <paragraph role="heading" id="hd_id151521553082338" level="3" xml-lang="en-US">Import</paragraph>
+ <h3 id="hd_id151521553082338">Import</h3>
<paragraph role="paragraph" id="par_id131521553077261" xml-lang="en-US">Pressing the Import button starts the import process based on the link definitions that the user has provided. Once the import finishes, the dialog will close.</paragraph>
<section id="relatedtopics">
<paragraph id="par_id240920171007419799" role="paragraph" xml-lang="en-US"><link href="https://wiki.documentfoundation.org/Development/Calc/XMLSource" target="_blank" name="Wiki page on XML Source">Wiki page on XML Source</link></paragraph>
diff --git a/source/text/scalc/guide/autofilter.xhp b/source/text/scalc/guide/autofilter.xhp
index 8e605f976..6e204cd84 100644
--- a/source/text/scalc/guide/autofilter.xhp
+++ b/source/text/scalc/guide/autofilter.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,8 +18,7 @@
* 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="textscalcguideautofilterxml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Applying AutoFilter</title>
diff --git a/source/text/scalc/main0112.xhp b/source/text/scalc/main0112.xhp
index 37a6a54b8..77725a325 100644
--- a/source/text/scalc/main0112.xhp
+++ b/source/text/scalc/main0112.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="textscalcmain0112xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Data</title>
@@ -30,29 +25,29 @@
</meta>
<body>
<section id="data">
-<bookmark xml-lang="en-US" branch="hid/.uno:DataMenu" id="bm_id9612414" localize="false"/><paragraph role="heading" id="hd_id3153254" xml-lang="en-US" level="1"><link href="text/scalc/main0112.xhp" name="Data">Data</link></paragraph>
+<bookmark xml-lang="en-US" branch="hid/.uno:DataMenu" id="bm_id9612414" localize="false"/><h1 id="hd_id3153254"><link href="text/scalc/main0112.xhp" name="Data">Data</link></h1>
<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp hid=".">Use the <emph>Data</emph> menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and create a pivot table.</ahelp></paragraph>
</section>
-<paragraph role="heading" id="hd_id3150400" xml-lang="en-US" level="2"><link href="text/scalc/01/12010000.xhp" name="Define Range">Define Range</link></paragraph>
-<embed href="text/scalc/01/12010000.xhp#bereichtext"/>
-<paragraph role="heading" id="hd_id3125863" xml-lang="en-US" level="2"><link href="text/scalc/01/12020000.xhp" name="Select Range">Select Range</link></paragraph>
-<embed href="text/scalc/01/12020000.xhp#bereichwaehlen"/>
-<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="2"><link href="text/scalc/01/12030000.xhp" name="Sort">Sort</link></paragraph>
-<embed href="text/scalc/01/12030000.xhp#sorttext"/>
+<embed href="text/scalc/01/12030000.xhp#sortheader"/>
+<embed href="text/shared/02/12010000.xhp#aufsteigend"/>
+<embed href="text/shared/02/12020000.xhp#absteigend"/>
+<embed href="text/scalc/01/12040100.xhp#autofilter"/>
<embed href="text/scalc/01/12040000.xhp#filter"/>
-<paragraph role="heading" id="hd_id3153142" xml-lang="en-US" level="2"><link href="text/scalc/01/12050000.xhp" name="Subtotals">Subtotals</link></paragraph>
-<embed href="text/scalc/01/12050000.xhp#teilergebnisse"/>
-<paragraph role="heading" id="hd_id3151073" xml-lang="en-US" level="2"><link href="text/scalc/01/12120000.xhp" name="Validity">Validity</link></paragraph>
-<embed href="text/scalc/01/12120000.xhp#gueltigkeit"/>
-<paragraph role="heading" id="hd_id3145254" xml-lang="en-US" level="2"><link href="text/scalc/01/12060000.xhp" name="Multiple Operations">Multiple Operations</link></paragraph>
-<embed href="text/scalc/01/12060000.xhp#mehrfachoperationen"/>
-<paragraph role="heading" id="hd_id1387066" xml-lang="en-US" level="2"><link href="text/scalc/01/text2columns.xhp">Text to Columns</link></paragraph>
-<embed href="text/scalc/01/text2columns.xhp#text2columns"/>
-<paragraph role="heading" id="hd_id3150717" xml-lang="en-US" level="2"><link href="text/scalc/01/12070000.xhp" name="Consolidate">Consolidate</link></paragraph>
-<embed href="text/scalc/01/12070000.xhp#konsolidieren"/>
-<embed href="text/scalc/01/12080000.xhp#gliederung"/>
+<embed href="text/scalc/01/12010000.xhp#defineDBrangeheader"/>
+<embed href="text/scalc/01/12020000.xhp#selectDBheader"/>
+<embed href="text/scalc/01/12100000.xhp#refreshrangehead"/>
<embed href="text/scalc/01/12090000.xhp#datenpilot"/>
-<paragraph role="heading" id="hd_id3154754" xml-lang="en-US" level="2"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></paragraph>
-<embed href="text/scalc/01/12100000.xhp#aktualisieren"/>
+<embed href="text/scalc/01/calculate.xhp#calculateheader"/>
+<embed href="text/scalc/01/12120000.xhp#validityheader"/>
+<embed href="text/scalc/01/12050000.xhp#subtotalheader"/>
+<embed href="text/scalc/01/data_form.xhp#data_form"/>
+<embed href="text/scalc/01/live_data_stream.xhp#live_data_stream"/>
+<embed href="text/scalc/01/xml_source.xhp#xml_source"/>
+<embed href="text/scalc/01/data_provider.xhp#data_provider"/>
+<embed href="text/scalc/01/12060000.xhp#multopheader"/>
+<embed href="text/scalc/01/text2columns.xhp#t2cheader"/>
+<embed href="text/scalc/01/12070000.xhp#consolidateheader"/>
+<embed href="text/scalc/01/12080000.xhp#gliederung"/>
+
</body>
</helpdocument>