From a9a5eef71062ee0fe8ab18845166af73f6e25a00 Mon Sep 17 00:00:00 2001 From: Csikós Tamás Date: Wed, 17 Jul 2013 18:29:19 +0200 Subject: update help ids for advanced filter dialog .ui conversion MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Change-Id: I3f4ed027caf18871f6642eb96c2f857d77cad242 Reviewed-on: https://gerrit.libreoffice.org/4961 Tested-by: Caolán McNamara Reviewed-by: Caolán McNamara --- source/text/scalc/01/12040201.xhp | 30 +++++++++++++++--------------- source/text/scalc/01/12040300.xhp | 6 +++--- 2 files changed, 18 insertions(+), 18 deletions(-) (limited to 'source/text/scalc/01') diff --git a/source/text/scalc/01/12040201.xhp b/source/text/scalc/01/12040201.xhp index 54e683d3f3..11ca7af68b 100644 --- a/source/text/scalc/01/12040201.xhp +++ b/source/text/scalc/01/12040201.xhp @@ -29,40 +29,40 @@ More - -Shows additional filter options. + +Shows additional filter options.

Options - + Case sensitive -Distinguishes between uppercase and lowercase letters when filtering the data. +Distinguishes between uppercase and lowercase letters when filtering the data. - + Range contains column labels -Includes the column labels in the first row of a cell range. +Includes the column labels in the first row of a cell range. - + - + - + Copy results to -Select the check box, and then select the cell range where you want to display the filter results. You can also select a named range from the list. +Select the check box, and then select the cell range where you want to display the filter results. You can also select a named range from the list.

- + Regular expression -Allows you to use wildcards in the filter definition. For a list of the regular expressions that $[officename] supports, click here. +Allows you to use wildcards in the filter definition. For a list of the regular expressions that $[officename] supports, click here. If the Regular Expressions check box is selected, you can use regular expressions in the Value field if the Condition list box is set to '=' EQUAL or '<>' UNEQUAL. This also applies to the respective cells that you reference for an advanced filter. - + No duplication -Excludes duplicate rows in the list of filtered data. - +Excludes duplicate rows in the list of filtered data. + Keep filter criteria Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range. Following this, you can reapply the defined filter at any time as follows: click into the source range, then choose Data - Refresh Range. diff --git a/source/text/scalc/01/12040300.xhp b/source/text/scalc/01/12040300.xhp index 7172d509d7..98b027dcf3 100644 --- a/source/text/scalc/01/12040300.xhp +++ b/source/text/scalc/01/12040300.xhp @@ -38,10 +38,10 @@ - - + + Read filter criteria from -Select the named range, or enter the cell range that contains the filter criteria that you want to use. +Select the named range, or enter the cell range that contains the filter criteria that you want to use.

-- cgit