Data Validation in LibreOffice Calc Worksheet

Data Validation in Calc

Data validation is a feature that defines restriction on what data can or should be entered in a cell. For example, you could use data validation to make sure a value is a number between 20 and 50, make sure a text entry is less than 10 characters. It facilitates you to stop invalid user input. Through data validation you can restrict the user to choose predefined words in a dropdown menu.

Step for data Validation-

1. Write the column on you spreadsheet as Employee ID, Name of employee, Age of employee and Department.
2. Select the column Age of employee> Click on Data menu & Click on validity.
3. In validity dialog box click on Criteria> Allow whole Number> Click on Data and selected valid range.
4. Below data you can defined Minimum range as 25 and Maximum range as 45 & Click on ok button.
5. You can selected Department Column> Data Menu > Validity> Criteria> Selected List> enter the name of Department as Purchase, Sales etc. Which will reflect in dropdown list. You can select the department of employee. If the employee is sales department selected sales from drop-down list.

After validation of data your system will not accept invalid data for example if you will enter 20 in age column, system will not accept this data because you already restrict Age of employees between 25 and 45.