From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/guide/validity.xhp | 93 +++++++++++++++++++++++ 1 file changed, 93 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/validity.xhp (limited to 'helpcontent2/source/text/scalc/guide/validity.xhp') diff --git a/helpcontent2/source/text/scalc/guide/validity.xhp b/helpcontent2/source/text/scalc/guide/validity.xhp new file mode 100644 index 000000000..76d5eb8ec --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/validity.xhp @@ -0,0 +1,93 @@ + + + + + + + + + +Validity of Cell Contents +/text/scalc/guide/validity.xhp + + +Sun Microsystems, Inc. + + + +values; limiting on input +limits; specifying value limits on input +permitted cell contents +data validity +validity +cells; validity +error messages; defining for incorrect input +actions in case of incorrect input +Help tips; defining text for cell input +comments;help text for cells +cells; defining input help +macros; running when incorrect input +data; validity check +mw changed "limit...;" +Validity of Cell Contents + +For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected. +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 Tools - Detective at any time and choose the command Mark Invalid Data to display which cells contain invalid values. +Using Cell Contents Validity + + +Select the cells for which you want to define a new validity rule. + + +Choose Data - Validity. + + +On the Criteria tab page, enter the conditions for new values entered into cells. + + +In the Allow field, select an option. + + +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 serial date. 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. +Select "List" to enter a list of valid entries. + + +Select the next condition under Data. According to what you choose, additional options will be selectable. + + +After you have determined the conditions for cell validity, you can use the other two tab pages to create message boxes: + + +On the Input Help tab page, enter the title and the text of the tip, which will then be displayed if the cell is selected. + + +On the Error Alert tab page, select the action to be carried out in the event of an error. +If you select "Stop" as the action, invalid entries are not accepted, and the previous cell contents are retained. +Select "Warning" or "Information" to display a dialog in which the entry can either be canceled or accepted. +If you select "Macro", then by using the Browse button you can specify a macro to be run in the event of an error. + + +To display the error message, select Show error message when invalid values are entered. +After changing the action for a cell on the Error Alert tab page and closing the dialog with OK, you must first select another cell before the change takes effect. +
+Data - Validity +
+ + -- cgit v1.2.3