diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2005-03-08 14:05:03 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2005-03-08 14:05:03 +0000 |
| commit | 330f710feb2cf4c7bcc658467818ccebcaf5d643 (patch) | |
| tree | 3c680b66bfdcd2c0785915ee6e8c1badf041151f /helpcontent2/source/text/scalc | |
| parent | 7657d9c12eb28b1acf99a636e02d09edf5d58a9b (diff) | |
INTEGRATION: CWS hc680pb2 (1.2.32); FILE MERGED
2005/02/03 12:20:20 fpe 1.2.32.1: regular update
Diffstat (limited to 'helpcontent2/source/text/scalc')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/validity.xhp | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/helpcontent2/source/text/scalc/guide/validity.xhp b/helpcontent2/source/text/scalc/guide/validity.xhp index d88bf7ce06..065801cfe2 100755 --- a/helpcontent2/source/text/scalc/guide/validity.xhp +++ b/helpcontent2/source/text/scalc/guide/validity.xhp @@ -37,8 +37,8 @@ * License at http://www.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS, + * 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. @@ -62,14 +62,14 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-08-16T13:25:56">converted from old format - fpe</lastedited> +<lastedited date="2005-02-01T09:43:47">converted from old format - fpe</lastedited> </history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3156442"><bookmark_value>values; limiting on input</bookmark_value> <bookmark_value>limiting values; specifying on input</bookmark_value> <bookmark_value>permitted cell contents</bookmark_value> -<bookmark_value>checking for validity</bookmark_value> +<bookmark_value>data validity</bookmark_value> <bookmark_value>validity</bookmark_value> <bookmark_value>cells; validity</bookmark_value> <bookmark_value>error messages; defining for incorrect input</bookmark_value> @@ -85,6 +85,7 @@ <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> |