diff options
| author | Caolán McNamara <caolanm@redhat.com> | 2014-03-10 20:49:57 +0000 |
|---|---|---|
| committer | Caolán McNamara <caolanm@redhat.com> | 2014-03-10 20:49:57 +0000 |
| commit | c0f068348420e4ef59842aaa4a9786aefabb3a83 (patch) | |
| tree | 0f02d5d89f984bfca949146a31b7cb72d88ee3f6 /source/text/scalc | |
| parent | 43dc63d9850e04adee3fac707e35576e0e7f4539 (diff) | |
update help ids for pivot filter dialog .ui conversion
Change-Id: I2b2a55a4cca7fbfffa7a2d1f9659faea2149fd3c
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/12090103.xhp | 20 | ||||
| -rw-r--r-- | source/text/scalc/01/12090104.xhp | 6 |
2 files changed, 13 insertions, 13 deletions
diff --git a/source/text/scalc/01/12090103.xhp b/source/text/scalc/01/12090103.xhp index 5b17e8889b..44818bb08f 100644 --- a/source/text/scalc/01/12090103.xhp +++ b/source/text/scalc/01/12090103.xhp @@ -32,17 +32,17 @@ </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> <paragraph role="heading" level="2" id="hd_id3151043" l10n="U" xml-lang="en-US" oldref="3">Filter Criteria</paragraph> <paragraph role="paragraph" id="par_id3150440" l10n="U" xml-lang="en-US" oldref="4">You can define a default filter for the data by filtering, for example, field names, using a combination of logical expressions arguments.</paragraph> - <bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_OP1" xml-lang="en-US" id="bm_id3153142" localize="false"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_OP2" xml-lang="en-US" id="bm_id3155412" localize="false"/><paragraph role="heading" level="3" id="hd_id3159153" l10n="U" xml-lang="en-US" oldref="5">Operator</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3153093" xml-lang="en-US" oldref="6"><ahelp hid="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_OP2" visibility="visible">Select a logical operator for the filter.</ahelp></paragraph> - <bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD1" xml-lang="en-US" id="bm_id3147317" localize="false"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD2" xml-lang="en-US" id="bm_id3148646" localize="false"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD3" xml-lang="en-US" id="bm_id3149667" localize="false"/><paragraph role="heading" level="3" id="hd_id3152462" l10n="U" xml-lang="en-US" oldref="7">Field name</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3155306" xml-lang="en-US" oldref="8"><ahelp hid="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_FIELD3" visibility="visible">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp></paragraph> - <bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND1" xml-lang="en-US" id="bm_id3147348" localize="false"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND2" xml-lang="en-US" id="bm_id3155855" localize="false"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND3" xml-lang="en-US" id="bm_id3156444" localize="false"/><paragraph role="heading" level="3" id="hd_id3148575" l10n="U" xml-lang="en-US" oldref="9">Condition</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3147394" xml-lang="en-US" oldref="10"><ahelp visibility="visible" hid="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_COND3">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp></paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/connect1" xml-lang="en-US" id="bm_id3153142" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/connect2" xml-lang="en-US" id="bm_id3155412" localize="false"/><paragraph role="heading" level="3" id="hd_id3159153" l10n="U" xml-lang="en-US" oldref="5">Operator</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153093" xml-lang="en-US" oldref="6"><ahelp hid="modules/scalc/ui/pivotfilterdialog/connect2" visibility="visible">Select a logical operator for the filter.</ahelp></paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field1" xml-lang="en-US" id="bm_id3147317" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field2" xml-lang="en-US" id="bm_id3148646" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field3" xml-lang="en-US" id="bm_id3149667" localize="false"/><paragraph role="heading" level="3" id="hd_id3152462" l10n="U" xml-lang="en-US" oldref="7">Field name</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3155306" xml-lang="en-US" oldref="8"><ahelp hid="modules/scalc/ui/pivotfilterdialog/field3" visibility="visible">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp></paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond1" xml-lang="en-US" id="bm_id3147348" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond2" xml-lang="en-US" id="bm_id3155855" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond3" xml-lang="en-US" id="bm_id3156444" localize="false"/><paragraph role="heading" level="3" id="hd_id3148575" l10n="U" xml-lang="en-US" oldref="9">Condition</paragraph> + <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"> @@ -106,9 +106,9 @@ </tablecell> </tablerow> </table> - <bookmark branch="hid/sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL1" xml-lang="en-US" id="bm_id3152990" localize="false"/><bookmark branch="hid/sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL2" xml-lang="en-US" id="bm_id3152994" localize="false"/><bookmark branch="hid/sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_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="SC:COMBOBOX:RID_SCDLG_PIVOTFILTER:ED_VAL3" visibility="visible">Select the value that you want to compare to the selected field.</ahelp></paragraph> - <bookmark branch="hid/sc:MoreButton:RID_SCDLG_PIVOTFILTER:BTN_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/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> <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 14de8e01a7..469d4735f2 100644 --- a/source/text/scalc/01/12090104.xhp +++ b/source/text/scalc/01/12090104.xhp @@ -37,12 +37,12 @@ <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 role="heading" level="2" id="hd_id3147008" l10n="U" xml-lang="en-US" oldref="3">Options</paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_PIVOTFILTER:BTN_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> + <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> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_PIVOTFILTER:BTN_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> + <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 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/sc:CheckBox:RID_SCDLG_PIVOTFILTER:BTN_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> + <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> |