AllLangHelp_shared.mk | 1
source/text/scalc/01/12040100.xhp | 4 -
source/text/scalc/main0218.xhp | 4 -
source/text/shared/00/00000409.xhp | 22 +++---
source/text/shared/01/02250000.xhp | 2
source/text/shared/02/01170101.xhp | 2
source/text/shared/02/01170203.xhp | 128 ++++++++++++++++++-------------------
source/text/shared/02/12030000.xhp | 20 ++---
source/text/shared/02/12090000.xhp | 65 ------------------
source/text/shared/02/12090100.xhp | 7 +-
source/text/shared/02/12090101.xhp | 50 +++++++-------
source/text/shared/main0212.xhp | 30 ++++----
12 files changed, 137 insertions(+), 198 deletions(-)
New commits:
commit 4a1a76e6b7c74f0903b7695f137160e4c7e622f7
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Sep 11 16:53:35 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Sep 12 01:08:01 2024 +0200
tdf#162607 Remove dup's in hid2file.js Standard filter
+ Deleted shared/02/12090000.xhp because 12090100.xhp has much more info
and duplicates contents
+ rebuild links to reach 12090100.xhp
+ renamed references to Default filter to Standard filter.
+ add section to standard filter icon for embed purposes
+ refactor
Change-Id: Ib88b7574fa12910c4cf9c8af9cbf79577b600e4b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173237
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index f15199acc9..8408c4e768 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -549,7 +549,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
helpcontent2/source/text/shared/02/12070200 \
helpcontent2/source/text/shared/02/12070300 \
helpcontent2/source/text/shared/02/12080000 \
- helpcontent2/source/text/shared/02/12090000 \
helpcontent2/source/text/shared/02/12090100 \
helpcontent2/source/text/shared/02/12090101 \
helpcontent2/source/text/shared/02/12100000 \
diff --git a/source/text/scalc/01/12040100.xhp
b/source/text/scalc/01/12040100.xhp
index ae90a75643..b68032b791 100644
--- a/source/text/scalc/01/12040100.xhp
+++ b/source/text/scalc/01/12040100.xhp
@@ -61,7 +61,7 @@
<h3 id="hd_id91674926632440">Bottom 10</h3>
<paragraph role="paragraph" id="par_id791674926643175">Displays the 10 rows of
the cell range that contain the lowest values in the cells of the current
column. If these values are unique then no more than 10 rows will be visible,
but if the values are not unique then it is possible for more than 10 rows to
be shown.</paragraph>
<h3 id="hd_id851621534131430">Standard Filter</h3>
-<paragraph role="paragraph" id="par_id171621544405886">Opens the <link
href="text/shared/02/12090000.xhp">Standard Filter</link> dialog.</paragraph>
+<paragraph role="paragraph" id="par_id171621544405886">Opens the <link
href="text/shared/02/12090100.xhp">Standard Filter</link> dialog.</paragraph>
<h2 id="hd_id551621534136181">Search text box</h2>
<paragraph role="paragraph" id="par_id421621544399700">Search for a specific
entry in the list of values found in the current column. As characters are
typed in the text box, this list is updated to show only matching
entries.</paragraph>
<h2 id="hd_id581621534140892">All</h2>
@@ -74,7 +74,7 @@
<paragraph role="paragraph" id="par_id331621544378745">List of unique values
found in the current column.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
-<paragraph role="paragraph" id="par_id3145171"><link
href="text/shared/02/12090000.xhp">Default filter</link></paragraph>
+<paragraph role="paragraph" id="par_id3145171" localize="false" ><embedvar
href="text/shared/02/12090100.xhp#StandardFilter_h1"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/main0218.xhp b/source/text/scalc/main0218.xhp
index b5dc86114a..84314467dc 100644
--- a/source/text/scalc/main0218.xhp
+++ b/source/text/scalc/main0218.xhp
@@ -48,8 +48,8 @@
<embed href="text/scalc/00/00000405.xhp#sythemes"/>
<embed href="text/scalc/01/12040100.xhp#autofilter"/>
<embed href="text/scalc/00/00000412.xhp#syautofilter"/>
-<embed href="text/shared/02/12090000.xhp#standardfilter1"/>
-<embed href="text/shared/02/12090000.xhp#systandardfilter"/>
+<embed href="text/shared/02/12090100.xhp#StandardFilter_h1"/>
+<embed href="text/shared/00/00000409.xhp#systandardfilter"/>
<h2 id="par_idN10690"><link href="text/scalc/01/12040300.xhp">Advanced
Filter</link></h2>
<embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
<h2 id="par_idN106A8"><link href="text/scalc/01/12090100.xhp">Start</link></h2>
diff --git a/source/text/shared/00/00000409.xhp
b/source/text/shared/00/00000409.xhp
index b24278c94e..007b3c1326 100644
--- a/source/text/shared/00/00000409.xhp
+++ b/source/text/shared/00/00000409.xhp
@@ -36,16 +36,18 @@
<paragraph role="paragraph" id="par_id381703618952856">Choose
<menuitem>Data - Standard Filter</menuitem>.</paragraph>
<paragraph role="paragraph" id="par_id881703618957531">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Standard Filter</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_toolbars"/>
- <table id="tbl_id3149976">
- <tablerow>
- <tablecell>
- <paragraph role="paragraph" id="par_id3155619"><image
src="cmd/lc_formfiltered.svg" id="img_id3147588" width="1cm" height="1cm"><alt
id="alt_id3147588">Icon Standard Filter</alt></image></paragraph>
- </tablecell>
- <tablecell>
- <paragraph role="paragraph" id="par_id3148731">Standard
Filter</paragraph>
- </tablecell>
- </tablerow>
- </table>
+ <section id="systandardfilter">
+ <table id="tbl_id3149976">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3155619"><image
src="cmd/lc_formfiltered.svg" id="img_id3147588" width="1cm" height="1cm"><alt
id="alt_id3147588">Icon Standard Filter</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3148731">Standard
Filter</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
</section>
</body>
diff --git a/source/text/shared/01/02250000.xhp
b/source/text/shared/01/02250000.xhp
index c60bf7d1e7..7a07314213 100644
--- a/source/text/shared/01/02250000.xhp
+++ b/source/text/shared/01/02250000.xhp
@@ -94,7 +94,7 @@
<paragraph id="par_id3149664" role="paragraph">The list of table records
is automatically updated to match the new filter settings.</paragraph>
<bookmark branch="hid/.uno:Bib/standardFilter" id="bm_id8315073"
localize="false"/>
<paragraph id="par_id3145590" role="paragraph"><ahelp hid=".">Use the
<emph>Standard Filter</emph> to refine and to combine <emph>AutoFilter</emph>
search options.</ahelp></paragraph>
- <embed href="text/shared/02/12090000.xhp#filterdialog"/>
+ <embed href="text/shared/02/12090100.xhp#filterdialog"/>
<bookmark branch="hid/.uno:Bib/removeFilter" id="bm_id8467360"
localize="false"/>
<paragraph id="par_id3155311" role="paragraph"><ahelp hid=".">To display all
of the records in a table, click the <emph>Reset Filter</emph>
icon.</ahelp></paragraph>
<bookmark branch="hid/SVX_HID_FM_DELETEROWS" id="bm_id3153954"
localize="false"/>
diff --git a/source/text/shared/02/01170101.xhp
b/source/text/shared/02/01170101.xhp
index 50e4bde0fa..7b5a1ec8df 100644
--- a/source/text/shared/02/01170101.xhp
+++ b/source/text/shared/02/01170101.xhp
@@ -795,7 +795,7 @@
<section id="Section75">
<bookmark branch="hid/EXTENSIONS_HID_PROP_SHOW_FILTERSORT" id="bm_id7137363"
localize="false"/>
<h2 id="par_idN12156">Filtering/Sorting</h2>
- <paragraph id="par_idN1215A" role="paragraph"><ahelp hid=".">Specifies to
show or hide the filtering and sorting items in a selected
<emph>Navigation</emph> bar control.</ahelp> Filtering and sorting items are
the following: <emph>Sort ascending, Sort descending, Sort, Automatic filter,
Default filter, Apply filter, Reset filter/sort</emph>.</paragraph>
+ <paragraph id="par_idN1215A" role="paragraph"><ahelp hid=".">Specifies to
show or hide the filtering and sorting items in a selected
<emph>Navigation</emph> bar control.</ahelp> Filtering and sorting items are
the following: <emph>Sort ascending, Sort descending, Sort, Automatic filter,
Standard filter, Apply filter, Reset filter/sort</emph>.</paragraph>
</section>
<section id="Section76">
<bookmark branch="hid/EXTENSIONS_HID_PROP_ICONSIZE" id="bm_id7815790"
localize="false"/>
diff --git a/source/text/shared/02/01170203.xhp
b/source/text/shared/02/01170203.xhp
index c467f17a9c..de9e641bc6 100644
--- a/source/text/shared/02/01170203.xhp
+++ b/source/text/shared/02/01170203.xhp
@@ -19,149 +19,149 @@
<helpdocument version="1.0">
<meta>
<topic id="textshared0201170203xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Data</title>
+<title id="tit">Data</title>
<filename>/text/shared/02/01170203.xhp</filename>
</topic>
</meta>
<body>
<section id="data">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150040"><bookmark_value>forms; data</bookmark_value>
+<bookmark branch="index" id="bm_id3150040"><bookmark_value>forms;
data</bookmark_value>
<bookmark_value>data; forms and subforms</bookmark_value>
<bookmark_value>forms; subforms</bookmark_value>
<bookmark_value>subforms; description</bookmark_value>
</bookmark>
<h1 id="hd_id3150040"><link href="text/shared/02/01170203.xhp">Data</link></h1>
-<paragraph role="paragraph" id="par_id3147242" xml-lang="en-US">The<emph> Data
</emph>tab page defines the form properties that refer to the database that is
linked to the form.</paragraph>
+<paragraph role="paragraph" id="par_id3147242">The<emph> Data </emph>tab page
defines the form properties that refer to the database that is linked to the
form.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US">Defines the
data source on which the form is based, or specifies whether the data can be
edited by the user. Apart from the sort and filter functions, you will also
find all the necessary properties to create a <link
href="text/shared/02/01170203.xhp">subform</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3149398">Defines the data source on
which the form is based, or specifies whether the data can be edited by the
user. Apart from the sort and filter functions, you will also find all the
necessary properties to create a <link
href="text/shared/02/01170203.xhp">subform</link>.</paragraph>
<section id="howtoget">
<embed href="text/shared/00/00040501.xhp#form_properties_data"/>
</section>
<sort order="asc" descendant="h2">
<section id="Section1">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATASOURCE"
id="bm_id3153146" localize="false"/><h2 id="hd_id3154810">Data
source<comment>UFI: was Database</comment></h2>
-<paragraph role="paragraph" id="par_id3152349" xml-lang="en-US"><ahelp
hid=".">Defines the data source to which the form should refer.</ahelp> If you
click the <emph>...</emph> button, you call the <link
href="text/shared/01/01020000.xhp"><emph>Open</emph></link> dialog, where you
can choose a data source.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_DATASOURCE" id="bm_id3153146"
localize="false"/><h2 id="hd_id3154810">Data source<comment>UFI: was
Database</comment></h2>
+<paragraph role="paragraph" id="par_id3152349"><ahelp hid=".">Defines the data
source to which the form should refer.</ahelp> If you click the
<emph>...</emph> button, you call the <link
href="text/shared/01/01020000.xhp"><emph>Open</emph></link> dialog, where you
can choose a data source.</paragraph>
</section>
<section id="Section2">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCE"
id="bm_id3150275" localize="false"/><h2 id="hd_id3146948">Content<comment>UFI:
was Data source</comment></h2>
-<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp
hid=".">Determines the content to be used for the form. The content can be an
existing table or a query (previously created in the database), or it can be
defined by an SQL-statement. Before you enter a content you have to define the
exact type in <emph>Content type</emph>.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3149657" xml-lang="en-US">If you have
selected either "Table" or "Query" in <emph>Content type</emph>, the box lists
all the tables and queries set up in the selected database.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCE" id="bm_id3150275"
localize="false"/><h2 id="hd_id3146948">Content<comment>UFI: was Data
source</comment></h2>
+<paragraph role="paragraph" id="par_id3155922"><ahelp hid=".">Determines the
content to be used for the form. The content can be an existing table or a
query (previously created in the database), or it can be defined by an
SQL-statement. Before you enter a content you have to define the exact type in
<emph>Content type</emph>.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149657">If you have selected either
"Table" or "Query" in <emph>Content type</emph>, the box lists all the tables
and queries set up in the selected database.</paragraph>
</section>
<section id="Section3">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCETYPE"
id="bm_id3153381" localize="false"/><h2 id="hd_id3148755">Content type</h2>
-<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US"><ahelp
hid="HID_PROP_CURSORSOURCETYPE">Defines whether the data source is to be an
existing database table or query, or if the form is to be generated based on an
SQL statement.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3153192" xml-lang="en-US">If you choose
"Table" or "Query", the form will refer to the table or query that you specify
under <emph>Content</emph>. If you want to create a new query or a <link
href="text/shared/02/01170203.xhp">subform</link>, then you have to choose the
"SQL" option. You can then enter the statement for the SQL query or the subform
directly in the <emph>List content</emph> box on the Control properties Data
tab page.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCETYPE" id="bm_id3153381"
localize="false"/><h2 id="hd_id3148755">Content type</h2>
+<paragraph role="paragraph" id="par_id3150541"><ahelp
hid="HID_PROP_CURSORSOURCETYPE">Defines whether the data source is to be an
existing database table or query, or if the form is to be generated based on an
SQL statement.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153192">If you choose "Table" or
"Query", the form will refer to the table or query that you specify under
<emph>Content</emph>. If you want to create a new query or a <link
href="text/shared/02/01170203.xhp">subform</link>, then you have to choose the
"SQL" option. You can then enter the statement for the SQL query or the subform
directly in the <emph>List content</emph> box on the Control properties Data
tab page.</paragraph>
</section>
<section id="Section4">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ESCAPE_PROCESSING"
id="bm_id3144433" localize="false"/><h2 id="hd_id3158409">Analyze SQL
command</h2>
-<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp
hid=".">Specifies whether the SQL statement is to be analyzed by
%PRODUCTNAME.</ahelp> If set to Yes, you can click the <emph>...</emph> button
next to the <emph>Content</emph> list box. This will open a window where you
can graphically create a database query. When you close that window, the SQL
statement for the created query will be inserted in the <emph>Content</emph>
list box.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_ESCAPE_PROCESSING" id="bm_id3144433"
localize="false"/><h2 id="hd_id3158409">Analyze SQL command</h2>
+<paragraph role="paragraph" id="par_id3145171"><ahelp hid=".">Specifies
whether the SQL statement is to be analyzed by %PRODUCTNAME.</ahelp> If set to
Yes, you can click the <emph>...</emph> button next to the <emph>Content</emph>
list box. This will open a window where you can graphically create a database
query. When you close that window, the SQL statement for the created query will
be inserted in the <emph>Content</emph> list box.</paragraph>
</section>
<section id="Section5">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTER"
id="bm_id3144434" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_FILTER" id="bm_id3144434"
localize="false"/>
<h2 id="hd_id3154684">Filter</h2>
-<paragraph role="paragraph" id="par_id3150449" xml-lang="en-US"><ahelp
hid=".">Enter the required conditions for filtering the data in the form. The
filter specifications follow SQL rules without using the WHERE clause.</ahelp>
For example, if you want to display all records with the "Mike" forename, type
into the data field: Forename = 'Mike'. You can also combine conditions:
Forename = 'Mike' OR Forename = 'Peter'. All records matching either of these
two conditions will be displayed.</paragraph>
-<paragraph role="paragraph" id="par_id3156212" xml-lang="en-US">The filter
function is available in user mode through the <link
href="text/shared/02/12030000.xhp"><emph>AutoFilter</emph></link> and <link
href="text/shared/02/12090000.xhp"><emph>Default Filter</emph></link> icons on
the <link href="text/shared/main0213.xhp"><emph>Form Navigation</emph>
Bar</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3150449"><ahelp hid=".">Enter the
required conditions for filtering the data in the form. The filter
specifications follow SQL rules without using the WHERE clause.</ahelp> For
example, if you want to display all records with the "Mike" forename, type into
the data field: Forename = 'Mike'. You can also combine conditions: Forename =
'Mike' OR Forename = 'Peter'. All records matching either of these two
conditions will be displayed.</paragraph>
+<paragraph role="paragraph" id="par_id3156212">The filter function is
available in user mode through the <link
href="text/shared/02/12030000.xhp"><emph>AutoFilter</emph></link> and <link
href="text/shared/02/12090100.xhp"><emph>Standard Filter</emph></link> icons on
the <link href="text/shared/main0213.xhp"><emph>Form Navigation</emph>
Bar</link>.</paragraph>
</section>
<section id="Section6">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SORT_CRITERIA"
id="bm_id3151353" localize="false"/><h2 id="hd_id3156005">Sort</h2>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp
hid=".">Specifies the conditions to sort the data in the form. The
specification of the sorting conditions follows SQL rules without the use of
the ORDER BY clause.</ahelp> For example, if you want all records of a database
to be sorted in one field in an ascending order and in another field in a
descending order, enter Forename ASC, Name DESC (presuming Forename and Name
are the names of the data fields).</paragraph>
-<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US">The
appropriate icons on the <link href="text/shared/main0213.xhp"><emph>Form
Navigation</emph> Bar</link> can be used in User mode to sort: <link
href="text/shared/02/12010000.xhp"><emph>Sort Ascending</emph></link>, <link
href="text/shared/02/12020000.xhp"><emph>Sort Descending</emph></link>, <link
href="text/shared/02/12100100.xhp"><emph>Sort</emph></link>.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_SORT_CRITERIA" id="bm_id3151353"
localize="false"/><h2 id="hd_id3156005">Sort</h2>
+<paragraph role="paragraph" id="par_id3163712"><ahelp hid=".">Specifies the
conditions to sort the data in the form. The specification of the sorting
conditions follows SQL rules without the use of the ORDER BY clause.</ahelp>
For example, if you want all records of a database to be sorted in one field in
an ascending order and in another field in a descending order, enter Forename
ASC, Name DESC (presuming Forename and Name are the names of the data
fields).</paragraph>
+<paragraph role="paragraph" id="par_id3156444">The appropriate icons on the
<link href="text/shared/main0213.xhp"><emph>Form Navigation</emph> Bar</link>
can be used in User mode to sort: <link
href="text/shared/02/12010000.xhp"><emph>Sort Ascending</emph></link>, <link
href="text/shared/02/12020000.xhp"><emph>Sort Descending</emph></link>, <link
href="text/shared/02/12100100.xhp"><emph>Sort</emph></link>.</paragraph>
</section>
<section id="Section7">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATAENTRY"
id="bm_id3154129" localize="false"/><h2 id="hd_id3148616">Add data only</h2>
-<paragraph role="paragraph" id="par_id3153139" xml-lang="en-US"><ahelp
hid=".">Determines if the form only allows the addition of new data (Yes) or if
it allows other properties as well (No).</ahelp></paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_DATAENTRY" id="bm_id3154129"
localize="false"/><h2 id="hd_id3148616">Add data only</h2>
+<paragraph role="paragraph" id="par_id3153139"><ahelp hid=".">Determines if
the form only allows the addition of new data (Yes) or if it allows other
properties as well (No).</ahelp></paragraph>
<note id="par_id3148575">If <emph>Add data only</emph> is set to "Yes",
changing or deleting data is not possible.</note>
</section>
<section id="Section8">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_NAVIGATION"
id="bm_id3155418" localize="false"/><h2 id="hd_id3148455">Navigation bar</h2>
-<paragraph role="paragraph" id="par_id3157976" xml-lang="en-US"><ahelp
hid=".">Specifies whether the navigation functions in the lower form bar can be
used.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3149485" xml-lang="en-US">The "Parent
Form" option is used for subforms. If you choose this option for a subform, you
can navigate using the records of the main form if the cursor is placed in the
subform. A subform is linked to the parent form by a 1:1 relationship, so
navigation is always performed in the parent form.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_NAVIGATION" id="bm_id3155418"
localize="false"/><h2 id="hd_id3148455">Navigation bar</h2>
+<paragraph role="paragraph" id="par_id3157976"><ahelp hid=".">Specifies
whether the navigation functions in the lower form bar can be
used.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149485">The "Parent Form" option is
used for subforms. If you choose this option for a subform, you can navigate
using the records of the main form if the cursor is placed in the subform. A
subform is linked to the parent form by a 1:1 relationship, so navigation is
always performed in the parent form.</paragraph>
</section>
<section id="Section9">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CYCLE"
id="bm_id3151282" localize="false"/><h2 id="hd_id3151051">Cycle</h2>
-<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"><ahelp
hid=".">Determines how the navigation should be done using the tab key.</ahelp>
Using the tab key, you can move forward in the form. If you simultaneously
press the Shift key, the navigation will follow the opposite direction. If you
reach the last (or the first) field and press the tab key again, it can have
various effects. Define the key control with the following options:</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_CYCLE" id="bm_id3151282"
localize="false"/><h2 id="hd_id3151051">Cycle</h2>
+<paragraph role="paragraph" id="par_id3154944"><ahelp hid=".">Determines how
the navigation should be done using the tab key.</ahelp> Using the tab key, you
can move forward in the form. If you simultaneously press the Shift key, the
navigation will follow the opposite direction. If you reach the last (or the
first) field and press the tab key again, it can have various effects. Define
the key control with the following options:</paragraph>
<table id="tbl_id3150658">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3166413"
xml-lang="en-US">Option</paragraph>
+<paragraph role="tablehead" id="par_id3166413">Option</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3150424"
xml-lang="en-US">Meaning</paragraph>
+<paragraph role="tablehead" id="par_id3150424">Meaning</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3150417"
xml-lang="en-US">Default</paragraph>
+<paragraph role="paragraph" id="par_id3150417">Default</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3157847" xml-lang="en-US">This setting
automatically defines a cycle which follows an existing database link: If the
form contains a database link, the Tab key will, by default, initiate a change
to the next or previous record on exit from the last field (see All Records).
If there is no database link the next/previous form is shown (see Current
Page).</paragraph>
+<paragraph role="paragraph" id="par_id3157847">This setting automatically
defines a cycle which follows an existing database link: If the form contains a
database link, the Tab key will, by default, initiate a change to the next or
previous record on exit from the last field (see All Records). If there is no
database link the next/previous form is shown (see Current Page).</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3153418" xml-lang="en-US">All
records</paragraph>
+<paragraph role="paragraph" id="par_id3153418">All records</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152972" xml-lang="en-US">This option
applies to database forms only and is used to navigate through all records. If
you use the Tab key to exit from the last field of a form, the current record
is changed.</paragraph>
+<paragraph role="paragraph" id="par_id3152972">This option applies to database
forms only and is used to navigate through all records. If you use the Tab key
to exit from the last field of a form, the current record is
changed.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3151020" xml-lang="en-US">Active
record</paragraph>
+<paragraph role="paragraph" id="par_id3151020">Active record</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3145301" xml-lang="en-US">This option
applies to database forms only, and is used to navigate within the current
record. If you use the Tab key to exit from the last field of a form, the
current record is changed.</paragraph>
+<paragraph role="paragraph" id="par_id3145301">This option applies to database
forms only, and is used to navigate within the current record. If you use the
Tab key to exit from the last field of a form, the current record is
changed.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3146913" xml-lang="en-US">Current
page</paragraph>
+<paragraph role="paragraph" id="par_id3146913">Current page</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US">On exit from
the last field of a form, the cursor skips to the first field in the next form.
This is standard for HTML forms; therefore, this option is especially relevant
for HTML forms.</paragraph>
+<paragraph role="paragraph" id="par_id3150330">On exit from the last field of
a form, the cursor skips to the first field in the next form. This is standard
for HTML forms; therefore, this option is especially relevant for HTML
forms.</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="Section10">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_ADDITIONS"
id="bm_id3155445" localize="false"/><h2 id="hd_id3155064">Allow additions</h2>
-<paragraph role="paragraph" id="par_id3154360" xml-lang="en-US"><ahelp
hid=".">Determines if data can be added.</ahelp></paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_ALLOW_ADDITIONS" id="bm_id3155445"
localize="false"/><h2 id="hd_id3155064">Allow additions</h2>
+<paragraph role="paragraph" id="par_id3154360"><ahelp hid=".">Determines if
data can be added.</ahelp></paragraph>
</section>
<section id="Section11">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_EDITS"
id="bm_id3083286" localize="false"/><h2 id="hd_id3156054">Allow
modifications</h2>
-<paragraph role="paragraph" id="par_id3156377" xml-lang="en-US"><ahelp
hid="."> Determines if the data can be modified.</ahelp></paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_ALLOW_EDITS" id="bm_id3083286"
localize="false"/><h2 id="hd_id3156054">Allow modifications</h2>
+<paragraph role="paragraph" id="par_id3156377"><ahelp hid="."> Determines if
the data can be modified.</ahelp></paragraph>
</section>
<section id="Section12">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_DELETIONS"
id="bm_id3153924" localize="false"/><h2 id="hd_id3149019">Allow deletions</h2>
-<paragraph role="paragraph" id="par_id3148995" xml-lang="en-US"><ahelp
hid=".">Determines if the data can be deleted.</ahelp></paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_ALLOW_DELETIONS" id="bm_id3153924"
localize="false"/><h2 id="hd_id3149019">Allow deletions</h2>
+<paragraph role="paragraph" id="par_id3148995"><ahelp hid=".">Determines if
the data can be deleted.</ahelp></paragraph>
</section>
<section id="Section13">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_MASTERFIELDS"
id="bm_id3147097" localize="false"/><h2 id="hd_id3153714">Link master
fields</h2>
-<paragraph role="paragraph" id="par_id3147339" xml-lang="en-US"><ahelp
hid=".">If you create a <link
href="text/shared/02/01170203.xhp">subform</link>, enter the data field of the
parent form responsible for the synchronization between parent and
subform.</ahelp> To enter multiple values, press Shift + Enter after each input
line.<comment>UFI: fixes #i22439#</comment></paragraph>
-<paragraph role="paragraph" id="par_id3149568" xml-lang="en-US">The subform is
based on an <link href="text/shared/00/00000005.xhp#sql">SQL</link> query; more
specifically, on a <link href="text/sdatabase/02010100.xhp">Parameter
Query</link>. If a field name is entered in the <emph>Link master fields</emph>
box, the data contained in that field in the main form is read to a variable
that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL
statement, this variable is compared to the table data that the subform refers
to. Alternatively, you can enter the column name in the <emph>Link master
fields</emph> box.</paragraph>
-<paragraph role="paragraph" id="par_id3156089" xml-lang="en-US">Consider the
following example:</paragraph>
-<paragraph role="paragraph" id="par_id3151017" xml-lang="en-US">The database
table on which the form is based is, for example, a customer database
("Customer"), where every customer has been given a unique number in a data
field named "Cust_ID". A customer's orders are maintained in another database
table. You now want to see each customer's orders after entering them into the
form. In order to do this you should create a subform. Under <emph>Link master
fields</emph> enter the data field from the customer database which clearly
identifies the customer, that is, Cust_ID. Under <emph>Link slave fields</emph>
enter the name of a variable which is to accept the data of the field Cust_ID,
for example, x.</paragraph>
-<paragraph role="paragraph" id="par_id3151248" xml-lang="en-US">The subform
should show the appropriate data from the orders table ("Orders") for each
customer ID (Customer_ID -> x). This is only possible if each order is
uniquely assigned to one customer in the orders table. Alternatively, you can
use another field called Customer_ID; however, to make sure that this field is
not confused with the same field from the main form, the field is called
Customer_Number.</paragraph>
-<paragraph role="paragraph" id="par_id3153537" xml-lang="en-US">Now compare
the Customer_Number in the "Orders" table with the Customer_ID from the
"Customers" table, which can be done, for example, using the x variable with
the following SQL statement:</paragraph>
-<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US">SELECT * FROM
Orders WHERE Customer_Number =: x (if you want the subform to show all data
from the orders table)</paragraph>
-<paragraph role="paragraph" id="par_id3163727" xml-lang="en-US">or:</paragraph>
-<paragraph role="paragraph" id="par_id3153921" xml-lang="en-US">SELECT Item
FROM Orders WHERE Customer_Number =: x (if you want the subform from the orders
table to show only the data contained in the "Item" field)</paragraph>
-<paragraph role="paragraph" id="par_id3148488" xml-lang="en-US">The SQL
statement can either be entered in the <emph>Data source</emph> field, or you
can create an appropriate parameter query, which can be used to create the
subform.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_MASTERFIELDS" id="bm_id3147097"
localize="false"/><h2 id="hd_id3153714">Link master fields</h2>
+<paragraph role="paragraph" id="par_id3147339"><ahelp hid=".">If you create a
<link href="text/shared/02/01170203.xhp">subform</link>, enter the data field
of the parent form responsible for the synchronization between parent and
subform.</ahelp> To enter multiple values, press Shift + Enter after each input
line.<comment>UFI: fixes #i22439#</comment></paragraph>
+<paragraph role="paragraph" id="par_id3149568">The subform is based on an
<link href="text/shared/00/00000005.xhp#sql">SQL</link> query; more
specifically, on a <link href="text/sdatabase/02010100.xhp">Parameter
Query</link>. If a field name is entered in the <emph>Link master fields</emph>
box, the data contained in that field in the main form is read to a variable
that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL
statement, this variable is compared to the table data that the subform refers
to. Alternatively, you can enter the column name in the <emph>Link master
fields</emph> box.</paragraph>
+<paragraph role="paragraph" id="par_id3156089">Consider the following
example:</paragraph>
+<paragraph role="paragraph" id="par_id3151017">The database table on which the
form is based is, for example, a customer database ("Customer"), where every
customer has been given a unique number in a data field named "Cust_ID". A
customer's orders are maintained in another database table. You now want to see
each customer's orders after entering them into the form. In order to do this
you should create a subform. Under <emph>Link master fields</emph> enter the
data field from the customer database which clearly identifies the customer,
that is, Cust_ID. Under <emph>Link slave fields</emph> enter the name of a
variable which is to accept the data of the field Cust_ID, for example,
x.</paragraph>
+<paragraph role="paragraph" id="par_id3151248">The subform should show the
appropriate data from the orders table ("Orders") for each customer ID
(Customer_ID -> x). This is only possible if each order is uniquely assigned
to one customer in the orders table. Alternatively, you can use another field
called Customer_ID; however, to make sure that this field is not confused with
the same field from the main form, the field is called
Customer_Number.</paragraph>
+<paragraph role="paragraph" id="par_id3153537">Now compare the Customer_Number
in the "Orders" table with the Customer_ID from the "Customers" table, which
can be done, for example, using the x variable with the following SQL
statement:</paragraph>
+<paragraph role="paragraph" id="par_id3155335">SELECT * FROM Orders WHERE
Customer_Number =: x (if you want the subform to show all data from the orders
table)</paragraph>
+<paragraph role="paragraph" id="par_id3163727">or:</paragraph>
+<paragraph role="paragraph" id="par_id3153921">SELECT Item FROM Orders WHERE
Customer_Number =: x (if you want the subform from the orders table to show
only the data contained in the "Item" field)</paragraph>
+<paragraph role="paragraph" id="par_id3148488">The SQL statement can either be
entered in the <emph>Data source</emph> field, or you can create an appropriate
parameter query, which can be used to create the subform.</paragraph>
</section>
<section id="Section14">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SLAVEFIELDS"
id="bm_id3145789" localize="false"/><h2 id="hd_id3150648">Link slave fields</h2>
-<paragraph role="paragraph" id="par_id3149923" xml-lang="en-US"><ahelp
hid=".">If you create a subform, enter the variable where possible values from
the parent form field can be stored.</ahelp> If a subform is based on a query,
enter the variable that you defined in the query. If you create a form using an
SQL statement entered in the <emph>Data source</emph> field, enter the variable
you used in the statement. You can choose any variable name. If you want to
enter multiple values, press Shift + Enter.</paragraph>
-<paragraph role="paragraph" id="par_id3155114" xml-lang="en-US">If, for
example, you specified the Customer_ID database field as a parent field under
<emph>Link master fields</emph>, then you can define under <emph>Link slave
fields</emph> the name of the variable in which the values of the Customer_ID
database field are to be stored. If you now specify an SQL statement in the
<emph>Data source</emph> box using this variable, the relevant values are
displayed in the subform.</paragraph>
+<bookmark branch="hid/EXTENSIONS_HID_PROP_SLAVEFIELDS" id="bm_id3145789"
localize="false"/><h2 id="hd_id3150648">Link slave fields</h2>
+<paragraph role="paragraph" id="par_id3149923"><ahelp hid=".">If you create a
subform, enter the variable where possible values from the parent form field
can be stored.</ahelp> If a subform is based on a query, enter the variable
that you defined in the query. If you create a form using an SQL statement
entered in the <emph>Data source</emph> field, enter the variable you used in
the statement. You can choose any variable name. If you want to enter multiple
values, press Shift + Enter.</paragraph>
+<paragraph role="paragraph" id="par_id3155114">If, for example, you specified
the Customer_ID database field as a parent field under <emph>Link master
fields</emph>, then you can define under <emph>Link slave fields</emph> the
name of the variable in which the values of the Customer_ID database field are
to be stored. If you now specify an SQL statement in the <emph>Data
source</emph> box using this variable, the relevant values are displayed in the
subform.</paragraph>
</section>
</sort>
<h2 id="hd_id3152778">What is a subform?</h2>
-<paragraph role="paragraph" id="par_id3155579" xml-lang="en-US">Forms are
created based on a database table or database query. They display the data in a
visually pleasant fashion and can be used to enter data or edit
data.</paragraph>
-<paragraph role="paragraph" id="par_id3147094" xml-lang="en-US"><variable
id="wozu">If you require a form that can refer to the data in a table or query
and can additionally display data from another table, you should create a
subform.
+<paragraph role="paragraph" id="par_id3155579">Forms are created based on a
database table or database query. They display the data in a visually pleasant
fashion and can be used to enter data or edit data.</paragraph>
+<paragraph role="paragraph" id="par_id3147094"><variable id="wozu">If you
require a form that can refer to the data in a table or query and can
additionally display data from another table, you should create a subform.
</variable> For example, this subform can be a text box that displays the data
of another database table.</paragraph>
-<paragraph role="paragraph" id="par_id3157972" xml-lang="en-US">A subform is
an additional component of the main form. The main form can be called the
"parent form" or "master". Subforms are needed as soon as you want to access
more than one table from a form. Each additional table requires its own
subform.</paragraph>
-<paragraph role="paragraph" id="par_id4807275" xml-lang="en-US">After creating
a form, it can be changed into a subform. To do this, enter Design Mode, and
open the Form Navigator. In the Form Navigator, drag a form (that will become a
subform) onto any other form (that will become a master).</paragraph>
-<paragraph role="paragraph" id="par_id3158444" xml-lang="en-US">The user of
your document will not see that a form has subforms. The user only sees a
document in which data is entered or where existing data is
displayed.</paragraph>
-<paragraph role="paragraph" id="par_idN10C2A" xml-lang="en-US">Specify the
Link master field from the data fields in the master form. In the subform, the
Link slave field can be set as a field which will be matched to the contents of
the Link master field.</paragraph>
-<paragraph role="paragraph" id="par_idN10C2D" xml-lang="en-US">When the user
navigates through the data, the form always displays the current data record.
If there are subforms defined, the contents of the subforms will be displayed
after a short delay of approximate 200 ms. This delay enables you to quickly
browse through the data records of the master form. If you navigate to the next
master data record within the delay limit, the subform data need not be
retrieved and displayed.</paragraph>
+<paragraph role="paragraph" id="par_id3157972">A subform is an additional
component of the main form. The main form can be called the "parent form" or
"master". Subforms are needed as soon as you want to access more than one table
from a form. Each additional table requires its own subform.</paragraph>
+<paragraph role="paragraph" id="par_id4807275">After creating a form, it can
be changed into a subform. To do this, enter Design Mode, and open the Form
Navigator. In the Form Navigator, drag a form (that will become a subform) onto
any other form (that will become a master).</paragraph>
+<paragraph role="paragraph" id="par_id3158444">The user of your document will
not see that a form has subforms. The user only sees a document in which data
is entered or where existing data is displayed.</paragraph>
+<paragraph role="paragraph" id="par_idN10C2A">Specify the Link master field
from the data fields in the master form. In the subform, the Link slave field
can be set as a field which will be matched to the contents of the Link master
field.</paragraph>
+<paragraph role="paragraph" id="par_idN10C2D">When the user navigates through
the data, the form always displays the current data record. If there are
subforms defined, the contents of the subforms will be displayed after a short
delay of approximate 200 ms. This delay enables you to quickly browse through
the data records of the master form. If you navigate to the next master data
record within the delay limit, the subform data need not be retrieved and
displayed.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/02/12030000.xhp
b/source/text/shared/02/12030000.xhp
index f05f562e3e..e12b8be4f8 100644
--- a/source/text/shared/02/12030000.xhp
+++ b/source/text/shared/02/12030000.xhp
@@ -19,32 +19,32 @@
<helpdocument version="1.0">
<meta>
<topic id="textshared0212030000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">AutoFilter</title>
+<title id="tit">AutoFilter</title>
<filename>/text/shared/02/12030000.xhp</filename>
</topic>
</meta>
<body>
<section id="autofilter">
-<bookmark xml-lang="en-US" branch="hid/.uno:AutoFilter" id="bm_id8419293"
localize="false"/>
+<bookmark branch="hid/.uno:AutoFilter" id="bm_id8419293" localize="false"/>
<h1 id="hd_id3149495"><link
href="text/shared/02/12030000.xhp">AutoFilter</link></h1>
-<paragraph role="paragraph" id="par_id3148983" xml-lang="en-US"><ahelp
hid=".uno:AutoFilter">Filters the records, based on the content of the
currently selected data field.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148983"><ahelp
hid=".uno:AutoFilter">Filters the records, based on the content of the
currently selected data field.</ahelp></paragraph>
</section>
<section id="syautofilter">
<table id="tbl_id3147143">
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3151234" xml-lang="en-US">
-<image id="img_id3147261" src="cmd/lc_datafilterautofilter.svg" width="1cm"
height="1cm"><alt id="alt_id3147261" xml-lang="en-US">Icon
AutoFilter</alt></image></paragraph>
+<paragraph role="paragraph" id="par_id3151234">
+<image id="img_id3147261" src="cmd/lc_datafilterautofilter.svg" width="1cm"
height="1cm"><alt id="alt_id3147261">Icon AutoFilter</alt></image></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3147043"
xml-lang="en-US">AutoFilter</paragraph>
+<paragraph role="paragraph" id="par_id3147043">AutoFilter</paragraph>
</tablecell>
</tablerow>
</table>
</section>
-<paragraph role="paragraph" id="par_id3155355" xml-lang="en-US">Place the
cursor in a field name whose content you want to filter and then click the
<emph>AutoFilter</emph> icon. Only those records with content identical to the
selected field name are visible.</paragraph>
-<paragraph role="paragraph" id="par_id3159234" xml-lang="en-US">For example,
to view all the customers from New York, click a field name with the entry "New
York". AutoFilter then filters all customers from New York from the
database.</paragraph>
-<paragraph role="paragraph" id="par_id3153577" xml-lang="en-US">You can remove
the current AutoFilter with the <link href="text/shared/02/12040000.xhp">Reset
Filter/Sorting</link> icon or with <emph>Data - Filter - Reset
Filter</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US">To filter with
several field names simultaneously, click the <emph>Default Filter </emph>icon.
The <link href="text/shared/02/12090000.xhp">Default Filter</link> dialog
appears, in which you can combine several filter criteria.</paragraph>
+<paragraph role="paragraph" id="par_id3155355">Place the cursor in a field
name whose content you want to filter and then click the
<emph>AutoFilter</emph> icon. Only those records with content identical to the
selected field name are visible.</paragraph>
+<paragraph role="paragraph" id="par_id3159234">For example, to view all the
customers from New York, click a field name with the entry "New York".
AutoFilter then filters all customers from New York from the
database.</paragraph>
+<paragraph role="paragraph" id="par_id3153577">You can remove the current
AutoFilter with the <link href="text/shared/02/12040000.xhp">Reset
Filter/Sorting</link> icon or with <emph>Data - Filter - Reset
Filter</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3145345">To filter with several field
names simultaneously, click the <emph>Default Filter </emph>icon. The <link
href="text/shared/02/12090100.xhp">Standard Filter</link> dialog appears, in
which you can combine several filter criteria.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/02/12090000.xhp
b/source/text/shared/02/12090000.xhp
deleted file mode 100644
index d14620569c..0000000000
--- a/source/text/shared/02/12090000.xhp
+++ /dev/null
@@ -1,65 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed
- * with this work for additional information regarding copyright
- * ownership. The ASF licenses this file to you under the Apache
- * License, Version 2.0 (the "License"); you may not use this file
- * except in compliance with the License. You may obtain a copy of
- * the License at http://www.apache.org/licenses/LICENSE-2.0 .
- -->
-
-
-<meta>
- <topic id="textshared0212090000xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Standard Filter</title>
- <filename>/text/shared/02/12090000.xhp</filename>
- </topic>
- </meta>
- <body>
- <section id="standardfilter1">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3109850"><bookmark_value>default filters, see standard
filters</bookmark_value>
- <bookmark_value>databases; standard filters</bookmark_value>
- <bookmark_value>standard filters;databases</bookmark_value>
-</bookmark><comment>mw converted "standard filters..." into a two level entry
and "default filters;" into a cross reference</comment>
-<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/queryfilterdialog/QueryFilterDialog" id="bm_id3154894"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:FilterCrit" id="bm_id2784060"
localize="false"/>
-<h1 id="hd_id3109850"><link href="text/shared/02/12090000.xhp">Standard
Filter</link></h1>
- <paragraph xml-lang="en-US" id="par_id3143281"
role="paragraph"><variable id="standardfilter"><ahelp
hid=".uno:FilterCrit">Allows you to set the filtering options.</ahelp>
-</variable></paragraph>
- </section>
- <paragraph xml-lang="en-US" id="par_id3149549" role="paragraph">Use the
<emph>Standard Filter</emph> to refine and to combine <emph>AutoFilter
</emph>search options.</paragraph>
- <section id="systandardfilter">
- <table id="tbl_id3152924">
- <tablerow>
- <tablecell>
- <paragraph xml-lang="en-US" id="par_id3152801"
role="paragraph">
-<image id="img_id3147291" src="cmd/sc_formfiltered.png" width="0.1665in"
height="0.1665in"><alt xml-lang="en-US" id="alt_id3147291">Icon</alt>
- </image></paragraph>
- </tablecell>
- <tablecell>
- <paragraph xml-lang="en-US" id="par_id3149183"
role="paragraph">Standard Filter</paragraph>
- </tablecell>
- </tablerow>
- </table>
-
- </section>
- <section id="filterdialog">
- <paragraph xml-lang="en-US" id="par_id3143267"
role="paragraph">$[officename] saves the current filter settings for the next
time that you open this dialog.</paragraph>
- </section>
- <paragraph xml-lang="en-US" id="par_id3156410" role="paragraph">To
remove the current filter, click <link
href="text/shared/02/12040000.xhp"><emph>Reset Filter/Sorting</emph></link>
icon.</paragraph>
- <section id="relatedtopics">
- <paragraph xml-lang="en-US" id="par_id3152996" role="paragraph"><link
href="text/shared/02/12030000.xhp">AutoFilter</link></paragraph>
- </section>
- </body>
-</helpdocument>
diff --git a/source/text/shared/02/12090100.xhp
b/source/text/shared/02/12090100.xhp
index fcab8c52a0..e755fcf6f4 100644
--- a/source/text/shared/02/12090100.xhp
+++ b/source/text/shared/02/12090100.xhp
@@ -37,9 +37,12 @@
<h1 id="hd_id3151097"><variable id="StandardFilter_h1"><link
href="text/shared/02/12090100.xhp">Standard Filter</link></variable></h1>
<paragraph id="par_id3149716" role="paragraph"><ahelp hid=".">Specifies
the logical conditions to filter your table data.</ahelp> This dialog is
available for spreadsheet documents, database tables and database forms. The
dialog for databases does not contain the <emph>More Options</emph>
button.</paragraph>
</section>
- <section id="howtoget">
+ <section id="filterdialog">
+ <paragraph id="par_id3143267" role="paragraph">$[officename] saves the
current filter settings for the next time that you open this dialog.</paragraph>
+ </section>
+ <section id="howtoget">
<embed href="text/shared/00/00000409.xhp#standard_filter"/>
- </section>
+ </section>
<switch select="appl">
<case select="CALC">
<paragraph id="par_idN105EE" role="paragraph" localize="false">
diff --git a/source/text/shared/02/12090101.xhp
b/source/text/shared/02/12090101.xhp
index be34382093..cbc85f557a 100644
--- a/source/text/shared/02/12090101.xhp
+++ b/source/text/shared/02/12090101.xhp
@@ -22,110 +22,110 @@
<meta>
<topic id="textshared0212090101xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Comparison Operators</title>
+ <title id="tit">Comparison Operators</title>
<filename>/text/shared/02/12090101.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3148983"><bookmark_value>comparisons;operators in standard filter
dialog</bookmark_value>
+<bookmark branch="index"
id="bm_id3148983"><bookmark_value>comparisons;operators in standard filter
dialog</bookmark_value>
<bookmark_value>operators;standard filters</bookmark_value>
<bookmark_value>standard filters;comparison operators</bookmark_value>
<bookmark_value>filters; comparison operators</bookmark_value>
<bookmark_value>equal sign, see also operators</bookmark_value>
</bookmark><comment>mw added "equal sign,..."</comment><comment>MW changed
"default filters;" into "standard filters;"</comment><comment>mw changed
"comparisons;" and "operators;"</comment>
<h1 id="hd_id3148983">Comparison Operators</h1>
- <paragraph xml-lang="en-US" id="par_id3155364" role="paragraph">The
following comparative operators can be set under <item
type="menuitem">Condition</item> in the <item type="menuitem">Standard
Filter</item> dialog.</paragraph>
+ <paragraph id="par_id3155364" role="paragraph">The following comparative
operators can be set under <item type="menuitem">Condition</item> in the <item
type="menuitem">Standard Filter</item> dialog.</paragraph>
<table id="tbl_id3149760">
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145313" role="tablehead">
+ <paragraph id="par_id3145313" role="tablehead">
<emph>Comparative operator</emph>
</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147089" role="tablehead">
+ <paragraph id="par_id3147089" role="tablehead">
<emph>Effect</emph>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147209"
role="paragraph">Equal (=)</paragraph>
+ <paragraph id="par_id3147209" role="paragraph">Equal
(=)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146797"
role="paragraph">Shows values equal to the condition.</paragraph>
+ <paragraph id="par_id3146797" role="paragraph">Shows values
equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3143271"
role="paragraph">Less than (<)</paragraph>
+ <paragraph id="par_id3143271" role="paragraph">Less than
(<)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153761"
role="paragraph">Shows values less than the condition.</paragraph>
+ <paragraph id="par_id3153761" role="paragraph">Shows values
less than the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146807"
role="paragraph">Greater than (>)</paragraph>
+ <paragraph id="par_id3146807" role="paragraph">Greater than
(>)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154852"
role="paragraph">Shows values greater than the condition.</paragraph>
+ <paragraph id="par_id3154852" role="paragraph">Shows values
greater than the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155342"
role="paragraph">Less than or equal to (< =)</paragraph>
+ <paragraph id="par_id3155342" role="paragraph">Less than or
equal to (< =)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154381"
role="paragraph">Shows values that are less than or equal to the
condition.</paragraph>
+ <paragraph id="par_id3154381" role="paragraph">Shows values
that are less than or equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153823"
role="paragraph">Greater than or equal to (> =)</paragraph>
+ <paragraph id="par_id3153823" role="paragraph">Greater than or
equal to (> =)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154143"
role="paragraph">Shows values that are greater than or equal to the
condition.</paragraph>
+ <paragraph id="par_id3154143" role="paragraph">Shows values
that are greater than or equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154811"
role="paragraph">Not equal (< >)</paragraph>
+ <paragraph id="par_id3154811" role="paragraph">Not equal (<
>)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148944"
role="paragraph">Shows the values not equal to the condition.</paragraph>
+ <paragraph id="par_id3148944" role="paragraph">Shows the values
not equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149669"
role="paragraph">Largest</paragraph>
+ <paragraph id="par_id3149669"
role="paragraph">Largest</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3159413"
role="paragraph">Shows the N (numeric value as parameter) largest
values.</paragraph>
+ <paragraph id="par_id3159413" role="paragraph">Shows the N
(numeric value as parameter) largest values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3151054"
role="paragraph">Smallest</paragraph>
+ <paragraph id="par_id3151054"
role="paragraph">Smallest</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3161657"
role="paragraph">Shows the N (numeric value as parameter) smallest
values.</paragraph>
+ <paragraph id="par_id3161657" role="paragraph">Shows the N
(numeric value as parameter) smallest values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150400"
role="paragraph">Largest %</paragraph>
+ <paragraph id="par_id3150400" role="paragraph">Largest
%</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3161645"
role="paragraph">Shows the largest N% (numeric value as parameter) of the total
values.</paragraph>
+ <paragraph id="par_id3161645" role="paragraph">Shows the
largest N% (numeric value as parameter) of the total values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149202"
role="paragraph">Smallest %</paragraph>
+ <paragraph id="par_id3149202" role="paragraph">Smallest
%</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3151176"
role="paragraph">Shows the smallest N% (numeric value as parameter) of the
entire values.</paragraph>
+ <paragraph id="par_id3151176" role="paragraph">Shows the
smallest N% (numeric value as parameter) of the entire values.</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/shared/main0212.xhp b/source/text/shared/main0212.xhp
index e6e8936ed6..27b8e79fd4 100644
--- a/source/text/shared/main0212.xhp
+++ b/source/text/shared/main0212.xhp
@@ -22,26 +22,26 @@
<meta>
<topic id="textsharedmain0212xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Table Data Bar</title>
+ <title id="tit">Table Data Bar</title>
<filename>/text/shared/main0212.xhp</filename>
</topic>
</meta>
<body>
<section id="database">
<h1 id="hd_id3147102"><link href="text/shared/main0212.xhp">Table
Data Bar</link></h1>
- <paragraph xml-lang="en-US" id="par_id3153394"
role="paragraph"><ahelp hid=".">Use the Table Data bar to control the data
view. </ahelp></paragraph>
+ <paragraph id="par_id3153394" role="paragraph"><ahelp hid=".">Use the
Table Data bar to control the data view. </ahelp></paragraph>
</section>
- <paragraph xml-lang="en-US" id="par_id3149346" role="paragraph">The
filtered data view is active until you change or cancel the sorting or
filtering criteria. If a filter is active, the <emph>Apply Filter</emph> icon
on the <emph>Table Data</emph> bar is activated.</paragraph>
+ <paragraph id="par_id3149346" role="paragraph">The filtered data view is
active until you change or cancel the sorting or filtering criteria. If a
filter is active, the <emph>Apply Filter</emph> icon on the <emph>Table
Data</emph> bar is activated.</paragraph>
<embed href="text/shared/02/07070200.xhp#save_record"/>
<table id="">
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147303" role="paragraph">
-<image id="img_id3153896" src="cmd/sc_recsave.png" width="0.222in"
height="0.222in"><alt xml-lang="en-US" id="alt_id3153896">Icon</alt>
+ <paragraph id="par_id3147303" role="paragraph">
+<image id="img_id3153896" src="cmd/sc_recsave.png" width="0.222in"
height="0.222in"><alt id="alt_id3153896">Icon</alt>
</image></paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153360"
role="paragraph">Save Record</paragraph>
+ <paragraph id="par_id3153360" role="paragraph">Save
Record</paragraph>
</tablecell>
</tablerow>
</table>
@@ -51,12 +51,12 @@
<table id="">
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145173" role="paragraph">
-<image id="img_id3154123" src="cmd/sc_recundo.png" width="0.222in"
height="0.222in"><alt xml-lang="en-US" id="alt_id3154123">Icon</alt>
+ <paragraph id="par_id3145173" role="paragraph">
+<image id="img_id3154123" src="cmd/sc_recundo.png" width="0.222in"
height="0.222in"><alt id="alt_id3154123">Icon</alt>
</image></paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3151382"
role="paragraph">Undo: Data Input</paragraph>
+ <paragraph id="par_id3151382" role="paragraph">Undo: Data
Input</paragraph>
</tablecell>
</tablerow>
</table>
@@ -74,19 +74,19 @@
<embed href="text/shared/02/12030000.xhp#syautofilter"/>
<embed href="text/shared/02/12120000.xhp#apply_filter"/>
<embed href="text/shared/02/12120000.xhp#syapply_filter"/>
- <embed href="text/shared/02/12090000.xhp#standardfilter1"/>
- <embed href="text/shared/02/12090000.xhp#systandardfilter"/>
+ <embed href="text/shared/02/12090100.xhp#StandardFilter_h1"/>
+ <embed href="text/shared/00/00000409.xhp#systandardfilter"/>
<embed href="text/shared/02/12040000.xhp#reset_filter"/>
<embed href="text/shared/02/12040000.xhp#syreset_filter"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:DSBInsertColumns"
id="bm_id5734733" localize="false"/>
+<bookmark branch="hid/.uno:DSBInsertColumns" id="bm_id5734733"
localize="false"/>
<h2 id="par_idN10744"><link href="text/shared/02/12070000.xhp">Data to
Text</link></h2>
- <paragraph xml-lang="en-US" id="par_idN10753" role="paragraph"><ahelp
hid=".">Inserts all fields of the marked record into the current document at
the cursor position.</ahelp></paragraph>
+ <paragraph id="par_idN10753" role="paragraph"><ahelp hid=".">Inserts all
fields of the marked record into the current document at the cursor
position.</ahelp></paragraph>
<embed href="text/shared/02/12070000.xhp#syinsert_db_columns"/>
<embed href="text/shared/02/12080000.xhp#data_to_fields"/>
<embed href="text/shared/02/12080000.xhp#sydata_to_fields"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:DSBFormLetter"
id="bm_id0928200901513623" localize="false"/><comment>Help ID is here because
we need it in shared since the F4 browser has another context "sdatabase" so I
had to move the Help ID from the swriter folder</comment>
+<bookmark branch="hid/.uno:DSBFormLetter" id="bm_id0928200901513623"
localize="false"/><comment>Help ID is here because we need it in shared since
the F4 browser has another context "sdatabase" so I had to move the Help ID
from the swriter folder</comment>
<h2 id="par_idN10780"><link href="text/swriter/01/mailmerge00.xhp">Mail
Merge</link></h2>
- <paragraph xml-lang="en-US" id="par_idN1078F" role="paragraph"><ahelp
hid=".">Starts the Mail Merge Wizard to create form letters.</ahelp></paragraph>
+ <paragraph id="par_idN1078F" role="paragraph"><ahelp hid=".">Starts the
Mail Merge Wizard to create form letters.</ahelp></paragraph>
<embed href="text/swriter/00/00000401.xhp#symail_merge"/>
<embed href="text/shared/02/12140000.xhp#current_doc_data"/>
<embed href="text/shared/02/12140000.xhp#sycurrent_doc_data"/>
