What’s new

Every update to Nought, from the latest release to the very first build.

v1.0.13

July 2026

Important data-safety fixes: your original files are protected

Fix

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.

New

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 2026

Reliability pass: formulas follow your edits, plus crash and data-loss fixes

Fix

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)).

Fix

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.

Fix

Fixed two crashes: FACT(0)/FACT(1) and RANDBETWEEN with its arguments reversed no longer quit the app.

Fix

HLOOKUP now works with its common three-argument form (it used to always return #N/A), and MOD now matches Excel for negative numbers.

Fix

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.

Fix

Delete Row and Delete Column now remove every row or column in your selection, not just the first.

Improved

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.

Improved

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 2026

Much faster large files, row auto-fit, and quality-of-life touches

Fix

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.

New

Double-click a row border to auto-fit its height to the content, matching the existing double-click column auto-fit.

New

Insert today’s date with Cmd+; or the current time with Cmd+Shift+; , just like Excel.

Improved

The status bar’s Sum, Average and Count now include non-contiguous (Cmd-click) selections, and whole numbers no longer show trailing zeros.

New

An About panel (Nought menu) and three more starter templates (Savings Goal, Expense Log, Weekly Schedule).

New

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 2026

Large files open, formatting fixes, and a data-loss fix

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.

Fix

Cell and table formatting from Numbers-exported and themed Excel files now displays correctly: fills, borders, fonts, bold, and strikethrough all render.

Fix

Theme and indexed colours now resolve, so coloured cells and text saved with Excel themes show the right colours.

Fix

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.

Fix

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.

New

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 2026

Big formula fixes, in-cell links, pictures, tables, and printing

Fix

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.

Fix

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.

Fix

Charts, data validation, and conditional formatting now save to .xlsx and reload correctly, instead of being dropped when you reopened a file.

New

In-cell links: attach a clickable web or email link to any cell (Insert > Link, or Cmd+K). Cmd-click opens it.

New

Pictures on a sheet: insert an image (Insert > Picture), then drag and resize it. Images save and reload with the file.

New

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]).

New

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).

New

Go To Special: step through all the constants, formulas, or blank cells in a range (Data > Go To Special).

v1.0.7

June 2026

AutoFilter, custom sort lists, and a file-opening fix

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.

New

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.

New

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 2026

Appearance control, reopen on launch, and a big sorting upgrade

New

Appearance setting: choose Light, Dark, or Follow System in Settings > General, so Nought no longer has to track the system theme.

New

Reopen last document on launch: a new On launch option in Settings > General reopens the spreadsheet you were last working on.

New

Sort by cell colour or font colour, grouping highlighted rows together.

New

Custom sort orders: sort by months, weekdays, or your own lists defined in Settings > Sort Lists.

New

Unlimited sort levels: add or remove levels in the Sort dialog instead of a fixed three.

New

Left to right sorting: sort columns by the values in a chosen row.

Improved

Smarter ordering: dates sort chronologically, text sorts naturally (item2 before item10), and sorting respects an active filter.

Fix

Multi-column sort is now undoable and stable, the case-sensitive option works, and blank cells always sort last.

v1.0.5

May 2026

Universal binary, locale support, and formatting improvements

New

Universal binary: Nought now runs on both Apple Silicon and Intel Macs.

New

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.

New

Number format submenu with presets for 0 to 4 decimal places, plus a thousands separator option.

New

Status bar shows the current cell mode (Ready, Enter, Point, Edit), matching Excel and LibreOffice behavior.

Fix

Fixed formula results displaying left-aligned. Numbers and formula results now right-align by default when no explicit alignment is set.

Improved

Increase/Decrease Decimal buttons now work correctly on formula cells, not just plain numbers.

v1.0.4

May 2026

Formula entry, function arguments dialog, and visual selection feedback

New

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.

New

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.

New

Blue selection highlight on cells and ranges when pointing during formula entry or filling function arguments.

New

Select-first-then-function workflow: select a range, then pick a function from the menu. The range is pre-filled as the first argument.

Fix

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.

Fix

Fixed auto-filter not hiding rows when a filter value was selected.

Improved

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 2026

Enter key fix and editing reliability

Fix

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.

Improved

Tab and Shift+Tab now reliably commit cell content before moving to the next or previous cell, using the same fix.

Improved

Internal logging switched to NSLog for better diagnostics when troubleshooting editing issues.

v1.0.2

April 2026

Formula fixes, better clipboard, and reliability

Fix

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.

Fix

Fixed formulas not evaluating on first entry. Typing =A1+B1 and pressing Return now computes and displays the result immediately.

Improved

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.

Improved

Formula bar consistently shows the leading = sign for all formulas, whether entered by the user or loaded from a file.

v1.0.1

April 2026

Stability, polish, and undo everywhere

Fix

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.

Fix

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.

New

Right-click context menu on the grid with Cut, Copy, Paste, Insert Row/Column, Delete Row/Column, and Clear Contents.

New

Editable name box in the formula bar. Type a cell reference like B12 and press Return to jump there.

New

Auto-fit column width by double-clicking a column header border. Measures content across all rows and resizes to fit.

New

Marching ants animation around copied cells, matching the behavior of Excel and Google Sheets.

Improved

Formatting changes (bold, italic, underline, fill color, font color, font size, alignment) are now undoable with Cmd+Z.

Improved

Sort operations are now undoable. Cmd+Z restores the original row order.

Improved

Grid scrolls to keep the selected cell visible after keyboard navigation.

v1.0

April 2026

Initial release

New

Native Mac spreadsheet built with Swift and AppKit. 3.1 MB download.

New

200+ formulas across math, statistical, lookup, text, date, financial, engineering, and array categories.

New

7 chart types: bar, line, pie, area, scatter, combo, and waterfall with interactive tooltips.

New

Full .xlsx read and write. Opens Excel files in-place and saves them back with formatting, charts, and formulas preserved.

New

ODS and CSV file support for LibreOffice and data interchange.

New

Conditional formatting with 17 rule types including color scales and data bars.

New

Data validation with dropdown lists, number ranges, and date ranges.

New

Multi-sheet workbooks with tabs, drag-to-reorder, tab colors, hide/unhide, and duplicate.

New

Named ranges, frozen panes, merged cells, sparklines, and cell comments.

New

Find and replace with case sensitivity, whole-cell matching, and formula search.

New

PDF export with charts rendered inline.

New

Pivot tables, Goal Seek, subtotals, remove duplicates, and text-to-columns.

New

Light and dark mode with automatic system detection.

New

Signed and notarized by Apple. No network access. Fully offline.