Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 53 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 53

    Step 4  Select the type of data  you want  to allow in the selected cells from the  Allow
                              drop-down list. The available options are:

                                  All values: No restrictions on data entry.
                                  Whole Numbers: Only integers are allowed.

                                  Decimal: Allows decimal numbers.
                                  Date: Restricts input to date format.

                                  Time: Restricts input to time format.
                                  Cell range: Defines a specific range for data entry.
                                  List: Select from predefined values.

                                  Text length: Limits the number of characters.
                              In our case, we have selected Whole Numbers option in the Allow drop-down list.

                     Step 5   Select how you want to restrict the data under the Data drop-down list. The available
                              options are:
                                  equal: Limits data to a specific value.

                                  less than: Allows values less than a specified number.
                                  greater than: Allows values greater than a specified number.

                                  less than or equal to: Allows values less than or equal to a specified number.
                                  greater than or equal to: Allows values greater than or equal to a specified number.
                                  not equal: Restricts values from a specific value.

                                   valid range: Allows you to restrict the entry to values within a specified range.
                                   invalid range: Specifies that the entered data must not fall within a particular range.

                              In our case, we have selected the valid range option from the Data drop-down list.
                     Step 6  Type 1 in the Minimum text box and 30 in the Maximum text box.

                     Step 7  Click on the OK button.

                     The selected column will now only accept data that meets the specified criteria, ensuring correct
                     data entry. Now, if you enter a quantity less than one or greater than thirty, an error message
                     will appear, as shown.

                                                                                            Using Calc as Database       51

| 48 49 50 51 52 53 54 55 56 57 58 |