diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2008-06-02 19:55:52 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2008-06-02 19:55:52 +0000 |
| commit | 4e2a0fb89aaf7a0ff41e8c07b8ce6dc7c8b02d09 (patch) | |
| tree | 30ba69441e58253f0735f4d65b1ce2de30164fd9 /helpcontent2/source/text/scalc | |
| parent | fe9cd58b8318fe4dd4be06824164607c86949691 (diff) | |
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
Diffstat (limited to 'helpcontent2/source/text/scalc')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/filters.xhp | 76 |
1 files changed, 40 insertions, 36 deletions
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 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<helpdocument version="1.0"> + +<!-- + *********************************************************************** * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2008 by Sun Microsystems, Inc. + * OpenOffice.org - a multi-platform office productivity suite * - * OpenOffice.org - a multi-platform office productivity suite + * $RCSfile: filters.xhp,v $fileonly,v $ * - * $RCSfile: filters.xhp,v $ - * $Revision: 1.10 $ + * $Revision: 1.11 $ * - * This file is part of OpenOffice.org. + * last change: $Author: vg $ $Date: 2008-06-02 20:55:52 $ * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * - ************************************************************************--> - - + * 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 + * + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> <topic id="textscalcguidefiltersxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Applying Filters</title> <filename>/text/scalc/guide/filters.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-21T09:52:22">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</lastedited> -</history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3153896"><bookmark_value>filters; introduction</bookmark_value> -<bookmark_value>advanced filters</bookmark_value> -<bookmark_value>rows; deleting with filters</bookmark_value> -</bookmark> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153896"><bookmark_value>filters; applying/removing</bookmark_value> +<bookmark_value>rows;removing/redisplaying with filters</bookmark_value> +<bookmark_value>removing;filters</bookmark_value> +</bookmark><comment>MW deleted "filters;showing..." and "clearing;", and changed "filters;introduction" and "rows;"</comment><comment>mw deleted advanced filters</comment> <paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="1" l10n="U" oldref="70"><variable id="filters"><link href="text/scalc/guide/filters.xhp" name="Applying Filters">Applying Filters</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" 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> -<list type="unordered"> +<list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3155131" xml-lang="en-US" 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> </listitem> @@ -63,7 +65,9 @@ YJ: checked</lastedited> <paragraph role="listitem" id="par_id3150010" xml-lang="en-US" l10n="U" oldref="5">The <emph>Advanced filter</emph> 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.</paragraph> </listitem> </list> -<paragraph role="note" id="par_idN10663" xml-lang="en-US" l10n="NEW">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 <emph>Format - Rows - Hide Rows</emph> command. Manually hidden rows are deleted when you delete a selection that contains them.</paragraph> +<paragraph role="tip" id="par_id9384746" xml-lang="en-US" 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> +<paragraph role="note" id="par_idN10663" xml-lang="en-US" 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> +<paragraph role="note" id="par_id218817" xml-lang="en-US" 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> <section id="relatedtopics"> <embed href="text/scalc/guide/autofilter.xhp#autofilter"/> <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> |