1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski <topic id="textscalcguidefiltersxml" indexer="include" status="PUBLISH"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">Applying Filters</title> 31*b1cdbd2cSJim Jagielski <filename>/text/scalc/guide/filters.xhp</filename> 32*b1cdbd2cSJim Jagielski </topic> 33*b1cdbd2cSJim Jagielski </meta> 34*b1cdbd2cSJim Jagielski <body> 35*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3153896"><bookmark_value>filters; applying/removing</bookmark_value> 36*b1cdbd2cSJim Jagielski <bookmark_value>rows;removing/redisplaying with filters</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>removing;filters</bookmark_value> 38*b1cdbd2cSJim Jagielski</bookmark> 39*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3153896" role="heading" level="1" l10n="U" 40*b1cdbd2cSJim Jagielski oldref="70"><variable id="filters"><link href="text/scalc/guide/filters.xhp" name="Applying Filters">Applying Filters</link> 41*b1cdbd2cSJim Jagielski</variable></paragraph> 42*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150869" role="paragraph" l10n="CHG" oldref="2">Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in $[officename] there are various possibilities for applying filters.</paragraph> 43*b1cdbd2cSJim Jagielski <list type="ordered"> 44*b1cdbd2cSJim Jagielski <listitem> 45*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155131" role="listitem" l10n="U" oldref="3">One use for the <emph>AutoFilter</emph> function is to quickly restrict the display to records with identical entries in a data field.</paragraph> 46*b1cdbd2cSJim Jagielski </listitem> 47*b1cdbd2cSJim Jagielski <listitem> 48*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146119" role="listitem" l10n="U" oldref="4">In the <emph>Standard Filter</emph> dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect the conditions with either a logical AND or a logical OR operator.</paragraph> 49*b1cdbd2cSJim Jagielski </listitem> 50*b1cdbd2cSJim Jagielski <listitem> 51*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150010" role="listitem" l10n="U" oldref="5">The <emph>Advanced filter</emph> allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.</paragraph> 52*b1cdbd2cSJim Jagielski </listitem> 53*b1cdbd2cSJim Jagielski </list> 54*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id9384746" role="tip" l10n="NEW">To remove a filter, so that you see all cells again, click inside the area where the filter was applied, then choose <item type="menuitem">Data - Filter - Remove Filter</item>.</paragraph> 55*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_idN10663" role="note" l10n="NEW">When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected. </paragraph> 56*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id218817" role="note" l10n="NEW">This is the opposite to rows that you have hidden manually by the <emph>Format - Rows - Hide Rows</emph> command. Manually hidden rows are deleted when you delete a selection that contains them.</paragraph> 57*b1cdbd2cSJim Jagielski <section id="relatedtopics"> 58*b1cdbd2cSJim Jagielski <embed href="text/scalc/guide/autofilter.xhp#autofilter"/> 59*b1cdbd2cSJim Jagielski <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> 60*b1cdbd2cSJim Jagielski <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 61*b1cdbd2cSJim Jagielski </section> 62*b1cdbd2cSJim Jagielski </body> 63*b1cdbd2cSJim Jagielski</helpdocument>