v3.0.0-beta.4

New Features

Filter Rows via SQL 🔎

Filter rows using SQL queries. By Apply Filter, non-matching rows are hidden.
You can also choose other actions:

• Delete Non-Matching Rows
• Delete Matching Rows
• Extract Matching Rows to New Document

To filter rows,

• use Ctrl+Alt+F (macOS: Cmd+Alt+F)
• select Grid > Filter from the menubar
• open the Command Palette (Ctrl+Shift+P or Cmd+Shift+P on macOS) and search for "Filter,"

For SQL specification, see SQL in Row Filter.

Hide/Show Rows/Columns 👀

Hide or show rows/columns via the context menu or Command Palette.
You can also delete all hidden rows/columns.

Move Rows/Columns ↕️

Move rows and columns using the context menu, Command Palette, or keyboard shortcuts:

• Move Row Up: Ctrl+Shift+Alt+Up (macOS: Cmd+Shift+Alt+Up)
• Move Row Down: Ctrl+Shift+Alt+Down (macOS: Cmd+Shift+Alt+Down)
• Move Column Left: Ctrl+Shift+Alt+Left (macOS: Cmd+Shift+Alt+Left)
• Move Column Right: Ctrl+Shift+Alt+Right (macOS: Cmd+Shift+Alt+Right)

Transform to Full-width/Half-width Characters 🔤

Transform selected cells to full-width or half-width characters.

Deduplicate Rows 👯

• Deduplicate rows based on selected columns.
• You can also clear duplicate cells in a selection.

Improvements

Extension Filter on Save (Windows) 💾

You can now filter the extension list in the Save dialog.
The selected extension will be automatically appended to the filename when saving.

Show error message when the file is too large to open

Previously, no rows were shown when opening a very large file (536,870,888 chars+) in Windows.
It will take a while to fix this issue.

Bug Fixes

• Fixed: Error when there is no row/column.
• Disabled auto text substitution on macOS. (Previously, " was automatically replaced with “ on macOS.)

Download

• macOS
• Windows