What is Computer

Module: M1-R5: Information Technology Tools and Network Basics

Chapter: Ch1 Computer Intro

Introduction

Data Validation in LibreOffice Calc ensures that users enter only valid and predefined data in a cell or range. It helps maintain accuracy, consistency, and reliability of the spreadsheet data.

1️⃣ What is Data Validation?

Data validation restricts the type of data that can be entered into a cell — such as numbers within a range, specific text, or a value from a drop-down list. You can apply validation rules to single or multiple cells.

2️⃣ Steps to Apply Data Validation
  1. Select the cell(s) where you want to apply validation.
  2. Go to Data → Validity.
  3. In the dialog box, choose the Criteria tab.
  4. Select the type of validation (e.g., Whole Number, Decimal, List, etc.).
  5. Set the condition and limit values.
  6. (Optional) Add custom messages in the Input Help and Error Alert tabs.
3️⃣ Types of Data Validation
A. Whole Number Validation

Restricts entry to only whole numbers (no decimals).

Example:
  • Select cell B2.
  • Go to Data → Validity → Criteria.
  • Set Allow: Whole Number
  • Set Data: between → 1 and 100.
  • This ensures only numbers from 1 to 100 can be entered.
B. Decimal Validation

Allows entry of decimal values within a specific range.

Example:
  • In cell C3, allow decimal values between 0.5 and 10.0.
  • Set Allow: Decimal → between 0.5 and 10.0.
C. Date Validation

Ensures that only dates within a certain period can be entered.

Example:
  • In cell D2, restrict dates to the current year.
  • Set Allow: Date → between 01/01/2025 and 31/12/2025.
D. List Validation (Drop-down List)

Creates a drop-down list of predefined choices.

Example:
  • In cell E2, create a list of options — “Yes, No, Maybe”.
  • Go to Data → Validity → Criteria.
  • Set Allow: List
  • Enter items: Yes;No;Maybe
  • Now the cell will show a drop-down list for selection.
E. Text Length Validation

Restricts the number of characters that can be entered in a cell.

Example:
  • In cell F2, set text length to maximum 10 characters.
  • Set Allow: Text Length → less than or equal to 10.
4️⃣ Adding Input Help

The Input Help tab displays a short message when a cell is selected, guiding users on what type of data to enter.

Example: When a user selects cell B2, a small box appears saying: “Enter a number between 1 and 100.”
5️⃣ Adding Error Alerts

The Error Alert tab controls what happens when invalid data is entered. You can choose from:

  • Stop: Rejects invalid data completely.
  • Warning: Displays a message but allows override.
  • Information: Shows a message for awareness only.
6️⃣ Example Table – Data Validation Summary
Validation Type Condition Example Cell Allowed Input
Whole Number Between 1 and 100 B2 45 ✅, 150 ❌
Decimal Between 0.5 and 10.0 C3 5.6 ✅, 12.3 ❌
Date Between 01/01/2025 and 31/12/2025 D2 15/07/2025 ✅, 02/03/2024 ❌
List Yes;No;Maybe E2 Yes ✅, Ok ❌
Text Length ≤ 10 characters F2 “WebTech” ✅, “LibreOfficeCalc” ❌
Conclusion

Data Validation in LibreOffice Calc enhances data quality and prevents incorrect entries. By combining validation rules, input help, and error alerts, you can make your spreadsheet user-friendly and error-free.

O Level Modules

Quick Links