v3.25.0

New Features

Copy with Options 📋

Copy a selection in the format you need: a Markdown table, a JSON array, SQL INSERT statements. Press Option+Cmd+C (Ctrl+Alt+C on Windows and Linux) to pick a format and tune it, with the preview updating as you go.

Save a setup as a preset to run it from the Copy As menu under your own name. The dialog otherwise opens on your last copy.

Related issues: #236

Fill Blanks Down ⬇️

Select a range and run Fill Blanks Down to give every empty cell the value of the nearest filled cell above it. Key columns written once per group, as in a pivot table export, become a value on every row, ready to sort and filter.

Related issues: #251

See the Spaces You Can't See ␣

HMA looks exactly like HMA. Turn on View › Toggle Render Whitespace and every blank gets a dot: trailing padding, doubled spaces, a full-width space from a Japanese source.

Set gridEditor.renderWhitespace to boundary to leave single spaces between words unmarked.

Related issues: #248

Improvements

• Reaching tabs that don't fit - The mouse wheel scrolls the tab bar sideways, and a button at its right end lists every open editor. (#256)
• Pinch to Zoom - Pinching on a trackpad now zooms the window, alongside Ctrl (Cmd on macOS) + mouse wheel. Enable it under Settings › Window › Mouse Wheel Zoom. (#255)
• Quit when all windows are closed (macOS) - Turn on window.quitWhenAllWindowsClosed in Settings to have SmoothCSV quit with its last window instead of staying in the Dock. (#250)
• Lighter and smoother on large files - Filtering or hiding rows in a large file uses tens of megabytes less memory, dragging a column border stays responsive over millions of rows, and scrolling a word-wrapped grid costs up to a third less per frame.
• Copy As formats - Column names now come from the header rows (c1, c2, ... when there are none) instead of the first selected row, JSON keys and SQL column lists are always unique, SQL values and identifiers are escaped, and the SQL table name follows the file name.
• The column menu closes after acting - A direct sort or column filter change now closes the menu, keeping the result in view.
• Richer SQL result grid - The result grid opens the same context menus as a CSV grid, including the row and column number menus. PgUp / PgDn scroll a screenful, and with Shift extend the selection.
• More of the app works in the Record View - Transform and Paste As act on the fields you selected, and Copy As copies them with their field names as the header row. Row and column commands leave its menus, since a record has fields instead. Click the grid to bring them back.
• Paste As fills the selection - A single pasted value now fills the whole selection, matching plain paste.
• Select to the start or end of the text anywhere - Ctrl+Shift+Home / Ctrl+Shift+End (Cmd+Shift+Up / Cmd+Shift+Down on macOS) extend the selection in every text field, including the SQL Console and the Cell Value panel. They previously worked only in a cell editor.
• Reopening a file picks up where you left off - Reopening a file in the same window restores the column widths and row heights you had set, along with the scroll position and selected cells.

Bug Fixes

• Fixed the editor being replaced by an "Editor Error" screen when editing a cell highlighted by a search. (#254)
• Fixed Mouse Wheel Zoom being far too sensitive on a trackpad, where a single gesture ran through the whole zoom range. Zooming no longer scrolls the grid at the same time. (#255)
• Fixed a file's creation date being reset each time the file was saved. (#262)
• Fixed the SQL Console failing with "Wrong number of parameters passed to query" on files whose rows have different numbers of cells, such as a file with a blank line in the middle. Cells a short row does not have are loaded as NULL. (#257)
• Fixed commands acting on the pane the app considered active instead of the one whose menu or shortcut you used, with the editor split or in the Compare editor, Record View and SQL results.
• Fixed unsaved changes being discarded when SmoothCSV was quit from outside the app on macOS, such as from the Dock or by AppleScript. It now prompts as the Quit menu item does, and a window that refuses stops the quit.
• Fixed actions on whole-row and whole-column selections also affecting hidden rows or columns.
• Fixed unquoted cells containing only whitespace being emptied when opening a file or pasting.
• Fixed the first click after closing a context menu on macOS selecting a cell but leaving the keyboard behind, with the view you clicked dimmed.
• Fixed selection and page keys ignoring the first keystroke in a grid.
• Fixed undo and redo not scrolling an off-screen change back into view.
• Fixed right-clicking handing the keyboard to a grid you did not click. Closing the menu leaves you where you opened it.
• Fixed Page Up / Page Down doing nothing when the grid could not scroll any further. They now move the selection to the first or last row.
• Fixed a setting being discarded when the settings tab was closed right after changing it, and rapid changes being dropped, which lost zoom steps when a zoom shortcut was held down.
• Fixed cells whose value begins with whitespace followed by a quote losing their quotes when copied, and manual quote mode corrupting such rows so the cell merged with its neighbours when pasted back.
• Fixed space-delimited files with quoted values failing to open: rows were cut short, or the whole file fell back to being read as if it had no quotes.
• Fixed column menu filters being ignored when the filter bar contained an error.
• Fixed the window being restored to a saved position that only overlapped the Dock or taskbar. Such a position falls back to the default placement.
• Fixed the app sometimes treating the window you had just switched away from as the active one, sending a file opened from Finder to the wrong window and saving that window's size and position.
• Fixed SmoothCSV failing to start on Linux systems without desktop-file-utils installed. The Deb, RPM, and AUR packages now require it, and failing to register smoothcsv:// links no longer stops the app from opening.
• Fixed F2 reaching past the panel it was pressed in: it did nothing while editing a cell in the Cell Value panel, and toggled edit mode on the grid behind the Record View.
• Fixed user-defined keybindings losing to default bindings for the same shortcut.
• Fixed menus naming a keyboard shortcut that this build never triggers while hiding the one that does, and losing a command's shortcut after you rebound it.
• Fixed a -command entry in your keybindings removing only one matching default. It now removes every default it covers, so removals you made in an earlier version keep working.
• Fixed the Copy As and Paste As messages appearing in English when another display language was selected.
• Other minor bug fixes and improvements.

Download

Download page