1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: 02230402.xhp,v $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textshared0102230402xml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">Filter
</title>
42 <filename>/text/shared/
01/
02230402.xhp
</filename>
47 <paragraph role=
"heading" id=
"hd_id3153323" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1"><link href=
"text/shared/01/02230402.xhp" name=
"Filter">Filter
</link></paragraph>
48 <paragraph role=
"paragraph" id=
"par_id3147088" xml-lang=
"en-US" l10n=
"U" oldref=
"2">Set the criteria for filtering the list of changes on the
<link href=
"text/shared/01/02230401.xhp" name=
"List"><emph>List
</emph></link> tab.
</paragraph>
50 <section id=
"howtoget">
51 <embed href=
"text/shared/00/00000402.xhp#rotliniefilter"/>
54 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_CB_DATE" id=
"bm_id3149398" localize=
"false"/>
55 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_LB_DATE" id=
"bm_id3147653" localize=
"false"/>
56 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_DF_DATE" id=
"bm_id3156113" localize=
"false"/>
57 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_TF_DATE" id=
"bm_id3148992" localize=
"false"/>
58 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_DF_DATE2" id=
"bm_id3155450" localize=
"false"/>
59 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_TF_DATE2" id=
"bm_id3149795" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3150355" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">Date
</paragraph>
60 <paragraph role=
"paragraph" id=
"par_id3147573" xml-lang=
"en-US" l10n=
"U" oldref=
"4"><ahelp hid=
"HID_REDLINING_FILTER_TF_DATE2">Filters the list of changes according to the date and the time that you specify.
</ahelp></paragraph>
61 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_IB_CLOCK" id=
"bm_id3155179" localize=
"false"/>
62 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_IB_CLOCK2" id=
"bm_id3156330" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3154811" xml-lang=
"en-US" level=
"3" l10n=
"U" oldref=
"17">Set Date/Time
</paragraph>
63 <table id=
"tbl_id3156192">
65 <tablecell colspan=
"" rowspan=
"">
66 <paragraph role=
"paragraph" id=
"par_id3159147" xml-lang=
"en-US" l10n=
"E">
67 <image id=
"img_id3150771" src=
"res/commandimagelist/sc_timefield.png" width=
"0.222inch" height=
"0.222inch"><alt id=
"alt_id3150771" xml-lang=
"en-US">Icon
</alt>
70 <tablecell colspan=
"" rowspan=
"">
71 <paragraph role=
"paragraph" id=
"par_id3143270" xml-lang=
"en-US" l10n=
"U" oldref=
"18"><ahelp hid=
"HID_REDLINING_FILTER_IB_CLOCK2">Enters the current date and time into the corresponding boxes.
</ahelp></paragraph>
75 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_CB_AUTOR" id=
"bm_id3149955" localize=
"false"/>
76 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_LB_AUTOR" id=
"bm_id3149786" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3155261" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5">Author
</paragraph>
77 <paragraph role=
"paragraph" id=
"par_id3150084" xml-lang=
"en-US" l10n=
"U" oldref=
"6"><ahelp hid=
"HID_REDLINING_FILTER_LB_AUTOR">Filters the list of changes according to the name of the author that you select from the list.
</ahelp></paragraph>
78 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_CB_RANGE" id=
"bm_id3151246" localize=
"false"/>
79 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_ED_RANGE" id=
"bm_id3152472" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3147531" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"13"><switchinline select=
"appl"><caseinline select=
"CALC">Range
80 </caseinline></switchinline></paragraph>
81 <paragraph role=
"paragraph" id=
"par_id3156344" xml-lang=
"en-US" l10n=
"U" oldref=
"14"><switchinline select=
"appl"><caseinline select=
"CALC"><ahelp hid=
"HID_REDLINING_FILTER_ED_RANGE">Filters the list of changes according to the range of cells that you specify. To select a range of cells in your sheet, click the
<emph>Set Reference
</emph>button (
<emph>...
</emph>).
</ahelp>
82 </caseinline></switchinline></paragraph>
83 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_BTN_REF" id=
"bm_id3149457" localize=
"false"/><paragraph role=
"paragraph" id=
"par_id4441663" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
"." visibility=
"hidden">Select the range of cells that you want to use as a filter.
</ahelp></paragraph>
84 <paragraph role=
"heading" id=
"hd_id3147304" xml-lang=
"en-US" level=
"3" l10n=
"U" oldref=
"15"><switchinline select=
"appl"><caseinline select=
"CALC">Set Reference
85 </caseinline></switchinline></paragraph>
86 <switch select=
"appl">
87 <case select=
"CALC"><table id=
"tbl_id3154073">
89 <tablecell colspan=
"" rowspan=
"">
90 <paragraph role=
"paragraph" id=
"par_id3151210" xml-lang=
"en-US" l10n=
"E">
91 <image id=
"img_id3154138" src=
"starmath/res/mi22011.png" width=
"0.3335inch" height=
"0.3335inch"><alt id=
"alt_id3154138" xml-lang=
"en-US">Icon
</alt>
94 <tablecell colspan=
"" rowspan=
"">
95 <paragraph role=
"paragraph" id=
"par_id3156215" xml-lang=
"en-US" l10n=
"U" oldref=
"16"><ahelp hid=
"HID_REDLINING_FILTER_BTN_REF">Select the range of cells that you want to use as a filter.
</ahelp></paragraph>
101 <bookmark xml-lang=
"en-US" branch=
"hid/SC:IMAGEBUTTON:RID_SCDLG_HIGHLIGHT_CHANGES:RB_ASSIGN" id=
"bm_id3147230" localize=
"false"/>
102 <bookmark xml-lang=
"en-US" branch=
"hid/SC:IMAGEBUTTON:RID_SCDLG_SIMPLEREF:RB_ASSIGN" id=
"bm_id3151044" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3159149" xml-lang=
"en-US" level=
"3" l10n=
"U" oldref=
"20"><switchinline select=
"appl"><caseinline select=
"CALC">Shrink/Max
103 </caseinline></switchinline></paragraph>
104 <switch select=
"appl">
105 <case select=
"CALC"><table id=
"tbl_id3158407">
107 <tablecell colspan=
"" rowspan=
"">
108 <paragraph role=
"paragraph" id=
"par_id3149809" xml-lang=
"en-US" l10n=
"E">
109 <image id=
"img_id3154153" src=
"formula/res/refinp1.png" width=
"0.1327inch" height=
"0.1327inch"><alt id=
"alt_id3154153" xml-lang=
"en-US">Icon
</alt>
112 <tablecell colspan=
"" rowspan=
"">
113 <paragraph role=
"paragraph" id=
"par_id3147287" xml-lang=
"en-US" l10n=
"U" oldref=
"21"><ahelp hid=
"SC:IMAGEBUTTON:RID_SCDLG_SIMPLEREF:RB_ASSIGN">Select the range of cells that you want to use as a filter, and then click this button to return to the filter list.
</ahelp></paragraph>
119 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_CB_ACTION" id=
"bm_id3149984" localize=
"false"/>
120 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_LB_ACTION" id=
"bm_id3145785" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3156543" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"9"><switchinline select=
"appl"><caseinline select=
"WRITER">Action
121 </caseinline></switchinline></paragraph>
122 <paragraph role=
"paragraph" id=
"par_id3155413" xml-lang=
"en-US" l10n=
"U" oldref=
"12"><switchinline select=
"appl"><caseinline select=
"WRITER"><ahelp hid=
"HID_REDLINING_FILTER_LB_ACTION">Filters the list of changes according to the type of change that you select in the
<emph>Action
</emph> box.
</ahelp>
123 </caseinline></switchinline></paragraph>
124 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_CB_COMMENT" id=
"bm_id3145264" localize=
"false"/>
125 <bookmark xml-lang=
"en-US" branch=
"hid/HID_REDLINING_FILTER_ED_COMMENT" id=
"bm_id3150105" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3155855" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"22">Comment
</paragraph>
126 <paragraph role=
"paragraph" id=
"par_id3151114" xml-lang=
"en-US" l10n=
"U" oldref=
"23"><ahelp hid=
"HID_REDLINING_FILTER_ED_COMMENT">Filters the comments of the changes according to the keyword(s) that you enter.
</ahelp></paragraph>
127 <paragraph role=
"tip" id=
"par_id3163820" xml-lang=
"en-US" l10n=
"U" oldref=
"24">You can also use
<link href=
"text/shared/01/02100000.xhp" name=
"regular expressions">regular expressions
</link> (wildcards) when you filter the comments.
</paragraph>