Competitive analysis
Scope: what each product does well and where a native, local-first Mac application can do better. Observations come from the products' public documentation and from using the applications installed on the build machine (Microsoft Excel for Mac, Apple Numbers, LibreOffice Calc). No performance claim against a competitor is made anywhere in this project: we publish only our own measurements.
| Area | Excel (Mac) | Numbers | LibreOffice Calc | Google Sheets | ORIX Sheet opportunity |
|---|---|---|---|---|---|
| Grid | 1,048,576 × 16,384, mature virtualized grid | Free-form canvas of small tables; slows down with large tables | Same limits as Excel (configurable), dated rendering | 10 M cells per file, browser bound | Excel-sized virtualized grid with native trackpad scrolling and pinch zoom |
| Formulas | ~500 functions, dynamic arrays, LET/LAMBDA | ~250 functions, no dynamic arrays | ~500 functions, partial dynamic arrays | Good coverage, own array model | Excel semantics validated function by function; a published compatibility table that lists only what passes reference tests |
| Formula help | Tooltips, Evaluate Formula dialog | Friendly function browser | Function wizard | Inline help | Step-by-step evaluation with real intermediate values, coloured references, dependency graph |
| Large data | Power Query + Data Model (Windows first; reduced on Mac) | None | Limited | Connected Sheets (cloud) | Embedded columnar engine: 10 M-row files are queried without becoming rows in a sheet |
| Data preparation | Power Query (limited editor on Mac) | None | None | Limited | Visual, reproducible steps compiled to SQL |
| Pivot tables | Reference implementation | Pivot tables since 2021, simpler | DataPilot | Good | Columnar aggregation, drill-down, refresh |
| Charts | Broad, defaults look dated | Beautiful defaults, fewer statistical types | Functional | Functional | Statistical charts (box, violin, density, heatmap) with vector PDF/SVG export; multi-panel figures |
| Financial modelling | Standard of the industry; auditing add-ins are third-party | Not a target | Adequate | Adequate | Built-in model auditor, scenario/sensitivity/Monte Carlo tools, validated day-count conventions |
| Statistics | Analysis ToolPak (static output) | Basic | Basic | Add-ons | Regression with robust errors, tests, time series — each validated against SciPy/statsmodels |
| Scripting | VBA, Office Scripts, Python in Excel (cloud execution) | AppleScript | Basic/Python macros | Apps Script (cloud) | Local Python against workbook ranges, run in a separate, restricted process, never automatically |
| AI | Copilot (cloud, subscription) | — | — | Gemini (cloud) | On-device assistance only; suggestions are verified by the engine |
| Interoperability | Native XLSX | Imports/exports XLSX with losses | Good XLSX/ODS | Import/export | Explicit compatibility report before any lossy save; unknown OOXML parts preserved |
| Privacy / account | Account for many features | iCloud optional | None | Account required | No account, no telemetry, no network in the core |
| Keyboard | Deep, de-facto standard | Mac-like, shallower | Excel-like | Excel-like | Excel-compatible shortcuts adapted to Mac conventions; deviations documented |
| Accessibility | Good VoiceOver support | Very good | Partial | Good in browser | VoiceOver labels for cells and controls, colour-blind-safe chart palettes |
WPS Spreadsheet and OnlyOffice follow the Excel model closely (ribbon interface, XLSX as native format) and were reviewed for import/export behaviour only. Notebook tools (Jupyter, Observable) and data-exploration tools (Tableau Prep, OpenRefine, DuckDB UI) informed the Python Studio and ORIX Transform designs: reproducible steps, a visible schema after every step, and results that can be materialized back into the sheet.
Product opportunities retained
- One document, two execution environments. A worksheet grid for modelling and a columnar engine for data, with an explicit, undoable bridge between them (materialize a query result, import a range as a table).
- Trust. Every function listed as supported has reference tests; the auditor explains findings with evidence; AI never computes.
- Explainability. Formula steps, traced precedents/dependents and error origins come from the real evaluator.
- Honest interoperability. A preflight report before saving to XLSX/CSV/ODS states what will be lost; nothing is dropped silently; macros are never run.
- Native feel without a ribbon. One formatting toolbar, contextual inspectors, studios that take over the centre of the window when a task needs room.
Deliberate non-goals for 1.0
Real-time collaboration, VBA execution, Excel's Data Model/DAX, cloud connectors, and pixel-identical chart import are out of scope and are listed in the README's known limitations.