When using WPS Data Validation on iOS, common questions usually involve rule prompts, checking whether a rule is active, and removing rules; this section covers 3 frequent questions.
FAQ
Why do I get a pop-up warning when I enter content?
- Check whether the current cell already has a data validation rule.
- Confirm whether the entered content matches the selected type and condition, such as Integer, Date, or Text Length.
- If you need to allow the current content, return to Data Validation to adjust the rule or clear data validation for that range.
How can I confirm that data validation is working?
- Select the cell or range where you applied the rule.
- Open Tools → Data → Data Validation and check whether the current rule type is displayed.
- Enter a test value that does not meet the rule. If a prompt appears, the rule is active.
Why can’t I edit a cell normally after I clear data validation?
- Confirm that you tapped Clear All and that you cleared the correct selected range.
- Check whether the file is read-only, protected, or limited by collaboration permissions.
- If the issue continues, select the cell again and clear the rule one more time, or check whether another sheet protection setting is still active.
Glossary
| Term | Definition |
|---|---|
| Data Validation | A rule that limits the type, range, or format of content that can be entered into a cell. |
| List | A predefined set of allowed values used to restrict input to specific options. |
| Custom | A user-defined validation rule used for more flexible input control. |