[Libreoffice-commits] help.git: source/text
Olivier Hallot (via logerrit)
logerrit at kemper.freedesktop.org
Thu Mar 19 13:37:35 UTC 2020
source/text/scalc/guide/specialfilter.xhp | 87 ++++++++++++++----------------
1 file changed, 41 insertions(+), 46 deletions(-)
New commits:
commit fba2134365ca68c0c19fc13c4bce727333dd7d8b
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Wed Mar 18 22:43:33 2020 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Thu Mar 19 14:37:14 2020 +0100
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 at libreoffice.org>
diff --git a/source/text/scalc/guide/specialfilter.xhp b/source/text/scalc/guide/specialfilter.xhp
index 4709176b5..0def973e0 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>
More information about the Libreoffice-commits
mailing list