diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-20 11:01:08 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-20 15:16:11 +0100 |
| commit | 562631aa3b0f0a6055e899e8b36491bee52fcb73 (patch) | |
| tree | f5d3868ab496a5edd32df4be654af0d5264cb3ba /source | |
| parent | ea72cf580abb767685e2fa6d9e5b9ef895eed06b (diff) | |
Review, refactor Calc Data Menu Help pages
- update to latest menu entries
- embed headings from individual Help files
- WIP: Statistics menu entry will come later
Change-Id: I66a2627b7bea65945210b6dcc2d1c3ed8783aec9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90796
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
27 files changed, 370 insertions, 373 deletions
diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp index 476ce5e283..c6de85323f 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 4c3bf3ee29..cfd99329dc 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 a699234c1b..ddc72f6f28 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 32e295b4b2..4706e8b584 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 1e9241d7ef..50b18d46ca 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 ceb97c8ac0..2ec45561c5 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 6aa6a3dfde..6f7ec99088 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 b58ccb5717..437f2b9847 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 3b6ddf52e4..81e11c3b4e 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 d709900ac6..f9a1f947f9 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 3118e332a3..5c44eb65c6 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 296d6958e1..6b99ab45f3 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 5a648893bc..37e1314124 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 d5a4332d0a..d5bf157658 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 1812b7bc57..e101beb39e 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 0000000000..b61d22229d --- /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 ab21054080..9c299714ff 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 f1948be68c..b7714b2d9e 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 6f26c9a02a..545a166b50 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 40195960d3..dec39b985f 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 6250ef7f75..05541b1871 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 8e605f9760..6e204cd843 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 37a6a54b85..77725a3257 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 083e427d35..879ad2fb5b 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 64369d9a86..e7b80728f0 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 9f8eb26da2..92cf50a6e9 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 5d74a7efb3..359c25412c 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"/> |