summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2018-09-11 20:41:11 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-09-12 04:46:22 +0200
commit11d6a45b5a8d269d451988c40a9a16dd3728f57c (patch)
tree82b21df9ef7828ca1a712caa8df1f73b8d8d4928
parentca3fd055cb8ae1b9293c95dbb8fc1c1ea5f2fb15 (diff)
tdf#115254 Some branch bookmarks are'nt working 20
Module sc r-z Change-Id: Ib8ee034cdbaf2f42280fac787cc31279cab3dc8e Reviewed-on: https://gerrit.libreoffice.org/60362 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/05050300.xhp8
-rw-r--r--source/text/scalc/01/05070500.xhp1
-rw-r--r--source/text/scalc/01/06050000.xhp3
-rw-r--r--source/text/scalc/01/12020000.xhp3
-rw-r--r--source/text/scalc/01/12030100.xhp9
-rw-r--r--source/text/scalc/01/12030200.xhp3
-rw-r--r--source/text/scalc/01/12050100.xhp3
-rw-r--r--source/text/scalc/01/12050200.xhp4
-rw-r--r--source/text/scalc/01/12090100.xhp1
-rw-r--r--source/text/scalc/01/12090101.xhp1
-rw-r--r--source/text/scalc/01/12090102.xhp2
-rw-r--r--source/text/scalc/01/12120100.xhp3
-rw-r--r--source/text/scalc/01/12120200.xhp3
-rw-r--r--source/text/scalc/01/solver.xhp3
-rw-r--r--source/text/scalc/01/solver_options.xhp3
-rw-r--r--source/text/scalc/01/statistics.xhp11
-rw-r--r--source/text/scalc/01/xml_source.xhp1
-rw-r--r--source/text/shared/00/00000208.xhp1
-rw-r--r--source/text/shared/01/02230200.xhp1
-rw-r--r--source/text/shared/01/02230402.xhp4
-rw-r--r--source/text/shared/01/05340100.xhp9
-rw-r--r--source/text/shared/02/12090100.xhp2
-rw-r--r--source/text/shared/guide/collab.xhp3
-rw-r--r--source/text/shared/optionen/01060100.xhp1
-rw-r--r--source/text/shared/optionen/01060300.xhp3
25 files changed, 65 insertions, 21 deletions
diff --git a/source/text/scalc/01/05050300.xhp b/source/text/scalc/01/05050300.xhp
index 1af493cdf4..f0628b62b6 100644
--- a/source/text/scalc/01/05050300.xhp
+++ b/source/text/scalc/01/05050300.xhp
@@ -30,8 +30,8 @@
</history>
</meta>
<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 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>
@@ -39,7 +39,9 @@
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fotenb"/>
</section>
- <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>
+ <bookmark branch="hid/modules/scalc/ui/showsheetdialog/ShowSheetDialog" xml-lang="en-US" id="bm_id3149260" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/showsheetdialog/@@nowidget@@" 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/05070500.xhp b/source/text/scalc/01/05070500.xhp
index bb48f031e0..2a21451edb 100644
--- a/source/text/scalc/01/05070500.xhp
+++ b/source/text/scalc/01/05070500.xhp
@@ -31,6 +31,7 @@
<body>
<section id="tabelle">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/SheetPrintPage" id="bm_id3147335" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/@@nowidget@@" id="bm_id3147335" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150542"><bookmark_value>pages; order when printing</bookmark_value>
<bookmark_value>printing; page order</bookmark_value>
</bookmark><comment>mw deletes three "printing;..." entries and copies 4 index entries to Calc guide print_details.xhp</comment><paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1"><link href="text/scalc/01/05070500.xhp" name="Sheet">Sheet</link></paragraph>
diff --git a/source/text/scalc/01/06050000.xhp b/source/text/scalc/01/06050000.xhp
index a1a4a53e30..fd5b9366f2 100644
--- a/source/text/scalc/01/06050000.xhp
+++ b/source/text/scalc/01/06050000.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalc0106050000xml" indexer="include" status="PUBLISH">
@@ -32,6 +32,7 @@
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:ScenarioManager" id="bm_id3154490" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/ScenarioDialog" id="bm_id3145068" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/@@nowidget@@" id="bm_id3145068" localize="false"/>
<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="1">Create Scenario</paragraph>
<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US"><variable id="szenariotext"><ahelp hid=".">Defines a scenario for the selected sheet area.</ahelp>
</variable></paragraph>
diff --git a/source/text/scalc/01/12020000.xhp b/source/text/scalc/01/12020000.xhp
index d372d18b88..1e9241d7ef 100644
--- a/source/text/scalc/01/12020000.xhp
+++ b/source/text/scalc/01/12020000.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112020000xml" indexer="include" status="PUBLISH">
@@ -34,6 +34,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:SelectDB" id="bm_id2131630" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/SelectRangeDialog" id="bm_id3148946" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/@@nowidget@@" id="bm_id3148946" localize="false"/>
<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1">Select Database Range</paragraph>
<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp" name="Data - Define Range">Data - Define Range</link>.</ahelp>
</variable></paragraph>
diff --git a/source/text/scalc/01/12030100.xhp b/source/text/scalc/01/12030100.xhp
index ec7fa8aa9f..631186a918 100644
--- a/source/text/scalc/01/12030100.xhp
+++ b/source/text/scalc/01/12030100.xhp
@@ -32,14 +32,19 @@
<section id="sortierkriterien">
<bookmark xml-lang="en-US" branch="index" id="bm_id3152350"><bookmark_value>sorting; sort criteria for database ranges</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortcriteriapage/SortCriteriaPage" id="bm_id3156326" localize="false"/><paragraph role="heading" id="hd_id3152350" xml-lang="en-US" level="1"><link href="text/scalc/01/12030100.xhp" name="Sort Criteria">Sort Criteria</link></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortcriteriapage/SortCriteriaPage" id="bm_id3156326" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortcriteriapage/@@nowidget@@" id="bm_id3156326" localize="false"/>
+<paragraph role="heading" id="hd_id3152350" xml-lang="en-US" level="1"><link href="text/scalc/01/12030100.xhp" name="Sort Criteria">Sort Criteria</link></paragraph>
<paragraph role="paragraph" id="par_id3151385" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortcriteriapage/SortCriteriaPage">Specify the sorting options for the selected range.</ahelp></paragraph>
</section>
<paragraph role="note" id="par_id3152462" xml-lang="en-US">Ensure that you include any row and column titles in the selection.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnsosk"/>
</section>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/sortlb" id="bm_id3147434" localize="false"/><paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2">Sort by</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/@@nowidget@@" id="bm_id3147434" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/SortKeyFrame" id="bm_id3147434" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/sortlb" id="bm_id3147434" localize="false"/>
+<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2">Sort by</paragraph>
<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortkey/sortlb">Select the column that you want to use as the primary sort key.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortkey/up" id="bm_id3153142" localize="false"/><paragraph role="heading" id="hd_id3146121" xml-lang="en-US" level="3">Ascending</paragraph>
<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortkey/up">Sorts the selection from the lowest value to the highest value. The sorting rules are given by the locale. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language Settings - Languages.</paragraph>
diff --git a/source/text/scalc/01/12030200.xhp b/source/text/scalc/01/12030200.xhp
index 44b2051f07..084627fce5 100644
--- a/source/text/scalc/01/12030200.xhp
+++ b/source/text/scalc/01/12030200.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112030200xml" indexer="include" status="PUBLISH">
@@ -38,6 +38,7 @@
<bookmark_value>natural sort algorithm</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortoptionspage/SortOptionsPage" id="bm_id3151044" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortoptionspage/@@nowidget@@" id="bm_id3151044" localize="false"/>
<paragraph role="heading" id="hd_id3147228" xml-lang="en-US" level="1"><link href="text/scalc/01/12030200.xhp" name="Options"> Options</link></paragraph>
<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortoptionspage/SortOptionsPage"> Sets additional sorting options.</ahelp></paragraph>
</section>
diff --git a/source/text/scalc/01/12050100.xhp b/source/text/scalc/01/12050100.xhp
index 805c0abf9b..4c317808f9 100644
--- a/source/text/scalc/01/12050100.xhp
+++ b/source/text/scalc/01/12050100.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112050100xml" indexer="include" status="PUBLISH">
@@ -32,6 +32,7 @@
<body>
<section id="gruppe">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/subtotalgrppage/SubTotalGrpPage" id="bm_id3147335" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/subtotalgrppage/@@nowidget@@" id="bm_id3147335" localize="false"/>
<paragraph role="heading" id="hd_id3149784" xml-lang="en-US" level="1"><link href="text/scalc/01/12050100.xhp" name="1st, 2nd, 3rd Group">1st, 2nd, 3rd Group</link></paragraph>
<paragraph role="paragraph" id="par_id3145068" xml-lang="en-US"><ahelp hid="modules/scalc/ui/subtotalgrppage/SubTotalGrpPage">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp></paragraph>
</section>
diff --git a/source/text/scalc/01/12050200.xhp b/source/text/scalc/01/12050200.xhp
index 3c32c50416..75d9a7bc14 100644
--- a/source/text/scalc/01/12050200.xhp
+++ b/source/text/scalc/01/12050200.xhp
@@ -32,7 +32,9 @@
<section id="optionen">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154758"><bookmark_value>subtotals; sorting options</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/subtotaloptionspage/SubTotalOptionsPage" id="bm_id3150543" localize="false"/><paragraph role="heading" id="hd_id3154758" xml-lang="en-US" level="1"><link href="text/scalc/01/12050200.xhp" name="Options">Options</link></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/subtotaloptionspage/SubTotalOptionsPage" id="bm_id3150543" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/subtotaloptionspage/@@nowidget@@" id="bm_id3150543" localize="false"/>
+<paragraph role="heading" id="hd_id3154758" xml-lang="en-US" level="1"><link href="text/scalc/01/12050200.xhp" name="Options">Options</link></paragraph>
<paragraph role="paragraph" id="par_id3154124" xml-lang="en-US"><ahelp hid=".">Specify the settings for calculating and presenting subtotals.</ahelp></paragraph>
</section>
<section id="howtoget">
diff --git a/source/text/scalc/01/12090100.xhp b/source/text/scalc/01/12090100.xhp
index 4e489a534b..f13d6c779f 100644
--- a/source/text/scalc/01/12090100.xhp
+++ b/source/text/scalc/01/12090100.xhp
@@ -29,6 +29,7 @@
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:DataDataPilotRun" id="bm_id3153822" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/SelectSourceDialog" id="bm_id3153823" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/@@nowidget@@" id="bm_id3153823" localize="false"/>
<paragraph role="heading" id="hd_id3153663" xml-lang="en-US" level="1">Select Source</paragraph>
<section id="datenpilot">
<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><ahelp hid=".uno:DataDataPilotRun">Opens a dialog where you can select the source for your pivot table, and then create your table.</ahelp></paragraph>
diff --git a/source/text/scalc/01/12090101.xhp b/source/text/scalc/01/12090101.xhp
index d95a7c7677..734309ac46 100644
--- a/source/text/scalc/01/12090101.xhp
+++ b/source/text/scalc/01/12090101.xhp
@@ -33,6 +33,7 @@
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/SelectDataSourceDialog" id="bm_id3154685" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/@@nowidget@@" id="bm_id3154685" localize="false"/>
<paragraph role="heading" id="hd_id3143268" xml-lang="en-US" level="1">Select Data Source</paragraph>
<paragraph role="paragraph" id="par_id3148552" xml-lang="en-US">Select the database and the table or query containing the data that you want to use.</paragraph>
<section id="howtoget">
diff --git a/source/text/scalc/01/12090102.xhp b/source/text/scalc/01/12090102.xhp
index f7c574b1b6..afd5487b45 100644
--- a/source/text/scalc/01/12090102.xhp
+++ b/source/text/scalc/01/12090102.xhp
@@ -94,7 +94,9 @@
</listitem>
</list>
<paragraph xml-lang="en-US" id="par_idN108F1" role="paragraph">If you double-click a field which has adjacent fields at the same level, the <emph>Show Detail</emph> dialog opens:</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showdetaildialog/ShowDetails" id="bm_id9630726" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showdetaildialog/dimsTreeview" id="bm_id9630726" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showdetaildialog/@@nowidget@@" id="bm_id9630726" localize="false"/>
<paragraph xml-lang="en-US" id="par_idN10900" role="heading" level="2">Show Detail</paragraph>
<paragraph xml-lang="en-US" id="par_idN10904" role="paragraph"><ahelp hid=".">Choose the field that you want to view the details for.</ahelp></paragraph>
<section id="relatedtopics">
diff --git a/source/text/scalc/01/12120100.xhp b/source/text/scalc/01/12120100.xhp
index 77821390ae..94e9e1b9bc 100644
--- a/source/text/scalc/01/12120100.xhp
+++ b/source/text/scalc/01/12120100.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112120100xml" indexer="include" status="PUBLISH">
@@ -34,6 +34,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id1464278"><bookmark_value>selection lists;validity</bookmark_value>
</bookmark><comment>UFI added index entry for new list feature. Guide needed. MW changed index entry</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage" id="bm_id3145673" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/@@nowidget@@" id="bm_id3145673" localize="false"/>
<paragraph role="heading" id="hd_id3153032" xml-lang="en-US" level="1"><link href="text/scalc/01/12120100.xhp" name="Criteria">Criteria</link></paragraph>
<paragraph role="paragraph" id="par_id3156327" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage">Specify the validation rules for the selected cell(s).</ahelp></paragraph>
</section>
diff --git a/source/text/scalc/01/12120200.xhp b/source/text/scalc/01/12120200.xhp
index 8d2aa64c8c..681436bbc5 100644
--- a/source/text/scalc/01/12120200.xhp
+++ b/source/text/scalc/01/12120200.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112120200xml" indexer="include" status="PUBLISH">
@@ -32,6 +32,7 @@
<body>
<section id="eingabehilfe">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/ValidationHelpTabPage" id="bm_id3150871" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/@@nowidget@@" id="bm_id3150871" localize="false"/>
<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="1"><link href="text/scalc/01/12120200.xhp" name="Input Help">Input Help</link></paragraph>
<paragraph role="paragraph" id="par_id3147229" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationhelptabpage/ValidationHelpTabPage">Enter the message that you want to display when the cell or cell range is selected in the sheet.</ahelp></paragraph>
</section>
diff --git a/source/text/scalc/01/solver.xhp b/source/text/scalc/01/solver.xhp
index bb79ce7110..956f21211a 100644
--- a/source/text/scalc/01/solver.xhp
+++ b/source/text/scalc/01/solver.xhp
@@ -37,6 +37,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/SolverDialog" id="bm_id5634023" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/@@nowidget@@" id="bm_id5634023" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:SolverDialog" id="bm_id5634022" localize="false"/>
<paragraph id="hd_id9216284" role="heading" level="1" xml-lang="en-US"><variable id="solver"><link href="text/scalc/01/solver.xhp">Solver</link></variable></paragraph>
@@ -103,4 +104,4 @@ I hate such spec docs that leave so many questions</comment></paragraph><comment
<paragraph id="par_id5323953" role="note" xml-lang="en-US">The default solver engine supports only linear equations.</paragraph><comment>Add an example. A good one is at http://www.solver.com/stepbystep.htm but that is not OpenSource</comment>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/solver_options.xhp b/source/text/scalc/01/solver_options.xhp
index 6cf313a010..a350d7e6f0 100644
--- a/source/text/scalc/01/solver_options.xhp
+++ b/source/text/scalc/01/solver_options.xhp
@@ -28,6 +28,7 @@
<body>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/SolverOptionsDialog" id="bm_id7214271" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/@@nowidget@@" id="bm_id7214271" localize="false"/>
<paragraph id="hd_id2794274" role="heading" level="1" xml-lang="en-US">Options</paragraph>
<paragraph id="par_id6776940" role="paragraph" xml-lang="en-US">The Options dialog for the <link href="text/scalc/01/solver.xhp">Solver</link> is used to set some options.</paragraph>
@@ -51,4 +52,4 @@
<paragraph id="par_id9999694" role="paragraph" xml-lang="en-US">Click OK to accept the changes and to go back to the <link href="text/scalc/01/solver.xhp">Solver</link> dialog.</paragraph>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp
index b5255956e5..8ae7093d0f 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -35,6 +35,7 @@
<bookmark_value>Data statistics;sampling</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog" id="bm_id2745673" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/@@nowidget@@" id="bm_id2745673" localize="false"/>
<paragraph id="hd_id1000020" role="heading" xml-lang="en-US" level="2">Sampling</paragraph>
<paragraph id="par_id1000030" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data sampled from another table.</ahelp></paragraph>
<section id="howtoget">
@@ -247,6 +248,7 @@
<bookmark_value>Data statistics;descriptive statistics</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog" id="bm_id01002" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/@@nowidget@@" id="bm_id01002" localize="false"/>
<paragraph id="hd_id1000050" role="heading" xml-lang="en-US" level="2">Descriptive Statistics</paragraph>
<paragraph id="par_id1000640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp></paragraph>
<section id="howtoget">
@@ -463,6 +465,7 @@
<bookmark_value>Data statistics;ANOVA</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog" id="bm_id02002" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/@@nowidget@@" id="bm_id02002" localize="false"/>
<paragraph id="hd_id1000060" role="heading" xml-lang="en-US" level="2">Analysis of Variance (ANOVA)</paragraph>
<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces the analysis of variance (ANOVA) of a given data set</ahelp></paragraph>
<section id="howtoget">
@@ -697,6 +700,7 @@
<bookmark_value>Data statistics;correlation</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/CorrelationDialog" id="bm_id3145673" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/@@nowidget@@" id="bm_id3145673" localize="false"/>
<paragraph id="hd_id1000090" role="heading" xml-lang="en-US" level="2">Correlation</paragraph>
<paragraph id="par_id1001740" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp></paragraph>
<section id="howtoget">
@@ -771,6 +775,7 @@
<bookmark_value>Data statistics;covariance</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/CovarianceDialog" id="bm_id2945673" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/@@nowidget@@" id="bm_id2945673" localize="false"/>
<paragraph id="hd_id1000100" role="heading" xml-lang="en-US" level="2">Covariance</paragraph>
<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph>
<section id="howtoget">
@@ -843,6 +848,7 @@
<bookmark_value>Data statistics;exponential smoothing</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog" id="bm_id03002" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/@@nowidget@@" id="bm_id03002" localize="false"/>
<paragraph id="hd_id1000110" role="heading" xml-lang="en-US" level="2">Exponential Smoothing</paragraph>
<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp></paragraph>
<section id="howtoget">
@@ -998,6 +1004,7 @@
<bookmark_value>Data statistics;moving average</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/MovingAverageDialog" id="bm_id04002" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/@@nowidget@@" id="bm_id04002" localize="false"/>
<paragraph id="hd_id1000130" role="heading" xml-lang="en-US" level="2">Moving Average</paragraph>
<paragraph id="par_id1002500" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp></paragraph>
<section id="howtoget">
@@ -1132,6 +1139,7 @@
<bookmark_value>Data statistics;paired t-test</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="bm_id05002" localize="false"/>
<paragraph id="hd_id1000150" role="heading" xml-lang="en-US" level="2">Paired t-test</paragraph>
<paragraph id="par_id1002820" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the paired t-Test of two data samples.</ahelp></paragraph>
<section id="howtoget">
@@ -1318,6 +1326,7 @@
<bookmark_value>Data statistics;F-test</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05003" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="@@nowidget@@" localize="false"/>
<paragraph id="hd_id1000180" role="heading" xml-lang="en-US" level="2">F-test</paragraph>
<paragraph id="par_id1003240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the F-Test of two data samples.</ahelp></paragraph>
<section id="howtoget">
@@ -1486,6 +1495,7 @@
<bookmark_value>Data statistics;Z-test</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/ZTestDialog" id="bm_id05004" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/@@nowidget@@" id="bm_id05004" localize="false"/>
<paragraph id="hd_id1000210" role="heading" xml-lang="en-US" level="2">Z-test</paragraph>
<paragraph id="par_id1003640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ztestdialog/ZTestDialog">Calculates the z-Test of two data samples.</ahelp></paragraph>
<section id="howtoget">
@@ -1641,6 +1651,7 @@
<bookmark_value>Data statistics;Chi-square test</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog" id="bm_id05005" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/@@nowidget@@" id="bm_id05005" localize="false"/>
<paragraph id="hd_id1000240" role="heading" xml-lang="en-US" level="2">Chi-square test</paragraph>
<paragraph id="par_id1003641" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog">Calculates the Chi-square test of a data sample.</ahelp></paragraph>
<section id="howtoget">
diff --git a/source/text/scalc/01/xml_source.xhp b/source/text/scalc/01/xml_source.xhp
index e015a428cf..8acb8e9ff6 100644
--- a/source/text/scalc/01/xml_source.xhp
+++ b/source/text/scalc/01/xml_source.xhp
@@ -28,6 +28,7 @@
<body>
<section id="xml_source">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog" id="bm_id240920171033409926" localize="false"/>
+ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/xmlsourcedialog/@@nowidget@@" id="bm_id240920171033409926" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
<bookmark_value>XML Source;load XML data in spreadsheets</bookmark_value>
</bookmark>
diff --git a/source/text/shared/00/00000208.xhp b/source/text/shared/00/00000208.xhp
index e39fa68fcf..03bba9a8df 100644
--- a/source/text/shared/00/00000208.xhp
+++ b/source/text/shared/00/00000208.xhp
@@ -28,6 +28,7 @@
<body>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/TextImportCsvDialog" id="bm_id3148919" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/@@nowidget@@" id="bm_id3148919" localize="false"/>
<paragraph id="hd_id3150960" role="heading" level="1" xml-lang="en-US">Text Import</paragraph>
<paragraph id="par_id3149987" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/textimportcsv/TextImportCsvDialog">Sets the import options for delimited data.</ahelp></paragraph>
diff --git a/source/text/shared/01/02230200.xhp b/source/text/shared/01/02230200.xhp
index f430d30989..5787e30e00 100644
--- a/source/text/shared/01/02230200.xhp
+++ b/source/text/shared/01/02230200.xhp
@@ -34,6 +34,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:ShowTrackedChanges" id="bm_id9726954" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showchangesdialog/ShowChangesDialog" id="bm_id3154349" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showchangesdialog/@@nowidget@@" id="bm_id3154349" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:ShowChanges" id="bm_id3147240" localize="false"/>
<paragraph role="heading" id="hd_id3149988" xml-lang="en-US" level="1"><link href="text/shared/01/02230200.xhp" name="Show Changes">Show Changes</link></paragraph>
<paragraph role="paragraph" id="par_id3153323" xml-lang="en-US"><variable id="text"><ahelp hid=".">Shows or hides recorded changes.</ahelp>
diff --git a/source/text/shared/01/02230402.xhp b/source/text/shared/01/02230402.xhp
index a047e6a978..83d2440a92 100644
--- a/source/text/shared/01/02230402.xhp
+++ b/source/text/shared/01/02230402.xhp
@@ -82,7 +82,9 @@
</table>
</case>
</switch>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/simplerefdialog/SimpleRefDialog" id="bm_id3151044" localize="false"/><paragraph role="heading" id="hd_id3159149" xml-lang="en-US" level="3"><switchinline select="appl"><caseinline select="CALC">Shrink/Max</caseinline></switchinline></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/simplerefdialog/SimpleRefDialog" id="bm_id3151044" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/simplerefdialog/@@nowidget@@" id="bm_id3151044" localize="false"/>
+<paragraph role="heading" id="hd_id3159149" xml-lang="en-US" level="3"><switchinline select="appl"><caseinline select="CALC">Shrink/Max</caseinline></switchinline></paragraph>
<switch select="appl">
<case select="CALC"><table id="tbl_id3158407">
<tablerow>
diff --git a/source/text/shared/01/05340100.xhp b/source/text/shared/01/05340100.xhp
index 797ec81148..bfa85b7a04 100644
--- a/source/text/shared/01/05340100.xhp
+++ b/source/text/shared/01/05340100.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,8 +18,8 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
+
+
<meta>
<topic id="textshared0105340100xml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Row Height</title>
@@ -28,12 +28,13 @@
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/rowheightdialog/RowHeightDialog" id="bm_id8702934" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/rowheightdialog/@@nowidget@@" id="bm_id8702934" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:RowHeight" id="bm_id3150146" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_BROWSER_ROWHEIGHT" id="bm_id3149987" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154400" role="heading" level="1">Row Height</paragraph>
<paragraph xml-lang="en-US" id="par_id3154044" role="paragraph"><variable id="zeilenhoehetext"><ahelp hid="modules/scalc/ui/rowheightdialog/RowHeightDialog">Changes the height of the current row, or the selected rows.</ahelp>
</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3150756" role="paragraph"><switchinline select="appl"><caseinline select="CALC">You can also change the height of a row by dragging the divider below the row header. To fit the row height to the cell contents, double-click the divider.
+ <paragraph xml-lang="en-US" id="par_id3150756" role="paragraph"><switchinline select="appl"><caseinline select="CALC">You can also change the height of a row by dragging the divider below the row header. To fit the row height to the cell contents, double-click the divider.
</caseinline></switchinline></paragraph>
<section id="howtoget">
<embed href="text/shared/00/00040503.xhp#fozeihoe"/>
diff --git a/source/text/shared/02/12090100.xhp b/source/text/shared/02/12090100.xhp
index 38ad010f3a..48610adf81 100644
--- a/source/text/shared/02/12090100.xhp
+++ b/source/text/shared/02/12090100.xhp
@@ -29,7 +29,9 @@
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:DataFilterStandardFilter" id="bm_id9065823" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/StandardFilterDialog" id="bm_id3154232" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/@@nowidget@@" id="bm_id3154232" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/QueryFilterDialog" id="bm_id3155888" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/@@nowidget@@" id="bm_id3155888" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3151097" role="heading" level="1">Standard Filter</paragraph>
<paragraph xml-lang="en-US" id="par_id3149716" role="paragraph"><ahelp hid=".">Specifies the logical conditions to filter your table data.</ahelp> This dialog is available for spreadsheet documents, database tables and database forms. The dialog for databases does not contain the <emph>More Options</emph> button.</paragraph>
<section id="howtoget">
diff --git a/source/text/shared/guide/collab.xhp b/source/text/shared/guide/collab.xhp
index 22d675c4b2..8a1824aa5f 100644
--- a/source/text/shared/guide/collab.xhp
+++ b/source/text/shared/guide/collab.xhp
@@ -16,7 +16,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<meta>
<topic id="textsharedguidecollabxml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Collaboration</title>
@@ -34,6 +34,7 @@
<paragraph id="par_id5821710" role="paragraph" xml-lang="en-US">In %PRODUCTNAME Writer, Impress, and Draw, only one user at a time can open any document for writing. In Calc, many users can open the same spreadsheet for writing at the same time.</paragraph><comment>Tools - Share Document menu</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:ShareDocument" id="bm_id8779564" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sharedocumentdlg/ShareDocumentDialog" id="bm_id8779565" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sharedocumentdlg/@@nowidget@@" id="bm_id8779565" localize="false"/>
<paragraph id="par_id9590136" role="paragraph" xml-lang="en-US"><ahelp hid="." visibility="hidden">Opens the Share Document dialog where you can enable or disable collaborative sharing of the document.</ahelp></paragraph><comment>Share Document dialog - Share this spreadsheet with other users</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sharedocumentdlg/share" id="bm_id7900021" localize="false"/>
<paragraph id="par_id2519913" role="paragraph" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enable to share the current document with other users. Disable to use the document unshared. This will invalidate the not yet saved edits that other users applied in the time since you last opened or saved this document.</ahelp></paragraph>
diff --git a/source/text/shared/optionen/01060100.xhp b/source/text/shared/optionen/01060100.xhp
index 7314c8fee6..616f4184b1 100644
--- a/source/text/shared/optionen/01060100.xhp
+++ b/source/text/shared/optionen/01060100.xhp
@@ -55,6 +55,7 @@
<bookmark_value>outlines;outline symbols</bookmark_value>
</bookmark><comment>MW copied "displaying;comments" over to Calc guide note_insert.xhp and deleted "comments;displaying"</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/tpviewpage/TpViewPage" id="bm_id3157898" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/tpviewpage/@@nowidget@@" id="bm_id3157898" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3150445" role="heading" level="1"><link href="text/shared/optionen/01060100.xhp" name="View">View</link></paragraph>
<paragraph xml-lang="en-US" id="par_id3153988" role="paragraph"><ahelp hid="modules/scalc/ui/tpviewpage/TpViewPage">Defines which elements of the <item type="productname">%PRODUCTNAME</item> Calc main window are displayed. You can also show or hide highlighting of values in tables.</ahelp></paragraph>
</section>
diff --git a/source/text/shared/optionen/01060300.xhp b/source/text/shared/optionen/01060300.xhp
index fd206d3b2d..1ea1b52e69 100644
--- a/source/text/shared/optionen/01060300.xhp
+++ b/source/text/shared/optionen/01060300.xhp
@@ -41,6 +41,7 @@
<bookmark_value>row headers; highlighting (Calc)</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scgeneralpage/ScGeneralPage" id="bm_id3147211" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scgeneralpage/@@nowidget@@" id="bm_id3147211" localize="false"/>
<paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1"><link href="text/shared/optionen/01060300.xhp" name="General">General</link></paragraph>
<paragraph role="paragraph" id="par_id3156410" xml-lang="en-US">Defines general settings for spreadsheet documents.</paragraph>
</section>
@@ -61,7 +62,7 @@
<bookmark xml-lang="en-US" branch="hid/.uno:SetInputMode" id="bm_id3079317" localize="false"/><comment>see i53756</comment><paragraph role="heading" id="hd_id3154307" xml-lang="en-US" level="3">Press Enter to switch to edit mode</paragraph>
<paragraph role="paragraph" id="par_id3148943" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scgeneralpage/editmodecb">Allows you to immediately edit the selected cell after pressing the Enter key.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scgeneralpage/formatcb" id="bm_id3148946" localize="false"/><paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="3">Expand formatting</paragraph>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scgeneralpage/formatcb">Specifies whether to automatically apply the formatting attributes of the selected cell to the empty adjacent cells.</ahelp> If, for example, the contents of the selected cell have the bold attribute, this bold attribute will also apply to adjacent cells. Cells that already have a special format will not be modified by this function. You can see the range in question by pressing the <switchinline select="sys"><caseinline select="MAC">Command
+<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scgeneralpage/formatcb">Specifies whether to automatically apply the formatting attributes of the selected cell to the empty adjacent cells.</ahelp> If, for example, the contents of the selected cell have the bold attribute, this bold attribute will also apply to adjacent cells. Cells that already have a special format will not be modified by this function. You can see the range in question by pressing the <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + * (multiplication sign on the number pad) shortcut. This format also applies to all new values inserted within this range. The normal default settings apply to cells outside this range.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scgeneralpage/exprefcb" id="bm_id3145419" localize="false"/><paragraph role="heading" id="hd_id3148451" xml-lang="en-US" level="3">Expand references when new columns/rows are inserted</paragraph>
<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scgeneralpage/exprefcb">Specifies whether to expand references when inserting columns or rows adjacent to the reference range. This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction.</ahelp></paragraph>