diff options
Diffstat (limited to 'source/text/scalc/01')
29 files changed, 46 insertions, 46 deletions
diff --git a/source/text/scalc/01/02140100.xhp b/source/text/scalc/01/02140100.xhp index 44166110d0..01795ae77e 100644 --- a/source/text/scalc/01/02140100.xhp +++ b/source/text/scalc/01/02140100.xhp @@ -35,7 +35,7 @@ <section id="unten"> <bookmark xml-lang="en-US" branch="hid/.uno:FillDown" id="bm_id8608585" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:FillDown" xml-lang="en-US" id="bm_id3145173"/><paragraph id="hd_id3150792" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140100.xhp" name="Down">Down</link></paragraph> +<bookmark branch="hid/.uno:FillDown" xml-lang="en-US" id="bm_id3145173" localize="false"/><paragraph id="hd_id3150792" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140100.xhp" name="Down">Down</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3153969" xml-lang="en-US" oldref="2"><ahelp hid=".uno:FillDown" visibility="visible">Fills a selected range of at least two rows with the contents of the top cell of the range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140200.xhp b/source/text/scalc/01/02140200.xhp index 71a64ae01c..a93bb41b35 100644 --- a/source/text/scalc/01/02140200.xhp +++ b/source/text/scalc/01/02140200.xhp @@ -35,7 +35,7 @@ <section id="rechts"> <bookmark xml-lang="en-US" branch="hid/.uno:FillRight" id="bm_id9676564" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:FillRight" xml-lang="en-US" id="bm_id3149456"/><paragraph id="hd_id3153896" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140200.xhp" name="Right">Right</link></paragraph> +<bookmark branch="hid/.uno:FillRight" xml-lang="en-US" id="bm_id3149456" localize="false"/><paragraph id="hd_id3153896" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140200.xhp" name="Right">Right</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3153361" xml-lang="en-US" oldref="2"><ahelp hid=".uno:FillRight" visibility="visible">Fills a selected range of at least two columns with the contents of the left most cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140300.xhp b/source/text/scalc/01/02140300.xhp index be0fc1a155..909631cb36 100644 --- a/source/text/scalc/01/02140300.xhp +++ b/source/text/scalc/01/02140300.xhp @@ -35,7 +35,7 @@ <section id="oben"> <bookmark xml-lang="en-US" branch="hid/.uno:FillUp" id="bm_id8879597" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:FillUp" xml-lang="en-US" id="bm_id3149456"/><paragraph id="hd_id3147264" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140300.xhp" name="Up">Up</link></paragraph> +<bookmark branch="hid/.uno:FillUp" xml-lang="en-US" id="bm_id3149456" localize="false"/><paragraph id="hd_id3147264" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140300.xhp" name="Up">Up</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3150793" xml-lang="en-US" oldref="2"><ahelp hid=".uno:FillUp" visibility="visible">Fills a selected range of at least two rows with the contents of the bottom most cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140400.xhp b/source/text/scalc/01/02140400.xhp index fd4fe16b76..0436d12e8e 100644 --- a/source/text/scalc/01/02140400.xhp +++ b/source/text/scalc/01/02140400.xhp @@ -35,7 +35,7 @@ <section id="links"> <bookmark xml-lang="en-US" branch="hid/.uno:FillLeft" id="bm_id3332954" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:FillLeft" xml-lang="en-US" id="bm_id3149456"/><paragraph id="hd_id3153896" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140400.xhp" name="Left">Left</link></paragraph> +<bookmark branch="hid/.uno:FillLeft" xml-lang="en-US" id="bm_id3149456" localize="false"/><paragraph id="hd_id3153896" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/02140400.xhp" name="Left">Left</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3150793" xml-lang="en-US" oldref="2"><ahelp hid=".uno:FillLeft" visibility="visible">Fills a selected range of at least two columns with the contents of the far right cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140500.xhp b/source/text/scalc/01/02140500.xhp index 2fb501df72..92a92f1880 100644 --- a/source/text/scalc/01/02140500.xhp +++ b/source/text/scalc/01/02140500.xhp @@ -29,7 +29,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:FillTable" id="bm_id3912388" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:FillTable" xml-lang="en-US" id="bm_id3148664"/><paragraph role="heading" level="1" id="hd_id3153897" l10n="U" xml-lang="en-US" oldref="1">Fill Sheet</paragraph> +<bookmark branch="hid/.uno:FillTable" xml-lang="en-US" id="bm_id3148664" localize="false"/><paragraph role="heading" level="1" id="hd_id3153897" l10n="U" xml-lang="en-US" oldref="1">Fill Sheet</paragraph> <paragraph l10n="CHG" role="paragraph" id="par_id3150791" xml-lang="en-US" oldref="2"><variable id="tabellenfuellentext"><ahelp hid=".uno:FillTable" visibility="visible">Specifies the options for transferring sheets or ranges of a certain sheet.</ahelp></variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000402.xhp#baustab"/> diff --git a/source/text/scalc/01/02210000.xhp b/source/text/scalc/01/02210000.xhp index c5a95123f9..1566c81c59 100644 --- a/source/text/scalc/01/02210000.xhp +++ b/source/text/scalc/01/02210000.xhp @@ -34,9 +34,9 @@ <bookmark xml-lang="en-US" branch="hid/.uno:SelectTables" id="bm_id6707893" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:SelectTables" xml-lang="en-US" id="bm_id3154758"/><paragraph role="heading" level="1" id="hd_id3156023" l10n="U" xml-lang="en-US" oldref="5">Selecting Sheets</paragraph> +<bookmark branch="hid/.uno:SelectTables" xml-lang="en-US" id="bm_id3154758" localize="false"/><paragraph role="heading" level="1" id="hd_id3156023" l10n="U" xml-lang="en-US" oldref="5">Selecting Sheets</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3147265" xml-lang="en-US" oldref="1"><variable id="tabellenauswaehlen"><ahelp hid=".uno:SelectTables" visibility="visible">Selects multiple sheets.</ahelp></variable></paragraph> - <bookmark branch="hid/SC_HID_SELECTTABLES" xml-lang="en-US" id="bm_id3154126"/><paragraph role="heading" level="2" id="hd_id3125863" l10n="U" xml-lang="en-US" oldref="2">Selected Sheets</paragraph> + <bookmark branch="hid/SC_HID_SELECTTABLES" xml-lang="en-US" id="bm_id3154126" localize="false"/><paragraph role="heading" level="2" id="hd_id3125863" l10n="U" xml-lang="en-US" oldref="2">Selected Sheets</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3153969" xml-lang="en-US" oldref="3"><ahelp hid="HID_SELECTTABLES" visibility="visible">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down Ctrl (Mac: Command) while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/04030000.xhp b/source/text/scalc/01/04030000.xhp index af5d83a780..aeddb21266 100644 --- a/source/text/scalc/01/04030000.xhp +++ b/source/text/scalc/01/04030000.xhp @@ -35,7 +35,7 @@ <section id="zeilen"> <bookmark branch="index" xml-lang="en-US" id="bm_id3150541"><bookmark_value>spreadsheets; inserting rows</bookmark_value><bookmark_value>rows; inserting</bookmark_value><bookmark_value>inserting; rows</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:InsertRows" id="bm_id4302477" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:InsertRows" xml-lang="en-US" id="bm_id3154366"/><paragraph id="hd_id3150541" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/04030000.xhp" name="Rows">Rows</link></paragraph> +<bookmark branch="hid/.uno:InsertRows" xml-lang="en-US" id="bm_id3154366" localize="false"/><paragraph id="hd_id3150541" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/04030000.xhp" name="Rows">Rows</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3150767" xml-lang="en-US" oldref="2"><ahelp hid=".uno:InsertRows" visibility="visible">Inserts a new row above the active cell.</ahelp> The number of rows inserted correspond to the number of rows selected. The existing rows are moved downward.</paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05050300.xhp b/source/text/scalc/01/05050300.xhp index a9a18d192c..6780556337 100644 --- a/source/text/scalc/01/05050300.xhp +++ b/source/text/scalc/01/05050300.xhp @@ -34,12 +34,12 @@ <bookmark branch="index" xml-lang="en-US" id="bm_id3148946"><bookmark_value>sheets; displaying</bookmark_value><bookmark_value>displaying; sheets</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:Show" id="bm_id8296013" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:Show" xml-lang="en-US" id="bm_id3150542"/><paragraph role="heading" level="1" id="hd_id3148946" l10n="U" xml-lang="en-US" oldref="1">Show Sheet</paragraph> +<bookmark branch="hid/.uno:Show" xml-lang="en-US" id="bm_id3150542" localize="false"/><paragraph role="heading" level="1" id="hd_id3148946" l10n="U" xml-lang="en-US" oldref="1">Show Sheet</paragraph> <paragraph l10n="U" xml-lang="en-US" role="paragraph" id="par_id3148799" oldref="2"><variable id="tabeintext"><ahelp visibility="visible" hid=".uno:Show">Displays sheets that were previously hidden with the <emph>Hide</emph> command.</ahelp></variable> Select one sheet only to call the command. The current sheet is always selected. If a sheet other than the current sheet is selected, you can deselect it by pressing <switchinline select="sys"> <caseinline select="MAC">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> while clicking the corresponding sheet tab at the bottom of the window.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fotenb"/> </section> - <bookmark branch="hid/sc:MultiListBox:RID_SCDLG_SHOW_TAB:LB_ENTRYLIST" xml-lang="en-US" id="bm_id3149260"/><paragraph role="heading" level="2" id="hd_id3151112" l10n="U" xml-lang="en-US" oldref="3">Hidden sheets</paragraph> + <bookmark branch="hid/sc:MultiListBox:RID_SCDLG_SHOW_TAB:LB_ENTRYLIST" xml-lang="en-US" id="bm_id3149260" localize="false"/><paragraph role="heading" level="2" id="hd_id3151112" l10n="U" xml-lang="en-US" oldref="3">Hidden sheets</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3145273" xml-lang="en-US" oldref="4"><ahelp hid="SC:MULTILISTBOX:RID_SCDLG_SHOW_TAB:LB_ENTRYLIST" visibility="visible">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05070000.xhp b/source/text/scalc/01/05070000.xhp index 9b6435cda7..5e9ec64a04 100644 --- a/source/text/scalc/01/05070000.xhp +++ b/source/text/scalc/01/05070000.xhp @@ -31,7 +31,7 @@ </history> </meta> <body> -<bookmark branch="hid/.uno:PageFormatDialog" xml-lang="en-US" id="bm_id3153561"/><paragraph role="heading" level="1" id="hd_id3157910" l10n="U" xml-lang="en-US" oldref="1">Page Style</paragraph> +<bookmark branch="hid/.uno:PageFormatDialog" xml-lang="en-US" id="bm_id3153561" localize="false"/><paragraph role="heading" level="1" id="hd_id3157910" l10n="U" xml-lang="en-US" oldref="1">Page Style</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3156023" xml-lang="en-US" oldref="2"><variable id="seitetext"><ahelp hid=".uno:PageFormatDialog" visibility="visible">Opens a dialog where you can define the appearance of all pages in your document.</ahelp></variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#foste"/> diff --git a/source/text/scalc/01/06030300.xhp b/source/text/scalc/01/06030300.xhp index 68b1ed7954..9f4a55a828 100644 --- a/source/text/scalc/01/06030300.xhp +++ b/source/text/scalc/01/06030300.xhp @@ -34,7 +34,7 @@ <section id="spurzumnachfolger"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153252"><bookmark_value>cells; tracing dependents</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:ShowDependents" id="bm_id6672482" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:ShowDependents" xml-lang="en-US" id="bm_id3143267"/><paragraph id="hd_id3153252" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030300.xhp" name="Trace Dependents">Trace Dependents</link></paragraph> +<bookmark branch="hid/.uno:ShowDependents" xml-lang="en-US" id="bm_id3143267" localize="false"/><paragraph id="hd_id3153252" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030300.xhp" name="Trace Dependents">Trace Dependents</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3156024" xml-lang="en-US" oldref="2"><ahelp hid=".uno:ShowDependents" visibility="visible">Draws tracer arrows to the active cell from formulas that depend on values in the active cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3148948" l10n="U" xml-lang="en-US" oldref="4">The area of all cells that are used together with the active cell in a formula is highlighted by a blue frame.</paragraph> diff --git a/source/text/scalc/01/06030400.xhp b/source/text/scalc/01/06030400.xhp index 11af3adca1..731f1e10da 100644 --- a/source/text/scalc/01/06030400.xhp +++ b/source/text/scalc/01/06030400.xhp @@ -35,7 +35,7 @@ <section id="spurzumnachfolgerentfernen"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>cells; removing dependents</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:ClearArrowDependents" id="bm_id6529459" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:ClearArrowDependents" xml-lang="en-US" id="bm_id3148552"/><paragraph id="hd_id3147335" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030400.xhp" name="Remove Dependents">Remove Dependents</link></paragraph> +<bookmark branch="hid/.uno:ClearArrowDependents" xml-lang="en-US" id="bm_id3148552" localize="false"/><paragraph id="hd_id3147335" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030400.xhp" name="Remove Dependents">Remove Dependents</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3148663" xml-lang="en-US" oldref="2"><ahelp visibility="visible" hid=".uno:ClearArrowDependents">Deletes one level of tracer arrows created with <emph>Trace Dependents</emph>.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030500.xhp b/source/text/scalc/01/06030500.xhp index 17f9be42eb..1628dd0e33 100644 --- a/source/text/scalc/01/06030500.xhp +++ b/source/text/scalc/01/06030500.xhp @@ -35,7 +35,7 @@ <section id="allespurenentfernen"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153088"><bookmark_value>cells; removing traces</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:ClearArrows" id="bm_id145517" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:ClearArrows" xml-lang="en-US" id="bm_id3153541"/><paragraph id="hd_id3153088" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030500.xhp" name="Remove All Traces">Remove All Traces</link></paragraph> +<bookmark branch="hid/.uno:ClearArrows" xml-lang="en-US" id="bm_id3153541" localize="false"/><paragraph id="hd_id3153088" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030500.xhp" name="Remove All Traces">Remove All Traces</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3151246" xml-lang="en-US" oldref="2"><ahelp hid=".uno:ClearArrows" visibility="visible">Removes all tracer arrows from the spreadsheet.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030600.xhp b/source/text/scalc/01/06030600.xhp index 2e1f622941..34d593aeb8 100644 --- a/source/text/scalc/01/06030600.xhp +++ b/source/text/scalc/01/06030600.xhp @@ -35,7 +35,7 @@ <section id="spurzumfehler"> <bookmark branch="index" xml-lang="en-US" id="bm_id3153561"><bookmark_value>cells; tracing errors</bookmark_value><bookmark_value>tracing errors</bookmark_value><bookmark_value>error tracing</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:ShowErrors" id="bm_id8441925" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:ShowErrors" xml-lang="en-US" id="bm_id3153541"/><paragraph id="hd_id3153561" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030600.xhp" name="Trace Error">Trace Error</link></paragraph> +<bookmark branch="hid/.uno:ShowErrors" xml-lang="en-US" id="bm_id3153541" localize="false"/><paragraph id="hd_id3153561" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030600.xhp" name="Trace Error">Trace Error</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3148550" xml-lang="en-US" oldref="2"><ahelp hid=".uno:ShowErrors" visibility="visible">Draws tracer arrows to all precedent cells which cause an error value in a selected cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030800.xhp b/source/text/scalc/01/06030800.xhp index caaf5ab755..bf8836de8a 100644 --- a/source/text/scalc/01/06030800.xhp +++ b/source/text/scalc/01/06030800.xhp @@ -35,7 +35,7 @@ <section id="dateneinkreisen"> <bookmark branch="index" xml-lang="en-US" id="bm_id3153821"><bookmark_value>cells; invalid data</bookmark_value><bookmark_value>data; showing invalid data</bookmark_value><bookmark_value>invalid data;marking</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:ShowInvalid" id="bm_id9508177" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:ShowInvalid" xml-lang="en-US" id="bm_id3157909"/><paragraph id="hd_id3153821" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030800.xhp" name="Mark Invalid Data">Mark Invalid Data</link></paragraph> +<bookmark branch="hid/.uno:ShowInvalid" xml-lang="en-US" id="bm_id3157909" localize="false"/><paragraph id="hd_id3153821" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06030800.xhp" name="Mark Invalid Data">Mark Invalid Data</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3147264" xml-lang="en-US" oldref="2"><ahelp hid=".uno:ShowInvalid" visibility="visible">Marks all cells in the sheet that contain values outside the validation rules.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06031000.xhp b/source/text/scalc/01/06031000.xhp index decb165749..bf02188d4e 100644 --- a/source/text/scalc/01/06031000.xhp +++ b/source/text/scalc/01/06031000.xhp @@ -35,7 +35,7 @@ <section id="autoaktu"> <bookmark branch="index" xml-lang="en-US" id="bm_id3154515"><bookmark_value>cells; autorefreshing traces</bookmark_value><bookmark_value>traces; autorefreshing</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:AutoRefreshArrows" id="bm_id2398344" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:AutoRefreshArrows" xml-lang="en-US" id="bm_id3153821"/><paragraph id="hd_id3154515" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06031000.xhp" name="AutoRefresh">AutoRefresh</link></paragraph> +<bookmark branch="hid/.uno:AutoRefreshArrows" xml-lang="en-US" id="bm_id3153821" localize="false"/><paragraph id="hd_id3154515" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/06031000.xhp" name="AutoRefresh">AutoRefresh</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3147264" xml-lang="en-US" oldref="2"><ahelp hid=".uno:AutoRefreshArrows" visibility="visible">Automatically refreshes all the traces in the sheet whenever you modify a formula.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/07080000.xhp b/source/text/scalc/01/07080000.xhp index b95944ddab..5fb554f2e6 100644 --- a/source/text/scalc/01/07080000.xhp +++ b/source/text/scalc/01/07080000.xhp @@ -34,7 +34,7 @@ <section id="teilen"> <bookmark xml-lang="en-US" branch="hid/.uno:SplitWindow" id="bm_id6328790" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:SplitWindow" xml-lang="en-US" id="bm_id3149164"/><paragraph id="hd_id3163800" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/07080000.xhp" name="Split">Split</link></paragraph> +<bookmark branch="hid/.uno:SplitWindow" xml-lang="en-US" id="bm_id3149164" localize="false"/><paragraph id="hd_id3163800" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/07080000.xhp" name="Split">Split</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3150084" xml-lang="en-US" oldref="2"><ahelp hid=".uno:SplitWindow" visibility="visible">Divides the current window at the top left corner of the active cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/07090000.xhp b/source/text/scalc/01/07090000.xhp index 3c3b0e4d1a..95d85b515a 100644 --- a/source/text/scalc/01/07090000.xhp +++ b/source/text/scalc/01/07090000.xhp @@ -35,7 +35,7 @@ <section id="fixieren"> <bookmark xml-lang="en-US" branch="hid/.uno:FreezePanes" id="bm_id6343491" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:FreezePanes" xml-lang="en-US" id="bm_id3155531"/><paragraph id="hd_id3150517" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/07090000.xhp" name="Freeze">Freeze</link></paragraph> +<bookmark branch="hid/.uno:FreezePanes" xml-lang="en-US" id="bm_id3155531" localize="false"/><paragraph id="hd_id3150517" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/07090000.xhp" name="Freeze">Freeze</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3156289" xml-lang="en-US" oldref="2"><ahelp hid=".uno:FreezePanes" visibility="visible">Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12010100.xhp b/source/text/scalc/01/12010100.xhp index f5459e1f92..7169c64036 100644 --- a/source/text/scalc/01/12010100.xhp +++ b/source/text/scalc/01/12010100.xhp @@ -34,13 +34,13 @@ <paragraph role="heading" level="1" id="hd_id3154760" l10n="U" xml-lang="en-US" oldref="1">Options</paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_HEADER" xml-lang="en-US" id="bm_id3150399"/><paragraph role="heading" level="3" id="hd_id3153379" l10n="U" xml-lang="en-US" oldref="3">Contains column labels</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_HEADER" xml-lang="en-US" id="bm_id3150399" localize="false"/><paragraph role="heading" level="3" id="hd_id3153379" l10n="U" xml-lang="en-US" oldref="3">Contains column labels</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3148798" xml-lang="en-US" oldref="4"><ahelp hid="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_HEADER" visibility="visible">Selected cell ranges contains labels.</ahelp></paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_SIZE" xml-lang="en-US" id="bm_id3156422"/><paragraph role="heading" level="3" id="hd_id3153970" l10n="U" xml-lang="en-US" oldref="5">Insert or delete cells</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_SIZE" xml-lang="en-US" id="bm_id3156422" localize="false"/><paragraph role="heading" level="3" id="hd_id3153970" l10n="U" xml-lang="en-US" oldref="5">Insert or delete cells</paragraph> <paragraph l10n="U" xml-lang="en-US" oldref="6" role="paragraph" id="par_id3154684"><ahelp hid="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_SIZE" visibility="visible">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh</emph> <emph>Range</emph>.</paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_FORMAT" xml-lang="en-US" id="bm_id3151117"/><paragraph role="heading" level="3" id="hd_id3153768" l10n="U" xml-lang="en-US" oldref="7">Keep formatting</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_FORMAT" xml-lang="en-US" id="bm_id3151117" localize="false"/><paragraph role="heading" level="3" id="hd_id3153768" l10n="U" xml-lang="en-US" oldref="7">Keep formatting</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3147435" xml-lang="en-US" oldref="8"><ahelp hid="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_FORMAT" visibility="visible">Applies the existing cell format of headers and first data row to the whole database range.</ahelp></paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_STRIPDATA" xml-lang="en-US" id="bm_id3145748"/><paragraph role="heading" level="3" id="hd_id3155856" l10n="U" xml-lang="en-US" oldref="9">Don't save imported data</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_DBNAMES:BTN_STRIPDATA" xml-lang="en-US" id="bm_id3145748" localize="false"/><paragraph role="heading" level="3" id="hd_id3155856" l10n="U" xml-lang="en-US" oldref="9">Don't save imported data</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3153363" xml-lang="en-US" oldref="10"><ahelp hid="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_STRIPDATA" visibility="visible">Only saves a reference to the database, and not the contents of the cells.</ahelp></paragraph> <paragraph role="heading" level="3" id="hd_id3147428" l10n="U" xml-lang="en-US" oldref="11">Source:</paragraph> <paragraph role="paragraph" id="par_id3148576" l10n="U" xml-lang="en-US" oldref="12">Displays information about the current database source and any existing operators.</paragraph> diff --git a/source/text/scalc/01/12040500.xhp b/source/text/scalc/01/12040500.xhp index 69fc05286f..5db68936d5 100644 --- a/source/text/scalc/01/12040500.xhp +++ b/source/text/scalc/01/12040500.xhp @@ -35,7 +35,7 @@ <section id="autofilterausblenden"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150276"><bookmark_value>database ranges; hiding AutoFilter</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:DataFilterHideAutoFilter" id="bm_id7401778" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:DataFilterHideAutoFilter" xml-lang="en-US" id="bm_id3145674"/><paragraph id="hd_id3150276" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12040500.xhp" name="Hide AutoFilter">Hide AutoFilter</link></paragraph> +<bookmark branch="hid/.uno:DataFilterHideAutoFilter" xml-lang="en-US" id="bm_id3145674" localize="false"/><paragraph id="hd_id3150276" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12040500.xhp" name="Hide AutoFilter">Hide AutoFilter</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3156326" xml-lang="en-US" oldref="2"><ahelp hid=".uno:DataFilterHideAutoFilter" visibility="visible">Hides the AutoFilter buttons in the selected cell range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12050000.xhp b/source/text/scalc/01/12050000.xhp index 24b3dbdc91..be6a019787 100644 --- a/source/text/scalc/01/12050000.xhp +++ b/source/text/scalc/01/12050000.xhp @@ -34,7 +34,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:DataSubTotals" id="bm_id1614637" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:DataSubTotals" xml-lang="en-US" id="bm_id3154515"/><paragraph role="heading" level="1" id="hd_id3153822" l10n="U" xml-lang="en-US" oldref="1">Subtotals</paragraph> +<bookmark branch="hid/.uno:DataSubTotals" xml-lang="en-US" id="bm_id3154515" localize="false"/><paragraph role="heading" level="1" id="hd_id3153822" l10n="U" xml-lang="en-US" oldref="1">Subtotals</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3145119" xml-lang="en-US" oldref="2"><variable id="teilergebnisse"><ahelp hid=".uno:DataSubTotals" visibility="visible">Calculates subtotals for the columns that you select.</ahelp></variable> $[officename] uses the SUM function to automatically calculate the subtotal and grand total values in a labeled range. You can also use other functions to perform the calculation. $[officename] automatically recognizes a defined database area when you place the cursor in it.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dntegs"/> diff --git a/source/text/scalc/01/12070100.xhp b/source/text/scalc/01/12070100.xhp index 12d2e0e490..bef39b9df3 100644 --- a/source/text/scalc/01/12070100.xhp +++ b/source/text/scalc/01/12070100.xhp @@ -36,12 +36,12 @@ <paragraph role="heading" level="1" id="hd_id3151210" l10n="U" xml-lang="en-US" oldref="1">Consolidate by</paragraph> <paragraph role="heading" level="2" id="hd_id3125864" l10n="U" xml-lang="en-US" oldref="2">Consolidate by</paragraph> <paragraph role="paragraph" id="par_id3154909" l10n="U" xml-lang="en-US" oldref="3">Use this section if the cell ranges that you want to consolidate contain labels. You only need to select these options if the consolidation ranges contain similar labels and the data arranged is arranged differently.</paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW" xml-lang="en-US" id="bm_id3154684"/><paragraph role="heading" level="3" id="hd_id3153968" l10n="U" xml-lang="en-US" oldref="4">Row labels</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW" xml-lang="en-US" id="bm_id3154684" localize="false"/><paragraph role="heading" level="3" id="hd_id3153968" l10n="U" xml-lang="en-US" oldref="4">Row labels</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3150441" xml-lang="en-US" oldref="5"><ahelp hid="SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYROW" visibility="visible">Uses the row labels to arrange the consolidated data.</ahelp></paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL" xml-lang="en-US" id="bm_id3149260"/><paragraph role="heading" level="3" id="hd_id3146976" l10n="U" xml-lang="en-US" oldref="6">Column labels</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL" xml-lang="en-US" id="bm_id3149260" localize="false"/><paragraph role="heading" level="3" id="hd_id3146976" l10n="U" xml-lang="en-US" oldref="6">Column labels</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3155411" xml-lang="en-US" oldref="7"><ahelp hid="SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYCOL" visibility="visible">Uses the column labels to arrange the consolidated data.</ahelp></paragraph> <paragraph role="heading" level="2" id="hd_id3153191" l10n="U" xml-lang="en-US" oldref="12">Options</paragraph> - <bookmark branch="hid/sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS" xml-lang="en-US" id="bm_id3153954"/><paragraph role="heading" level="3" id="hd_id3159154" l10n="U" xml-lang="en-US" oldref="8">Link to source data</paragraph> + <bookmark branch="hid/sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS" xml-lang="en-US" id="bm_id3153954" localize="false"/><paragraph role="heading" level="3" id="hd_id3159154" l10n="U" xml-lang="en-US" oldref="8">Link to source data</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3146986" xml-lang="en-US" oldref="9"><ahelp hid="SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_REFS" visibility="visible">Links the data in the consolidation range to the source data, and automatically updates the results of the consolidation when the source data is changed.</ahelp></paragraph> <paragraph role="heading" level="2" id="hd_id3163708" l10n="U" xml-lang="en-US" oldref="10">More <<</paragraph> <paragraph role="paragraph" id="par_id3151118" l10n="U" xml-lang="en-US" oldref="11">Hides the additional options.</paragraph> diff --git a/source/text/scalc/01/12080100.xhp b/source/text/scalc/01/12080100.xhp index 6141b8b974..18a3de66d3 100644 --- a/source/text/scalc/01/12080100.xhp +++ b/source/text/scalc/01/12080100.xhp @@ -35,7 +35,7 @@ <section id="detailausblenden"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155628"><bookmark_value>sheets; hiding details</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:HideDetail" id="bm_id253394" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:HideDetail" xml-lang="en-US" id="bm_id3149784"/><paragraph id="hd_id3155628" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080100.xhp" name="Hide Details">Hide Details</link></paragraph> +<bookmark branch="hid/.uno:HideDetail" xml-lang="en-US" id="bm_id3149784" localize="false"/><paragraph id="hd_id3155628" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080100.xhp" name="Hide Details">Hide Details</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3154515" xml-lang="en-US" oldref="2"><ahelp hid=".uno:HideDetail" visibility="visible">Hides the details of the grouped row or column that contains the cursor. To hide all of the grouped rows or columns, select the outlined table, and then choose this command.</ahelp></paragraph> </section> <paragraph xml-lang="en-US" oldref="3" role="paragraph" id="par_id3153252" l10n="U">To show all hidden groups, select the outlined table, and then choose <emph>Data - Group and Outline –</emph> <link href="text/scalc/01/12080200.xhp" name="Show Details"><emph>Show Details</emph></link>.</paragraph> diff --git a/source/text/scalc/01/12080300.xhp b/source/text/scalc/01/12080300.xhp index e75927d4a5..2dd7b36741 100644 --- a/source/text/scalc/01/12080300.xhp +++ b/source/text/scalc/01/12080300.xhp @@ -34,8 +34,8 @@ <section id="gruppieren"> - <bookmark branch="hid/sc:ModalDialog:RID_SCDLG_GROUP" xml-lang="en-US" id="bm_id3156329"/><bookmark xml-lang="en-US" branch="hid/.uno:Group" id="bm_id9177845" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:Group" xml-lang="en-US" id="bm_id3149786"/><paragraph id="hd_id3153088" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080300.xhp" name="Group">Group</link></paragraph> + <bookmark branch="hid/sc:ModalDialog:RID_SCDLG_GROUP" xml-lang="en-US" id="bm_id3156329" localize="false"/><bookmark xml-lang="en-US" branch="hid/.uno:Group" id="bm_id9177845" localize="false"/><!-- HID added by script --> +<bookmark branch="hid/.uno:Group" xml-lang="en-US" id="bm_id3149786" localize="false"/><paragraph id="hd_id3153088" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080300.xhp" name="Group">Group</link></paragraph> </section> <paragraph l10n="U" role="paragraph" id="par_id3153821" xml-lang="en-US" oldref="2"><variable id="gruppierung"><ahelp hid=".uno:Group" visibility="visible">Defines the selected cell range as a group of rows or columns.</ahelp></variable></paragraph> <section id="howtoget"> @@ -43,9 +43,9 @@ </section> <paragraph xml-lang="en-US" oldref="3" role="paragraph" id="par_id3145069" l10n="U">When you group a cell range, and outline icon appears in the margins next to the group. To hide or show the group, click the icon. To ungroup the selection, choose <emph>Data – Outline -</emph> <link href="text/scalc/01/12080400.xhp" name="Ungroup"><emph>Ungroup</emph></link>.</paragraph> <paragraph role="heading" level="2" id="hd_id3125863" l10n="U" xml-lang="en-US" oldref="4">Include</paragraph> - <bookmark branch="hid/SC_HID_SC_GROUP_ROWS" xml-lang="en-US" id="bm_id3150770"/><paragraph role="heading" level="3" id="hd_id3150448" l10n="U" xml-lang="en-US" oldref="6">Rows</paragraph> + <bookmark branch="hid/SC_HID_SC_GROUP_ROWS" xml-lang="en-US" id="bm_id3150770" localize="false"/><paragraph role="heading" level="3" id="hd_id3150448" l10n="U" xml-lang="en-US" oldref="6">Rows</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3153194" xml-lang="en-US" oldref="7"><ahelp hid="HID_SC_GROUP_ROWS" visibility="visible">Groups the selected rows.</ahelp></paragraph> - <bookmark branch="hid/SC_HID_SC_GROUP_COLS" xml-lang="en-US" id="bm_id3153771"/><paragraph role="heading" level="3" id="hd_id3145786" l10n="U" xml-lang="en-US" oldref="8">Columns</paragraph> + <bookmark branch="hid/SC_HID_SC_GROUP_COLS" xml-lang="en-US" id="bm_id3153771" localize="false"/><paragraph role="heading" level="3" id="hd_id3145786" l10n="U" xml-lang="en-US" oldref="8">Columns</paragraph> <paragraph l10n="U" role="paragraph" id="par_id3146984" xml-lang="en-US" oldref="9"><ahelp hid="HID_SC_GROUP_COLS" visibility="visible">Groups the selected columns.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12080400.xhp b/source/text/scalc/01/12080400.xhp index 1f2cb8bac0..33e672ade7 100644 --- a/source/text/scalc/01/12080400.xhp +++ b/source/text/scalc/01/12080400.xhp @@ -35,7 +35,7 @@ <section id="gruppierungaufheben"> <bookmark xml-lang="en-US" branch="hid/.uno:Ungroup" id="bm_id8812419" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:Ungroup" xml-lang="en-US" id="bm_id3153561"/><paragraph id="hd_id3148492" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080400.xhp" name="Ungroup">Ungroup</link></paragraph> +<bookmark branch="hid/.uno:Ungroup" xml-lang="en-US" id="bm_id3153561" localize="false"/><paragraph id="hd_id3148492" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080400.xhp" name="Ungroup">Ungroup</link></paragraph> </section> <paragraph l10n="U" role="paragraph" id="par_id3151384" xml-lang="en-US" oldref="2"><variable id="gruppierungauf"><ahelp hid=".uno:Ungroup" visibility="visible">Ungroups the selection. In a nested group, the last rows or columns that were added are removed from the group.</ahelp></variable></paragraph> <section id="howtoget"> diff --git a/source/text/scalc/01/12080600.xhp b/source/text/scalc/01/12080600.xhp index 68dad4ae35..9a98ff9b73 100644 --- a/source/text/scalc/01/12080600.xhp +++ b/source/text/scalc/01/12080600.xhp @@ -35,7 +35,7 @@ <section id="entfernen"> <bookmark xml-lang="en-US" branch="hid/.uno:ClearOutline" id="bm_id8214497" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:ClearOutline" xml-lang="en-US" id="bm_id3150400"/><paragraph id="hd_id3148947" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080600.xhp" name="Remove">Remove</link></paragraph> +<bookmark branch="hid/.uno:ClearOutline" xml-lang="en-US" id="bm_id3150400" localize="false"/><paragraph id="hd_id3148947" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12080600.xhp" name="Remove">Remove</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3149656" xml-lang="en-US" oldref="2"><ahelp hid=".uno:ClearOutline" visibility="visible">Removes the outline from the selected cell range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12090103.xhp b/source/text/scalc/01/12090103.xhp index a8c6750198..5b17e8889b 100644 --- a/source/text/scalc/01/12090103.xhp +++ b/source/text/scalc/01/12090103.xhp @@ -37,11 +37,11 @@ <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"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_OP2" xml-lang="en-US" id="bm_id3155412"/><paragraph role="heading" level="3" id="hd_id3159153" l10n="U" xml-lang="en-US" oldref="5">Operator</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"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD2" xml-lang="en-US" id="bm_id3148646"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD3" xml-lang="en-US" id="bm_id3149667"/><paragraph role="heading" level="3" id="hd_id3152462" l10n="U" xml-lang="en-US" oldref="7">Field name</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"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND2" xml-lang="en-US" id="bm_id3155855"/><bookmark branch="hid/sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND3" xml-lang="en-US" id="bm_id3156444"/><paragraph role="heading" level="3" id="hd_id3148575" l10n="U" xml-lang="en-US" oldref="9">Condition</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> <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"/><bookmark branch="hid/sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL2" xml-lang="en-US" id="bm_id3152994"/><bookmark branch="hid/sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL3" xml-lang="en-US" id="bm_id3150370"/><paragraph role="heading" level="3" id="hd_id3150886" l10n="U" xml-lang="en-US" oldref="25">Value</paragraph> + <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"/><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/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> <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 5d442d097f..14de8e01a7 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"/><paragraph role="heading" level="3" id="hd_id3153662" l10n="U" xml-lang="en-US" oldref="5">Case sensitive</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> <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"/><paragraph role="heading" level="3" id="hd_id3156327" l10n="U" xml-lang="en-US" oldref="7">Regular Expression</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> <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"/><paragraph role="heading" level="3" id="hd_id3153379" l10n="U" xml-lang="en-US" oldref="30">Unique records only</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> <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> diff --git a/source/text/scalc/01/12090300.xhp b/source/text/scalc/01/12090300.xhp index a2bd3a6fbb..fab8e14674 100644 --- a/source/text/scalc/01/12090300.xhp +++ b/source/text/scalc/01/12090300.xhp @@ -29,7 +29,7 @@ <body> <section id="loeschen"> <bookmark xml-lang="en-US" branch="hid/.uno:DeletePivotTable" id="bm_id8594613" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:DeletePivotTable" xml-lang="en-US" id="bm_id3148491"/><paragraph id="hd_id3150276" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12090300.xhp" name="Delete">Delete</link></paragraph> +<bookmark branch="hid/.uno:DeletePivotTable" xml-lang="en-US" id="bm_id3148491" localize="false"/><paragraph id="hd_id3150276" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12090300.xhp" name="Delete">Delete</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3159400" xml-lang="en-US" oldref="2"><ahelp hid=".uno:DeletePivotTable" visibility="visible">Deletes the selected pivot table.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12100000.xhp b/source/text/scalc/01/12100000.xhp index 78edb75e27..37b879859b 100644 --- a/source/text/scalc/01/12100000.xhp +++ b/source/text/scalc/01/12100000.xhp @@ -34,8 +34,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark><bookmark xml-lang="en-US" branch="hid/.uno:DataReImport" id="bm_id3171995" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:DataReImport" xml-lang="en-US" id="bm_id3153880"/><bookmark xml-lang="en-US" branch="hid/.uno:DataAreaRefresh" id="bm_id439095" localize="false"/><!-- HID added by script --> -<bookmark branch="hid/.uno:DataAreaRefresh" xml-lang="en-US" id="bm_id3149166"/><paragraph id="hd_id3153662" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></paragraph> +<bookmark branch="hid/.uno:DataReImport" xml-lang="en-US" id="bm_id3153880" localize="false"/><bookmark xml-lang="en-US" branch="hid/.uno:DataAreaRefresh" id="bm_id439095" localize="false"/><!-- HID added by script --> +<bookmark branch="hid/.uno:DataAreaRefresh" xml-lang="en-US" id="bm_id3149166" localize="false"/><paragraph id="hd_id3153662" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></paragraph> <paragraph l10n="U" role="paragraph" id="par_id3153088" xml-lang="en-US" oldref="2"><variable id="aktualisieren"><ahelp hid=".uno:DataAreaRefresh" visibility="visible">Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.</ahelp></variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dndakt"/> |