Version 1.0.14 — June 23, 2026 Computed Columns & Formula Editor - Many new functions: CUMSUM, CUMSUM_GROUP, PREV, ROW, FIRSTROW, LASTROW, PRORATA, PRORATA_GROUP, TOTAL, GROUP_TOTAL, PERCENT_TOTAL, PERCENT_GROUP, ROLLUP, COL, GET, REJOIN, REVERSE, REVERSE_JOIN, ALPHA, NUMERIC, PERCHANGE, CURRENCY, ISEQUAL, SLUGIFY, DESLUGIFY - NAME() enhancements: first_last, last_first, complete_name, and phonetic variants - RAW(col) — returns raw underlying value of a column - Shorthand syntax: = means ==, <> means !=; leading-operator shorthand (e.g. > 3); A IF > 3 conditional shorthand - Integer range syntax in argument lists: 2:5 expands to 2,3,4,5 - Structural keyword splitting — typing IF, ELSE, etc. splits the formula field into sub-fields automatically - Inline signature help bar replaces floating overlay - Formula completion improvements: string choices, column param hints, variables listed first with smart preselection - Constants section driven by dataset-level definitions with AppSettings defaults - F9 / Recompute Now command to force recomputation of all computed columns Performance - Skip full summary rebuild when opening/closing ComputePanel - Column-level summary cache invalidation on computed column upserts - Eliminated async hops from formula editor focus path - Coalesced redundant refreshStats calls via task cancellation View Settings - Currency & timezone locale preferences (Phase 2) - Error/blank sort placement — control whether errors sort first, last, or with blanks - Bookmark category label overrides — rename bookmark colors without changing defaults - Spreadsheet App / Text Editor App pickers in View Settings (Advanced) - Settings storage and drift indicator now work correctly across panel open/close Copy & Selection - Copy Headers setting wired to ⌘C / ⌘⌥C — takes effect immediately - File > New Table from > Copy selected columns (⌘⌃C) - Copy Frequency / Distribution Table from Column Summary panel - Column copy now respects selection order; fixed column-mode vs. row-mode copy restrictions - Column Summary panel numbers formatted with user display preferences Lookup, Join & Combine - Lookup filter toggle — show only matching rows from lookup - Second ⌘L fills the remote tab from current selection - Lookup column highlights: source columns (blue) and match columns (purple) - Lookup column header icon + Edit Lookup footer button - Join panel is now multi-column aware - Combined Columns section with key/include toggles Insert Panel (new) - Paste Columns — new Insert Panel for inserting columns from another dataset - Row insertion mode with match-by-name or sequential placement - matchAll / ignoreExtra toggles; Enter key inserts; align-with prefers name match Split Table Panel - Restructured SplitTablePanel UI with working highlights and execution External App Integration - File > External menu — open current dataset in another app - App pickers for Spreadsheet App and Text Editor App (enumerate by UTI) - Detects web-downloaded files via "Where From" xattr on open - File > Import launches SummerDB.app (disabled when not installed) Filtering - String choices filter as you type in unquoted param fields - Boolean columns: Show True / Show False tri-state quick filter - Tri-state lookup filter: matches / non-matches / clear - Set filter None/invert/paste buttons respect current filter list Column Formatting & Display - Unified ctrl-, format cycling across types; ctrl-0 decimal toggle; ctrl-3 date/integer toggle - Date cycle (ctrl-3) now includes Time: Date → DateTime → Time → Date - Pill labels improvements — type/raw pills, min-width, percentage 3-state - Per-column format changes now correctly update column widths Bookmarks - Previous / next bookmark navigation in Bookmarks panel header - clearBookmarks() and opt-F2 hotkeys - Bookmark labels load from AppSettings; changes take effect without "Set as Default" - Trash and Clear action buttons in bookmark footer Aggregate / Summary - New aggregate ops: distinctCount, minLength, maxLength, avgLength, range - Group summary (rollup) rows now show correct values for all aggregate ops - Summary footer for pinned columns fixed Data Inference & Normalization - Auto-flag SSN and Tax ID columns as sensitive on load - Detect Excel errors and blank sentinels during inference - Boolean inference now recognizes on/off - prettifyHeader splits camelCase and separates trailing ID suffix - sourceHeader shown in mono font on raw-mode column headers Keyboard Shortcuts - Keyboard shortcuts reference page with diagram, nav pills, and row-hover highlighting - Sticky keyboard bar with multi-chip shortcuts and modifier word labels Miscellaneous Fixes - Tab close button appears on hover - Duplicates panel stub wired to Table menu - Edit > Empty Trash menu command - Shift-click and cmd-drag preserve column selection sequence - Column drag clamped to boundary when mouse leaves column area - KV rows no longer stretch to fill panel height - Recent Downloads / Recently Viewed "N more" expands to 100 items --- That's ~3 weeks of work (June 5–23). Want me to trim this down, reorder sections, or adjust the tone for a specific audience (end users vs. developers)?