summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorGabor Kelemen <kelemeng@gnome.hu>2018-05-04 16:56:24 +0200
committerGabor Kelemen <kelemeng@ubuntu.com>2018-05-04 17:32:49 +0200
commit575d72e10f919a19a8793d16636f5cca8dcd4564 (patch)
tree9e282312c3fa949ed7e5f1a94b2754a8a6331e02 /source
parentadc9acd36edabe6e169f4acf8e83fde8562fce70 (diff)
Remove duplicate HIDs added by script - from scalc
To improve readability of xhps Also fix some ahelps with multiple bookmarks Change-Id: Ia3394344ac8b0bdca78ce4c1aebef8d827d8313c Reviewed-on: https://gerrit.libreoffice.org/53854 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/01/02140100.xhp4
-rw-r--r--source/text/scalc/01/02140200.xhp4
-rw-r--r--source/text/scalc/01/02140300.xhp4
-rw-r--r--source/text/scalc/01/02140400.xhp4
-rw-r--r--source/text/scalc/01/02170000.xhp1
-rw-r--r--source/text/scalc/01/02210000.xhp9
-rw-r--r--source/text/scalc/01/04010100.xhp1
-rw-r--r--source/text/scalc/01/04010200.xhp1
-rw-r--r--source/text/scalc/01/05030300.xhp5
-rw-r--r--source/text/scalc/01/05030400.xhp4
-rw-r--r--source/text/scalc/01/05050300.xhp9
-rw-r--r--source/text/scalc/01/05080100.xhp1
-rw-r--r--source/text/scalc/01/05080200.xhp1
-rw-r--r--source/text/scalc/01/05080400.xhp1
-rw-r--r--source/text/scalc/01/06030100.xhp1
-rw-r--r--source/text/scalc/01/06030300.xhp5
-rw-r--r--source/text/scalc/01/06030400.xhp5
-rw-r--r--source/text/scalc/01/06030500.xhp5
-rw-r--r--source/text/scalc/01/06030600.xhp5
-rw-r--r--source/text/scalc/01/06030700.xhp1
-rw-r--r--source/text/scalc/01/06030800.xhp5
-rw-r--r--source/text/scalc/01/06031000.xhp5
-rw-r--r--source/text/scalc/01/12030000.xhp1
-rw-r--r--source/text/scalc/01/12040500.xhp5
-rw-r--r--source/text/scalc/01/12050000.xhp4
-rw-r--r--source/text/scalc/01/12080100.xhp5
-rw-r--r--source/text/scalc/01/12080400.xhp4
-rw-r--r--source/text/scalc/01/12080600.xhp4
-rw-r--r--source/text/scalc/01/12090200.xhp1
-rw-r--r--source/text/scalc/01/12090300.xhp4
-rw-r--r--source/text/scalc/01/12100000.xhp9
-rw-r--r--source/text/scalc/01/12120000.xhp1
-rw-r--r--source/text/scalc/02/02130000.xhp4
-rw-r--r--source/text/scalc/02/02140000.xhp1
-rw-r--r--source/text/scalc/02/02150000.xhp4
-rw-r--r--source/text/scalc/02/06080000.xhp1
-rw-r--r--source/text/scalc/02/18020000.xhp1
37 files changed, 61 insertions, 69 deletions
diff --git a/source/text/scalc/01/02140100.xhp b/source/text/scalc/01/02140100.xhp
index 08857cfe2e..7859a6099b 100644
--- a/source/text/scalc/01/02140100.xhp
+++ b/source/text/scalc/01/02140100.xhp
@@ -33,8 +33,8 @@
<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" localize="false"/><paragraph id="hd_id3150792" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/02140100.xhp" name="Down">Down</link></paragraph>
<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><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 93a2b9c1ff..5b24a5708c 100644
--- a/source/text/scalc/01/02140200.xhp
+++ b/source/text/scalc/01/02140200.xhp
@@ -33,8 +33,8 @@
<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" localize="false"/><paragraph id="hd_id3153896" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/02140200.xhp" name="Right">Right</link></paragraph>
<paragraph role="paragraph" id="par_id3153361" xml-lang="en-US"><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 fe10904608..6480500a27 100644
--- a/source/text/scalc/01/02140300.xhp
+++ b/source/text/scalc/01/02140300.xhp
@@ -33,8 +33,8 @@
<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" localize="false"/><paragraph id="hd_id3147264" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/02140300.xhp" name="Up">Up</link></paragraph>
<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><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 58836abb07..5e930927da 100644
--- a/source/text/scalc/01/02140400.xhp
+++ b/source/text/scalc/01/02140400.xhp
@@ -33,8 +33,8 @@
<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" localize="false"/><paragraph id="hd_id3153896" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/02140400.xhp" name="Left">Left</link></paragraph>
<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><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/02170000.xhp b/source/text/scalc/01/02170000.xhp
index 300f65fca9..6d96ccdcd2 100644
--- a/source/text/scalc/01/02170000.xhp
+++ b/source/text/scalc/01/02170000.xhp
@@ -34,7 +34,6 @@
<bookmark_value>sheets; deleting</bookmark_value>
<bookmark_value>deleting; spreadsheets</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:Remove" id="bm_id7030283" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:Remove" id="bm_id3150769" localize="false"/>
<paragraph role="heading" id="hd_id3156424" xml-lang="en-US" level="1"> Delete Sheet</paragraph>
<paragraph role="paragraph" id="par_id3153193" xml-lang="en-US"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes the current sheet after query confirmation.</ahelp>
diff --git a/source/text/scalc/01/02210000.xhp b/source/text/scalc/01/02210000.xhp
index 99a6082300..43f4cc5224 100644
--- a/source/text/scalc/01/02210000.xhp
+++ b/source/text/scalc/01/02210000.xhp
@@ -32,10 +32,11 @@
<body>
- <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" localize="false"/><paragraph role="heading" level="1" id="hd_id3156023" xml-lang="en-US">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" xml-lang="en-US">Selecting Sheets</paragraph>
<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US"><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" localize="false"/><paragraph role="heading" level="2" id="hd_id3125863" xml-lang="en-US">Selected Sheets</paragraph>
- <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><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 <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> 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>
+ <bookmark branch="hid/SC_HID_SELECTTABLES" xml-lang="en-US" id="bm_id3154126" localize="false"/>
+<paragraph role="heading" level="2" id="hd_id3125863" xml-lang="en-US">Selected Sheets</paragraph>
+ <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><ahelp hid="SC_HID_SELECTTABLES">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 <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> 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/04010100.xhp b/source/text/scalc/01/04010100.xhp
index d24625e948..e5b68f1179 100644
--- a/source/text/scalc/01/04010100.xhp
+++ b/source/text/scalc/01/04010100.xhp
@@ -36,7 +36,6 @@
<bookmark_value>inserting; manual row breaks</bookmark_value>
<bookmark_value>manual row breaks</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertRowBreak" id="bm_id7744261" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:InsertRowBreak" id="bm_id3151245" localize="false"/>
<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="1"><link href="text/scalc/01/04010100.xhp" name="Row Break">Row Break</link></paragraph>
<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp hid=".uno:InsertRowBreak">Inserts a row break (horizontal page break) above the selected cell.</ahelp></paragraph>
diff --git a/source/text/scalc/01/04010200.xhp b/source/text/scalc/01/04010200.xhp
index 1c2ad551d1..929b9f2aee 100644
--- a/source/text/scalc/01/04010200.xhp
+++ b/source/text/scalc/01/04010200.xhp
@@ -36,7 +36,6 @@
<bookmark_value>inserting; manual column breaks</bookmark_value>
<bookmark_value>manual column breaks</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnBreak" id="bm_id9499162" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnBreak" id="bm_id3148947" localize="false"/>
<paragraph role="heading" id="hd_id3155923" xml-lang="en-US" level="1"><link href="text/scalc/01/04010200.xhp" name="Column Break">Column Break</link></paragraph>
<paragraph role="paragraph" id="par_id3150447" xml-lang="en-US"><ahelp hid=".uno:InsertColumnBreak">Inserts a column break (vertical page break) to the left of the active cell.</ahelp></paragraph>
diff --git a/source/text/scalc/01/05030300.xhp b/source/text/scalc/01/05030300.xhp
index 429fe813b2..01b1d5d68f 100644
--- a/source/text/scalc/01/05030300.xhp
+++ b/source/text/scalc/01/05030300.xhp
@@ -39,14 +39,11 @@
<bookmark_value>columns;hiding</bookmark_value>
<bookmark_value>rows;hiding</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:HideRow" id="bm_id1092740" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:HideRow" id="bm_id3154760" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:HideColumn" id="bm_id6394987" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:HideColumn" id="bm_id3148663" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:Hide" id="bm_id9380668" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:Hide" id="bm_id3149457" localize="false"/>
<paragraph role="heading" id="hd_id3147265" xml-lang="en-US" level="1"><link href="text/scalc/01/05030300.xhp" name="Hide">Hide</link></paragraph>
-<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"><ahelp hid=".uno:Hide">Hides selected rows, columns or individual sheets.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"><ahelp hid=".">Hides selected rows, columns or individual sheets.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fozeiaus"/>
diff --git a/source/text/scalc/01/05030400.xhp b/source/text/scalc/01/05030400.xhp
index a81d7aede8..b53974052a 100644
--- a/source/text/scalc/01/05030400.xhp
+++ b/source/text/scalc/01/05030400.xhp
@@ -35,12 +35,10 @@
<bookmark_value>showing; columns</bookmark_value>
<bookmark_value>showing; rows</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowRow" id="bm_id332357" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:ShowRow" id="bm_id3154760" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowColumn" id="bm_id4036373" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:ShowColumn" id="bm_id3149456" localize="false"/>
<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1"><link href="text/scalc/01/05030400.xhp" name="Show">Show</link></paragraph>
-<paragraph role="paragraph" id="par_id3150447" xml-lang="en-US"><ahelp hid=".uno:ShowColumn">Choose this command to show previously hidden rows or columns.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150447" xml-lang="en-US"><ahelp hid=".">Choose this command to show previously hidden rows or columns.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fozeiebl"/>
diff --git a/source/text/scalc/01/05050300.xhp b/source/text/scalc/01/05050300.xhp
index 59ce80a81d..1af493cdf4 100644
--- a/source/text/scalc/01/05050300.xhp
+++ b/source/text/scalc/01/05050300.xhp
@@ -32,13 +32,14 @@
<body>
- <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" localize="false"/><paragraph role="heading" level="1" id="hd_id3148946" xml-lang="en-US">Show Sheet</paragraph>
+ <bookmark branch="index" xml-lang="en-US" id="bm_id3148946"><bookmark_value>sheets; displaying</bookmark_value><bookmark_value>displaying; sheets</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:Show" xml-lang="en-US" id="bm_id3150542" localize="false"/>
+<paragraph role="heading" level="1" id="hd_id3148946" xml-lang="en-US">Show Sheet</paragraph>
<paragraph xml-lang="en-US" role="paragraph" id="par_id3148799"><variable id="tabeintext"><ahelp visibility="visible" hid=".uno:Show">Displays sheets that were previously hidden with the <emph>Hide Sheets</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/modules/scalc/ui/whowsheetdialog/ShowSheetDialog" xml-lang="en-US" id="bm_id3149260" localize="false"/><paragraph role="heading" level="2" id="hd_id3151112" xml-lang="en-US">Hidden sheets</paragraph>
- <paragraph role="paragraph" id="par_id3145273" xml-lang="en-US"><ahelp hid="modules/scalc/ui/whowsheetdialog/ShowSheetDialog" 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>
+ <bookmark branch="hid/modules/scalc/ui/showsheetdialog/ShowSheetDialog" xml-lang="en-US" id="bm_id3149260" localize="false"/><paragraph role="heading" level="2" id="hd_id3151112" xml-lang="en-US">Hidden sheets</paragraph>
+ <paragraph role="paragraph" id="par_id3145273" xml-lang="en-US"><ahelp hid="modules/scalc/ui/showsheetdialog/ShowSheetDialog" 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/05080100.xhp b/source/text/scalc/01/05080100.xhp
index 7a0169ee1e..289378e699 100644
--- a/source/text/scalc/01/05080100.xhp
+++ b/source/text/scalc/01/05080100.xhp
@@ -31,7 +31,6 @@
</meta>
<body>
<section id="festlegen">
-<bookmark xml-lang="en-US" branch="hid/.uno:DefinePrintArea" id="bm_id4715132" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:DefinePrintArea" id="bm_id3153561" localize="false"/>
<paragraph role="heading" id="hd_id3145673" xml-lang="en-US" level="1"><link href="text/scalc/01/05080100.xhp" name="Define">Define</link></paragraph>
<paragraph role="paragraph" id="par_id3153896" xml-lang="en-US"><ahelp hid=".uno:DefinePrintArea">Defines an active cell or selected cell area as the print range.</ahelp></paragraph>
diff --git a/source/text/scalc/01/05080200.xhp b/source/text/scalc/01/05080200.xhp
index 76dbf0641e..e3dfef31d8 100644
--- a/source/text/scalc/01/05080200.xhp
+++ b/source/text/scalc/01/05080200.xhp
@@ -31,7 +31,6 @@
</meta>
<body>
<section id="aufheben">
-<bookmark xml-lang="en-US" branch="hid/.uno:DeletePrintArea" id="bm_id7204561" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:DeletePrintArea" id="bm_id3150275" localize="false"/>
<paragraph role="heading" id="hd_id3153562" xml-lang="en-US" level="1"><link href="text/scalc/01/05080200.xhp" name="Clear">Clear</link></paragraph>
<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:DeletePrintArea">Removes the defined print area.</ahelp></paragraph>
diff --git a/source/text/scalc/01/05080400.xhp b/source/text/scalc/01/05080400.xhp
index ad6e6a9411..309d80f4a4 100644
--- a/source/text/scalc/01/05080400.xhp
+++ b/source/text/scalc/01/05080400.xhp
@@ -31,7 +31,6 @@
</meta>
<body>
<section id="hinzu">
-<bookmark xml-lang="en-US" branch="hid/.uno:AddPrintArea" id="bm_id820140" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:AddPrintArea" id="bm_id3150543" localize="false"/>
<paragraph role="heading" id="hd_id3149457" xml-lang="en-US" level="1"><link href="text/scalc/01/05080400.xhp" name="Add">Add</link></paragraph>
<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US"><ahelp hid=".uno:AddPrintArea">Adds the current selection to the defined print areas.</ahelp></paragraph>
diff --git a/source/text/scalc/01/06030100.xhp b/source/text/scalc/01/06030100.xhp
index d7f4e2470d..811a440ecd 100644
--- a/source/text/scalc/01/06030100.xhp
+++ b/source/text/scalc/01/06030100.xhp
@@ -34,7 +34,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155628"><bookmark_value>cells; tracing precedents</bookmark_value>
<bookmark_value>formula cells;tracing precedents</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowPrecedents" id="bm_id2408205" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:ShowPrecedents" id="bm_id3145673" localize="false"/>
<paragraph role="heading" id="hd_id3155628" xml-lang="en-US" level="1"><link href="text/scalc/01/06030100.xhp" name="Trace Precedents">Trace Precedents</link></paragraph>
<paragraph role="paragraph" id="par_id3153542" xml-lang="en-US"><ahelp hid=".uno:ShowPrecedents">This function shows the relationship between the current cell containing a formula and the cells used in the formula.</ahelp></paragraph>
diff --git a/source/text/scalc/01/06030300.xhp b/source/text/scalc/01/06030300.xhp
index 0885160644..2d276b1961 100644
--- a/source/text/scalc/01/06030300.xhp
+++ b/source/text/scalc/01/06030300.xhp
@@ -32,8 +32,9 @@
<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" localize="false"/><paragraph id="hd_id3153252" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030300.xhp" name="Trace Dependents">Trace Dependents</link></paragraph>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3153252"><bookmark_value>cells; tracing dependents</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ShowDependents" xml-lang="en-US" id="bm_id3143267" localize="false"/>
+<paragraph id="hd_id3153252" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030300.xhp" name="Trace Dependents">Trace Dependents</link></paragraph>
<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><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" xml-lang="en-US">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 75e4b6d622..07e9b5bb2d 100644
--- a/source/text/scalc/01/06030400.xhp
+++ b/source/text/scalc/01/06030400.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3147335" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030400.xhp" name="Remove Dependents">Remove Dependents</link></paragraph>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>cells; removing dependents</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ClearArrowDependents" xml-lang="en-US" id="bm_id3148552" localize="false"/>
+<paragraph id="hd_id3147335" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030400.xhp" name="Remove Dependents">Remove Dependents</link></paragraph>
<paragraph role="paragraph" id="par_id3148663" xml-lang="en-US"><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 9a3d9decca..82afa0fd93 100644
--- a/source/text/scalc/01/06030500.xhp
+++ b/source/text/scalc/01/06030500.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3153088" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030500.xhp" name="Remove All Traces">Remove All Traces</link></paragraph>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3153088"><bookmark_value>cells; removing traces</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:ClearArrows" xml-lang="en-US" id="bm_id3153541" localize="false"/>
+<paragraph id="hd_id3153088" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030500.xhp" name="Remove All Traces">Remove All Traces</link></paragraph>
<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><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 90538e90bd..00f77630cd 100644
--- a/source/text/scalc/01/06030600.xhp
+++ b/source/text/scalc/01/06030600.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3153561" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030600.xhp" name="Trace Error">Trace Error</link></paragraph>
+ <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 branch="hid/.uno:ShowErrors" xml-lang="en-US" id="bm_id3153541" localize="false"/>
+<paragraph id="hd_id3153561" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030600.xhp" name="Trace Error">Trace Error</link></paragraph>
<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><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/06030700.xhp b/source/text/scalc/01/06030700.xhp
index 44adfa90da..78ab009107 100644
--- a/source/text/scalc/01/06030700.xhp
+++ b/source/text/scalc/01/06030700.xhp
@@ -34,7 +34,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3145119"><bookmark_value>cells; trace fill mode</bookmark_value>
<bookmark_value>traces; precedents for multiple cells</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:AuditingFillMode" id="bm_id5785183" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:AuditingFillMode" id="bm_id3148491" localize="false"/>
<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"><link href="text/scalc/01/06030700.xhp" name="Fill Mode">Fill Mode</link></paragraph>
<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><ahelp hid=".uno:AuditingFillMode">Activates the Fill Mode in the Detective. The mouse pointer changes to a special symbol, and you can click any cell to see a trace to the precedent cell.</ahelp> To exit this mode, press Escape or click the <emph>End Fill Mode</emph> command in the context menu.</paragraph>
diff --git a/source/text/scalc/01/06030800.xhp b/source/text/scalc/01/06030800.xhp
index c817e2b371..bddfcf69b0 100644
--- a/source/text/scalc/01/06030800.xhp
+++ b/source/text/scalc/01/06030800.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3153821" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030800.xhp" name="Mark Invalid Data">Mark Invalid Data</link></paragraph>
+ <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 branch="hid/.uno:ShowInvalid" xml-lang="en-US" id="bm_id3157909" localize="false"/>
+<paragraph id="hd_id3153821" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030800.xhp" name="Mark Invalid Data">Mark Invalid Data</link></paragraph>
<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><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 4f30d46fa2..304abc9a6f 100644
--- a/source/text/scalc/01/06031000.xhp
+++ b/source/text/scalc/01/06031000.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3154515" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06031000.xhp" name="AutoRefresh">AutoRefresh</link></paragraph>
+ <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 branch="hid/.uno:AutoRefreshArrows" xml-lang="en-US" id="bm_id3153821" localize="false"/>
+<paragraph id="hd_id3154515" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06031000.xhp" name="AutoRefresh">AutoRefresh</link></paragraph>
<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><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/12030000.xhp b/source/text/scalc/01/12030000.xhp
index 6ff8e7dcb9..ceb97c8ac0 100644
--- a/source/text/scalc/01/12030000.xhp
+++ b/source/text/scalc/01/12030000.xhp
@@ -30,7 +30,6 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:DataSort" id="bm_id8745502" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:DataSort" id="bm_id3150084" localize="false"/>
<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1">Sort</paragraph>
<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><variable id="sorttext"><ahelp hid=".uno:DataSort">Sorts the selected rows according to the conditions that you specify.</ahelp>
diff --git a/source/text/scalc/01/12040500.xhp b/source/text/scalc/01/12040500.xhp
index cd66c511c8..3ce7206b36 100644
--- a/source/text/scalc/01/12040500.xhp
+++ b/source/text/scalc/01/12040500.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3150276" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12040500.xhp" name="Hide AutoFilter">Hide AutoFilter</link></paragraph>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3150276"><bookmark_value>database ranges; hiding AutoFilter</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:DataFilterHideAutoFilter" xml-lang="en-US" id="bm_id3145674" localize="false"/>
+<paragraph id="hd_id3150276" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12040500.xhp" name="Hide AutoFilter">Hide AutoFilter</link></paragraph>
<paragraph role="paragraph" id="par_id3156326" xml-lang="en-US"><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 fa400ceb93..d709900ac6 100644
--- a/source/text/scalc/01/12050000.xhp
+++ b/source/text/scalc/01/12050000.xhp
@@ -32,8 +32,8 @@
<body>
- <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" localize="false"/><paragraph role="heading" level="1" id="hd_id3153822" xml-lang="en-US">Subtotals</paragraph>
+<bookmark branch="hid/.uno:DataSubTotals" xml-lang="en-US" id="bm_id3154515" localize="false"/>
+<paragraph role="heading" level="1" id="hd_id3153822" xml-lang="en-US">Subtotals</paragraph>
<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><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/12080100.xhp b/source/text/scalc/01/12080100.xhp
index 6935395716..0926ed921c 100644
--- a/source/text/scalc/01/12080100.xhp
+++ b/source/text/scalc/01/12080100.xhp
@@ -33,8 +33,9 @@
<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" localize="false"/><paragraph id="hd_id3155628" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12080100.xhp" name="Hide Details">Hide Details</link></paragraph>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3155628"><bookmark_value>sheets; hiding details</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:HideDetail" xml-lang="en-US" id="bm_id3149784" localize="false"/>
+<paragraph id="hd_id3155628" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12080100.xhp" name="Hide Details">Hide Details</link></paragraph>
<paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><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" role="paragraph" id="par_id3153252">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/12080400.xhp b/source/text/scalc/01/12080400.xhp
index 68340340af..92a4d8f50b 100644
--- a/source/text/scalc/01/12080400.xhp
+++ b/source/text/scalc/01/12080400.xhp
@@ -33,8 +33,8 @@
<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" localize="false"/><paragraph id="hd_id3148492" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/12080400.xhp" name="Ungroup">Ungroup</link></paragraph>
</section>
<paragraph role="paragraph" id="par_id3151384" xml-lang="en-US"><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 d887850fde..a290cc759a 100644
--- a/source/text/scalc/01/12080600.xhp
+++ b/source/text/scalc/01/12080600.xhp
@@ -33,8 +33,8 @@
<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" localize="false"/><paragraph id="hd_id3148947" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/12080600.xhp" name="Remove">Remove</link></paragraph>
<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><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/12090200.xhp b/source/text/scalc/01/12090200.xhp
index 65fba017ed..cad6469a32 100644
--- a/source/text/scalc/01/12090200.xhp
+++ b/source/text/scalc/01/12090200.xhp
@@ -31,7 +31,6 @@
</meta>
<body>
<section id="aktualisieren">
-<bookmark xml-lang="en-US" branch="hid/.uno:RecalcPivotTable" id="bm_id7263611" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:RecalcPivotTable" id="bm_id3145069" localize="false"/>
<paragraph role="heading" id="hd_id3151385" xml-lang="en-US" level="1"><link href="text/scalc/01/12090200.xhp" name="Refresh">Refresh</link></paragraph>
<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid=".uno:RecalcPivotTable">Updates the pivot table.</ahelp></paragraph>
diff --git a/source/text/scalc/01/12090300.xhp b/source/text/scalc/01/12090300.xhp
index 7ec8ad87be..771f49d31c 100644
--- a/source/text/scalc/01/12090300.xhp
+++ b/source/text/scalc/01/12090300.xhp
@@ -28,8 +28,8 @@
</meta>
<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" localize="false"/><paragraph id="hd_id3150276" role="heading" level="1" 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" xml-lang="en-US"><link href="text/scalc/01/12090300.xhp" name="Delete">Delete</link></paragraph>
<paragraph role="paragraph" id="par_id3159400" xml-lang="en-US"><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 f513fb9c15..d5a4332d0a 100644
--- a/source/text/scalc/01/12100000.xhp
+++ b/source/text/scalc/01/12100000.xhp
@@ -32,10 +32,11 @@
<body>
- <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" 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" xml-lang="en-US"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></paragraph>
- <paragraph role="paragraph" id="par_id3153088" xml-lang="en-US"><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>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:DataReImport" xml-lang="en-US" id="bm_id3153880" localize="false"/>
+<bookmark branch="hid/.uno:DataAreaRefresh" xml-lang="en-US" id="bm_id3149166" localize="false"/>
+<paragraph id="hd_id3153662" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12100000.xhp" name="Refresh Range">Refresh Range</link></paragraph>
+ <paragraph role="paragraph" id="par_id3153088" xml-lang="en-US"><variable id="aktualisieren"><ahelp hid=".">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"/>
</section>
diff --git a/source/text/scalc/01/12120000.xhp b/source/text/scalc/01/12120000.xhp
index 867fcfd4a8..1812b7bc57 100644
--- a/source/text/scalc/01/12120000.xhp
+++ b/source/text/scalc/01/12120000.xhp
@@ -30,7 +30,6 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:Validation" id="bm_id9039238" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:Validation" id="bm_id3153880" localize="false"/>
<paragraph role="heading" id="hd_id3156347" xml-lang="en-US" level="1">Validity</paragraph>
<paragraph role="paragraph" id="par_id3153252" xml-lang="en-US"><variable id="gueltigkeit"><ahelp hid=".uno:Validation">Defines what data is valid for a selected cell or cell range.</ahelp>
diff --git a/source/text/scalc/02/02130000.xhp b/source/text/scalc/02/02130000.xhp
index a034a204f1..3524906477 100644
--- a/source/text/scalc/02/02130000.xhp
+++ b/source/text/scalc/02/02130000.xhp
@@ -33,8 +33,8 @@
<section id="waehrung">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatCurrency" id="bm_id9668852" localize="false"/><!-- HID added by script -->
-<bookmark branch="hid/.uno:NumberFormatCurrency" xml-lang="en-US" id="bm_id3148701" localize="false"/><paragraph id="hd_id3152892" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/02/02130000.xhp" name="Number format: Currency">Number format: Currency</link></paragraph>
+<bookmark branch="hid/.uno:NumberFormatCurrency" xml-lang="en-US" id="bm_id3148701" localize="false"/>
+<paragraph id="hd_id3152892" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/02/02130000.xhp" name="Number format: Currency">Number format: Currency</link></paragraph>
<paragraph role="paragraph" id="par_id3148837" xml-lang="en-US"><ahelp hid=".uno:NumberFormatCurrency" visibility="visible">Applies the default currency format to the selected cells.</ahelp></paragraph>
</section>
<section id="sywaehrung">
diff --git a/source/text/scalc/02/02140000.xhp b/source/text/scalc/02/02140000.xhp
index 516f0cca4d..110c5e12fa 100644
--- a/source/text/scalc/02/02140000.xhp
+++ b/source/text/scalc/02/02140000.xhp
@@ -31,7 +31,6 @@
</meta>
<body>
<section id="prozent">
-<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id6598479" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatPercent" id="bm_id3153541" localize="false"/>
<paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1"><link href="text/scalc/02/02140000.xhp" name="Number format: Percent">Number format: Percent</link></paragraph>
<paragraph role="paragraph" id="par_id3155629" xml-lang="en-US"><ahelp hid=".uno:NumberFormatPercent">Applies the percentage format to the selected cells.</ahelp></paragraph>
diff --git a/source/text/scalc/02/02150000.xhp b/source/text/scalc/02/02150000.xhp
index 21b5d139c8..e492f43f3c 100644
--- a/source/text/scalc/02/02150000.xhp
+++ b/source/text/scalc/02/02150000.xhp
@@ -33,8 +33,8 @@
<section id="standard">
- <bookmark xml-lang="en-US" branch="hid/.uno:NumberFormatStandard" id="bm_id6331318" localize="false"/><!-- HID added by script -->
-<bookmark branch="hid/.uno:NumberFormatStandard" xml-lang="en-US" id="bm_id3152996" localize="false"/><paragraph id="hd_id3149182" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/02/02150000.xhp" name="Number format: Default">Number format: Default</link></paragraph>
+<bookmark branch="hid/.uno:NumberFormatStandard" xml-lang="en-US" id="bm_id3152996" localize="false"/>
+<paragraph id="hd_id3149182" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/02/02150000.xhp" name="Number format: Default">Number format: Default</link></paragraph>
<paragraph role="paragraph" id="par_id3163802" xml-lang="en-US"><ahelp hid=".uno:NumberFormatStandard" visibility="visible">Applies the default number format to the selected cells.</ahelp></paragraph>
</section>
<section id="systandard">
diff --git a/source/text/scalc/02/06080000.xhp b/source/text/scalc/02/06080000.xhp
index 109521fb7b..bbcde7fb64 100644
--- a/source/text/scalc/02/06080000.xhp
+++ b/source/text/scalc/02/06080000.xhp
@@ -30,7 +30,6 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id5786643" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id3147335" localize="false"/>
<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="1"><link href="text/scalc/02/06080000.xhp" name="Theme Selection">Theme Selection</link></paragraph>
<paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><variable id="thementext"><ahelp hid=".uno:ChooseDesign">Applies a formatting style to the selected cells.</ahelp>
diff --git a/source/text/scalc/02/18020000.xhp b/source/text/scalc/02/18020000.xhp
index c7c6f6f57f..2ae8b6ed86 100644
--- a/source/text/scalc/02/18020000.xhp
+++ b/source/text/scalc/02/18020000.xhp
@@ -33,7 +33,6 @@
<section id="zelleneinfuegen">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150275"><bookmark_value>inserting; cells, toolbar icon</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsCellsCtrl" id="bm_id3670488" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:InsCellsCtrl" id="bm_id3156329" localize="false"/>
<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1"><link href="text/scalc/02/18020000.xhp" name="Insert Cells">Insert Cells</link></paragraph>
<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><ahelp hid=".uno:InsCellsCtrl">Click the arrow next to the icon to open the <emph>Insert Cells </emph>toolbar, where you can insert cells, rows, and columns into the current sheet.</ahelp></paragraph>