diff options
Diffstat (limited to 'source/text/scalc/01/06030800.xhp')
-rw-r--r-- | source/text/scalc/01/06030800.xhp | 31 |
1 files changed, 15 insertions, 16 deletions
diff --git a/source/text/scalc/01/06030800.xhp b/source/text/scalc/01/06030800.xhp index 27710674ce..a109848ae1 100644 --- a/source/text/scalc/01/06030800.xhp +++ b/source/text/scalc/01/06030800.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="textscalc0106030800xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Mark Invalid Data</title> +<title id="tit">Mark Invalid Data</title> <filename>/text/scalc/01/06030800.xhp</filename> </topic> <history> @@ -30,17 +27,19 @@ </history> </meta> <body> - - - <section id="mark_invalid_data"> - <bookmark branch="index" xml-lang="en-US" id="bm_id3153821"><bookmark_value>cells; invalid data</bookmark_value><bookmark_value>data; showing invalid data</bookmark_value><bookmark_value>invalid data;marking</bookmark_value></bookmark> -<bookmark branch="hid/.uno:ShowInvalid" xml-lang="en-US" id="bm_id3157909" localize="false"/> -<h1 id="hd_id3153821"><link href="text/scalc/01/06030800.xhp">Mark Invalid Data</link></h1> - <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp hid=".uno:ShowInvalid" visibility="visible">Marks all cells in the sheet that contain values outside the validation rules.</ahelp></paragraph> - </section> - <section id="howtoget"> - <embed href="text/scalc/00/00000406.xhp#dateneinkreisen"/> +<bookmark branch="index" id="bm_id3153821"><bookmark_value>cells; invalid data</bookmark_value><bookmark_value>data; showing invalid data</bookmark_value><bookmark_value>invalid data;marking</bookmark_value></bookmark> +<bookmark branch="hid/.uno:ShowInvalid" id="bm_id3157909" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuTools-ShowInvalid" id="bm_id151704580056032" localize="false"/> +<section id="mark_invalid_data"> + <h1 id="hd_id3153821"><link href="text/scalc/01/06030800.xhp">Mark Invalid Data</link></h1> + <paragraph role="paragraph" id="par_id3147264"><ahelp hid=".uno:ShowInvalid" visibility="visible">Marks all cells in the sheet that contain values outside the validation rules.</ahelp></paragraph> </section> - <paragraph xml-lang="en-US" role="paragraph" id="par_id3151211">The <link href="text/scalc/01/12120000.xhp">validity rules</link> restrict the input of numbers, dates, time values and text to certain values. However, it is possible to enter invalid values or copy invalid values into the cells if the <emph>Stop</emph> option is not selected. When you assign a validity rule, existing values in a cell will not be modified.</paragraph> - </body> +<section id="howtoget"> + <embed href="text/scalc/00/00000406.xhp#mark_invalid_data"/> +</section> +<paragraph role="paragraph" id="par_id3151211">The <link href="text/scalc/01/12120000.xhp">validity rules</link> restrict the input of numbers, dates, time values and text to certain values. However, it is possible to enter invalid values or copy invalid values into the cells if the <emph>Stop</emph> option is not selected. When you assign a validity rule, existing values in a cell will not be modified.</paragraph> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id821704581444268" localize="false"><embedvar href="text/scalc/01/06030000.xhp#h1" markup="ignore"/></paragraph> +</section> +</body> </helpdocument> |