sort-and-filter-calc-tables

name	Sort and Filter Calc Tables
description	Apply sorts, auto-filters, and range filters to Calc tables and verify the visible filtered rows or ordering on the sheet.

Sort and Filter Calc Tables

When This Skill Applies

• Use when the task asks to sort, filter, or exclude values from a table.
• Use when the main result is the visible ordering or filtered subset of a worksheet table.

Preconditions

• The target table is visible or selected.
• The requested sort key or filter values are known.

Procedure

1. Use when the task asks to sort, filter, or exclude values from a table.
2. These are table-filtering tasks.
3. Check the final visible Calc state and confirm the task-specific result is actually present.

Visual State Card Usage

• Detailed review cards live in state_cards.json.
• Runtime-facing cards live in runtime_state_cards.json.
• Load only the state whose screenshot actually matches the live Calc surface.
• Image references in this package:
  • Images/data_menu_autofilter.jpg
  • Images/data_menu_autofilter_after.jpg
  • Images/data_menu_autofilter_focus_crop.jpg
  • Images/filtered_table_result.jpg
  • Images/filtered_table_result_focus_crop.jpg
  • Images/header_filter_controls_visible.jpg
  • Images/header_filter_controls_visible_after.jpg
  • Images/header_filter_controls_visible_focus_crop.jpg

Common Failure Modes

• Filtering the wrong range or wrong column.
• Assuming the filter was applied without checking the visible table subset.