#i10000# Undo CWS integration hc680fin

1 files changed, 39 insertions, 55 deletions

diff --git a/helpcontent2/source/text/scalc/guide/validity.xhp b/helpcontent2/source/text/scalc/guide/validity.xhp
index 35abc5df84..3282a25c27 100755
--- a/helpcontent2/source/text/scalc/guide/validity.xhp
+++ b/helpcontent2/source/text/scalc/guide/validity.xhp
@@ -1,56 +1,36 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <!--***********************************************************************
  *
- *  The Contents of this file are made available subject to the terms of
- *  either of the following licenses
+ *  OpenOffice.org - a multi-platform office productivity suite
  *
- *         - GNU Lesser General Public License Version 2.1
- *         - Sun Industry Standards Source License Version 1.1
+ *  $RCSfile: validity.xhp,v $
  *
- *  Sun Microsystems Inc., October, 2000
+ *  $Revision: 1.6 $
  *
- *  GNU Lesser General Public License Version 2.1
- *  =============================================
- *  Copyright 2000 by Sun Microsystems, Inc.
- *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *  last change: $Author: obo $ $Date: 2006-03-28 13:29:05 $
  *
- *  This library is free software; you can redistribute it and/or
- *  modify it under the terms of the GNU Lesser General Public
- *  License version 2.1, as published by the Free Software Foundation.
+ *  The Contents of this file are made available subject to
+ *  the terms of GNU Lesser General Public License Version 2.1.
  *
- *  This library is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
- *  Lesser General Public License for more details.
  *
- *  You should have received a copy of the GNU Lesser General Public
- *  License along with this library; if not, write to the Free Software
- *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
- *  MA  02111-1307  USA
+ *    GNU Lesser General Public License Version 2.1
+ *    =============================================
+ *    Copyright 2005 by Sun Microsystems, Inc.
+ *    901 San Antonio Road, Palo Alto, CA 94303, USA
  *
+ *    This library is free software; you can redistribute it and/or
+ *    modify it under the terms of the GNU Lesser General Public
+ *    License version 2.1, as published by the Free Software Foundation.
  *
- *  Sun Industry Standards Source License Version 1.1
- *  =================================================
- *  The contents of this file are subject to the Sun Industry Standards
- *  Source License Version 1.1 (the "License"); You may not use this file
- *  except in compliance with the License. You may obtain a copy of the
- *  License at http://www.openoffice.org/license.html.
- *
- *  Software provided under this License is provided on an "AS IS" basis,
- *  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
- *  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
- *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
- *  See the License for the specific provisions governing your rights and
- *  obligations concerning the Software.
- *
- *  The Initial Developer of the Original Code is: Sun Microsystems, Inc..
- *
- *  Copyright: 2000 by Sun Microsystems, Inc.
- *
- *  All Rights Reserved.
- *
- *  Contributor(s): _______________________________________
+ *    This library is distributed in the hope that it will be useful,
+ *    but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *    Lesser General Public License for more details.
  *
+ *    You should have received a copy of the GNU Lesser General Public
+ *    License along with this library; if not, write to the Free Software
+ *    Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *    MA  02111-1307  USA
  *
  ************************************************************************-->
 	
@@ -62,7 +42,7 @@
 </topic>
 <history>
 <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2005-10-14T11:12:31">converted from old format - fpe</lastedited>
+<lastedited date="2005-02-01T09:43:47">converted from old format - fpe</lastedited>
 </history>
 </meta>
 <body>
@@ -82,32 +62,36 @@
 </bookmark>
 <paragraph role="heading" id="hd_id3156442" xml-lang="en-US" level="1" l10n="U" oldref="22"><variable id="validity"><link href="text/scalc/guide/validity.xhp" name="Validity of Cell Contents">Validity of Cell Contents</link>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="2">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" l10n="U" oldref="3">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" l10n="NEW">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="paragraph" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="2">For each cell, you can define in advance what type of contents is valid for that cell. This allows you to guide users through data entry in $[officename] Calc by restricting cells to receive specific values and ranges.</paragraph>
+<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US" l10n="U" oldref="3">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. 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="paragraph" id="par_id3154016" xml-lang="en-US" l10n="U" oldref="4">Additional details about <link href="text/scalc/01/12120000.xhp" name="data validity">data validity</link> can be found in the $[officename] Help.</paragraph>
+<paragraph role="tip" id="par_idN10776" xml-lang="en-US" l10n="NEW">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.</paragraph>
 <paragraph role="heading" id="hd_id3155603" xml-lang="en-US" level="2" l10n="U" oldref="5">Using Cell Contents Validity</paragraph>
 <list type="ordered">
 <listitem>
-<paragraph role="paragraph" id="par_id3155959" xml-lang="en-US" l10n="U" oldref="6">Select the cells for which you want to define a new validity rule.</paragraph>
+<paragraph role="paragraph" id="par_id3155959" xml-lang="en-US" l10n="U" oldref="6">Select the cells for which you want to define a new validity rule. You can select multiple cells by clicking on all the cells while holding down the <item type="keycode">Ctrl</item> key.</paragraph>
+<paragraph role="note" id="par_id3149530" xml-lang="en-US" l10n="U" oldref="7">The validity rule is a component of the cell format. To copy the validity rule to other cells, choose <item type="menuitem">Edit - Copy</item> and <item type="menuitem">Edit - Paste Special</item>, and select "Formats."</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_id3148837" xml-lang="en-US" l10n="U" oldref="8">Choose <item type="menuitem">Data - Validity</item>. The <emph>Validity</emph> dialog appears.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3148837" xml-lang="en-US" l10n="U" oldref="8">Choose <item type="menuitem">Data - Validity</item>. </paragraph>
+<paragraph role="paragraph" id="par_id3156020" xml-lang="en-US" l10n="U" oldref="9">On the <emph>Criteria</emph> tab page, enter the conditions for new values entered into cells. Values you have already entered will not be affected.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3156020" xml-lang="en-US" l10n="U" oldref="9">On the <emph>Criteria</emph> tab page, enter the conditions for new values entered into cells. </paragraph>
+<paragraph role="paragraph" id="par_id3159208" xml-lang="en-US" l10n="U" oldref="10">In the <emph>Allow</emph> field, "All Values" is selected by default. To place a condition on a cell entry, choose from one of the other options listed.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3159208" xml-lang="en-US" l10n="U" oldref="10">In the <emph>Allow</emph> field, select an option.</paragraph>
+<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US" l10n="U" oldref="11">This choice already sets the first condition. If you choose "Whole Numbers", values such as "12.5" are not allowed, even if they satisfy the other conditions. 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>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US" l10n="U" oldref="11">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_id9224829" xml-lang="en-US" l10n="NEW">Select "List" to enter a list of valid entries.</paragraph>
+<paragraph role="paragraph" id="par_id3149317" xml-lang="en-US" l10n="U" oldref="13">After you have set the first condition under <emph>Allow</emph>, select the next condition under <emph>Data</emph>. According to what you choose, additional text fields (<emph>Value</emph>, <emph>Minimum </emph>and <emph>Maximum</emph>) may appear to further refine the condition.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3149317" xml-lang="en-US" l10n="U" oldref="13">Select the next condition under <emph>Data</emph>. According to what you choose, additional options will be selectable.</paragraph>
+<paragraph role="paragraph" id="par_id3153334" xml-lang="en-US" l10n="U" oldref="14">A few possible conditions resulting from this register could be as follows: "Integer greater than 1", "Decimal between 10 and 12.5", "Date earlier than or equal to 1/1/2000", "Time not equal to 00:00", "Text with a length of more than 2 characters".</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3151389" xml-lang="en-US" l10n="U" oldref="15">After you have determined the conditions for cell validity, you can use the other two tab pages to create message boxes:</paragraph>
+<paragraph role="paragraph" id="par_id3151389" xml-lang="en-US" l10n="U" oldref="15">After you have determined the conditions for cell validity, you can use the other two tabs in the dialog to create input help and error/invalid entry messages:</paragraph>
 <list type="unordered">
 <listitem>
 <paragraph role="listitem" id="par_id3159261" xml-lang="en-US" l10n="U" oldref="16">On the <emph>Input Help</emph> tab page, enter the title and the text of the tip, which will then be displayed if the cell is selected.</paragraph>
@@ -115,11 +99,11 @@
 <listitem>
 <paragraph role="listitem" id="par_id3156396" xml-lang="en-US" l10n="U" oldref="17">On the <emph>Error Alert</emph> tab page, select the action to be carried out in the event of an error.</paragraph>
 <paragraph role="listitem" id="par_id3147416" xml-lang="en-US" l10n="U" oldref="18">If you select "Stop" as the action, invalid entries are not accepted, and the previous cell contents are retained.</paragraph>
-<paragraph role="listitem" id="par_id3150033" xml-lang="en-US" l10n="U" oldref="19">Select "Warning" or "Information" to display a dialog in which the entry can either be canceled or accepted.</paragraph>
+<paragraph role="listitem" id="par_id3150033" xml-lang="en-US" l10n="U" oldref="19">Select "Warning" or "Information" to display a dialog in which the entry can either be canceled (the cell value will be retained) or accepted (even if the new value violates the validity rule).</paragraph>
 <paragraph role="listitem" id="par_id3149947" xml-lang="en-US" l10n="U" oldref="20">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" l10n="U" oldref="35">To display the error message, select <emph>Show error message when invalid values are entered</emph>. </paragraph>
+<paragraph role="paragraph" id="par_id3149011" xml-lang="en-US" l10n="U" oldref="35">To display the error message, mark the <emph>Show error message when invalid values are entered</emph>. If the option is unmarked, no error message will be displayed, even with an invalid entry.</paragraph>
 <embed href="text/scalc/01/12120300.xhp#examplemakro"/>
 <paragraph role="note" id="par_id3148586" xml-lang="en-US" l10n="U" oldref="21">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">