WPS Data Validation on Android FAQ

Last updated:July 16, 2026

When using WPS Data Validation, the most common questions involve rule setup, rules not taking effect, and removing rules; this FAQ covers 3 common questions and practical answers.

FAQ

Why can I still enter content that does not match the rule after setting data validation?

  1. Make sure you selected the correct cell or range before applying the rule.
  2. Open Tools → Data → Data Validation again and check whether the rule type and condition were fully configured.
  3. Test the target cell again and see whether a warning prompt appears for invalid input.

What rule types are supported in WPS Data Validation?

  1. Open the spreadsheet and select the target cell or range.
  2. Go to Tools → Data → Data Validation.
  3. Review the available types. The current options include Any Value, Integer, Decimal, List, Date, Time, and Text Length.

How do I remove data validation that has already been set?

  1. Select the cell or range that already has a rule.
  2. Go to Tools → Data → Data Validation.
  3. Change the validation type to Any Value, then confirm the setting.

Glossary

TermDefinition
Data ValidationA feature that limits the range, type, or format of content that can be entered into a spreadsheet cell.
ListA preset group of options that lets users choose from fixed entries.
Text LengthA rule type that limits how many characters can be entered into a cell.