AllLangHelp_scalc.mk | 1
source/text/scalc/00/00000412.xhp | 324 +++++++++++++++---------------
source/text/scalc/01/06070000.xhp | 5
source/text/scalc/01/06080000.xhp | 6
source/text/scalc/01/12010000.xhp | 18 -
source/text/scalc/01/12020000.xhp | 14 -
source/text/scalc/01/12030000.xhp | 9
source/text/scalc/01/12030100.xhp | 25 --
source/text/scalc/01/12040000.xhp | 13 -
source/text/scalc/01/12040100.xhp | 9
source/text/scalc/01/12050000.xhp | 14 -
source/text/scalc/01/12060000.xhp | 20 +
source/text/scalc/01/12070000.xhp | 21 +
source/text/scalc/01/12090000.xhp | 7
source/text/scalc/01/12100000.xhp | 9
source/text/scalc/01/12120000.xhp | 9
source/text/scalc/01/calculate.xhp | 31 ++
source/text/scalc/01/data_form.xhp | 26 +-
source/text/scalc/01/data_provider.xhp | 7
source/text/scalc/01/live_data_stream.xhp | 6
source/text/scalc/01/text2columns.xhp | 22 +-
source/text/scalc/01/xml_source.xhp | 23 +-
source/text/scalc/guide/autofilter.xhp | 5
source/text/scalc/main0112.xhp | 47 +---
source/text/shared/02/12010000.xhp | 32 --
source/text/shared/02/12020000.xhp | 28 --
source/text/shared/main0212.xhp | 9
source/text/shared/main0213.xhp | 4
28 files changed, 371 insertions(+), 373 deletions(-)
New commits:
commit 562631aa3b0f0a6055e899e8b36491bee52fcb73
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Mar 20 11:01:08 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Mar 20 15:16:11 2020 +0100
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.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index eeca4db24..61401028c 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -180,6 +180,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/12120100 \
helpcontent2/source/text/scalc/01/12120200 \
helpcontent2/source/text/scalc/01/12120300 \
+ helpcontent2/source/text/scalc/01/calculate \
helpcontent2/source/text/scalc/01/data_form \
helpcontent2/source/text/scalc/01/data_provider \
helpcontent2/source/text/scalc/01/ex_data_stat_func \
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
>></paragraph>
+<h2 id="hd_id3150010">More >></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></></emph>, and</paragraph>
+ <paragraph id="par_id521521494825665" role="listitem"
xml-lang="en-US">single non-recurring element, represented by the symbol
<emph></></emph>, and</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id691521494844848" role="listitem"
xml-lang="en-US">recurring element, represented by the symbol
<emph><//></emph>.</paragraph>
+ <paragraph id="par_id691521494844848" role="listitem"
xml-lang="en-US">recurring element, represented by the symbol
<emph><//></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>
diff --git a/source/text/shared/02/12010000.xhp
b/source/text/shared/02/12010000.xhp
index 083e427d3..879ad2fb5 100644
--- a/source/text/shared/02/12010000.xhp
+++ b/source/text/shared/02/12010000.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="textshared0212010000xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sort Ascending</title>
@@ -30,26 +25,19 @@
</meta>
<body>
<section id="aufsteigend">
-<paragraph role="heading" id="hd_id3152594" xml-lang="en-US" level="1"><link
href="text/shared/02/12010000.xhp" name="Sort Ascending">Sort
Ascending</link></paragraph>
+<h1 id="hd_id3152594"><link href="text/shared/02/12010000.xhp" name="Sort
Ascending">Sort Ascending</link></h1>
<paragraph role="paragraph" id="par_id3150693" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Sorts the data of the selected field in ascending order.
</ahelp>Text fields are sorted alphabetically, numerical fields are sorted by
number.<comment>UFI: Help ID .uno:Sortup is found in
text/shared/explorer/database/11090000.xhp so I deleted it
here</comment></paragraph>
</section>
-<section id="syaufsteigend">
-<table id="tbl_id3150774">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3154749" xml-lang="en-US">
-<image id="img_id3147276" src="cmd/sc_sortascending.png" width="0.1665inch"
height="0.1665inch"><alt id="alt_id3147276" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3159158" xml-lang="en-US">Sort
Ascending</paragraph>
-</tablecell>
-</tablerow>
-</table>
+<section id="howtoget">
+ <switch select="appl"><case select="CALC">
+ <embed href="text/scalc/00/00000412.xhp#datasortascending"/>
+ <embed href="text/scalc/00/00000412.xhp#onthestandardbar"/>
+ </case></switch>
+ <embed href="text/scalc/00/00000412.xhp#sortascending"/>
</section>
-<paragraph role="paragraph" id="par_id3154380" xml-lang="en-US"><variable
id="selektionsortieren">Data of the currently selected field are always sorted.
A field is always selected as soon as you place the cursor in the field. To
sort within tables, you can also click the corresponding column header.
+<paragraph role="paragraph" id="par_id3154380" xml-lang="en-US"><variable
id="selektionsortieren">Data of the currently selected field are always sorted.
A field is always selected as soon as you place the cursor in the field. To
sort within tables, you can also click the corresponding column header.
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150504" xml-lang="en-US"><variable
id="dialogsortieren">To sort more than one data field, choose <emph>Data -
Sort</emph>, then choose the <link href="text/shared/02/12100100.xhp"
name="Sort Criteria">Sort Criteria</link> tab, where you can combine several
sort criteria.
+<paragraph role="paragraph" id="par_id3150504" xml-lang="en-US"><variable
id="dialogsortieren">To sort more than one data field, choose <emph>Data -
Sort</emph>, then choose the <link href="text/shared/02/12100100.xhp"
name="Sort Criteria">Sort Criteria</link> tab, where you can combine several
sort criteria.
</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/02/12020000.xhp
b/source/text/shared/02/12020000.xhp
index 64369d9a8..e7b80728f 100644
--- a/source/text/shared/02/12020000.xhp
+++ b/source/text/shared/02/12020000.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="textshared0212020000xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sort Descending</title>
@@ -31,22 +26,15 @@
<body>
<section id="absteigend">
<bookmark xml-lang="en-US" branch="hid/.uno:SortDown" id="bm_id5470183"
localize="false"/>
-<paragraph role="heading" id="hd_id3154689" xml-lang="en-US" level="1"><link
href="text/shared/02/12020000.xhp" name="Sort Descending">Sort
Descending</link></paragraph>
+<h1 id="hd_id3154689"><link href="text/shared/02/12020000.xhp" name="Sort
Descending">Sort Descending</link></h1>
<paragraph role="paragraph" id="par_id3149987" xml-lang="en-US"><ahelp
hid=".uno:SortDown" visibility="hidden">Sorts the data of the selected field in
descending order.</ahelp> Text fields are sorted alphabetically, number fields
are sorted by number.</paragraph>
</section>
-<section id="syabsteigend">
-<table id="tbl_id3155271">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149496" xml-lang="en-US">
-<image id="img_id3153255" src="cmd/sc_sortdescending.png" width="0.1665inch"
height="0.1665inch"><alt id="alt_id3153255" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3144436" xml-lang="en-US">Sort
Descending</paragraph>
-</tablecell>
-</tablerow>
-</table>
+<section id="howtoget">
+ <switch select="appl"><case select="CALC">
+ <embed href="text/scalc/00/00000412.xhp#datasortdescending"/>
+ <embed href="text/scalc/00/00000412.xhp#onthestandardbar"/>
+ </case></switch>
+ <embed href="text/scalc/00/00000412.xhp#sortdescending"/>
</section>
<embed href="text/shared/02/12010000.xhp#selektionsortieren"/>
<embed href="text/shared/02/12010000.xhp#dialogsortieren"/>
diff --git a/source/text/shared/main0212.xhp b/source/text/shared/main0212.xhp
index 9f8eb26da..92cf50a6e 100644
--- a/source/text/shared/main0212.xhp
+++ b/source/text/shared/main0212.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="textsharedmain0212xml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Table Data Bar</title>
@@ -67,8 +67,9 @@
<embed href="text/shared/02/12100100.xhp#sortorder"/>
<embed href="text/shared/00/00000450.xhp#sysortieren"/>
<embed href="text/shared/02/12010000.xhp#aufsteigend"/>
- <embed href="text/shared/02/12010000.xhp#syaufsteigend"/>
+ <embed href="text/scalc/00/00000412.xhp#sortascending"/>
<embed href="text/shared/02/12020000.xhp#absteigend"/>
+ <embed href="text/scalc/00/00000412.xhp#sortdescending"/>
<embed href="text/shared/02/12020000.xhp#syabsteigend"/>
<embed href="text/shared/02/12030000.xhp#autofilter"/>
<embed href="text/shared/02/12030000.xhp#syautofilter"/>
diff --git a/source/text/shared/main0213.xhp b/source/text/shared/main0213.xhp
index 5d74a7efb..359c25412 100644
--- a/source/text/shared/main0213.xhp
+++ b/source/text/shared/main0213.xhp
@@ -174,9 +174,9 @@
<embed href="text/shared/02/12100200.xhp#suchentext"/>
<embed href="text/shared/00/00000450.xhp#sydatensuchen"/>
<embed href="text/shared/02/12010000.xhp#aufsteigend"/>
-<embed href="text/shared/02/12010000.xhp#syaufsteigend"/>
+<embed href="text/scalc/00/00000412.xhp#sortascending"/>
<embed href="text/shared/02/12020000.xhp#absteigend"/>
-<embed href="text/shared/02/12020000.xhp#syabsteigend"/>
+<embed href="text/scalc/00/00000412.xhp#sortdescending"/>
<embed href="text/shared/02/12030000.xhp#autofilter"/>
<embed href="text/shared/02/12030000.xhp#syautofilter"/>
<embed href="text/shared/02/12110000.xhp#formbasedfilters"/>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
