diff options
| author | Andras Timar <andras.timar@collabora.com> | 2015-09-25 16:55:03 +0200 |
|---|---|---|
| committer | Andras Timar <andras.timar@collabora.com> | 2015-09-25 16:55:03 +0200 |
| commit | 65a36196fb4c3e99d9b6a0ef2b236314a34f7b55 (patch) | |
| tree | b34886e8ce81c87cacdec8e50fcdd6dcd087205c /source | |
| parent | 6be1e0f94330fc5109ca33c63873e4bcedb93a62 (diff) | |
Pivot table Filter dialog help: sync help text with UI and add missing hids
Change-Id: I58a175788fb26be0feee0edd3e83014a687a274a
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/12090103.xhp | 14 | ||||
| -rw-r--r-- | source/text/scalc/01/12090104.xhp | 22 |
2 files changed, 17 insertions, 19 deletions
diff --git a/source/text/scalc/01/12090103.xhp b/source/text/scalc/01/12090103.xhp index 44818bb08f..b289eee8cb 100644 --- a/source/text/scalc/01/12090103.xhp +++ b/source/text/scalc/01/12090103.xhp @@ -31,7 +31,7 @@ </history> </meta> <body> - + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/PivotFilterDialog" xml-lang="en-US" id="bm_id3153143" localize="false"/> <paragraph role="heading" level="1" id="hd_id3153970" l10n="U" xml-lang="en-US" oldref="1">Filter</paragraph> <paragraph role="paragraph" id="par_id3150448" l10n="U" xml-lang="en-US" oldref="2">Set the filtering options for the data.</paragraph> @@ -45,18 +45,18 @@ <paragraph l10n="U" role="paragraph" id="par_id3147394" xml-lang="en-US" oldref="10"><ahelp visibility="visible" hid="modules/scalc/ui/pivotfilterdialog/cond3">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3144764" l10n="U" xml-lang="en-US" oldref="11">The following operators are available:</paragraph> <table id="tbl_id3149379"> - - - + + + <tablerow> <tablecell> <paragraph l10n="U" role="paragraph" id="par_id3153415" xml-lang="en-US" oldref="12"><emph>Conditions:</emph></paragraph> </tablecell> <tablecell> - + </tablecell> </tablerow> - + <tablerow> <tablecell> <paragraph role="paragraph" id="par_id3150324" l10n="U" xml-lang="en-US" oldref="13">=</paragraph> @@ -108,7 +108,7 @@ </table> <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val1" xml-lang="en-US" id="bm_id3152990" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val2" xml-lang="en-US" id="bm_id3152994" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val3" xml-lang="en-US" id="bm_id3150370" localize="false"/><paragraph role="heading" level="3" id="hd_id3150886" l10n="U" xml-lang="en-US" oldref="25">Value</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3155506" xml-lang="en-US" oldref="26"><ahelp hid="modules/scalc/ui/pivotfilterdialog/val3" visibility="visible">Select the value that you want to compare to the selected field.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/more" xml-lang="en-US" id="bm_id3152987" localize="false"/><paragraph id="hd_id3146980" role="heading" level="2" oldref="27" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12090104.xhp" name="More>>">More>></link></paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/more" xml-lang="en-US" id="bm_id3152987" localize="false"/><paragraph id="hd_id3146980" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/12090104.xhp" name="Options">Options</link></paragraph> <embed href="text/scalc/01/12090104.xhp#zusaetzetext"/> </body> </helpdocument> diff --git a/source/text/scalc/01/12090104.xhp b/source/text/scalc/01/12090104.xhp index 469d4735f2..3dfa36b6d1 100644 --- a/source/text/scalc/01/12090104.xhp +++ b/source/text/scalc/01/12090104.xhp @@ -31,23 +31,21 @@ </history> </meta> <body> - - - + + + <paragraph id="hd_id3149119" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12090104.xhp" name="Options">Options</link></paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3147102" xml-lang="en-US" oldref="2"><variable id="zusaetzetext"><ahelp hid="" visibility="visible">Displays or hides additional filtering options.</ahelp></variable></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3147102" xml-lang="en-US" oldref="2"><variable id="zusaetzetext"><ahelp hid="modules/scalc/ui/pivotfilterdialog/more" visibility="visible">Displays or hides additional filtering options.</ahelp></variable></paragraph> <paragraph role="heading" level="2" id="hd_id3147008" l10n="U" xml-lang="en-US" oldref="3">Options</paragraph> <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/case" xml-lang="en-US" id="bm_id3153562" localize="false"/><paragraph role="heading" level="3" id="hd_id3153662" l10n="U" xml-lang="en-US" oldref="5">Case sensitive</paragraph> - <paragraph role="paragraph" id="par_id3145673" l10n="U" xml-lang="en-US" oldref="6">Distinguishes between uppercase and lowercase letters.</paragraph> + <paragraph role="paragraph" id="par_id3145673" l10n="U" xml-lang="en-US" oldref="6"><ahelp hid="." visibility="visible">Distinguishes between uppercase and lowercase letters.</ahelp></paragraph> <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/regexp" xml-lang="en-US" id="bm_id3153881" localize="false"/><paragraph role="heading" level="3" id="hd_id3156327" l10n="U" xml-lang="en-US" oldref="7">Regular Expression</paragraph> - <paragraph role="paragraph" id="par_id3151245" l10n="U" xml-lang="en-US" oldref="8">Allows you to use wildcards in the filter definition.</paragraph> + <paragraph role="paragraph" id="par_id3151245" l10n="U" xml-lang="en-US" oldref="8"><ahelp hid="." visibility="visible">Allows you to use wildcards in the filter definition.</ahelp></paragraph> <paragraph xml-lang="en-US" role="paragraph" id="par_id3147264" l10n="U" oldref="29">If the <emph>Regular Expression</emph> check box is selected, you can use EQUAL (=) and NOT EQUAL (<>) also in comparisons. You can also use the following functions: DCOUNTA, DGET, MATCH, COUNTIF, SUMIF, LOOKUP, VLOOKUP and HLOOKUP.</paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/unique" xml-lang="en-US" id="bm_id3150541" localize="false"/><paragraph role="heading" level="3" id="hd_id3153379" l10n="U" xml-lang="en-US" oldref="30">Unique records only</paragraph> - <paragraph role="paragraph" id="par_id3154138" l10n="U" xml-lang="en-US" oldref="31">Excludes duplicate rows in the list of filtered data.</paragraph> - <paragraph role="heading" level="2" id="hd_id3156282" l10n="U" xml-lang="en-US" oldref="32">Data area</paragraph> - <paragraph role="paragraph" id="par_id3150768" l10n="U" xml-lang="en-US" oldref="33">Displays the name of the filtered data area in the table.</paragraph> - <paragraph role="heading" level="2" id="hd_id3156424" l10n="U" xml-lang="en-US" oldref="34">More<<</paragraph> - <paragraph role="paragraph" id="par_id3125864" l10n="U" xml-lang="en-US" oldref="35">Hides the additional options.</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/unique" xml-lang="en-US" id="bm_id3150541" localize="false"/><paragraph role="heading" level="3" id="hd_id3153379" xml-lang="en-US">No duplications</paragraph> + <paragraph role="paragraph" id="par_id3154138" l10n="U" xml-lang="en-US" oldref="31"><ahelp hid="." visibility="visible">Excludes duplicate rows in the list of filtered data.</ahelp></paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/dbarea" xml-lang="en-US" id="bm_id3150541" localize="false"/><paragraph role="heading" level="2" id="hd_id3156282" xml-lang="en-US">Data range</paragraph> + <paragraph role="paragraph" id="par_id3150768" xml-lang="en-US"><ahelp hid="." visibility="visible">Displays the name of the filtered data range in the table.</ahelp></paragraph> <section id="relatedtopics"> <paragraph l10n="C" role="paragraph" id="par_id3154011" xml-lang="en-US" oldref=""><link href="text/shared/01/02100001.xhp" name="List of Regular Expressions">List of Regular Expressions</link></paragraph> </section> |