What’s new

Three things Nought used to do silently, it now says out loud - and a spreadsheet made by a script keeps its formatting.

Fixed

• A workbook written by Python's openpyxl, which is most spreadsheets that come out of an automated report, opened with every font, colour, fill, border and number format silently gone. One optional attribute the library leaves out - optional by the file format's own rules - was enough to discard the lot. They now open looking the way they were built.
• Column widths from other people's files are honoured. There are four legal ways a width reaches an .xlsx and Nought read only one, so a real report, especially an auto-fitted one or one with a sheet-wide default, opened at the wrong shape and had to be tidied by hand before it could be read. All four now work, and they survive a save.
• A workbook too large to open completely now says so. Very large files are capped so they cannot exhaust memory, which is right, but the cap was silent: rows past the limit were quietly missing, formulas reaching into them read empty, and saving wrote the short version over the original. Nought now tells you what it could not show and will not overwrite the file. Save As writes what is on screen to a new one and leaves yours whole.
• A colour you pick is the colour you get. Nought was quietly overruling any text colour it judged low-contrast against the grid, which sounds prudent and was not: it rejected 23 of the 50 colours in its own picker in light mode and 32 in dark. You picked yellow, the file recorded yellow, Excel showed yellow, and Nought drew something darker. It now steps in only where the text would otherwise be invisible.
• Opening a file is where you would look for it. The Open action sat as the last item under a heading reading NEW SPREADSHEET, so anyone arriving with their own file read that heading and stopped looking. It has its own place at the top of the welcome window now.
• CONCATENATE over a range now gives what Excel gives. CONCATENATE and CONCAT are different functions and Nought had them sharing one implementation, so =CONCATENATE(C7:E7) joined every cell in the range. Excel takes the one cell that lines up with the formula, and errors when none does. CONCAT is the one that joins a whole range, and still does.
• A workbook whose text could not be read no longer opens blank. If the shared text table defeated the reader, every piece of text in the file came back empty and the sheet opened looking as though nothing had loaded. A second reader now picks it up, and if both fail Nought says so and asks for the file rather than leaving you with an empty grid.
• Workbooks written in Hebrew, Arabic or Persian keep their direction when you save them. Nought does not lay a sheet out right to left yet, but it no longer throws away the file's statement that it should.

A CSV that took ten minutes to open now opens at once, and copied cells keep their accents.

Added

• GROUPBY and PIVOTBY. Both spill a whole table from one formula: GROUPBY groups a column and totals another beside it, with a Total row, and PIVOTBY builds a cross-tab. Change a source number and the table follows.
• A default save format, in Settings under Formats. It governs new spreadsheets only: an existing .xlsx stays .xlsx when you save it, because a workbook changing type behind your back would be worse than the setting is useful.
• The window comes back where you left it. Move it, resize it, quit, and it reopens at that size in that place rather than at whatever macOS chooses.

Fixed

• An 800 KB CSV took ten minutes to open. It was reported with the detail that made it findable, and the cause was not the file: reading it takes about a tenth of a second. The label in the Data menu that says which range a command will act on was being recomputed on every single frame, and the function behind it rescanned the whole block for every row it grew by. On the reported shape that is 373 times slower than it needed to be. It is instant now.
• Copying a range of cells and pasting it into another app mangled accented characters. Copying one cell was always fine, which made it look like a problem with reading files; it was not. A block of cells goes over as HTML, and an HTML fragment that does not say what encoding it is in is supposed to be read as Windows-1252, so the receiving app was decoding our text exactly as the standard told it to. Nought was the one in the wrong. It now says utf-8, and there is a test that reads the bytes back the way the other app would rather than checking that we remembered to write the declaration.
• Filtering a long sheet stuttered, and Select All with the inspector open fell behind. Both were re-walking every row, or every selected cell, on every frame, which is the cost you notice precisely when you reached for the feature because the sheet was big. Both keep up now.

Colours come from the file, a save stops losing things, and a crash a file could trigger on its own

Added

• Merged cells behave like one cell. Merging tells you how many cells it is about to discard and asks first, clicking a merged region and pressing Merge again unmerges it, the highlight covers the whole region rather than its top-left corner, and a merged title in a frozen row draws as one cell instead of several stacked on top of each other.
• Export as PDF uses the page setup you already chose, including the print area, fit to page width and repeating header rows, and it can export just the current selection without making you describe it as a range first.
• The fill handle is visible on a single selected cell, and double-clicking it fills down the column. It worked before, and there was no small square to tell you so, which meant the gesture could only be found by accident.
• While editing inside a cell, Command-A selects the text in that cell, and the arrow keys move the caret between characters instead of moving the selected cell.
• The title bar keeps its name and its edited marker instead of occasionally rendering empty.
• Nought can check for updates, and you can turn that off in Settings.

Fixed

• Files made in Excel are drawn the way Excel draws them. A workbook can define its own colour palette, and Nought was ignoring that and using the standard one, so a spreadsheet whose rows were banded in light grey opened here banded in solid blue. It was reported with screenshots, and the first two attempts to explain it were wrong in an instructive way: every copy of the file left on the machine had already been saved by Nought, which had written its own misreading into it as a plain blue. The original was recovered from the backup Nought keeps before it first overwrites anything, and it settled the question in one line of XML.
• A save keeps much more of your workbook. Sheet protection, row grouping and subtotals, chart data labels, trendlines, sparklines, conditional formatting thresholds, data validation and auto-filters all survive being saved and reopened. Several of these were being dropped silently, which is the worst way to lose something: nothing tells you, and the file looks fine until the part you needed is missing.
• The parts of a file Nought does not understand are now carried across instead of discarded. The workbook theme, custom document properties and custom XML are copied into the saved file byte for byte. Anything that could not be copied safely is still left out on purpose, because a part that quietly points at the wrong place is worse than one that is honestly absent.
• Opening a workbook and closing it without editing no longer rewrites the file on disk.
• Smaller things: the fill handle is visible on a selected cell and fills down when you double-click it, Command-A while editing selects that cell's text rather than every cell, selecting a range backwards no longer crashes the app, macro-enabled workbooks open, very large formula workbooks open promptly, and dark mode is readable.
• Sparklines survive being saved. Every sparkline in a workbook was destroyed the first time Nought saved it, silently. Nothing was written and nothing was said, so the usual reaction is to assume you did something wrong. Conditional formatting thresholds went the same way: a colour scale reopened with default stops, which looks entirely plausible and means something different.
• Selecting a range backwards no longer kills the app. Start at the bottom right and drag up, or hold Shift and press Up, and seventeen places in the code assumed the start came before the end. Several of them could be reached by the contents of a file rather than by anything you did.
• Macro-enabled workbooks open. The App Store build had never been able to open one, because the file type was not declared.

The Buy button in 1.0.28 could never have worked

Added

• The permission is now present, and it is worth being exact about what it changes. It allows outgoing connections; it does not create any. Nought still makes no network calls of its own: no telemetry, no sync, no update check, and nothing in a document goes anywhere. The only traffic is Apple's own purchase check, made by the system when you open the Licence tab or buy. The claim that Nought has no network access at all is no longer true, so it has been removed from this site rather than left standing.

Fixed

• Buying Nought works. Version 1.0.28 reached the App Store with a Buy button that could not have worked on any machine: Nought deliberately carried no network permission, on the reasoning that a spreadsheet has no business talking to anyone, and the App Store's purchase check runs from inside the app. Pressing Buy returned "The store is not reachable". Nothing failed at build time and nothing failed review, so it took downloading the shipped build and pressing the button to find it.
• If you already had Nought before the price, nothing about this affected you. The grandfathering was checked against the live App Store build and was working: it read "Free, as an early user", which is what it should say and what it will keep saying.

Number formats fixed, CSV import rebuilt, and a round of things you could not find

Added

• Nought is free to download with a 14 day trial, then $9.99 once, no subscription. If you already had Nought before this version, you keep it in full, permanently, and nothing changes for you. You can still buy it if you want to support the work. When a trial ends Nought goes read only: your files still open, still scroll, still print, and nothing you have already made is held hostage.
• Type a formula by clicking cells and keep typing. Clicking a cell to add its reference no longer takes the keyboard away, so you can type the operator between references instead of clicking back into the formula bar every time.
• Wrap Text is in the Format menu and on the toolbar, on Control+Shift+W. It was already built, and hidden behind a chevron labelled alignment, which is not where anyone looks for it.
• Print Selection, on Cmd+Option+P. Prints what you have highlighted without making you type a range into Page Setup first, and without changing the print area you had saved.
• The warning about things Nought cannot save now only appears when your file actually contains one. It was naming the workbook theme, which nearly every spreadsheet has whether anyone chose it or not, so it appeared on almost every file and was easy to stop reading.
• Settings rebuilt to match Verso, with the last three releases of work reachable in it: chart defaults, the zoom gestures, and control over the macro warning. Content no longer scrolls up underneath the tab bar.
• The fill and text colour buttons show the colour you last picked, and keep it, so you can apply it again without opening the picker.
• The welcome templates rebuilt to use what Nought can actually do: frozen headers, dropdowns, number formats, conditional formatting, filters and charts, instead of a bold row and a SUM.

Fixed

• Number formats no longer collapse onto each other. A workbook with a currency column and a percent column saved with one of them wrong, because every format written was pointing at the same entry in the file. This is the commonest layout there is, so it affected a lot of ordinary files.
• CSV import was audited against a corpus of files every other spreadsheet already opens, and rewritten. A single stray quote in a large export used to collapse every following row into one cell. Semicolon files, the ones Excel writes across most of continental Europe, imported as a single column. Blank rows shifted everything below them up. UTF-16 files with no byte order mark, which is what a lot of Windows tools export, failed to open at all.
• The On launch setting works. All four options did nothing at all, not just the one that was reported, so whatever you chose you got the file picker.

Real pivot tables, 23 chart types, chart export, and the delete fix

Added

• Pivot tables, properly. Nest several fields down the rows and across the columns, use more than one value field at once, filter any field, group dates by month or quarter, and show a value as a percentage of the total or as a running total. Pivots refresh when their source data changes, and are written into the .xlsx as a real pivot cache, so a pivot you build in Nought is still a pivot when you open it in Excel.
• 23 chart types, up from 10. Added horizontal bar, stacked and 100% stacked area, bubble, step line, radar, stock, treemap, sunburst, histogram, Pareto, box and whisker, and funnel. The picker groups them by family, and marks the types that Excel stores in a newer format so you can see before you commit that saving will fall back to the closest classic chart.
• Export any chart on its own: right-click it for Copy as Image, Copy as SVG, Export as PNG, or Export as SVG. The SVG is real vector output with live text, so it stays sharp and stays editable.
• Pinch on the trackpad, or hold Option and scroll, to zoom from 25% to 400%. The cell under the pointer stays put.
• Cmd+backtick is back to macOS, where it cycles windows. Show Formulas is now Control+backtick, matching Excel on the Mac.

Fixed

• Delete over a multi-cell selection now clears every cell in it. This was reported five times before the actual cause was found: the key was being swallowed by an edit field before any of the code being fixed could run.
• A sort is visible immediately, instead of only after you click off the selection. Eight related redraw bugs were found and fixed alongside it.
• Sorting no longer silently reorders columns outside your selection. Filter, Sort and Custom Sort now name the range they will act on, and Custom Sort is in the Data menu rather than only the toolbar.
• Charts stay inside the grid. They no longer draw over the toolbar, the column letters, the row numbers, the sheet tabs, or the scroll bar.

Macro workbooks, very large files, and a round of data-fidelity fixes

Added

• Macro-enabled workbooks (.xlsm and .xltm) open. Nought does not run VBA, but your macro code is kept byte for byte and written back when you save as .xlsm. Saving a macro workbook as plain .xlsx now warns you first, instead of dropping the macros silently.
• Double-click the fill handle to fill down.
• Pivot Table added to the toolbar's Insert menu, next to Chart. Four format-bar icons redrawn to read as what they do.

Fixed

• A 66,000-formula workbook that never opened - minutes at full CPU with no window - now opens. Nought trusts the values already in the file instead of recalculating everything before it can show you anything.
• Data validation rules survive a save. Every rule was being destroyed by every save; all six types now round-trip.
• The auto-filter survives a save in both directions, and a table's own filter is read, so you can sort from the header row.
• Conditional-format colours no longer drift slightly on every save.
• Pressing Return on a cell you had not edited no longer wipes it, and a SUM now updates when a cell it depends on changes.
• Fixed a crash when extending a selection to the end of a sheet over rows of uneven length.
• Merged cells behave as one cell. The covered cells are no longer separately clickable and editable.
• Charts use the series names and category range the file states, instead of inventing their own.
• Escape gets you out of cell editing again after switching to another app and back.

Dark mode readability, faster Find, and warnings before a lossy save

Added

• Templates are reachable at any time from File > New from Template, not only from the welcome screen on first launch.
• Nought tells you when a workbook contains something it cannot write back, as a banner when you open it, and stops autosave from overwriting that file behind your back.

Fixed

• Cells with a light fill are readable in dark mode again, instead of white text on a pale background.
• Find is fast on large sheets. On a 17,000-row workbook it no longer locks the app while it searches.
• The App Store build installs as Nought, not Nought-appstore, so it has the right name in the Dock and in Spotlight.
• The Open panel no longer flickers onto the screen at every launch.
• Send Feedback mailed a domain that did not exist and bounced. It now reaches hello@nought.app.
• Four CSV import defects fixed, including quoted fields containing a line break being torn across rows.

Formula correctness, sorting, and Excel chart compatibility

Added

• Charts export cleanly to Excel (no more “repair” prompt), and charts made in Excel keep their legend, colors, and axis titles when opened in Nought.
• Format Painter works, Fill Down/Right carry formatting, row and column sizes save with the file, and the inspector opens with a smooth animation.

Fixed

• Deleting the first or last row of a range now shrinks it (SUM(A1:A10) becomes SUM(A1:A9)) instead of breaking the whole total to #REF!.
• Sorting a column that contains formulas now moves the formulas with their data, so a per-row calculation keeps pointing at the right row.
• Editing across sheets is reliable: inserting or deleting rows updates references on other sheets, and editing a cell recalculates the sheets that depend on it.
• Undo after a cell edit now updates every dependent formula, and Increase/Decrease Decimal is undoable.
• Copying in another app and pasting into Nought no longer pastes stale Nought cells; a leading apostrophe forces text; SUMPRODUCT handles blanks correctly.

Inspector panel, autosave, and a round of editing fixes

Added

• New Inspector panel (View > Toggle Inspector, or Cmd+Option+I). A contextual side panel showing the selected cell's content, number format, size, protection and quick statistics, plus chart, image and sheet controls. It opens beneath the toolbar and has its own toolbar button to show and hide it.
• Autosave with a live save-status indicator in the status bar, so you can see at a glance whether your work is saved. Turn it on or off and set the interval in Settings > General.
• The Find bar slides in and out, and animations across the app respect the system Reduce Motion setting.
• Added a proper Help menu (Nought Help, What's New, Send Feedback, Save Diagnostics) and background diagnostics to make issues easier to report and fix.
• The menus, toolbar and status bar are now built for translation, the groundwork for shipping Nought in more languages.

Fixed

• Delete now clears the whole selected range, not nothing, and also responds to the forward-delete key.
• Grid lines now keep a consistent, crisp weight at every zoom level instead of looking uneven.
• The row-height and column-width controls in the Inspector now resize immediately.

Important data-safety fixes: your original files are protected

Added

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

Fixed

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

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

Added

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

Fixed

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

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

Added

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

Fixed

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

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

Added

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

Fixed

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

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

Added

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

Fixed

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

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

Added

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

Fixed

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

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

Added

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

Fixed

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

Universal binary, locale support, and formatting improvements

Added

• 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.
• Increase/Decrease Decimal buttons now work correctly on formula cells, not just plain numbers.

Fixed

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

Formula entry, function arguments dialog, and visual selection feedback

Added

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

Fixed

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

Enter key fix and editing reliability

Added

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

Fixed

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

Formula fixes, better clipboard, and reliability

Added

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

Fixed

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

Stability, polish, and undo everywhere

Added

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

Fixed

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

Initial release

Added

• 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 summaries, 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.