What’s new
Every update to Nought, from the latest release to the very first build.
v1.0.13
July 2026Important data-safety fixes: your original files are protected
Fixed a data-loss issue where simply opening a file and quitting could rewrite it. Opening a spreadsheet no longer counts as an edit, so Nought can no longer silently overwrite (or reformat) a file you only looked at.
Nought now automatically keeps a copy of the original the first time it overwrites a file you opened, so you can always recover it if a save drops formatting Nought cannot yet reproduce. Find them under File > Reveal Original Backups.
v1.0.11
June 2026Reliability pass: formulas follow your edits, plus crash and data-loss fixes
Formulas now follow structural edits. Insert a row above row 5 and =A5 becomes =A6; delete a referenced row and it correctly shows #REF! instead of silently pointing at the wrong data. Ranges shrink to match (SUM(A1:A10) becomes SUM(A1:A9)).
Paste and fill-handle drag are now undoable. Pasting copied cells or dragging the fill handle can be reverted with Cmd+Z, instead of permanently changing the sheet.
Fixed two crashes: FACT(0)/FACT(1) and RANDBETWEEN with its arguments reversed no longer quit the app.
HLOOKUP now works with its common three-argument form (it used to always return #N/A), and MOD now matches Excel for negative numbers.
SUM, AVERAGE, MIN/MAX and other aggregates now surface an error (like #DIV/0!) when a cell in their range is an error, instead of quietly skipping it.
Delete Row and Delete Column now remove every row or column in your selection, not just the first.
Saving to .xlsx and .csv is more robust: non-numeric edge cases no longer produce files Excel refuses to open, quoted values with embedded quotes survive a CSV round-trip, and worksheet names with characters Excel forbids are cleaned up automatically.
Toolbar polish: the Values/Formulas switch in the formula bar is now a soft sliding toggle, and the format-bar icons share a consistent weight.
v1.0.10
June 2026Much faster large files, row auto-fit, and quality-of-life touches
Very large spreadsheets now open dramatically faster. A 48 MB file that used to take minutes (or never finish) now opens in a few seconds.
Double-click a row border to auto-fit its height to the content, matching the existing double-click column auto-fit.
Insert today’s date with Cmd+; or the current time with Cmd+Shift+; , just like Excel.
The status bar’s Sum, Average and Count now include non-contiguous (Cmd-click) selections, and whole numbers no longer show trailing zeros.
An About panel (Nought menu) and three more starter templates (Savings Goal, Expense Log, Weekly Schedule).
Experimental: open and save .csvs files (CSV with formulas), a plain-text, version-control-friendly spreadsheet that keeps your formulas, with a Values/Formulas toggle in the formula bar. Early preview.
v1.0.9
June 2026Large files open, formatting fixes, and a data-loss fix
Large spreadsheets now open. Files with very large shared-text tables (tens of megabytes) used to appear to hang forever on open; they now load in seconds.
Cell and table formatting from Numbers-exported and themed Excel files now displays correctly: fills, borders, fonts, bold, and strikethrough all render.
Theme and indexed colours now resolve, so coloured cells and text saved with Excel themes show the right colours.
Prevented a data-loss issue: opening an unsupported file (such as a Numbers document) no longer opens a blank sheet that could overwrite the original. Nought now shows a clear message and suggests exporting to .xlsx.
CSV files saved with non-UTF-8 encodings (Windows-1252, Latin-1) now open without errors, and sheet order and wrapped text are preserved on save.
Cell comments, non-contiguous selection (Cmd-click to select multiple separate ranges), an About panel, three more starter templates, and Excel-style number-format keyboard shortcuts.
v1.0.8
June 2026Big formula fixes, in-cell links, pictures, tables, and printing
Fixed formulas that use whole-column references such as VLOOKUP(E2, ReferenceData!A:E, 5, FALSE) or COUNTIFS(Transactions!C:C, "North"). They used to come back blank; now they calculate correctly.
Formulas that reference another sheet no longer show a false circular-reference error, and every sheet now recalculates when you open a file, so cross-sheet dashboards are correct straight away.
Charts, data validation, and conditional formatting now save to .xlsx and reload correctly, instead of being dropped when you reopened a file.
In-cell links: attach a clickable web or email link to any cell (Insert > Link, or Cmd+K). Cmd-click opens it.
Pictures on a sheet: insert an image (Insert > Picture), then drag and resize it. Images save and reload with the file.
Format as Table: turn a range into a styled table with banded rows and a header (Cmd+T). Table columns work in formulas, e.g. SUM(Sales[Amount]).
Print and Page Setup: set a print area, repeat header rows on every page, fit all columns to one page wide, choose portrait or landscape, and print directly (Cmd+P).
Go To Special: step through all the constants, formulas, or blank cells in a range (Data > Go To Special).
v1.0.7
June 2026AutoFilter, custom sort lists, and a file-opening fix
Fixed a regression in 1.0.6 where existing .xlsx, .csv, and .ods files could not be opened (the app reported "cannot open files in the Spreadsheet format"). File type associations are restored.
AutoFilter: a one-click filter button in the toolbar, plus a per-column dropdown to filter by values or by a condition (contains, equals, greater than, between), with a search box, multi-select, and quick Sort A to Z / Z to A.
Custom sort lists: define your own sort orders (for example a status or priority sequence) in Settings > Sort Lists, alongside the built-in month and weekday orders.
v1.0.6
June 2026Appearance control, reopen on launch, and a big sorting upgrade
Appearance setting: choose Light, Dark, or Follow System in Settings > General, so Nought no longer has to track the system theme.
Reopen last document on launch: a new On launch option in Settings > General reopens the spreadsheet you were last working on.
Sort by cell colour or font colour, grouping highlighted rows together.
Custom sort orders: sort by months, weekdays, or your own lists defined in Settings > Sort Lists.
Unlimited sort levels: add or remove levels in the Sort dialog instead of a fixed three.
Left to right sorting: sort columns by the values in a chosen row.
Smarter ordering: dates sort chronologically, text sorts naturally (item2 before item10), and sorting respects an active filter.
Multi-column sort is now undoable and stable, the case-sensitive option works, and blank cells always sort last.
v1.0.5
May 2026Universal binary, locale support, and formatting improvements
Universal binary: Nought now runs on both Apple Silicon and Intel Macs.
Locale-aware number input: typing "1,5" on a system with comma as decimal separator is now recognized as the number 1.5, not treated as text.
Number format submenu with presets for 0 to 4 decimal places, plus a thousands separator option.
Status bar shows the current cell mode (Ready, Enter, Point, Edit), matching Excel and LibreOffice behavior.
Fixed formula results displaying left-aligned. Numbers and formula results now right-align by default when no explicit alignment is set.
Increase/Decrease Decimal buttons now work correctly on formula cells, not just plain numbers.
v1.0.4
May 2026Formula entry, function arguments dialog, and visual selection feedback
Formula entry mode: type = to start a formula, then click or drag cells to insert references. Operators (+, -, *, /) return to Enter mode for the next reference.
Function Arguments dialog: a guided panel (like Excel's) that shows each argument with a labeled field. Click cells in the grid to fill the active argument.
Blue selection highlight on cells and ranges when pointing during formula entry or filling function arguments.
Select-first-then-function workflow: select a range, then pick a function from the menu. The range is pre-filled as the first argument.
Fixed formulas typed directly in a cell sometimes displaying as text instead of evaluating. A defensive check now promotes any value starting with = to a formula.
Fixed auto-filter not hiding rows when a filter value was selected.
Cell selection visuals unified: single-cell accent border, multi-cell range fill with anchor highlight, formula pointing highlight, function args highlight, and marching ants all draw correctly and trigger redraws immediately.
v1.0.3
April 2026Enter key fix and editing reliability
Fixed a critical bug where cell content disappeared when pressing Enter to confirm. A race condition between the AppKit text field and the SwiftUI key handler caused the committed value to be overwritten with an empty string.
Tab and Shift+Tab now reliably commit cell content before moving to the next or previous cell, using the same fix.
Internal logging switched to NSLog for better diagnostics when troubleshooting editing issues.
v1.0.2
April 2026Formula fixes, better clipboard, and reliability
Fixed formula storage so user-entered formulas and file-loaded formulas use the same internal format. Eliminates a double-equals bug that could corrupt formulas when re-editing with F2.
Fixed formulas not evaluating on first entry. Typing =A1+B1 and pressing Return now computes and displays the result immediately.
Copy now places both tab-separated text and HTML table markup on the clipboard. Pasting into a text editor, email, or any rich-text app preserves the table structure.
Formula bar consistently shows the leading = sign for all formulas, whether entered by the user or loaded from a file.
v1.0.1
April 2026Stability, polish, and undo everywhere
Fixed a critical bug where the grid lost keyboard focus after editing a cell. Arrow keys, typing, and shortcuts now work reliably after every edit.
Fixed keyboard shortcuts (Cmd+C, Cmd+V, Cmd+X, Cmd+Z, Cmd+B, Cmd+I, Cmd+U) not reaching the grid when it had focus.
Right-click context menu on the grid with Cut, Copy, Paste, Insert Row/Column, Delete Row/Column, and Clear Contents.
Editable name box in the formula bar. Type a cell reference like B12 and press Return to jump there.
Auto-fit column width by double-clicking a column header border. Measures content across all rows and resizes to fit.
Marching ants animation around copied cells, matching the behavior of Excel and Google Sheets.
Formatting changes (bold, italic, underline, fill color, font color, font size, alignment) are now undoable with Cmd+Z.
Sort operations are now undoable. Cmd+Z restores the original row order.
Grid scrolls to keep the selected cell visible after keyboard navigation.
v1.0
April 2026Initial release
Native Mac spreadsheet built with Swift and AppKit. 3.1 MB download.
200+ formulas across math, statistical, lookup, text, date, financial, engineering, and array categories.
7 chart types: bar, line, pie, area, scatter, combo, and waterfall with interactive tooltips.
Full .xlsx read and write. Opens Excel files in-place and saves them back with formatting, charts, and formulas preserved.
ODS and CSV file support for LibreOffice and data interchange.
Conditional formatting with 17 rule types including color scales and data bars.
Data validation with dropdown lists, number ranges, and date ranges.
Multi-sheet workbooks with tabs, drag-to-reorder, tab colors, hide/unhide, and duplicate.
Named ranges, frozen panes, merged cells, sparklines, and cell comments.
Find and replace with case sensitivity, whole-cell matching, and formula search.
PDF export with charts rendered inline.
Pivot tables, Goal Seek, subtotals, remove duplicates, and text-to-columns.
Light and dark mode with automatic system detection.
Signed and notarized by Apple. No network access. Fully offline.