Filter in Spreadsheet in WPS on iOS FAQ

Last updated:July 24, 2026

When using Filter in Spreadsheet, the most common questions focus on condition logic, data safety, and shared visibility; this FAQ includes 3 common answers.

FAQ

Are multiple filter conditions treated as AND or OR?

  1. After adding two or more filter rules, check the condition combination setting.
  2. Choose All Conditions when a record must meet every rule.
  3. Choose Any Condition when a record only needs to meet one rule to appear.

Does filtering delete data?

  1. Filtering only changes what is currently shown.
  2. Hidden rows still remain in the original data table.
  3. When you remove or adjust the filter, you can view the full data again.

Are filter conditions in a shared view visible to other people?

  1. When you set filter conditions in a shared data table, collaborators can see those conditions.
  2. If you want everyone to review the same result, confirm the rules before sharing.
  3. Before collaboration, explain the current filter logic so everyone understands the visible data range.

Glossary

TermDefinition
Filter conditionA rule that decides which records remain visible in the current data table.
All ConditionsA multi-rule setting where a record must satisfy every rule to appear.
Any ConditionA multi-rule setting where a record appears if it satisfies at least one rule.