diff options
| author | Rafael Lima <rafael.palma.lima@gmail.com> | 2021-07-01 20:11:05 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-07-02 21:07:26 +0200 |
| commit | 86d4cff5887833253bcfe95ecdb1689ef810315c (patch) | |
| tree | 510853ff108240bfbbc1d59fda7f93a88b7d8f29 /source/text/scalc/guide | |
| parent | 5eac8cf1a7d652c4ab41f4a39cc1095198660808 (diff) | |
tdf#102523 Improve Advanced Filter help page
This patch embeds the page specialfilter.xhp and 12040201.xhp into the 12040300.xhp file, which is the landing page when the user clicks the Help button in the Advanced Filter dialog.
As a result, the landing page now covers all the features in the dialog and also presents a useful example.
This also updates the .tree file.
Change-Id: I25d31838fa2604851962fdf8200b887255489017
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118191
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/guide')
| -rw-r--r-- | source/text/scalc/guide/specialfilter.xhp | 85 |
1 files changed, 30 insertions, 55 deletions
diff --git a/source/text/scalc/guide/specialfilter.xhp b/source/text/scalc/guide/specialfilter.xhp index 3cb7367ae1..e206214360 100644 --- a/source/text/scalc/guide/specialfilter.xhp +++ b/source/text/scalc/guide/specialfilter.xhp @@ -1,4 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- * This file is part of the LibreOffice project. * @@ -16,24 +18,23 @@ * 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="textscalcguidespecialfilterxml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Filter: Applying Advanced Filters</title> -<filename>/text/scalc/guide/specialfilter.xhp</filename> -</topic> + <topic id="textscalcguidespecialfilterxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Applying Advanced Filters</title> + <filename>/text/scalc/guide/specialfilter.xhp</filename> + </topic> </meta> <body> - - <bookmark xml-lang="en-US" branch="index" id="bm_id3148798"><bookmark_value>filters;defining advanced filters </bookmark_value> <bookmark_value>advanced filters</bookmark_value> <bookmark_value>defining; advanced filters</bookmark_value> <bookmark_value>database ranges; advanced filters</bookmark_value> </bookmark> - <comment>MW made "applying;advanced filters" a one level entry</comment> - <h1 id="hd_id3148798"><variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp" name="Filter: Applying Advanced Filters">Filter: Applying Advanced Filters</link> +<comment>MW made "applying;advanced filters" a one level entry</comment> +<section id="AdvancedFilter"> + <h1 id="hd_id3148798"><variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp" name="Applying Advanced Filters">Applying Advanced Filters</link> </variable></h1> <list type="ordered"> <listitem> @@ -50,9 +51,7 @@ <paragraph xml-lang="en-US" id="par_id3147427" role="paragraph">Load a spreadsheet with a large number of records. We are using a fictional <emph>Turnover</emph> document, but you can just as easily use any other document. The document has the following layout:</paragraph> <table id="tbl_id3149377"> <tablerow> - <tablecell> - - </tablecell> + <tablecell></tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3154510" role="tablehead" localize="false"> <emph>A</emph> </paragraph> </tablecell> @@ -139,12 +138,8 @@ <tablecell> <paragraph xml-lang="en-US" id="par_id3153334" role="paragraph" localize="false">170000</paragraph> </tablecell> - <tablecell> - - </tablecell> - <tablecell> - - </tablecell> + <tablecell></tablecell> + <tablecell></tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3151391" role="paragraph">and so on...</paragraph> </tablecell> @@ -152,12 +147,8 @@ </table> <paragraph xml-lang="en-US" id="par_id3147300" role="paragraph">Copy row 1 with the row headers (field names), to row 20, for example. Enter the filter conditions linked with OR in rows 21, 22, and so on.</paragraph> <table id="tbl_id3166462"> - - <tablerow> - <tablecell> - - </tablecell> + <tablecell></tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3159115" role="tablehead" localize="false"> <emph>A</emph> </paragraph> </tablecell> @@ -201,48 +192,32 @@ <tablecell> <paragraph xml-lang="en-US" id="par_id3149956" role="paragraph">January</paragraph> </tablecell> - <tablecell> - - </tablecell> - <tablecell> - - </tablecell> - <tablecell> - - </tablecell> - <tablecell> - - </tablecell> + <tablecell></tablecell> + <tablecell></tablecell> + <tablecell></tablecell> + <tablecell></tablecell> </tablerow> <tablerow> <tablecell> <paragraph xml-lang="en-US" id="par_id3150865" role="tablehead" localize="false"> <emph>22</emph> </paragraph> </tablecell> - <tablecell> - - </tablecell> + <tablecell></tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3155957" role="paragraph" localize="false"><160000</paragraph> </tablecell> - <tablecell> - - </tablecell> - <tablecell> - - </tablecell> - <tablecell> - - </tablecell> + <tablecell></tablecell> + <tablecell></tablecell> + <tablecell></tablecell> </tablerow> </table> <paragraph xml-lang="en-US" id="par_id3153566" role="paragraph">Specify that only rows which either have the value <literal>January</literal> in the <emph>Month</emph> cells OR a value of under 160000 in the <emph>Standard</emph><comment>standard not default, look at U59!!!</comment> cells will be displayed.</paragraph> <paragraph xml-lang="en-US" id="par_id3147372" role="paragraph">Choose <menuitem>Data - More Filters - Advanced Filter</menuitem>, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view.</paragraph> - <section id="relatedtopics"> - - <embed href="text/scalc/guide/filters.xhp#filters"/> - <embed href="text/scalc/guide/autofilter.xhp#autofilter"/> - <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> - - </section> - </body> +</section> + +<section id="relatedtopics"> + <embed href="text/scalc/guide/filters.xhp#filters"/> + <embed href="text/scalc/guide/autofilter.xhp#autofilter"/> + <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> +</section> +</body> </helpdocument> |