ORIX Sheet 1.0.0 (2) — Release Report
Date: 2026-11-21 · Build machine: Apple M5 Max (18 cores, 48 GB), macOS 27.0 (26A5425a), Xcode 27.2, Swift 6.4.2
Every statement below is backed by a file in the repository or by command output captured during the release run. What was not verified is listed explicitly.
1. Summary
| Item | Status | Evidence |
|---|---|---|
| Application builds (Debug and universal Release) | ✅ | Scripts/build.sh, Scripts/sign.sh output |
| Automated tests | ✅ 1,270 test functions in 22 packages + 9 app-hosted tests, all passing | docs/reports/tests.json, docs/reports/app-tests.json |
| Developer ID signature, hardened runtime | ✅ | codesign output in §8 |
| Apple notarization | ✅ Accepted (app and DMG) | docs/reports/notary/*.json |
| Stapling and Gatekeeper | ✅ | §8 |
| DMG and ZIP with SHA-256 | ✅ | docs/reports/ORIXSheet-1.0.0.sha256 |
| Source repository, verified push | ✅ public since 21 Nov 2026 (owner's request) | §8 |
SPB Git release v1.0.0 |
✅ published, downloads re-verified | §8 |
2. Implemented features
| Area | What exists | Where |
|---|---|---|
| Grid | Virtualized AppKit grid (1,048,576 × 16,384), selection, navigation, editing, fill handle, copy/paste variants, insert/delete, resize, freeze, hide, merge, notes, links, names, find/replace, undo/redo | Packages/SheetUI, Packages/SheetCore |
| Formula engine | Parser, AST, evaluator, dependency graph, incremental recalculation, spills, LET/LAMBDA, structured references, cycle detection, cancellation, progress | Packages/SheetCore |
| Functions | 473 (465 registered + 8 special forms) | Packages/FunctionsNumeric, FunctionsText, FunctionsLookup, SheetCore |
| Number formats | Full Excel format-code grammar | Packages/SheetFormat |
| Formatting | Fonts, colours, borders, alignment, wrap, merge, conditional formatting (all rule kinds), cell styles through the inspector | SheetUI, FeatureAudit |
| Tables & validation | Structured tables, filters, multi-key sort, duplicates, missing values, data validation with in-cell list | FeatureAudit, SheetAnalytics/Audit |
| Pivot tables | Columnar pivots with drill-down and refresh | SheetData, FeatureData |
| ORIX Transform | 23 step kinds compiled to SQL, per-step validation and preview | SheetData, FeatureData |
| Data Core | Embedded DuckDB 2.0.1, virtualized dataset grid, profiles, SQL console, materialize/export | SheetData, FeatureData |
| Charts | 21 kinds, vector PDF/SVG/PNG export, inspector, interactive viewer | SheetCharts, FeatureCharts |
| Figure Studio | Multi-panel figures, templates, export presets | SheetCharts, FeatureCharts |
| Finance | 49 worksheet functions; studio with 12 tools; what-if tools (7) | FunctionsLookup, SheetAnalytics, FeatureAnalysis |
| Statistics | 27 analyses | SheetAnalytics, FeatureAnalysis |
| Python Studio | Subprocess runtime, orix module, restricted mode, consent, audit log |
SheetPython, FeaturePython |
| Local AI | Foundation Models backend with validation of every suggestion | SheetIntelligence, FeatureIntelligence |
| Formula intelligence | Step evaluation, dependency graph, autocomplete, error explanations | SheetAnalytics/Audit, FeatureAudit |
| Model auditor | 21 rules, report export | SheetAnalytics/Audit, FeatureAudit |
| Automation | 25 workflow step kinds, CLI (orix-sheet), App Intents, optional LaunchAgent scheduling |
SheetAutomation, FeatureAutomation |
| Import/export | XLSX, XLSM, ODS, CSV, TSV, JSON, JSONL, PDF; compatibility reports | SheetIO, App |
| Native format | .orixsheet package with integrity hashes |
SheetIO |
| Documents | NSDocument: new, open, save, duplicate, rename, revert, recent, autosave in place, multiple windows and tabs | App/Sources/WorkbookDocument.swift |
| Printing | Page setup, pagination, headers/footers, repeat rows, vector PDF | SheetUI/Grid/PrintRenderer.swift, App |
| Templates | 15, English and Canadian French | SheetTemplates |
| Localization | English, Canadian French | Scripts/localize.py, feature catalogs |
3. Verified features and how
| Verification | Result | Source |
|---|---|---|
| Package test suites | 1,270 test functions, 0 failing packages | docs/reports/tests.json |
| App-hosted tests (real documents, windows, synthesized key and mouse events, save/reopen, import policy, export preflight, corrupted files, paginated PDF, 200,000-cell background recalculation, unique menu shortcuts) | 9 / 9 | App/Tests/AppIntegrationTests.swift, docs/reports/app-tests.json |
| Formula reference cases | 15,378 (numeric) + 86,965 (lookup/financial, 68,075 Excel-computed) + 7,951 (text/date) + 5,085 (formats) | package COMPATIBILITY.md files |
| Whole-stack cross-check | 18,714 formula cells of the 15 templates recalculated by LibreOffice from exported XLSX: 0 mismatches at 1e-6 with no waiver | Packages/SheetTemplates tests |
| XLSX written by ORIX read by openpyxl and LibreOffice | values, formulas, styles, merges, validations, conditional formats, tables, names, panes agree | Packages/SheetIO tests |
| Statistics and finance models | validated against SciPy, statsmodels, scikit-learn, linearmodels, arch, Python decimal; Excel-compatible bond and day-count conventions match the worksheet functions on 2,700 bonds and 9,456 date pairs |
Packages/SheetAnalytics/VALIDATION.md |
| Python restricted mode | each denial asserted in restricted mode and its success asserted unrestricted | Packages/SheetPython/SECURITY.md |
| DuckDB isolation | extension, network, configuration and path-escape attempts rejected | Packages/SheetData tests |
| Signed Release smoke test | app launched and rendered a template; embedded CLI ran sql, convert, eval |
this report, §8 |
4. Formula compatibility
473 functions by category: Statistical 144, Math 58, Financial 49, Engineering 46, Text 41, Date & Time 25, Trigonometry 23, Dynamic Array 22, Information 21, Lookup & Reference 19, Logical 13, Database 12. Catalogue with validation source per function: docs/compatibility/formulas.md. Deviations from Excel: docs/compatibility/excel.md.
Microsoft Excel was never launched or automated. Excel behaviour comes from Excel-computed public data (financial functions), Microsoft's documentation, and LibreOffice where the two agree.
5. Excel import/export fidelity
Read and written: cell values and types, formulas (shared formulas expanded, dynamic arrays), styles, number formats, multiple sheets, merges, defined names, tables, conditional formatting, data validation, notes, hyperlinks, freeze panes, print settings. Preserved byte-for-byte and re-attached: drawings with charts and images, pivot tables and caches, custom XML, theme, VBA project (in .xlsm only; never executed). Reported and dropped: chart sheets, sparklines, slicers, form controls, OLE objects. Lost with a notice: formulas the engine cannot represent (external-workbook references) keep their cached value. Not exported to XLSX: ORIX charts, pivot objects and workbook attachments — announced as a loss by the export preflight. Dynamic-array metadata written for Excel has not been opened in Excel. Full matrix: Packages/SheetIO/COMPATIBILITY.md.
6. Numerical accuracy and performance
- Cells hold IEEE-754 doubles with Excel semantics;
SUMuses compensated summation;ROUNDand number formatting are decimal-correct at 15 significant digits; amortization schedules useDecimaland match a Pythondecimalreference to the cent. Details:docs/mathematics/numerical-precision.md. - Engine (release build): 800,000 formulas recalculated in 1.21 s; 4,000,000 in 5.01 s (4.5 GB resident); one-edit incremental pass 0.1 ms; 1,000,000-formula chain 0.39 s. Source:
docs/benchmarks/engine.json. - Large data: 10,000,000-row CSV imported in 0.30 s; pivot 38 ms; join 88 ms; peak RSS 2.9 GB for the whole benchmark. Source:
Packages/SheetData/BENCHMARKS.md. - Files, 1,000,000 cells: native read 0.10 s / write 0.58 s; XLSX read 1.90 s / write 1.19 s. Source:
Packages/SheetIO/COMPATIBILITY.md. - Grid repaint: 2–8 ms at 1440 × 900; 9–16 ms at 2560 × 1440 on dense content; 1.8 ms worst case in the app-hosted large-sheet test.
No performance comparison with another product is made anywhere.
7. Python, AI, supported configurations
- Python: functional with Homebrew Python 3.14.4 (NumPy, pandas, SciPy, matplotlib…) and with the system Python 3.9.6 without pandas. Restricted mode verified on macOS 27.0. Not exercised by hand: editor typing, completion popup, file panels, a real
pip install. - AI: Foundation Models available on the build machine ("AFM 3 Core Advanced", 8,192-token context). Measured: 20/20 requests received a formula that validates; 12/20 a formula computing the expected value (
Packages/SheetIntelligence/EVALUATION.md). The unavailable state is implemented and unit-tested but could not be observed on this machine. - Supported Macs: macOS 14.0 or later; universal binary (arm64 + x86_64). Only Apple Silicon on macOS 27.0 was actually run. The Intel slice and macOS 14–26 are untested.
8. Repository, signing, notarization
| Item | Value |
|---|---|
| Repository | https://git.spboucher.ai/orix-sheet (public since 21 Nov 2026 at the owner's request; the earlier private copy remains at gitsrv:srv/git-private/orix-sheet.git, remote private) |
| Release | tag v1.0.0 → 32f576a; assets at https://git.spboucher.ai/releases/orix-sheet/v1.0.0/: ORIXSheet-1.0.0.dmg, ORIXSheet-1.0.0.zip, SHA256SUMS.txt, RELEASE-NOTES.md |
| Download verification | DMG and ZIP downloaded back from the forge: sizes and SHA-256 match, DMG stapled, spctl accepted (Notarized Developer ID) |
| Commit built | 32f576a (build 2: French strings for the template chooser and privacy text added after build 1 2003fab, which was also notarized and is superseded); later commits add reports and documentation only |
| Version / build | 1.0.0 / 2 |
| Bundle identifier | ai.spboucher.orix.sheet |
| Signing identity | Developer ID Application: Simon-Pierre Boucher (3YM54G49SN) |
| Signature | valid on disk, satisfies its designated requirement, flags=0x10000(runtime), secure timestamp 21 Nov 2026 (build 2), no get-task-allow; libduckdb.dylib and orix-sheet re-signed with the same identity |
| Entitlements | none (not sandboxed; hardened runtime) |
| Notarization — app | submission 2c7463bf-26a6-49f2-8d29-250a664f487e: Accepted, no issues ("Ready for distribution") |
| Notarization — DMG | submission 824f9e74-d90b-409d-a5e4-cf9034581b5a: Accepted |
| Stapling | app and DMG stapled; stapler validate succeeded for both and for the app inside the mounted DMG |
| Gatekeeper | spctl: accepted, source=Notarized Developer ID for the app, the DMG, the app inside the mounted DMG and the app extracted from the ZIP |
| DMG | ORIXSheet-1.0.0.dmg, 80,310,380 bytes, SHA-256 04867c73714939249c1f2f19d085102932308765d29a7188dcd445a78231f861 |
| ZIP | ORIXSheet-1.0.0.zip, 79,521,512 bytes, SHA-256 576bc7dc3776f7893c21aaaf5abe76be17cc2e3c7fce8d39f70658491a644455 |
| Checksums re-verified | shasum -a 256 -c: both OK |
| Secret scan before push | clean (Scripts/secret-scan.sh) |
Notary profile used: an existing keychain profile; no credential was created, printed or stored in the repository. The Apple developer web pages were not opened in Safari: the signing and notarization requirements were verified by the toolchain itself (notarytool acceptance, stapler, spctl).
Not done: testing on a second, clean Mac; first-launch from a downloaded (quarantined) copy.
9. Known limitations
See README §34 and docs/compatibility/excel.md. The most important ones: single-threaded calculation; structural edits rebuild the dependency graph; no text rotation or rich text in the grid; ORIX charts not exported to XLSX; datasets linked rather than embedded; no XCUITest target; VoiceOver not listened to; line coverage not measured; Shortcuts discovery and LaunchAgent installation not exercised in an installed build; no automatic updates; AppleScript absent.
10. Outstanding approvals
Publishing on git.spboucher.ai— authorized and done on 21 November 2026.- Trust default for typed Python edits. After a script has been reviewed, later edits typed in the same session run without a new prompt; scripts arriving with a file always prompt. Confirm or tighten.
- Automatic updates. Sparkle was evaluated and left out; it needs a hosted, signed appcast and a key-management decision.
11. Remaining work
- XCUITest target and a VoiceOver review by a person
- measure line coverage
- test the Intel slice and macOS 14–26
- chart export to XLSX; in-grid text rotation and rich text
- multi-threaded recalculation; incremental graph maintenance for structural edits; dirty-rectangle grid drawing
- localize engine-generated text (audit explanations, statistical notes, function summaries)
- verify Shortcuts discovery and scheduled workflows from an installed copy