Filter in Spreadsheet in WPS on Android FAQ

Last updated:July 23, 2026

Common questions about spreadsheet filtering usually focus on condition logic, data safety, and shared visibility; this FAQ covers 3 frequent questions and a short glossary.

FAQ

Do multiple filter conditions use AND or OR logic?

  1. Open the filter panel and review the conditions you added.
  2. If you choose All Conditions, a record must meet every rule.
  3. If you choose Any Condition, a record only needs to meet one rule to remain visible.

Does filtering delete or change the original data?

  1. Filtering changes only the current display.
  2. Rows that do not match the conditions are temporarily hidden, not deleted.
  3. After you clear the filter, the full dataset becomes visible again.

Can other people see filter conditions in a shared view?

  1. After you apply filters in a shared data table, confirm that the current view is being used for collaboration.
  2. Filter conditions in a shared view are visible to collaborators.
  3. If needed, communicate the purpose of the current filter before you continue.

Glossary

TermDefinition
Filter conditionA rule that decides which records remain visible based on a selected field and matching logic.
All ConditionsA relationship between multiple rules where a record must satisfy every condition.
Any ConditionA relationship between multiple rules where a record only needs to satisfy one condition.