source/text/scalc/00/00000412.xhp | 45 ++++++++++++++--
source/text/scalc/01/12120000.xhp | 11 ++-
source/text/scalc/01/12120100.xhp | 105 +++++++++++++++++++-------------------
source/text/scalc/01/12120200.xhp | 30 +++++-----
source/text/scalc/01/12120300.xhp | 38 +++++++------
5 files changed, 136 insertions(+), 93 deletions(-)
New commits:
commit ecd1826d0874e89fe363193e9e6f71e0055741fe
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Jan 3 14:48:08 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Jan 3 20:24:24 2024 +0100
tdf#155876 UI cmds Calc-Sheet menu (40)
+ Data menu for Calc, validity commands
+ refactoring
Change-Id: If520f434d2f908cd2adfd64374a1bc4a5da06a07
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161595
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index fa03249942..60471b6ecb 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -241,10 +241,47 @@
<paragraph role="paragraph" id="par_id3166424"><variable
id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3154574"><variable
id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph>
tabs.</variable></paragraph>
<paragraph role="paragraph" id="par_id3151277"><variable
id="dntopi">Choose <emph>Data - Subtotals - Options</emph>
tab.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3145133"><variable
id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3152992"><variable
id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph>
tab.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3150367"><variable
id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph>
tab.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3154486"><variable
id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph>
tab.</variable></paragraph>
+
+ <section id="validity">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3145133"><variable
id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id941704298058952">Choose
<menuitem>Data - Validity</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id161704298115623">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Validity</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id961704298143024">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id821704298143026"
role="paragraph"><image src="cmd/lc_validation.svg" id="img_id561704298143028"
width="1cm" height="1cm"><alt id="alt_id991704298143029">Icon Data
Validity</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id611704298143032"
role="paragraph">Data Validity</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+
+ <section id="validity_critera">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3152992"><variable
id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph>
tab.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id281704302934153">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Validity - Criteria</menuitem> tab.</paragraph>
+ </section>
+
+ <section id="input_help">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3150367"><variable
id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph>
tab.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id391704303360650">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Validity - Input Help</menuitem> tab.</paragraph>
+ </section>
+
+ <section id="error_alert">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3154486"><variable
id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph>
tab.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id951704303538788">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Validity - Error - Alert</menuitem> tab.</paragraph>
+ </section>
+
<paragraph role="paragraph" id="par_id3146978"><variable id="dnmfo">Choose
<emph>Data - Multiple Operations</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3155809"><variable id="dnksd">Choose
<emph>Data - Consolidate</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3148701"><variable id="dngld">Choose
<emph>Data - Group and Outline</emph>.</variable></paragraph>
diff --git a/source/text/scalc/01/12120000.xhp
b/source/text/scalc/01/12120000.xhp
index f7c3a98c4e..a5330bb8dd 100644
--- a/source/text/scalc/01/12120000.xhp
+++ b/source/text/scalc/01/12120000.xhp
@@ -19,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112120000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Validity</title>
+<title id="tit">Validity</title>
<filename>/text/scalc/01/12120000.xhp</filename>
</topic>
<history>
@@ -27,14 +27,15 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:Validation" id="bm_id3153880"
localize="false"/>
+<bookmark branch="hid/.uno:Validation" id="bm_id3153880" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-Validation"
id="bm_id271704298339663" localize="false"/>
<section id="validityheader">
-<h1 id="hd_id3156347"><link
href="text/scalc/01/12120000.xhp">Validity</link></h1>
-<paragraph role="paragraph" id="par_id3153252" xml-lang="en-US"><variable
id="gueltigkeit"><ahelp hid=".uno:Validation">Defines what data is valid for a
selected cell or cell range.</ahelp>
+ <h1 id="hd_id3156347"><variable id="h1"><link
href="text/scalc/01/12120000.xhp">Validity</link></variable></h1>
+<paragraph role="paragraph" id="par_id3153252"><variable
id="gueltigkeit"><ahelp hid=".uno:Validation">Defines what data is valid for a
selected cell or cell range.</ahelp>
</variable></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#datengueltig"/>
+ <embed href="text/scalc/00/00000412.xhp#validity"/>
</section>
<tip id="par_idN105D1">You can also insert a list box from the Controls
toolbar and link the list box to a cell. This way you can specify the valid
values on the <link href="text/shared/02/01170102.xhp">Data</link> page of the
list box properties window.</tip>
<embed href="text/scalc/01/12120100.xhp#criteria"/>
diff --git a/source/text/scalc/01/12120100.xhp
b/source/text/scalc/01/12120100.xhp
index cb8054fc7b..56492670cc 100644
--- a/source/text/scalc/01/12120100.xhp
+++ b/source/text/scalc/01/12120100.xhp
@@ -20,7 +20,7 @@
<meta>
<topic id="textscalc0112120100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Criteria</title>
+<title id="tit">Criteria</title>
<filename>/text/scalc/01/12120100.xhp</filename>
</topic>
<history>
@@ -29,92 +29,92 @@
</meta>
<body>
<section id="criteria">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id1464278"><bookmark_value>selection lists;validity</bookmark_value>
+<bookmark 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"/>
-<h1 id="hd_id3153032" xml-lang="en-US"><link
href="text/scalc/01/12120100.xhp">Criteria</link></h1>
-<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>
+<bookmark
branch="hid/modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage"
id="bm_id3145673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/@@nowidget@@"
id="bm_id3145673" localize="false"/>
+<h1 id="hd_id3153032"><link
href="text/scalc/01/12120100.xhp">Criteria</link></h1>
+<paragraph role="paragraph" id="par_id3156327"><ahelp
hid="modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage">Specify
the validation rules for the selected cell(s).</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#datengueltigwerte"/>
+ <embed href="text/scalc/00/00000412.xhp#validity_critera"/>
</section>
-<paragraph role="paragraph" id="par_id3155923" xml-lang="en-US">For example,
you can define criteria such as: "Numbers between 1 and 10" or "Texts that are
no more than 20 characters".</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/allow" id="bm_id3148663"
localize="false"/>
-<h2 id="hd_id3153896" xml-lang="en-US">Allow</h2>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/allow">Click a validation option
for the selected cell(s).</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3148797" xml-lang="en-US">The following
conditions are available:</paragraph>
+<paragraph role="paragraph" id="par_id3155923">For example, you can define
criteria such as: "Numbers between 1 and 10" or "Texts that are no more than 20
characters".</paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/allow"
id="bm_id3148663" localize="false"/>
+<h2 id="hd_id3153896">Allow</h2>
+<paragraph role="paragraph" id="par_id3150400"><ahelp
hid="modules/scalc/ui/validationcriteriapage/allow">Click a validation option
for the selected cell(s).</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148797">The following conditions are
available:</paragraph>
<table id="tbl_id3150870">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3150447"
xml-lang="en-US">Condition</paragraph>
+<paragraph role="tablehead" id="par_id3150447">Condition</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3155854"
xml-lang="en-US">Effect</paragraph>
+<paragraph role="tablehead" id="par_id3155854">Effect</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153092" xml-lang="en-US">All
values</paragraph>
+<paragraph role="tablecontent" id="par_id3153092">All values</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3155411" xml-lang="en-US">No
limitation.</paragraph>
+<paragraph role="tablecontent" id="par_id3155411">No limitation.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3147434" xml-lang="en-US">Whole
numbers</paragraph>
+<paragraph role="tablecontent" id="par_id3147434">Whole numbers</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154319" xml-lang="en-US">Only whole
numbers corresponding to the condition.</paragraph>
+<paragraph role="tablecontent" id="par_id3154319">Only whole numbers
corresponding to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3145802"
xml-lang="en-US">Decimal</paragraph>
+<paragraph role="tablecontent" id="par_id3145802">Decimal</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3153160" xml-lang="en-US">All numbers
corresponding to the condition.</paragraph>
+<paragraph role="tablecontent" id="par_id3153160">All numbers corresponding to
the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3149377"
xml-lang="en-US">Date</paragraph>
+<paragraph role="tablecontent" id="par_id3149377">Date</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3150718" xml-lang="en-US">All numbers
corresponding to the condition. The entered values are formatted accordingly
the next time the dialog is called up.</paragraph>
+<paragraph role="tablecontent" id="par_id3150718">All numbers corresponding to
the condition. The entered values are formatted accordingly the next time the
dialog is called up.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3146969"
xml-lang="en-US">Time</paragraph>
+<paragraph role="tablecontent" id="par_id3146969">Time</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3155066" xml-lang="en-US">All numbers
corresponding to the condition. The entered values are formatted accordingly
the next time the dialog is called up.</paragraph>
+<paragraph role="tablecontent" id="par_id3155066">All numbers corresponding to
the condition. The entered values are formatted accordingly the next time the
dialog is called up.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_idN106A0" xml-lang="en-US">Cell
range</paragraph>
+<paragraph role="tablecontent" id="par_idN106A0">Cell range</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN106A5" xml-lang="en-US">Allow only
values that are given in a cell range. The cell range can be specified
explicitly, or as a named database range, or as a named range. The range may
consist of one column or one row of cells. If you specify a range of columns
and rows, only the first column is used.</paragraph>
+<paragraph role="tablecontent" id="par_idN106A5">Allow only values that are
given in a cell range. The cell range can be specified explicitly, or as a
named database range, or as a named range. The range may consist of one column
or one row of cells. If you specify a range of columns and rows, only the first
column is used.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_idN106AB"
xml-lang="en-US">List</paragraph>
+<paragraph role="tablecontent" id="par_idN106AB">List</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN106B0" xml-lang="en-US">Allow only
values or strings specified in a list. Strings and values can be mixed. Numbers
evaluate to their value, so if you enter the number 1 in the list, the entry
100% is also valid.</paragraph> <paragraph role="note"
id="par_id221603980244052">Only up to 255 characters are saved, when using
Excel format.</paragraph>
+<paragraph role="tablecontent" id="par_idN106B0">Allow only values or strings
specified in a list. Strings and values can be mixed. Numbers evaluate to their
value, so if you enter the number 1 in the list, the entry 100% is also
valid.</paragraph> <note id="par_id221603980244052">Only up to 255 characters
are saved, when using Excel format.</note>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154756" xml-lang="en-US">Text
length</paragraph>
+<paragraph role="tablecontent" id="par_id3154756">Text length</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3147339" xml-lang="en-US">Entries
whose length corresponds to the condition.</paragraph>
+<paragraph role="tablecontent" id="par_id3147339">Entries whose length
corresponds to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -128,30 +128,33 @@
</tablerow>
</table>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/allowempty"
id="bm_id263985" localize="false"/>
-<h2 id="hd_id3154704" xml-lang="en-US">Allow blank cells</h2>
-<paragraph role="paragraph" id="par_id3153967" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/allowempty">In conjunction with
<emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank
cells are shown as invalid data (disabled) or not (enabled).</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/showlist" id="bm_id5339518"
localize="false"/>
-<h2 id="par_idN10709" xml-lang="en-US">Show selection list</h2>
-<paragraph role="paragraph" id="par_idN1070D" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/showlist">Shows a list of all
valid strings or values to select from. The list can also be opened by
selecting the cell and pressing <switchinline select="sys"><caseinline
select="MAC"><keycode>Option+Down
Arrow</keycode></caseinline><defaultinline><keycode>Alt+Down
Arrow</keycode></defaultinline></switchinline>.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/sortascend"
id="bm_id6317331" localize="false"/>
-<h3 id="par_idN10724" xml-lang="en-US">Sort entries ascending</h3>
-<paragraph role="paragraph" id="par_idN10728" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/sortascend">Sorts the selection
list in ascending order and filters duplicates from the list. If not checked,
the order from the data source is taken.</ahelp></paragraph>
-<h2 id="par_idN1073F" xml-lang="en-US">Source</h2>
-<paragraph role="paragraph" id="par_idN10743" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/min">Enter the cell range that
contains the valid values or text.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/minlist" id="bm_id5921506"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/allowempty"
id="bm_id263985" localize="false"/>
+<h2 id="hd_id3154704">Allow blank cells</h2>
+<paragraph role="paragraph" id="par_id3153967"><ahelp
hid="modules/scalc/ui/validationcriteriapage/allowempty">In conjunction with
<emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank
cells are shown as invalid data (disabled) or not (enabled).</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/showlist"
id="bm_id5339518" localize="false"/>
+<h2 id="par_idN10709">Show selection list</h2>
+<paragraph role="paragraph" id="par_idN1070D"><ahelp
hid="modules/scalc/ui/validationcriteriapage/showlist">Shows a list of all
valid strings or values to select from. The list can also be opened by
selecting the cell and pressing <switchinline select="sys"><caseinline
select="MAC"><keycode>Option+Down
Arrow</keycode></caseinline><defaultinline><keycode>Alt+Down
Arrow</keycode></defaultinline></switchinline>.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/sortascend"
id="bm_id6317331" localize="false"/>
+<h3 id="par_idN10724">Sort entries ascending</h3>
+<paragraph role="paragraph" id="par_idN10728"><ahelp
hid="modules/scalc/ui/validationcriteriapage/sortascend">Sorts the selection
list in ascending order and filters duplicates from the list. If not checked,
the order from the data source is taken.</ahelp></paragraph>
+<h2 id="par_idN1073F">Source</h2>
+<paragraph role="paragraph" id="par_idN10743"><ahelp
hid="modules/scalc/ui/validationcriteriapage/min">Enter the cell range that
contains the valid values or text.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/minlist"
id="bm_id5921506" localize="false"/>
<h2 id="par_idN1075A">Entries</h2>
-<paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/minlist">Enter the entries that
will be valid values or text strings.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/data" id="bm_id3147344"
localize="false"/>
+<paragraph role="paragraph" id="par_idN1075E"><ahelp
hid="modules/scalc/ui/validationcriteriapage/minlist">Enter the entries that
will be valid values or text strings.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/data"
id="bm_id3147344" localize="false"/>
<h2 id="hd_id3163807">Data</h2>
-<paragraph role="paragraph" id="par_id3144502" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/data">Select the comparative
operator that you want to use.</ahelp> The available operators depend on what
you selected in the <emph>Allow </emph>box. If you select "between" or "not
between", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear.
Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum</emph>, or the
<emph>Value</emph> input boxes appear.</paragraph>
+<paragraph role="paragraph" id="par_id3144502"><ahelp
hid="modules/scalc/ui/validationcriteriapage/data">Select the comparative
operator that you want to use.</ahelp> The available operators depend on what
you selected in the <emph>Allow </emph>box. If you select "between" or "not
between", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear.
Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum</emph>, or the
<emph>Value</emph> input boxes appear.</paragraph>
<h2 id="hd_id3153782">Value</h2>
-<paragraph role="paragraph" id="par_id3153266" xml-lang="en-US">Enter the
value for the data validation option that you selected in the <emph>Allow
</emph>box.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/min" id="bm_id3149528"
localize="false"/>
-<h2 id="hd_id3149814" xml-lang="en-US">Minimum</h2>
-<paragraph role="paragraph" id="par_id3153199" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/min">Enter the minimum value for
the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/max" id="bm_id3150206"
localize="false"/>
+<paragraph role="paragraph" id="par_id3153266">Enter the value for the data
validation option that you selected in the <emph>Allow </emph>box.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/min"
id="bm_id3149528" localize="false"/>
+<h2 id="hd_id3149814">Minimum</h2>
+<paragraph role="paragraph" id="par_id3153199"><ahelp
hid="modules/scalc/ui/validationcriteriapage/min">Enter the minimum value for
the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationcriteriapage/max"
id="bm_id3150206" localize="false"/>
<h2 id="hd_id3149035">Maximum</h2>
-<paragraph role="paragraph" id="par_id3150089" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/max">Enter the maximum value for
the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150089"><ahelp
hid="modules/scalc/ui/validationcriteriapage/max">Enter the maximum value for
the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id91704303891085"
localize="false"><embedvar href="text/scalc/01/12120000.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12120200.xhp
b/source/text/scalc/01/12120200.xhp
index 69a60d9dda..5202f41bf3 100644
--- a/source/text/scalc/01/12120200.xhp
+++ b/source/text/scalc/01/12120200.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="textscalc0112120200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Input Help</title>
+<title id="tit">Input Help</title>
<filename>/text/scalc/01/12120200.xhp</filename>
</topic>
<history>
@@ -30,25 +27,28 @@
</history>
</meta>
<body>
+<bookmark
branch="hid/modules/scalc/ui/validationhelptabpage/ValidationHelpTabPage"
id="bm_id3150871" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/validationhelptabpage/@@nowidget@@"
id="bm_id3150871" localize="false"/>
<section id="input_help">
-<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"/>
<h1 id="hd_id3156280"><link href="text/scalc/01/12120200.xhp">Input
Help</link></h1>
-<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>
+<paragraph role="paragraph" id="par_id3147229"><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>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#datengueltigeingabe"/>
+ <embed href="text/scalc/00/00000412.xhp#input_help"/>
</section>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationhelptabpage/tsbhelp" id="bm_id3149260"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/validationhelptabpage/tsbhelp"
id="bm_id3149260" localize="false"/>
<h2 id="hd_id3146986">Show input help when cell is selected</h2>
-<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationhelptabpage/tsbhelp">Displays the message that
you enter in the <emph>Contents</emph> box when the cell or cell range is
selected in the sheet.</ahelp></paragraph>
-<paragraph role="warning" id="par_id3154730" xml-lang="en-US">If you enter
text in the <emph>Contents</emph> box of this dialog, and then select and clear
this check box, the text will be lost.</paragraph>
+<paragraph role="paragraph" id="par_id3153363"><ahelp
hid="modules/scalc/ui/validationhelptabpage/tsbhelp">Displays the message that
you enter in the <emph>Contents</emph> box when the cell or cell range is
selected in the sheet.</ahelp></paragraph>
+<warning id="par_id3154730">If you enter text in the <emph>Contents</emph> box
of this dialog, and then select and clear this check box, the text will be
lost.</warning>
<h2 id="hd_id3147394">Contents</h2>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationhelptabpage/title" id="bm_id3149377"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/validationhelptabpage/title"
id="bm_id3149377" localize="false"/>
<h3 id="hd_id3149582">Title</h3>
-<paragraph role="paragraph" id="par_id3149400" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationhelptabpage/title">Enter the title that you
want to display when the cell or cell range is selected.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationhelptabpage/inputhelp" id="bm_id3156275"
localize="false"/>
+<paragraph role="paragraph" id="par_id3149400"><ahelp
hid="modules/scalc/ui/validationhelptabpage/title">Enter the title that you
want to display when the cell or cell range is selected.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/validationhelptabpage/inputhelp"
id="bm_id3156275" localize="false"/>
<h3 id="hd_id3149121">Input help</h3>
-<paragraph role="paragraph" id="par_id3150752" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationhelptabpage/inputhelp">Enter the message that
you want to display when the cell or cell range is selected.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150752"><ahelp
hid="modules/scalc/ui/validationhelptabpage/inputhelp">Enter the message that
you want to display when the cell or cell range is selected.</ahelp></paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id91704303891085"
localize="false"><embedvar href="text/scalc/01/12120000.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12120300.xhp
b/source/text/scalc/01/12120300.xhp
index 9ffe4720d4..29d304efa9 100644
--- a/source/text/scalc/01/12120300.xhp
+++ b/source/text/scalc/01/12120300.xhp
@@ -16,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="textscalc0112120300xml" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Error Alert</title>
+ <title id="tit">Error Alert</title>
<filename>/text/scalc/01/12120300.xhp</filename>
</topic>
<history>
@@ -28,33 +27,33 @@
</history>
</meta>
<body>
+ <bookmark branch="hid/modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage"
id="bm_id3156024" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/erroralerttabpage/@@nowidget@@"
id="bm_id3156024" localize="false"/>
<section id="error_alert">
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage"
id="bm_id3156024" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/@@nowidget@@" id="bm_id3156024"
localize="false"/>
<h1 id="hd_id3153821"><link href="text/scalc/01/12120300.xhp">Error
Alert</link></h1>
- <paragraph role="paragraph" id="par_id3153379" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage">Defines the error
message that is displayed when invalid data is entered in a
cell.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3153379"><ahelp
hid="modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage">Defines the error
message that is displayed when invalid data is entered in a
cell.</ahelp></paragraph>
</section>
-<paragraph role="paragraph" id="par_id3154138" xml-lang="en-US">You can also
start a macro with an error message. A sample macro is provided at the end of
this page.</paragraph>
+<paragraph role="paragraph" id="par_id3154138">You can also start a macro with
an error message. A sample macro is provided at the end of this
page.</paragraph>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#datengueltigfehler"/>
+ <embed href="text/scalc/00/00000412.xhp#error_alert"/>
</section>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/tsbshow" id="bm_id3154908"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/erroralerttabpage/tsbshow"
id="bm_id3154908" localize="false"/>
<h2 id="hd_id3156280">Show error message when invalid values are entered.</h2>
-<paragraph role="paragraph" id="par_id3150768" xml-lang="en-US"><ahelp
hid=".">Displays the error message that you enter in the <emph>Contents</emph>
area when invalid data is entered in a cell.</ahelp> If enabled, the message is
displayed to prevent an invalid entry.</paragraph>
-<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US">In both cases,
if you select "Stop", the invalid entry is deleted and the previous value is
reentered in the cell. The same applies if you close the "Warning" and
"Information" dialogs by clicking the <emph>Cancel </emph>button. If you close
the dialogs with the <emph>OK</emph> button, the invalid entry is not
deleted.</paragraph>
+<paragraph role="paragraph" id="par_id3150768"><ahelp hid=".">Displays the
error message that you enter in the <emph>Contents</emph> area when invalid
data is entered in a cell.</ahelp> If enabled, the message is displayed to
prevent an invalid entry.</paragraph>
+<paragraph role="paragraph" id="par_id3146984">In both cases, if you select
"Stop", the invalid entry is deleted and the previous value is reentered in the
cell. The same applies if you close the "Warning" and "Information" dialogs by
clicking the <emph>Cancel </emph>button. If you close the dialogs with the
<emph>OK</emph> button, the invalid entry is not deleted.</paragraph>
<h2 id="hd_id3152460">Contents</h2>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/actionCB" id="bm_id3154014"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/erroralerttabpage/actionCB"
id="bm_id3154014" localize="false"/>
<h3 id="hd_id3148646">Action</h3>
-<paragraph role="paragraph" id="par_id3151115" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/erroralerttabpage/actionCB">Select the action that you
want to occur when invalid data is entered in a cell.</ahelp> The "Stop" action
rejects the invalid entry and displays a dialog that you have to close by
clicking <emph>OK</emph>. The "Warning" and "Information" actions display a
dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>.
The invalid entry is only rejected when you click
<emph>Cancel</emph>.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/browseBtn" id="bm_id3154729"
localize="false"/>
+<paragraph role="paragraph" id="par_id3151115"><ahelp
hid="modules/scalc/ui/erroralerttabpage/actionCB">Select the action that you
want to occur when invalid data is entered in a cell.</ahelp> The "Stop" action
rejects the invalid entry and displays a dialog that you have to close by
clicking <emph>OK</emph>. The "Warning" and "Information" actions display a
dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>.
The invalid entry is only rejected when you click
<emph>Cancel</emph>.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/erroralerttabpage/browseBtn"
id="bm_id3154729" localize="false"/>
<h3 id="hd_id3156441">Browse</h3>
-<paragraph role="paragraph" id="par_id3153160" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/erroralerttabpage/browseBtn">Opens the <link
href="text/shared/01/06130000.xhp">Macro</link> dialog where you can select the
macro that is executed when invalid data is entered in a cell. The macro is
executed after the error message is displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/title" id="bm_id3149958"
localize="false"/>
+<paragraph role="paragraph" id="par_id3153160"><ahelp
hid="modules/scalc/ui/erroralerttabpage/browseBtn">Opens the <link
href="text/shared/01/06130000.xhp">Macro</link> dialog where you can select the
macro that is executed when invalid data is entered in a cell. The macro is
executed after the error message is displayed.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/erroralerttabpage/title"
id="bm_id3149958" localize="false"/>
<h3 id="hd_id3153876">Title</h3>
-<paragraph role="paragraph" id="par_id3149410" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/erroralerttabpage/title">Enter the title of the macro or
the error message that you want to display when invalid data is entered in a
cell.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/erroralerttabpage/errorMsg" id="bm_id3153836"
localize="false"/>
+<paragraph role="paragraph" id="par_id3149410"><ahelp
hid="modules/scalc/ui/erroralerttabpage/title">Enter the title of the macro or
the error message that you want to display when invalid data is entered in a
cell.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/erroralerttabpage/errorMsg"
id="bm_id3153836" localize="false"/>
<h3 id="hd_id3154510">Error message</h3>
-<paragraph role="paragraph" id="par_id3149122" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/erroralerttabpage/errorMsg">Enter the message that you
want to display when invalid data is entered in a cell.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149122"><ahelp
hid="modules/scalc/ui/erroralerttabpage/errorMsg">Enter the message that you
want to display when invalid data is entered in a cell.</ahelp></paragraph>
<h3 id="hd_id881545240342781">Sample macro:</h3>
<paragraph role="paragraph" id="par_id521625929022780">Below is a sample
function that can be called when an error occurs. Note that the macro takes in
two parameters that are passed on by %PRODUCTNAME when the function is
called:</paragraph>
<list type="unordered">
@@ -79,5 +78,8 @@
<paragraph role="bascode" localize="false" id="bas_id11625928661345">
ExampleValidity = (iAnswer = IDYES)</paragraph>
<paragraph role="bascode" localize="false" id="par_id971545240220293">End
Function</paragraph>
</bascode>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id91704303891085"
localize="false"><embedvar href="text/scalc/01/12120000.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
