AllLangHelp_scalc.mk | 1
source/text/scalc/00/00000404.xhp | 63 +++++++-
source/text/scalc/01/04070000.xhp | 19 +-
source/text/scalc/01/04070100.xhp | 109 +++++++-------
source/text/scalc/01/04070200.xhp | 2
source/text/scalc/01/04070300.xhp | 44 ++---
source/text/scalc/01/04070400.xhp | 48 +++---
source/text/scalc/01/ManageNames.xhp | 49 ++++++
source/text/scalc/main0116.xhp | 3
source/text/shared/00/00000001.xhp | 262 +++++++++++++++++------------------
10 files changed, 353 insertions(+), 247 deletions(-)
New commits:
commit 3a46c3ed3dac763cca328715a4aed82a35f4145f
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Dec 15 19:14:29 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Dec 16 00:35:04 2023 +0100
tdf#155876 UI cmds Calc-Sheet menu (32)
+ Sheet menu for Calc: manage Names
+ untangle manage names and define names
+ refactoring
Change-Id: I27fe448ae251cb98a829e92c307fc31ad3b2c967
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160845
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
(cherry picked from commit 2a305eedde1c9f9e1ba4af534688b4f83ea814d8)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160854
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 6fd3c5f682..8b630a5e2f 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -291,6 +291,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/JumpToNextTableSel \
helpcontent2/source/text/scalc/01/JumpToPrevTableSel \
helpcontent2/source/text/scalc/01/live_data_stream \
+ helpcontent2/source/text/scalc/01/ManageNames \
helpcontent2/source/text/scalc/01/MergeCellsMenu \
helpcontent2/source/text/scalc/01/NormalViewMode \
helpcontent2/source/text/scalc/01/recalculate_hard \
diff --git a/source/text/scalc/00/00000404.xhp
b/source/text/scalc/00/00000404.xhp
index 7473556970..52a29b8dc8 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -262,7 +262,12 @@
</variable></paragraph>
<paragraph role="paragraph" id="par_id3154059"><variable
id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose
<menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+
+<section id="names">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose
<menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id61702668060030">Choose <menuitem>Sheet
- Named Range or Expression</menuitem></paragraph>
+</section>
<section id="extlink">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -282,9 +287,50 @@
</table>
</section>
+<section id="manage_names">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id751702675082804">Choose
<menuitem>Sheet - Named Ranges and Expressions - Manage</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id301702675433245">Choose
<menuitem>Insert - Manage Names</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id601702675437816">Choose <menuitem>Data
- Manage Names</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id641702675445810">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Manage</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id551702675107129">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id661702675107130" role="paragraph"><image
src="cmd/lc_definename.svg" id="img_id561702675107131" width="1cm"
height="1cm"><alt id="alt_id721702675107132">Icon Manage
Names</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121702675107134" role="paragraph">Manage
Names</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id3149385"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
+ F3</paragraph>
+ <h3 id="hd_id201702761733377">Other</h3>
+ <paragraph role="paragraph" id="par_id521702676756048">On the drop-down list
in the <link href="text/scalc/02/06010000.xhp"><emph>Name Box</emph></link> of
the <emph>Formula Bar</emph>, select <menuitem>Manage
Names</menuitem>.</paragraph>
+</section>
+
<section id="define_name">
-<paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet - Named
Ranges and Expressions - Define</menuitem>.</paragraph>
-<paragraph role="paragraph" id="par_id3149385"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet -
Named Ranges and Expressions - Define</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id801702661547552">Choose
<menuitem>Insert - Define Name</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id601702661988059">Choose <menuitem>Data
- Define Name</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id811702661629800">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Define</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id11702662103998">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id871702662103999" role="paragraph"><image
src="cmd/lc_label.svg" id="img_id321702662104000" width="1cm"
height="1cm"><alt id="alt_id281702662104001">Icon Define
Name</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id621702662104003" role="paragraph">Define
Name</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <h3 id="hd_id201702661733377">Other</h3>
+ <paragraph role="paragraph" id="par_id321702661807915">On the <link
href="text/scalc/02/06010000.xhp"><emph>Name Box</emph></link> of the
<emph>Formula Bar</emph>, insert a name for the selected cells range and press
<keycode>Enter</keycode>.</paragraph>
</section>
<section id="insertnames">
@@ -295,7 +341,14 @@
<paragraph role="paragraph" id="par_id21698845324130">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Named Ranges and Expressions</menuitem>.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3153558"><variable id="einaueb">Choose
<menuitem>Sheet - Named Ranges and Expressions -
Create</menuitem>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153483"><variable id="einabesch">Choose
<menuitem>Sheet - Named Ranges and Expressions -
Labels</menuitem>.</variable></paragraph>
+<section id="create_names">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153558"><variable id="einaueb">Choose
<menuitem>Sheet - Named Ranges and Expressions -
Create</menuitem>.</variable></paragraph>
+</section>
+
+<section id="define_label_range">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153483"><variable
id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions -
Labels</menuitem>.</variable></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/04070000.xhp
b/source/text/scalc/01/04070000.xhp
index af57b50a4d..fc9c04a2e4 100644
--- a/source/text/scalc/01/04070000.xhp
+++ b/source/text/scalc/01/04070000.xhp
@@ -27,21 +27,20 @@
</history>
</meta>
<body>
-<section id="namen">
<bookmark branch="hid/.uno:NamesMenu" id="bm_id2043214" localize="false"/>
+<section id="namen">
<h1 id="hd_id3153951"><link href="text/scalc/01/04070000.xhp">Named Ranges and
Expressions</link></h1>
<paragraph role="paragraph" id="par_id3145801"><ahelp hid=".">Allows you to
name the different sections of your spreadsheet document.</ahelp> By naming the
different sections, you can easily <link
href="text/scalc/01/02110000.xhp">navigate</link> through the spreadsheet
documents and find specific information.</paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000404.xhp#einamen"/>
+ <embed href="text/scalc/00/00000404.xhp#names"/>
</section>
-<h2 id="hd_id3153878"><link
href="text/scalc/01/04070100.xhp">Define</link></h2>
-<embed href="text/scalc/01/04070100.xhp#namenfestlegentext"/>
-<h2 id="hd_id3146969"><link
href="text/scalc/01/04070200.xhp">Insert</link></h2>
-<embed href="text/scalc/01/04070200.xhp#nameneinfuegentext"/>
-<h2 id="hd_id3155764"><link href="text/scalc/01/04070300.xhp">Apply</link></h2>
-<embed href="text/scalc/01/04070300.xhp#namenuebernehmentext"/>
-<h2 id="hd_id3156382"><link
href="text/scalc/01/04070400.xhp">Labels</link></h2>
-<embed href="text/scalc/01/04070400.xhp#beschtext"/>
+
+<embed href="text/scalc/01/04070100.xhp#definenames"/>
+<embed href="text/scalc/01/ManageNames.xhp#manage_names"/>
+<embed href="text/scalc/01/04070200.xhp#insertname"/>
+<embed href="text/scalc/01/04070300.xhp#create_names"/>
+<embed href="text/scalc/01/04070400.xhp#define_label_range"/>
+
</body>
</helpdocument>
diff --git a/source/text/scalc/01/04070100.xhp
b/source/text/scalc/01/04070100.xhp
index 03db97a285..5d03d25b26 100644
--- a/source/text/scalc/01/04070100.xhp
+++ b/source/text/scalc/01/04070100.xhp
@@ -22,66 +22,67 @@
<meta>
<topic id="textscalc0104070100xml" indexer="include">
-<title id="tit" xml-lang="en-US">Define Names</title>
+<title id="tit">Define Names</title>
<filename>/text/scalc/01/04070100.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:DefineName" id="bm_id4757802"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/definename/DefineNameDialog" id="bm_id3155922"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/definename/@@nowidget@@" id="bm_id3155922"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog"
id="bm_id3155923" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@" id="bm_id3155923"
localize="false"/>
-<h1 id="hd_id3156330">Define Names</h1>
-<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><variable
id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you
can specify a name for a selected area or a name for a formula
expression.</ahelp>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US">Use the mouse
to define ranges or type the reference into the <emph>Define Name </emph>dialog
fields.</paragraph>
+<bookmark branch="hid/.uno:AddName" id="bm_id721702666245648"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definename/DefineNameDialog"
id="bm_id3155922" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definename/@@nowidget@@"
id="bm_id3155922" localize="false"/>
+
+<section id="definenames">
+ <h1 id="hd_id3156330"><link href="text/scalc/01/04070100.xhp">Define
Names</link></h1>
+ <paragraph role="paragraph" id="par_id3154366"><variable
id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you
can specify a name for a selected area or a name for a formula
expression.</ahelp></variable></paragraph>
+</section>
+
+<paragraph role="paragraph" id="par_id3154123">Use the mouse to define ranges
or type the reference into the <emph>Define Name </emph>dialog
fields.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#define_name"/>
</section>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">The
<emph>Sheet Area</emph> box on the Formula bar contains a list of defined names
for the ranges or formula expressions and their scope between parenthesis.
Click a name from this box to highlight the corresponding reference on the
spreadsheet. Names given formulas or parts of a formula are not listed
here.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/edit"
id="bm_id3151114" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115"
localize="false"/>
-<h2 id="hd_id3151118">Name</h2>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp
hid=".">Enter the name of the area for which you want to define a reference or
a formula expression.</ahelp> All area names already defined in the spreadsheet
are listed in the text field above. If you click a name on the list, the
corresponding reference in the document will be shown with a blue frame. If
multiple cell ranges belong to the same area name, they are displayed with
different colored frames.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/range"
id="bm_id3145750" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751"
localize="false"/>
-<h2 id="hd_id3153728">Range or formula expression</h2>
-<paragraph role="paragraph" id="par_id3147435" xml-lang="en-US"><ahelp
hid=".">The reference of the selected area name is shown here as an absolute
value.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3146986" xml-lang="en-US">To insert a
new area reference, place the cursor in this field and use your mouse to select
the desired area in any sheet of your spreadsheet document. To insert a new
named formula, type the formula expression.</paragraph>
-<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/scope"
id="bm_id3148455" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456"
localize="false"/>
-<h2 id="hd_id31547290">Scope</h2>
-<paragraph role="paragraph" id="hd_id31547291" xml-lang="en-US"
level="2"><ahelp hid=".">Select the scope of the named range or named formula.
Document (Global) means the name is valid for the whole document.</ahelp> Any
other sheet name selected will restrict the scope of the named range or formula
expression to that sheet. </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/more"
id="bm_id3148457" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458"
localize="false"/>
-<h2 id="hd_id3154729">Range options</h2>
-<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US"><ahelp
hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the
reference.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3155416" xml-lang="en-US">Defines
additional options related to the type of reference area.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/printarea"
id="bm_id3146972" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973"
localize="false"/>
-<h4 id="hd_id3150716">Print range</h4>
-<paragraph role="paragraph" id="par_id3150751" xml-lang="en-US"><ahelp
hid=".">Defines the area as a print range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/filter"
id="bm_id3155446" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447"
localize="false"/>
-<h4 id="hd_id3153764">Filter</h4>
-<paragraph role="paragraph" id="par_id3155766" xml-lang="en-US"><ahelp
hid=".">Defines the selected area to be used in an <link
href="text/scalc/01/12040300.xhp">advanced filter</link>.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/colheader"
id="bm_id3147344" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345"
localize="false"/>
-<h4 id="hd_id3159267">Repeat column</h4>
-<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US"><ahelp
hid=".">Defines the area as a repeating column.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/rowheader"
id="bm_id3154021" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022"
localize="false"/>
-<h4 id="hd_id3153966">Repeat row</h4>
-<paragraph role="paragraph" id="par_id3150300" xml-lang="en-US"><ahelp
hid=".">Defines the area as a repeating row.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/add"
id="bm_id3150207" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/add"
id="bm_id3150208" localize="false"/>
-<h2 id="hd_id3155112">Add</h2>
-<paragraph role="paragraph" id="par_id3159236" xml-lang="en-US"><ahelp
hid=".">Click the <emph>Add</emph> button to add a new defined
name.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209"
localize="false"/>
-<embed href="text/shared/00/00000001.xhp#delete"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/names" id="bm_id3150210"
localize="false"/>
-<paragraph role="paragraph" id="par_id3150301" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/managenamesdialog/names" visibility="hidden">Select a
named range or named formula from the list to modify its
properties.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155131">The <emph>Sheet Area</emph> box
on the Formula bar contains a list of defined names for the ranges or formula
expressions and their scope between parenthesis. Click a name from this box to
highlight the corresponding reference on the spreadsheet. Names given formulas
or parts of a formula are not listed here.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114"
localize="false"/>
+<section id="h2name">
+ <h2 id="hd_id3151118">Name</h2>
+ <paragraph role="paragraph" id="par_id3163712"><ahelp hid=".">Enter the
name of the area for which you want to define a reference or a formula
expression.</ahelp> All area names already defined in the spreadsheet are
listed in the text field above. If you click a name on the list, the
corresponding reference in the document will be shown with a blue frame. If
multiple cell ranges belong to the same area name, they are displayed with
different colored frames.</paragraph>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750"
localize="false"/>
+<section id="h2range">
+ <h2 id="hd_id3153728">Range or formula expression</h2>
+ <paragraph role="paragraph" id="par_id3147435"><ahelp hid=".">The
reference of the selected area name is shown here as an absolute
value.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3146986">To insert a new area
reference, place the cursor in this field and use your mouse to select the
desired area in any sheet of your spreadsheet document. To insert a new named
formula, type the formula expression.</paragraph>
+ <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455"
localize="false"/>
+<section id="h2scope">
+ <h2 id="hd_id31547290">Scope</h2>
+ <paragraph role="paragraph" id="hd_id31547291"><ahelp hid=".">Select the
scope of the named range or named formula. Document (Global) means the name is
valid for the whole document.</ahelp> Any other sheet name selected will
restrict the scope of the named range or formula expression to that sheet.
</paragraph>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457"
localize="false"/>
+
+<section id="h2options">
+ <h2 id="hd_id3154729">Range options</h2>
+ <paragraph role="paragraph" id="par_id3149958"><ahelp hid=".">Allows you
to specify the <emph>Area type</emph> (optional) for the
reference.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3155416">Defines additional options
related to the type of reference area.</paragraph>
+ <bookmark branch="hid/modules/scalc/ui/definename/printarea"
id="bm_id3146972" localize="false"/>
+ <h3 id="hd_id3150716">Print range</h3>
+ <paragraph role="paragraph" id="par_id3150751"><ahelp hid=".">Defines the
area as a print range.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/definename/filter"
id="bm_id3155446" localize="false"/>
+ <h3 id="hd_id3153764">Filter</h3>
+ <paragraph role="paragraph" id="par_id3155766"><ahelp hid=".">Defines the
selected area to be used in an <link href="text/scalc/01/12040300.xhp">advanced
filter</link>.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/definename/colheader"
id="bm_id3147344" localize="false"/>
+ <h3 id="hd_id3159267">Repeat column</h3>
+ <paragraph role="paragraph" id="par_id3149565"><ahelp hid=".">Defines the
area as a repeating column.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/definename/rowheader"
id="bm_id3154021" localize="false"/>
+ <h3 id="hd_id3153966">Repeat row</h3>
+ <paragraph role="paragraph" id="par_id3150300"><ahelp hid=".">Defines the
area as a repeating row.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207"
localize="false"/>
+ <h2 id="hd_id3155112">Add</h2>
+ <paragraph role="paragraph" id="par_id3159236"><ahelp hid=".">Click the
<emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
+</section>
+
</body>
</helpdocument>
diff --git a/source/text/scalc/01/04070200.xhp
b/source/text/scalc/01/04070200.xhp
index d634bae21a..761a9c5ed9 100644
--- a/source/text/scalc/01/04070200.xhp
+++ b/source/text/scalc/01/04070200.xhp
@@ -35,7 +35,7 @@
<bookmark branch="hid/modules/scalc/ui/insertname/@@nowidget@@"
id="bm_id3154910" localize="false"/>
<section id="insertname">
- <h1 id="hd_id3153195"><variable id="h1"><link
href="text/scalc/01/04070200.xhp">Named Range or
Expression</link></variable></h1>
+ <h1 id="hd_id3153195"><variable id="h1"><link
href="text/scalc/01/04070200.xhp">Insert Name</link></variable></h1>
<paragraph role="paragraph" id="par_id3150011"><variable
id="nameneinfuegentext"><ahelp hid=".uno:InsertName">Inserts a defined named
cell range at the current cursor's position with the <emph>Paste Names</emph>
dialog.</ahelp></variable></paragraph>
</section>
<note id="par_id3149412">You can only insert a cell area after having defined
a name for the area.</note>
diff --git a/source/text/scalc/01/04070300.xhp
b/source/text/scalc/01/04070300.xhp
index 76fa81909f..95ddb6c055 100644
--- a/source/text/scalc/01/04070300.xhp
+++ b/source/text/scalc/01/04070300.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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="textscalc0104070300xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Creating Names</title>
+<title id="tit">Creating Names</title>
<filename>/text/scalc/01/04070300.xhp</filename>
</topic>
<history>
@@ -30,32 +27,35 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3147264"><bookmark_value>cell ranges;creating names
automatically</bookmark_value>
+<bookmark branch="index" id="bm_id3147264"><bookmark_value>cell
ranges;creating names automatically</bookmark_value>
<bookmark_value>names; for cell ranges</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:CreateNames" id="bm_id8912439"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog"
id="bm_id3150398" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@" id="bm_id3150398"
localize="false"/>
-<h1 id="hd_id3147264">Creating Names</h1>
-<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><variable
id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to
automatically name multiple cell ranges.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:CreateNames" id="bm_id8912439" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog"
id="bm_id3150398" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@"
id="bm_id3150398" localize="false"/>
+
+<section id="create_names">
+ <h1 id="hd_id3147264"><link href="text/scalc/01/04070300.xhp">Create
Names</link></h1>
+<paragraph role="paragraph" id="par_id3153969"><variable
id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to
automatically name multiple cell ranges.</ahelp></variable></paragraph>
+</section>
+
<section id="howtoget">
- <embed href="text/scalc/00/00000404.xhp#einaueb"/>
+ <embed href="text/scalc/00/00000404.xhp#create_names"/>
</section>
-<paragraph role="paragraph" id="par_id3156280" xml-lang="en-US">Select the
area containing all the ranges that you want to name. Then choose <emph>Sheet -
Named Ranges and Expressions - Create</emph>. This opens the <emph>Create
Names</emph> dialog, from which you can select the naming options that you
want.</paragraph>
+<paragraph role="paragraph" id="par_id3156280">Select the area containing all
the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and
Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog,
from which you can select the naming options that you want.</paragraph>
<h2 id="hd_id3151116">Create names from</h2>
-<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US">Defines which
part of the spreadsheet is to be used for creating the name.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/top"
id="bm_id3156444" localize="false"/>
+<paragraph role="paragraph" id="par_id3152597">Defines which part of the
spreadsheet is to be used for creating the name.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/top"
id="bm_id3156444" localize="false"/>
<h3 id="hd_id3153729">Top row</h3>
-<paragraph role="paragraph" id="par_id3149263" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the
header row of the selected range.</ahelp> Each column receives a separated name
and cell reference.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/createnamesdialog/left" id="bm_id3145749"
localize="false"/>
+<paragraph role="paragraph" id="par_id3149263"><ahelp
hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the
header row of the selected range.</ahelp> Each column receives a separated name
and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/left"
id="bm_id3145749" localize="false"/>
<h3 id="hd_id3146984">Left Column</h3>
-<paragraph role="paragraph" id="par_id3153190" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the
entries in the first column of the selected sheet range.</ahelp> Each row
receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/createnamesdialog/bottom" id="bm_id3145645"
localize="false"/>
+<paragraph role="paragraph" id="par_id3153190"><ahelp
hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the
entries in the first column of the selected sheet range.</ahelp> Each row
receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/bottom"
id="bm_id3145645" localize="false"/>
<h3 id="hd_id3156284">Bottom row</h3>
-<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from
the entries in the last row of the selected sheet range.</ahelp> Each column
receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/createnamesdialog/right" id="bm_id3145253"
localize="false"/>
+<paragraph role="paragraph" id="par_id3147124"><ahelp
hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from
the entries in the last row of the selected sheet range.</ahelp> Each column
receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/right"
id="bm_id3145253" localize="false"/>
<h3 id="hd_id3154731">Right Column</h3>
-<paragraph role="paragraph" id="par_id3153158" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the
entries in the last column of the selected sheet range.</ahelp> Each row
receives a separated name and cell reference.</paragraph>
+<paragraph role="paragraph" id="par_id3153158"><ahelp
hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the
entries in the last column of the selected sheet range.</ahelp> Each row
receives a separated name and cell reference.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/04070400.xhp
b/source/text/scalc/01/04070400.xhp
index 6ed548c49d..60fef5b4a8 100644
--- a/source/text/scalc/01/04070400.xhp
+++ b/source/text/scalc/01/04070400.xhp
@@ -22,45 +22,47 @@
<meta>
<topic id="textscalc0104070400xml" indexer="include">
-<title id="tit" xml-lang="en-US">Define Label Range</title>
+<title id="tit">Define Label Range</title>
<filename>/text/scalc/01/04070400.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150791"><bookmark_value>sheets; defining label ranges</bookmark_value>
+<bookmark branch="index" id="bm_id3150791"><bookmark_value>sheets; defining
label ranges</bookmark_value>
<bookmark_value>label ranges in sheets</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:DefineLabelRange"
id="bm_id9319643" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/NameRangesDialog"
id="bm_id3150447" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@" id="bm_id3150447"
localize="false"/>
-<paragraph role="heading" id="hd_id3150791" xml-lang="en-US"
level="1"><variable id="define_label_range"><link
href="text/scalc/01/04070400.xhp">Define Label Range</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150868" xml-lang="en-US"><variable
id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you
can define a label range.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:DefineLabelRange" id="bm_id9319643"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/NameRangesDialog"
id="bm_id3150447" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@"
id="bm_id3150447" localize="false"/>
+
+<section id="define_label_range">
+ <h1 id="hd_id3150791"><link href="text/scalc/01/04070400.xhp">Define Label
Range</link></h1>
+ <paragraph role="paragraph" id="par_id3150868"><variable
id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you
can define a label range.</ahelp></variable></paragraph>
+</section>
+
<section id="howtoget">
-<embed href="text/scalc/00/00000404.xhp#einabesch"/>
+<embed href="text/scalc/00/00000404.xhp#define_label_range"/>
</section>
<embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
-<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US">The cell
contents of a label range can be used like names in formulas - $[officename]
recognizes these names in the same manner that it does the predefined names of
the weekdays and months. These names are automatically completed when typed
into a formula. In addition, the names defined by label ranges will have
priority over names defined by automatically generated ranges.</paragraph>
-<paragraph role="note" id="par_id3147435" xml-lang="en-US">You can set label
ranges that contain the same labels on different sheets. $[officename] first
searches the label ranges of the current sheet and, following a failed search,
the ranges of other sheets.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/range" id="bm_id3149958"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/edassign" id="bm_id3148457"
localize="false"/>
+<paragraph role="paragraph" id="par_id3155411">The cell contents of a label
range can be used like names in formulas - $[officename] recognizes these names
in the same manner that it does the predefined names of the weekdays and
months. These names are automatically completed when typed into a formula. In
addition, the names defined by label ranges will have priority over names
defined by automatically generated ranges.</paragraph>
+<note id="par_id3147435">You can set label ranges that contain the same labels
on different sheets. $[officename] first searches the label ranges of the
current sheet and, following a failed search, the ranges of other sheets.</note>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/range"
id="bm_id3149958" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/edassign"
id="bm_id3148457" localize="false"/>
<h2 id="hd_id3145801">Range</h2>
-<paragraph role="paragraph" id="par_id3154731" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of
each label range.</ahelp> In order to remove a label range from the list box,
select it and then click <emph>Delete</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3154731"><ahelp
hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of
each label range.</ahelp> In order to remove a label range from the list box,
select it and then click <emph>Delete</emph>.</paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/colhead" id="bm_id3155064"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/colhead"
id="bm_id3155064" localize="false"/>
<h3 id="hd_id3149121">Contains column labels</h3>
-<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the
current label range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/rowhead" id="bm_id3145642"
localize="false"/>
+<paragraph role="paragraph" id="par_id3150330"><ahelp
hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the
current label range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rowhead"
id="bm_id3145642" localize="false"/>
<h3 id="hd_id3149020">Contains row labels</h3>
-<paragraph role="paragraph" id="par_id3154754" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the
current label range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/edassign2" id="bm_id3146919"
localize="false"/>
+<paragraph role="paragraph" id="par_id3154754"><ahelp
hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the
current label range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/edassign2"
id="bm_id3146919" localize="false"/>
<h3 id="hd_id3159264">For data range</h3>
-<paragraph role="paragraph" id="par_id3154703" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which
the selected label range is valid. To modify it, click in the sheet and select
another range with the mouse.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154703"><ahelp
hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which
the selected label range is valid. To modify it, click in the sheet and select
another range with the mouse.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/add"
id="bm_id3150299" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/add" id="bm_id3150299"
localize="false"/>
<h2 id="hd_id3145789">Add</h2>
-<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the
list.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147005"><ahelp
hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the
list.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#delete"/>
<section id="relatedtopics">
<embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
diff --git a/source/text/scalc/01/ManageNames.xhp
b/source/text/scalc/01/ManageNames.xhp
new file mode 100644
index 0000000000..c2b14007d0
--- /dev/null
+++ b/source/text/scalc/01/ManageNames.xhp
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textscalc01ManageNamesxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Manage Names</title>
+ <filename>/text/scalc/01/ManageNames.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark
branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog"
id="bm_id3155923" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@"
id="bm_id3155923" localize="false"/>
+ <bookmark branch="hid/.uno:DefineName" id="bm_id4757802" localize="false"/>
+ <section id="manage_names">
+ <h1 id="hd_id511702671562154"><variable id="h1"><link
href="text/scalc/01/ManageNames.xhp">Manage Names</link></variable></h1>
+ <paragraph id="par_id971702671562156" role="paragraph">Opens a dialog
where you can manage names in the spreadsheet.</paragraph>
+ </section>
+
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000404.xhp#manage_names"/>
+ </section>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/names"
id="bm_id3150210" localize="false"/>
+ <h2 id="hd_id421702675891023">Names area</h2>
+ <paragraph role="paragraph" id="par_id3150301"><ahelp
hid="modules/scalc/ui/managenamesdialog/names">Select a named range or named
formula from the list to modify its properties.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/name"
id="bm_id3151115" localize="false"/>
+ <embed href="text/scalc/01/04070100.xhp#h2name"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/range"
id="bm_id3145751" localize="false"/>
+ <embed href="text/scalc/01/04070100.xhp#h2range"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/scope"
id="bm_id3148456" localize="false"/>
+ <embed href="text/scalc/01/04070100.xhp#h2scope"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/more"
id="bm_id3148458" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/printrange"
id="bm_id3146973" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/filter"
id="bm_id3155447" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/colheader"
id="bm_id3147345" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/rowheader"
id="bm_id3154022" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/add"
id="bm_id3150208" localize="false"/>
+ <embed href="text/scalc/01/04070100.xhp#h2options"/>
+ <bookmark branch="hid/modules/scalc/ui/managenamesdialog/delete"
id="bm_id3150209" localize="false"/>
+ <embed href="text/shared/00/00000001.xhp#delete"/>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index 9e525c979e..4afdc0506d 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -49,10 +49,11 @@
<embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
<embed href="text/scalc/01/04090000.xhp#extdata"/>
<embed href="text/scalc/01/02170000.xhp#deletesheet"/>
+<embed href="text/scalc/01/02150000.xhp#del_contents"/>
<embed href="text/scalc/01/ToggleRelative.xhp#cycle_types"/>
<embed href="text/scalc/01/02140000.xhp#fill"/>
+<embed href="text/scalc/01/04070000.xhp#namen"/>
-<embed href="text/scalc/01/02150000.xhp#del_contents"/>
<h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp">Move or Copy
Sheet</link></h2>
<embed href="text/scalc/01/02180000.xhp#tabelleverschiebenkopierentext"/>
diff --git a/source/text/shared/00/00000001.xhp
b/source/text/shared/00/00000001.xhp
index caac6a48fa..b1f508f692 100644
--- a/source/text/shared/00/00000001.xhp
+++ b/source/text/shared/00/00000001.xhp
@@ -20,223 +20,223 @@
<meta>
<topic id="textshared0000000001xml" indexer="exclude">
- <title xml-lang="en-US" id="tit">Frequently-Used Buttons</title>
+ <title id="tit">Frequently-Used Buttons</title>
<filename>/text/shared/00/00000001.xhp</filename>
</topic>
</meta>
<body>
<h1 id="hd_id3152952">Frequently-Used Buttons</h1>
<section id="help">
- <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_HELP"
id="bm_id911668777580235" localize="false"/>
+ <bookmark branch="hid/DBACCESS_HID_DBWIZ_HELP" id="bm_id911668777580235"
localize="false"/>
<h2 id="hd_id211668777619062">Help</h2>
<paragraph role="paragraph" id="par_id761668777629023">Click the
<menuitem>Help</menuitem> button to open the help page associated with the
currently open dialog.</paragraph>
</section>
<section id="cancel">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDCANCEL"
id="bm_id4245124" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_CANCEL"
id="bm_id7074800" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_0_CMDCANCEL"
id="bm_id3147653" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_FAXWIZARD_CANCEL"
id="bm_id833765" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_CANCEL" id="bm_id7899105"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_CANCEL"
id="bm_id3149183" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDCANCEL"
id="bm_id3149177" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGREPORT_0_CMDCANCEL"
id="bm_id3154142" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_CANCEL"
id="bm_id3145416" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_CANCEL"
id="bm_id1058076" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDCANCEL" id="bm_id4245124"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_CANCEL" id="bm_id7074800"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGIMPORT_0_CMDCANCEL" id="bm_id3147653"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_FAXWIZARD_CANCEL" id="bm_id833765"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID0_CANCEL" id="bm_id7899105" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_GROUPWIZARD_CANCEL" id="bm_id3149183"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDCANCEL" id="bm_id3149177"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGREPORT_0_CMDCANCEL" id="bm_id3154142"
localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_LISTWIZARD_CANCEL" id="bm_id3145416"
localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_CANCEL" id="bm_id1058076"
localize="false"/>
<h2 id="hd_id3147617">Cancel</h2>
- <paragraph xml-lang="en-US" id="par_id3155913" role="paragraph"><ahelp
hid=".">Clicking <emph>Cancel</emph> closes a dialog without saving any changes
made.</ahelp></paragraph>
+ <paragraph id="par_id3155913" role="paragraph"><ahelp hid=".">Clicking
<emph>Cancel</emph> closes a dialog without saving any changes
made.</ahelp></paragraph>
</section>
<section id="finish">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDFINISH"
id="bm_id3211157" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_CREATE"
id="bm_id189519" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_FINISH"
id="bm_id1058076" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDFINISH" id="bm_id3211157"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_CREATE" id="bm_id189519"
localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_FINISH" id="bm_id1058076"
localize="false"/>
<h2 id="hd_id2341685">Finish</h2>
- <paragraph xml-lang="en-US" id="par_id6909390" role="paragraph"><ahelp
hid=".">Applies all changes and closes the wizard.</ahelp></paragraph>
+ <paragraph id="par_id6909390" role="paragraph"><ahelp hid=".">Applies all
changes and closes the wizard.</ahelp></paragraph>
</section>
<section id="toolbars">
<h2 id="hd_id3147477">Toolbars</h2>
- <paragraph xml-lang="en-US" id="par_id3149783" role="paragraph">By clicking
the arrow next to some icons you open a toolbar. To move a toolbar, drag the
title bar. As soon as you release the mouse button, the toolbar remains at the
new position. Drag the title bar to another position, or drag to an edge of the
window, where the toolbar will dock. Close a toolbar by clicking the
<emph>Close Window</emph> icon. Make the toolbar visible again by choosing
<emph>View - Toolbars - (toolbar name)</emph>.</paragraph>
+ <paragraph id="par_id3149783" role="paragraph">By clicking the arrow next to
some icons you open a toolbar. To move a toolbar, drag the title bar. As soon
as you release the mouse button, the toolbar remains at the new position. Drag
the title bar to another position, or drag to an edge of the window, where the
toolbar will dock. Close a toolbar by clicking the <emph>Close Window</emph>
icon. Make the toolbar visible again by choosing <emph>View - Toolbars -
(toolbar name)</emph>.</paragraph>
</section>
<section id="spin_button">
<h2 id="hd_id3152414">Spin button</h2>
<section id="spinbutton">
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id1094088" role="paragraph">In form
controls, a spin button is a property of a numerical field, currency field,
date field, or time field. If the property "Spin button" is enabled, the field
shows a pair of symbols with arrows pointing to opposing directions, either
vertically or horizontally.</paragraph>
+ <paragraph id="par_id1094088" role="paragraph">In form controls, a spin
button is a property of a numerical field, currency field, date field, or time
field. If the property "Spin button" is enabled, the field shows a pair of
symbols with arrows pointing to opposing directions, either vertically or
horizontally.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id7493209" role="paragraph">In the
<emph>Basic IDE</emph>, a spin button is the name used for the numerical field
together with the two arrow symbols.</paragraph>
+ <paragraph id="par_id7493209" role="paragraph">In the <emph>Basic
IDE</emph>, a spin button is the name used for the numerical field together
with the two arrow symbols.</paragraph>
</listitem>
</list>
-<paragraph xml-lang="en-US" id="par_id3155599" role="paragraph">You can type a
numerical value into the field next to the spin button, or select the value
with the <emph>Up Arrow</emph> or <emph>Down Arrow</emph> symbols on the spin
button. On the keyboard you can press the <item type="keycode">Up Arrow</item>
and <item type="keycode">Down Arrow</item> keys to increase or reduce the
value. You can press the <item type="keycode">Page Up</item> and <item
type="keycode">Page Down</item> keys to set the maximum and minimum
value.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150264" role="paragraph">If the field
next to the spin button defines numerical values, you can also define a <link
href="text/shared/00/00000003.xhp#measurement_units">measurement unit</link>,
for example, <emph>1 cm or 5 mm, 12 pt or 2"</emph>.</paragraph>
+<paragraph id="par_id3155599" role="paragraph">You can type a numerical value
into the field next to the spin button, or select the value with the <emph>Up
Arrow</emph> or <emph>Down Arrow</emph> symbols on the spin button. On the
keyboard you can press the <item type="keycode">Up Arrow</item> and <item
type="keycode">Down Arrow</item> keys to increase or reduce the value. You can
press the <item type="keycode">Page Up</item> and <item type="keycode">Page
Down</item> keys to set the maximum and minimum value.</paragraph>
+<paragraph id="par_id3150264" role="paragraph">If the field next to the spin
button defines numerical values, you can also define a <link
href="text/shared/00/00000003.xhp#measurement_units">measurement unit</link>,
for example, <emph>1 cm or 5 mm, 12 pt or 2"</emph>.</paragraph>
</section>
</section>
<section id="import">
<h2 id="hd_id3154232">Convert</h2>
- <paragraph xml-lang="en-US" id="par_id3148983" role="paragraph"><ahelp
hid=".">If you click forward through the dialog, this button is called
<emph>Next</emph>. On the last page the button has the name
<emph>Convert</emph>. The conversion is then performed by clicking the
button.</ahelp></paragraph>
+ <paragraph id="par_id3148983" role="paragraph"><ahelp hid=".">If you click
forward through the dialog, this button is called <emph>Next</emph>. On the
last page the button has the name <emph>Convert</emph>. The conversion is then
performed by clicking the button.</ahelp></paragraph>
</section>
<section id="contextmenu">
<h2 id="hd_id3145129">Context Menu</h2>
-<paragraph xml-lang="en-US" id="par_id3156553" role="paragraph"><variable
id="context">To activate the context menu of an object, first click the object
with the <switchinline select="sys"><caseinline select="MAC">
+<paragraph id="par_id3156553" role="paragraph"><variable id="context">To
activate the context menu of an object, first click the object with the
<switchinline select="sys"><caseinline select="MAC">
</caseinline><defaultinline>left</defaultinline></switchinline> mouse button
to select it, and then, <switchinline select="sys"><caseinline
select="MAC">while holding down the <emph>Ctrl</emph> key or the
<emph>Command</emph> and <emph>Option</emph> keys, click the mouse button again
</caseinline><defaultinline> click the right mouse
button</defaultinline></switchinline>. Some context menus can be called even if
the object has not been selected. Context menus are found just about everywhere
in $[officename].</variable></paragraph>
</section>
<section id="delete">
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/autoformattable/remove" id="bm_id3153766"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/delete" id="bm_id3153839"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150089"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/definedatabaserangedialog/delete"
id="bm_id3146120" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SW_HID_MD_GLOS_DELETE"
id="bm_id3148722" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optsortslist/delete"
id="bm_id3152577" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/colorpage/delete"
id="bm_id3156382" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/hatchpage/delete"
id="bm_id3148943" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/imagetabpage/BTN_DELETE"
id="bm_id3149762" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/gradientpage/delete"
id="bm_id3148924" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/lineendstabpage/BTN_DELETE"
id="bm_id3153717" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/paratabspage/buttonBTN_DEL"
id="bm_id3156007" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/macropage/delete"
id="bm_id3143232" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/dialogpage/library"
id="bm_id3214514" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/libpage/delete"
id="bm_id3145749" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/linestyletabpage/BTN_DELETE"
id="bm_id3150443" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/autoformattable/remove"
id="bm_id3153766" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/delete"
id="bm_id3153839" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/managenamesdialog/delete"
id="bm_id3150089" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/delete"
id="bm_id3146120" localize="false"/>
+<bookmark branch="hid/SW_HID_MD_GLOS_DELETE" id="bm_id3148722"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/optsortslist/delete" id="bm_id3152577"
localize="false"/>
+<bookmark branch="hid/cui/ui/colorpage/delete" id="bm_id3156382"
localize="false"/>
+<bookmark branch="hid/cui/ui/hatchpage/delete" id="bm_id3148943"
localize="false"/>
+<bookmark branch="hid/cui/ui/imagetabpage/BTN_DELETE" id="bm_id3149762"
localize="false"/>
+<bookmark branch="hid/cui/ui/gradientpage/delete" id="bm_id3148924"
localize="false"/>
+<bookmark branch="hid/cui/ui/lineendstabpage/BTN_DELETE" id="bm_id3153717"
localize="false"/>
+<bookmark branch="hid/cui/ui/paratabspage/buttonBTN_DEL" id="bm_id3156007"
localize="false"/>
+<bookmark branch="hid/modules/BasicIDE/ui/macropage/delete" id="bm_id3143232"
localize="false"/>
+<bookmark branch="hid/modules/BasicIDE/ui/dialogpage/library"
id="bm_id3214514" localize="false"/>
+<bookmark branch="hid/modules/BasicIDE/ui/libpage/delete" id="bm_id3145749"
localize="false"/>
+<bookmark branch="hid/cui/ui/linestyletabpage/BTN_DELETE" id="bm_id3150443"
localize="false"/>
<h2 id="hd_id3149180">Delete</h2>
- <paragraph xml-lang="en-US" id="par_id3153750" role="paragraph"><ahelp
hid=".">Deletes the selected element or elements after
confirmation.</ahelp></paragraph>
+ <paragraph id="par_id3153750" role="paragraph"><ahelp hid=".">Deletes the
selected element or elements after confirmation.</ahelp></paragraph>
</section>
<section id="delete2">
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/consolidatedialog/delete" id="bm_id3146916"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/simpress/ui/customslideshows/delete" id="bm_id3147296"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/sw:PushButton:DLG_BIB_BASE:PB_DELETE"
id="bm_id6168401" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/selectpathdialog/delete"
id="bm_id3154687" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/multipathdialog/delete"
id="bm_id3154686" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/acorreplacepage/delete"
id="bm_id7878353" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/acorexceptpage/delabbrev"
id="bm_id5413373" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/acorexceptpage/deldouble"
id="bm_id2580950" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/consolidatedialog/delete"
id="bm_id3146916" localize="false"/>
+<bookmark branch="hid/modules/simpress/ui/customslideshows/delete"
id="bm_id3147296" localize="false"/>
+<bookmark branch="hid/sw:PushButton:DLG_BIB_BASE:PB_DELETE" id="bm_id6168401"
localize="false"/>
+<bookmark branch="hid/cui/ui/selectpathdialog/delete" id="bm_id3154687"
localize="false"/>
+<bookmark branch="hid/cui/ui/multipathdialog/delete" id="bm_id3154686"
localize="false"/>
+<bookmark branch="hid/cui/ui/acorreplacepage/delete" id="bm_id7878353"
localize="false"/>
+<bookmark branch="hid/cui/ui/acorexceptpage/delabbrev" id="bm_id5413373"
localize="false"/>
+<bookmark branch="hid/cui/ui/acorexceptpage/deldouble" id="bm_id2580950"
localize="false"/>
<h2 id="hd_id3147557">Delete</h2>
- <paragraph xml-lang="en-US" id="par_id3155338" role="paragraph"><ahelp
hid=".">Deletes the selected element or elements without requiring
confirmation.</ahelp></paragraph>
+ <paragraph id="par_id3155338" role="paragraph"><ahelp hid=".">Deletes the
selected element or elements without requiring confirmation.</ahelp></paragraph>
</section>
<h2 id="hd_id3148620">Metrics</h2>
- <paragraph xml-lang="en-US" id="par_id3145345" role="paragraph">You can
enter values in the input fields in different <link
href="text/shared/00/00000003.xhp#measurement_units">units of
measurement</link>. The default unit is inches. However, if you want a space of
exactly 1 cm, then type "1cm". Additional units are available according to the
context, for example, 12 pt for a 12 point spacing. If the value of the new
unit is unrealistic, the program uses a predefined maximum or minimum
value.</paragraph>
+ <paragraph id="par_id3145345" role="paragraph">You can enter values in the
input fields in different <link
href="text/shared/00/00000003.xhp#measurement_units">units of
measurement</link>. The default unit is inches. However, if you want a space of
exactly 1 cm, then type "1cm". Additional units are available according to the
context, for example, 12 pt for a 12 point spacing. If the value of the new
unit is unrealistic, the program uses a predefined maximum or minimum
value.</paragraph>
<section id="close">
<h2 id="hd_id3155535">Close</h2>
- <paragraph xml-lang="en-US" id="par_id3147008" role="paragraph"><ahelp
hid=".">Closes the dialog and saves all changes.</ahelp></paragraph>
+ <paragraph id="par_id3147008" role="paragraph"><ahelp hid=".">Closes the
dialog and saves all changes.</ahelp></paragraph>
</section>
<section id="close2">
<h2 id="hd_id3147275">Close</h2>
- <paragraph xml-lang="en-US" id="par_id3153031" role="paragraph"><ahelp
hid=".">Closes the dialog.</ahelp></paragraph>
+ <paragraph id="par_id3153031" role="paragraph"><ahelp hid=".">Closes the
dialog.</ahelp></paragraph>
</section>
<section id="apply">
-<bookmark xml-lang="en-US" branch="hid/modules/smath/ui/catalogdialog/insert"
id="bm_id3149053" localize="false"/>
+<bookmark branch="hid/modules/smath/ui/catalogdialog/insert" id="bm_id3149053"
localize="false"/>
<h2 id="hd_id3156113">Apply</h2>
- <paragraph xml-lang="en-US" id="par_id3155341" role="paragraph"><ahelp
hid=".">Applies the modified or selected values without closing the
dialog.</ahelp></paragraph>
+ <paragraph id="par_id3155341" role="paragraph"><ahelp hid=".">Applies the
modified or selected values without closing the dialog.</ahelp></paragraph>
</section>
<section id="only_ParaFramePage_style">
-<paragraph role="paragraph" xml-lang="en-US" id="par_id131583023155214">This
option appears only for Paragraph Style, Frame Style, and Page
Style.</paragraph>
+<paragraph role="paragraph" id="par_id131583023155214">This option appears
only for Paragraph Style, Frame Style, and Page Style.</paragraph>
</section>
<section id="only_ParaChar_style">
-<paragraph role="paragraph" xml-lang="en-US" id="par_id131583023155356">This
option appears only for Paragraph Style and Character Style.</paragraph>
+<paragraph role="paragraph" id="par_id131583023155356">This option appears
only for Paragraph Style and Character Style.</paragraph>
</section>
<section id="shrink_maximize">
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-button"
id="bm_id3155067" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/formulasref"
id="bm_id3149785" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/rowref" id="bm_id3149019"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/colref" id="bm_id3153712"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/goalseekdlg/formulabutton" id="bm_id3153364"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/varbutton"
id="bm_id3153363" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/rbassign" id="bm_id3149400"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/namerangesdialog/rbassign2" id="bm_id3155962"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/consolidatedialog/rbdataarea" id="bm_id3145640"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/consolidatedialog/rbdestarea" id="bm_id3153713"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/rbprintarea" id="bm_id3152596"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/rbrepeatrow" id="bm_id3146975"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/printareasdialog/rbrepeatcol" id="bm_id3154321"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/rbassign"
id="bm_id3155532" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/managenamesdialog/assign" id="bm_id3159155"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/definedatabaserangedialog/assignrb"
id="bm_id3149262" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/advancedfilterdialog/rbfilterarea"
id="bm_id3153190" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/rbcopyarea" id="bm_id3150010"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/advancedfilterdialog/rbcopyarea" id="bm_id3146985"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-button"
id="bm_id3155067" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/formulasref"
id="bm_id3149785" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/rowref"
id="bm_id3149019" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/colref"
id="bm_id3153712" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/formulabutton"
id="bm_id3153364" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/varbutton"
id="bm_id3153363" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rbassign"
id="bm_id3149400" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rbassign2"
id="bm_id3155962" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/consolidatedialog/rbdataarea"
id="bm_id3145640" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/consolidatedialog/rbdestarea"
id="bm_id3153713" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/rbprintarea"
id="bm_id3152596" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/rbrepeatrow"
id="bm_id3146975" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/rbrepeatcol"
id="bm_id3154321" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/rbassign"
id="bm_id3155532" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/managenamesdialog/assign"
id="bm_id3159155" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/assignrb"
id="bm_id3149262" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/rbfilterarea"
id="bm_id3153190" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/rbcopyarea"
id="bm_id3150010" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/rbcopyarea"
id="bm_id3146985" localize="false"/>
<h2 id="hd_id3153760">Shrink / Expand</h2>
- <paragraph xml-lang="en-US" id="par_id3153087" role="paragraph"><ahelp
hid=".">Click the <emph>Shrink</emph> icon to reduce the dialog to the size of
the input field. It is then easier to mark the required reference in the sheet.
The icons then automatically convert to the <emph>Expand</emph> icon. Click it
to restore the dialog to its original size.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id3155062" role="paragraph">The dialog
is automatically minimized when you click into a sheet with the mouse. As soon
as you release the mouse button, the dialog is restored and the reference range
defined with the mouse is highlighted in the document by a blue
frame.</paragraph>
+ <paragraph id="par_id3153087" role="paragraph"><ahelp hid=".">Click the
<emph>Shrink</emph> icon to reduce the dialog to the size of the input field.
It is then easier to mark the required reference in the sheet. The icons then
automatically convert to the <emph>Expand</emph> icon. Click it to restore the
dialog to its original size.</ahelp></paragraph>
+ <paragraph id="par_id3155062" role="paragraph">The dialog is automatically
minimized when you click into a sheet with the mouse. As soon as you release
the mouse button, the dialog is restored and the reference range defined with
the mouse is highlighted in the document by a blue frame.</paragraph>
<table id="tbl_id3148473">
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3157808" role="paragraph"><image
id="img_id3148685" src="formula/res/refinp1.png" width="1cm" height="1cm"><alt
xml-lang="en-US" id="alt_id3148685">Icon shrink</alt></image></paragraph>
+ <paragraph id="par_id3157808" role="paragraph"><image id="img_id3148685"
src="formula/res/refinp1.svg" width="1cm" height="1cm"><alt
id="alt_id3148685">Icon shrink</alt></image></paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153321"
role="paragraph">Shrink</paragraph>
+ <paragraph id="par_id3153321" role="paragraph">Shrink</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153349" role="paragraph"><image
id="img_id3149784" src="formula/res/refinp2.png" width="1cm" height="1cm"><alt
xml-lang="en-US" id="alt_id3149784">Icon Expand</alt></image></paragraph>
+ <paragraph id="par_id3153349" role="paragraph"><image id="img_id3149784"
src="formula/res/refinp2.svg" width="1cm" height="1cm"><alt
id="alt_id3149784">Icon Expand</alt></image></paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155628"
role="paragraph">Expand</paragraph>
+ <paragraph id="par_id3155628" role="paragraph">Expand</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="preview_field">
-<bookmark xml-lang="en-US" branch="hid/CUI_HID_MEASURE_CTL_PREVIEW"
id="bm_id3157970" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SVX_HID_GALLERY_PREVIEW"
id="bm_id3153896" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/autoformattable/preview" id="bm_id3155601"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/swriter/ui/autoformattable/preview" id="bm_id3147175"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/swriter/ui/inserttable/previewinstable" id="bm_id3147227"
localize="false"/>
+<bookmark branch="hid/CUI_HID_MEASURE_CTL_PREVIEW" id="bm_id3157970"
localize="false"/>
+<bookmark branch="hid/SVX_HID_GALLERY_PREVIEW" id="bm_id3153896"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/autoformattable/preview"
id="bm_id3155601" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/preview"
id="bm_id3147175" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/inserttable/previewinstable"
id="bm_id3147227" localize="false"/>
<h2 id="hd_id3156192">Preview Field</h2>
- <paragraph xml-lang="en-US" id="par_id3154046" role="paragraph"><variable
id="previewhelp"><ahelp hid=".">Displays a preview of the current
selection.</ahelp></variable></paragraph>
+ <paragraph id="par_id3154046" role="paragraph"><variable
id="previewhelp"><ahelp hid=".">Displays a preview of the current
selection.</ahelp></variable></paragraph>
</section>
<section id="preview">
<h2 id="hd_id3156193">Preview</h2>
<embed href="text/shared/00/00000001.xhp#previewhelp"/>
</section>
<section id="next">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDNEXT"
id="bm_id8281197" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT"
id="bm_id3147576" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_NEXT"
id="bm_id4154179" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_NEXT"
id="bm_id1058076" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_NEXT" id="bm_id480666"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_NEXT"
id="bm_id3149095" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT"
id="bm_id31475761" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDNEXT" id="bm_id8281197"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id3147576"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_NEXT" id="bm_id4154179"
localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_NEXT" id="bm_id1058076"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID0_NEXT" id="bm_id480666" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_GROUPWIZARD_NEXT" id="bm_id3149095"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id31475761"
localize="false"/>
<!-- removed HID HID_DLGREPORT_0_CMDNEXTORREADY -->
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT"
id="bm_id3155135" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT" id="bm_id3155135"
localize="false"/>
<h2 id="hd_id3145609">Next</h2>
- <paragraph xml-lang="en-US" id="par_id3152473" role="paragraph"><ahelp
hid=".">Click the <emph>Next</emph> button, and the wizard uses the current
dialog settings and proceeds to the next step. If you are on the last step,
this button becomes <emph>Create</emph>.</ahelp></paragraph>
+ <paragraph id="par_id3152473" role="paragraph"><ahelp hid=".">Click the
<emph>Next</emph> button, and the wizard uses the current dialog settings and
proceeds to the next step. If you are on the last step, this button becomes
<emph>Create</emph>.</ahelp></paragraph>
</section>
<section id="AutocorrectButtons">
-<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/reset"
id="bm_id4539934" localize="false"/>
+<bookmark branch="hid/cui/ui/autocorrectdialog/reset" id="bm_id4539934"
localize="false"/>
<h2 id="hd_id3149671">Dialog Buttons</h2>
<h3 id="par_id3145069">Reset</h3>
- <paragraph xml-lang="en-US" id="par_id3145169" role="paragraph"><ahelp
hid="cui/ui/autocorrectdialog/reset">Resets modified values back to the tab
page previous values.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/cancel"
id="bm_id4539935" localize="false"/>
+ <paragraph id="par_id3145169" role="paragraph"><ahelp
hid="cui/ui/autocorrectdialog/reset">Resets modified values back to the tab
page previous values.</ahelp></paragraph>
+<bookmark branch="hid/cui/ui/autocorrectdialog/cancel" id="bm_id4539935"
localize="false"/>
<section id="cancel_autocorr">
<h3 id="par_id3145070">Cancel</h3>
- <paragraph xml-lang="en-US" id="par_id3145269" role="paragraph"><ahelp
hid="cui/ui/autocorrectdialog/cancel">Closes dialog and discards all
changes.</ahelp></paragraph>
+ <paragraph id="par_id3145269" role="paragraph"><ahelp
hid="cui/ui/autocorrectdialog/cancel">Closes dialog and discards all
changes.</ahelp></paragraph>
</section>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/ok"
id="bm_id4539936" localize="false"/>
+<bookmark branch="hid/cui/ui/autocorrectdialog/ok" id="bm_id4539936"
localize="false"/>
<section id="ok">
<h3 id="par_id3145071">OK</h3>
- <paragraph xml-lang="en-US" id="par_id3145369" role="paragraph"><ahelp
hid="cui/ui/autocorrectdialog/ok">Saves all changes and closes
dialog.</ahelp></paragraph>
+ <paragraph id="par_id3145369" role="paragraph"><ahelp
hid="cui/ui/autocorrectdialog/ok">Saves all changes and closes
dialog.</ahelp></paragraph>
</section>
</section>
<section id="reset">
-<bookmark xml-lang="en-US" branch="hid/cui/ui/optionsdialog/revert"
id="bm_id4539933" localize="false"/>
+<bookmark branch="hid/cui/ui/optionsdialog/revert" id="bm_id4539933"
localize="false"/>
<h2 id="hd_id3149670">Reset<comment>in Tools - Options</comment></h2>
- <paragraph xml-lang="en-US" id="par_id3145068" role="paragraph"><ahelp
hid="cui/ui/optionsdialog/revert">Resets changes made to the current tab to
those applicable when this dialog was opened.</ahelp></paragraph>
+ <paragraph id="par_id3145068" role="paragraph"><ahelp
hid="cui/ui/optionsdialog/revert">Resets changes made to the current tab to
those applicable when this dialog was opened.</ahelp></paragraph>
</section>
<section id="reset2">
-<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TABDLG_RESET_BTN"
id="bm_id3151054" localize="false"/>
+<bookmark branch="hid/SFX2_HID_TABDLG_RESET_BTN" id="bm_id3151054"
localize="false"/>
<h2 id="hd_id3148755">Reset<comment>all tab dialogs</comment></h2>
- <paragraph xml-lang="en-US" id="par_id3149651" role="paragraph"><ahelp
hid=".">Resets changes made to the current tab to those applicable when this
dialog was opened. A confirmation query does not appear when you close the
dialog.</ahelp></paragraph>
+ <paragraph id="par_id3149651" role="paragraph"><ahelp hid=".">Resets changes
made to the current tab to those applicable when this dialog was opened. A
confirmation query does not appear when you close the
dialog.</ahelp></paragraph>
</section>
<section id="standard">
-<bookmark xml-lang="en-US" branch="hid/sw:PushButton:TP_STD_FONT:PB_STANDARD"
id="bm_id481887" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TABDLG_STANDARD_BTN"
id="bm_id3157322" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/sdraw/ui/copydlg/default"
id="bm_id3083280" localize="false"/>
+<bookmark branch="hid/sw:PushButton:TP_STD_FONT:PB_STANDARD" id="bm_id481887"
localize="false"/>
+<bookmark branch="hid/SFX2_HID_TABDLG_STANDARD_BTN" id="bm_id3157322"
localize="false"/>
+<bookmark branch="hid/modules/sdraw/ui/copydlg/default" id="bm_id3083280"
localize="false"/>
<h2 id="hd_id3145173">Standard<comment>UFI: Name is Default on
Tools-Options-Writer-Basic Fonts</comment></h2>
- <paragraph xml-lang="en-US" id="par_id3154153" role="paragraph"><ahelp
hid=".">Resets the values visible in the dialog back to the default
installation values.</ahelp></paragraph>
+ <paragraph id="par_id3154153" role="paragraph"><ahelp hid=".">Resets the
values visible in the dialog back to the default installation
values.</ahelp></paragraph>
<warning id="par_id3154299">A confirmation does not appear before the
defaults are reloaded.</warning>
</section>
<section id="cancel_for_styles">
@@ -256,42 +256,42 @@
<paragraph role="paragraph" id="par_id581616061494132">Values for the current
tab are set to those found in the corresponding tab of the style specified in
“Inherit from” in Organizer. In all cases, also when “Inherit from” is “- None
-”, current tab values specified in “Contains” are removed.</paragraph>
</section>
<section id="only_ParaCharFrame_style">
-<paragraph role="paragraph" xml-lang="en-US" id="par_id131583023830621">This
option appears only for Paragraph Style, Character Style, and Frame
Style.</paragraph>
+<paragraph role="paragraph" id="par_id131583023830621">This option appears
only for Paragraph Style, Character Style, and Frame Style.</paragraph>
</section>
<section id="back">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDPREV"
id="bm_id1064180" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_BACK"
id="bm_id3681447" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_PREVIOUS"
id="bm_id5176244" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_PREV" id="bm_id1207617"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_PREVIOUS"
id="bm_id3154318" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDPREV"
id="bm_id3145346" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGREPORT_0_CMDPREV"
id="bm_id3150984" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS"
id="bm_id3156155" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDPREV" id="bm_id1064180"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_BACK" id="bm_id3681447"
localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_PREVIOUS" id="bm_id5176244"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID0_PREV" id="bm_id1207617" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_GROUPWIZARD_PREVIOUS" id="bm_id3154318"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDPREV" id="bm_id3145346"
localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGREPORT_0_CMDPREV" id="bm_id3150984"
localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS" id="bm_id3156155"
localize="false"/>
<h2 id="hd_id3147502">Back</h2>
- <paragraph xml-lang="en-US" id="par_id3150439" role="paragraph"><ahelp
hid=".">View the selections in the dialog made in the previous step. The
current settings remain unchanged.</ahelp> This button can only be activated
from page two on.</paragraph>
+ <paragraph id="par_id3150439" role="paragraph"><ahelp hid=".">View the
selections in the dialog made in the previous step. The current settings remain
unchanged.</ahelp> This button can only be activated from page two
on.</paragraph>
</section>
<section id="options">
-<bookmark xml-lang="en-US" branch="hid/SFX2_HID_MOREOPTIONS_BTN"
id="bm_id3157322" localize="false"/>
+<bookmark branch="hid/SFX2_HID_MOREOPTIONS_BTN" id="bm_id3157322"
localize="false"/>
<h2 id="hd_id3147353">Options</h2>
- <paragraph xml-lang="en-US" id="par_id3155314" role="paragraph"><ahelp
hid=".">Click the <emph>Options</emph> label to expand the dialog to show
further options. Click again to restore the dialog.</ahelp></paragraph>
+ <paragraph id="par_id3155314" role="paragraph"><ahelp hid=".">Click the
<emph>Options</emph> label to expand the dialog to show further options. Click
again to restore the dialog.</ahelp></paragraph>
</section>
-<paragraph xml-lang="en-US" id="par_id3161659" role="paragraph"><variable
id="siehe">See also the following functions:</variable></paragraph>
+<paragraph id="par_id3161659" role="paragraph"><variable id="siehe">See also
the following functions:</variable></paragraph>
<section id="regex">
- <paragraph xml-lang="en-US" id="par_id3147418" role="paragraph">The search
supports wildcards or <link href="text/shared/01/02100001.xhp">regular
expressions</link>. With regular expressions enabled, you can enter "all.*",
for example to find the first location of "all" followed by any characters. If
you want to search for a text that is also a regular expression, you must
either precede every regular expression metacharacter or operator with a "\"
character, or enclose the text into \Q...\E. You can switch the automatic
evaluation of wildcards or regular expression on and off in <link
href="text/shared/optionen/01060500.xhp"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link>.</paragraph>
+ <paragraph id="par_id3147418" role="paragraph">The search supports
wildcards or <link href="text/shared/01/02100001.xhp">regular
expressions</link>. With regular expressions enabled, you can enter "all.*",
for example to find the first location of "all" followed by any characters. If
you want to search for a text that is also a regular expression, you must
either precede every regular expression metacharacter or operator with a "\"
character, or enclose the text into \Q...\E. You can switch the automatic
evaluation of wildcards or regular expression on and off in <link
href="text/shared/optionen/01060500.xhp"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link>.</paragraph>
<section id="regexnumex">
<warning id="par_id651572973288601">When using functions where one or
more arguments are search criteria strings that represents a regular
expression, the first attempt is to convert the string criteria to numbers. For
example, ".0" will convert to 0.0 and so on. If successful, the match will not
be a regular expression match but a numeric match. However, when switching to a
locale where the decimal separator is not the dot makes the regular expression
conversion work. To force the evaluation of the regular expression instead of a
numeric expression, use some expression that can not be misread as numeric,
such as ".[0]" or ".\0" or "(?i).0". </warning>
</section>
</section>
-<paragraph xml-lang="en-US" id="par_id3163714" role="paragraph"><variable
id="wahr">If an error occurs, the function returns a logical or numerical
value.</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id3154145" role="paragraph"><variable
id="kontext">(This command is only accessible through the <link
href="text/shared/00/00000005.xhp#contextmenu">context
menu</link>).</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id3152791" role="paragraph"><variable
id="wiederholen">By double-clicking a tool, you can use it for multiple tasks.
If you call the tool with a single-click, it reverts back to the last selection
after completing the task.</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id9345377" role="paragraph"><variable
id="ShiftF1">Press <emph>Shift+F1</emph> and point to a control to learn more
about that control.</variable></paragraph>
+<paragraph id="par_id3163714" role="paragraph"><variable id="wahr">If an error
occurs, the function returns a logical or numerical
value.</variable></paragraph>
+<paragraph id="par_id3154145" role="paragraph"><variable id="kontext">(This
command is only accessible through the <link
href="text/shared/00/00000005.xhp#contextmenu">context
menu</link>).</variable></paragraph>
+<paragraph id="par_id3152791" role="paragraph"><variable id="wiederholen">By
double-clicking a tool, you can use it for multiple tasks. If you call the tool
with a single-click, it reverts back to the last selection after completing the
task.</variable></paragraph>
+<paragraph id="par_id9345377" role="paragraph"><variable id="ShiftF1">Press
<emph>Shift+F1</emph> and point to a control to learn more about that
control.</variable></paragraph>
<section id="optionsbuttons">
<h2 id="hd_id631527692833772">Options dialog buttons</h2>
<h3 id="hd_id831527692839432">OK</h3>
-<paragraph role="paragraph" id="par_id471527692844934" xml-lang="en-US">Save
the changes in the page and close the Options dialog.</paragraph>
+<paragraph role="paragraph" id="par_id471527692844934">Save the changes in the
page and close the Options dialog.</paragraph>
<h3 id="hd_id261527692850720">Cancel</h3>
-<paragraph role="paragraph" id="par_id571527692855533" xml-lang="en-US">Close
the Options dialog and discard all changes done.</paragraph>
+<paragraph role="paragraph" id="par_id571527692855533">Close the Options
dialog and discard all changes done.</paragraph>
<h3 id="hd_id321597440555403">Apply</h3>
<paragraph role="paragraph" id="par_id51597440622057">Applies the modified or
selected values without closing the Options dialog.</paragraph>
<embed href="text/shared/00/00000001.xhp#reset"/>
