SPB Git

Repository Public

competitive-analysis.md 4.8 KB

# 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

  1. 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).
  2. Trust. Every function listed as supported has reference tests; the auditor explains findings with evidence; AI never computes.
  3. Explainability. Formula steps, traced precedents/dependents and error origins come from the real evaluator.
  4. Honest interoperability. A preflight report before saving to XLSX/CSV/ODS states what will be lost; nothing is dropped silently; macros are never run.
  5. 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.

Files main
Menu

Theme