How to Add Numeric Data Validation in Calc Spreadsheet

This tutorial will explain the basics of numeric data validation in LibreOffice Calc worksheet.

Calc provides various ways of data validation in worksheet cells – numeric validation, range validation etc. When a worksheet is used to receive input data from users, data validation can be used to restrict user from invalid data input. Lets see how can it be done in Calc.

Validation

I have a worksheet where I want to restrict user to input any number from 1 to 10 only.

Go to Input Help tab and enter the message you want to show to user when the cell is selected. The message would be shown as popup when the cell is selected by user.

Go to next tab Error Alert and put the message which can be shown as popup error message to the user. You can opt it out by checking off the option – ‘Show error message when invalid values are entered’.

Press OK once all the options are set. Now click the cell, you can see the popup message which set in Input Help tab:

Now, if you try to enter any value e.g. 20 which is invalid as per the Min and Max we have set in Criteria tab, the popup message box would be displayed:

This is the way you can input proper accepted values in Calc spreadsheet.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 69 other subscribers.

Email Address

This website is not related to LibreOffice OR LibreOffice official guide. You can visit the LibreOffice official site here and forum here. LibreOffice and related names/logos are registered trademark of their respective owners.