From 4e2a0fb89aaf7a0ff41e8c07b8ce6dc7c8b02d09 Mon Sep 17 00:00:00 2001 From: Vladimir Glazounov Date: Mon, 2 Jun 2008 19:55:52 +0000 Subject: INTEGRATION: CWS hcshared18 (1.10.2); FILE MERGED 2008/05/28 18:13:15 fpe 1.10.2.5: remove DOCTYPE headers from source files to avoid performance problems in installed help 2008/05/27 13:20:05 ufi 1.10.2.4: vor final build 2008/05/23 11:07:58 ufi 1.10.2.3: building Sol 2008/05/21 09:10:24 ufi 1.10.2.2: vor testbuild 2008/04/23 09:53:42 fpe 1.10.2.1: committing changes to makefile and xhps --- helpcontent2/source/text/scalc/guide/filters.xhp | 76 +++++++++++++----------- 1 file changed, 40 insertions(+), 36 deletions(-) (limited to 'helpcontent2/source/text/scalc') diff --git a/helpcontent2/source/text/scalc/guide/filters.xhp b/helpcontent2/source/text/scalc/guide/filters.xhp index a3e9b76d41..4520d680a9 100755 --- a/helpcontent2/source/text/scalc/guide/filters.xhp +++ b/helpcontent2/source/text/scalc/guide/filters.xhp @@ -1,58 +1,60 @@ - - - + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + ************************************************************************ + --> + - Applying Filters /text/scalc/guide/filters.xhp - -Sun Microsystems, Inc. -FPE: Removed dead link -UFI: changed text and note re spec http://specs.openoffice.org/calc/ease-of-use/editing_of_non-filtered_selections.sxw -YJ: checked - -filters; introduction -advanced filters -rows; deleting with filters - +filters; applying/removing +rows;removing/redisplaying with filters +removing;filters +MW deleted "filters;showing..." and "clearing;", and changed "filters;introduction" and "rows;"mw deleted advanced filters Applying Filters 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. - + One use for the AutoFilter function is to quickly restrict the display to records with identical entries in a data field. @@ -63,7 +65,9 @@ YJ: checked The Advanced filter exceeds the three condition limitation and allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet. -When you select filtered rows and then either apply formatting, or delete the selected rows, this action then applies only to the filtered rows. The hidden rows are not affected. This is the opposite to rows that you have hidden manually by the Format - Rows - Hide Rows command. Manually hidden rows are deleted when you delete a selection that contains them. +To remove a filter, so that you see all cells again, click inside the area where the filter was applied, then choose Data - Filter - Remove Filter. +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. +This is the opposite to rows that you have hidden manually by the Format - Rows - Hide Rows command. Manually hidden rows are deleted when you delete a selection that contains them.
-- cgit