diff options
Diffstat (limited to 'source/text/scalc/guide/validity.xhp')
-rw-r--r-- | source/text/scalc/guide/validity.xhp | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/source/text/scalc/guide/validity.xhp b/source/text/scalc/guide/validity.xhp index 76d5eb8ec8..6f6e6f1332 100644 --- a/source/text/scalc/guide/validity.xhp +++ b/source/text/scalc/guide/validity.xhp @@ -45,11 +45,11 @@ <bookmark_value>macros; running when incorrect input</bookmark_value> <bookmark_value>data; validity check</bookmark_value> </bookmark><comment>mw changed "limit...;"</comment> -<paragraph role="heading" id="hd_id3156442" xml-lang="en-US" level="1"><variable id="validity"><link href="text/scalc/guide/validity.xhp" name="Validity of Cell Contents">Validity of Cell Contents</link> +<paragraph role="heading" id="hd_id3156442" xml-lang="en-US" level="1"><variable id="validity"><link href="text/scalc/guide/validity.xhp">Validity of Cell Contents</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3156283" xml-lang="en-US">For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected.</paragraph> <paragraph role="warning" id="par_id3145252" xml-lang="en-US">The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule will not take effect.</paragraph> -<paragraph role="note" id="par_id5174718" xml-lang="en-US">You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href="text/scalc/01/06030800.xhp" name="Mark Invalid Data"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values.</paragraph> +<paragraph role="note" id="par_id5174718" xml-lang="en-US">You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href="text/scalc/01/06030800.xhp"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values.</paragraph> <paragraph role="heading" id="hd_id3155603" xml-lang="en-US" level="2">Using Cell Contents Validity</paragraph> <list type="ordered"> <listitem> @@ -65,7 +65,7 @@ <paragraph role="paragraph" id="par_id3159208" xml-lang="en-US">In the <emph>Allow</emph> field, select an option.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US">If you select "Whole Numbers", values such as "12.5" are not allowed. Choosing "Date" allows date information both in the local date format as well as in the form of a <link href="text/sbasic/shared/03030101.xhp" name="serial date">serial date</link>. Similarly, the "Time" condition permits time values such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to contain text only.</paragraph> +<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US">If you select "Whole Numbers", values such as "12.5" are not allowed. Choosing "Date" allows date information both in the local date format as well as in the form of a <link href="text/sbasic/shared/03030101.xhp">serial date</link>. Similarly, the "Time" condition permits time values such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to contain text only.</paragraph> <paragraph role="paragraph" id="par_id9224829" xml-lang="en-US">Select "List" to enter a list of valid entries.</paragraph> </listitem> <listitem> @@ -84,10 +84,10 @@ <paragraph role="listitem" id="par_id3149947" xml-lang="en-US">If you select "Macro", then by using the <emph>Browse</emph> button you can specify a macro to be run in the event of an error.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3149011" xml-lang="en-US">To display the error message, select <link href="text/scalc/01/12120300.xhp" name="erroralert">Show error message when invalid values are entered</link>.</paragraph> +<paragraph role="paragraph" id="par_id3149011" xml-lang="en-US">To display the error message, select <link href="text/scalc/01/12120300.xhp">Show error message when invalid values are entered</link>.</paragraph> <paragraph role="note" id="par_id3148586" xml-lang="en-US">After changing the action for a cell on the <emph>Error Alert</emph> tab page and closing the dialog with OK, you must first select another cell before the change takes effect.</paragraph> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3154805" xml-lang="en-US"><link href="text/scalc/01/12120000.xhp" name="Data - Validity">Data - Validity</link></paragraph> +<paragraph role="paragraph" id="par_id3154805" xml-lang="en-US"><link href="text/scalc/01/12120000.xhp">Data - Validity</link></paragraph> </section> </body> </helpdocument> |