SPB Git

Repository Public

RELEASE-REPORT.md 12.9 KB

# 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; SUM uses compensated summation; ROUND and number formatting are decimal-correct at 15 significant digits; amortization schedules use Decimal and match a Python decimal reference 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

  1. Publishing on git.spboucher.ai — authorized and done on 21 November 2026.
  2. 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.
  3. 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
Files main
Menu

Theme