diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-18 22:43:33 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-19 14:37:14 +0100 |
| commit | fba2134365ca68c0c19fc13c4bce727333dd7d8b (patch) | |
| tree | 7fa74881a0280424c555dadcb6f47f965ed693ae | |
| parent | b6ece13cb50762fefce07a3d85f475721083fbff (diff) | |
Apply correct style for table head in page
Change-Id: I042e1ee043a9dc2034f9fa9c77100286cad02770
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90726
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/guide/specialfilter.xhp | 87 |
1 files changed, 41 insertions, 46 deletions
diff --git a/source/text/scalc/guide/specialfilter.xhp b/source/text/scalc/guide/specialfilter.xhp index 4709176b54..0def973e08 100644 --- a/source/text/scalc/guide/specialfilter.xhp +++ b/source/text/scalc/guide/specialfilter.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="textscalcguidespecialfilterxml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Filter: Applying Advanced Filters</title> @@ -29,17 +24,17 @@ </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> - <paragraph xml-lang="en-US" id="hd_id3148798" role="heading" level="1"><variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp" name="Filter: Applying Advanced Filters">Filter: Applying Advanced Filters</link> -</variable></paragraph> + <h1 id="hd_id3148798"><variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp" name="Filter: Applying Advanced Filters">Filter: Applying Advanced Filters</link> +</variable></h1> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3145785" role="listitem">Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR.</paragraph> @@ -54,31 +49,31 @@ <paragraph xml-lang="en-US" id="par_id3149664" role="paragraph"> <emph>Example</emph> </paragraph> <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> - <paragraph xml-lang="en-US" id="par_id3154510" role="paragraph"> <emph>A</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3154510" role="tablehead"> <emph>A</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150327" role="paragraph"> <emph>B</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3150327" role="tablehead"> <emph>B</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154756" role="paragraph"> <emph>C</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3154756" role="tablehead"> <emph>C</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155335" role="paragraph"> <emph>D</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3155335" role="tablehead"> <emph>D</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3146315" role="paragraph"> <emph>E</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3146315" role="tablehead"> <emph>E</emph> </paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145790" role="paragraph"> <emph>1</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3145790" role="tablehead"> <emph>1</emph> </paragraph> </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3159239" role="paragraph">Month</paragraph> @@ -98,7 +93,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154486" role="paragraph"> <emph>2</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3154486" role="tablehead"> <emph>2</emph> </paragraph> </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3148839" role="paragraph">January</paragraph> @@ -118,7 +113,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3146782" role="paragraph"> <emph>3</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3146782" role="tablehead"> <emph>3</emph> </paragraph> </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3149900" role="paragraph">February</paragraph> @@ -138,7 +133,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3151191" role="paragraph"> <emph>4</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3151191" role="tablehead"> <emph>4</emph> </paragraph> </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3147250" role="paragraph">March</paragraph> @@ -147,10 +142,10 @@ <paragraph xml-lang="en-US" id="par_id3153334" role="paragraph">170000</paragraph> </tablecell> <tablecell> - + </tablecell> <tablecell> - + </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3151391" role="paragraph">and so on...</paragraph> @@ -159,31 +154,31 @@ </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> - <paragraph xml-lang="en-US" id="par_id3159115" role="paragraph"> <emph>A</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3159115" role="tablehead"> <emph>A</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3146886" role="paragraph"> <emph>B</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3146886" role="tablehead"> <emph>B</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3153124" role="paragraph"> <emph>C</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3153124" role="tablehead"> <emph>C</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3152979" role="paragraph"> <emph>D</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3152979" role="tablehead"> <emph>D</emph> </paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145827" role="paragraph"> <emph>E</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3145827" role="tablehead"> <emph>E</emph> </paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149892" role="paragraph"> <emph>20</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3149892" role="tablehead"> <emph>20</emph> </paragraph> </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3150693" role="paragraph">Month</paragraph> @@ -203,53 +198,53 @@ </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149188" role="paragraph"> <emph>21</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3149188" role="tablehead"> <emph>21</emph> </paragraph> </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3149956" role="paragraph">January</paragraph> </tablecell> <tablecell> - + </tablecell> <tablecell> - + </tablecell> <tablecell> - + </tablecell> <tablecell> - + </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150865" role="paragraph"> <emph>22</emph> </paragraph> + <paragraph xml-lang="en-US" id="par_id3150865" role="tablehead"> <emph>22</emph> </paragraph> </tablecell> <tablecell> - + </tablecell> <tablecell> <paragraph xml-lang="en-US" id="par_id3155957" role="paragraph"><160000</paragraph> </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 <item type="literal">January</item> 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 <emph>Data - Filter - Advanced Filter</emph>, 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> </helpdocument> |