Common questions about WPS Data Validation usually involve rule scope, batch updates, and prompt behavior; this FAQ covers 3 frequent questions.
FAQ
Do Data Validation rules apply to all collaborators?
- Data Validation rules are saved in the current spreadsheet file.
- Other collaborators editing the same cells are subject to the same rules.
- To standardize team input, configure the rules before sharing the file.
How do I batch update an existing Data Validation rule or source?
- Select the cell range that already has Data Validation applied.
- Open the Data Validation dialog box and edit the rule.
- Select Apply these changes to all other cells with the same settings, then confirm the update.
Why do I not see the expected input message or error alert?
- Check whether you entered a title and message on the Input Message or Error Alert tab.
- Make sure the rule was applied to the current cell instead of another range.
- Test both valid and invalid input again to confirm that the prompt behavior matches the rule.
Glossary
| Term | Definition |
|---|---|
| Data Validation | A feature that restricts the type or range of content that can be entered into a cell. |
| Input Message | A prompt shown when a cell is selected to guide users on what to enter. |
| Error Alert | A message shown when entered content does not meet the rule, helping warn or stop invalid input. |