SPB Git

Repository Public

excel.md 26.9 KB 380 lines markdown

1# Compatibility with Microsoft Excel23What ORIX Sheet reads, writes, preserves and drops from Excel workbooks, and where the grid, the4calculation engine, number formats and keyboard shortcuts behave differently from Excel.56**Ground rule of this page.** Microsoft Excel was never run during the development of ORIX Sheet.7"Excel does X" below means: X is what Microsoft documents, what the OOXML specification states, or8what the package authors cite; it was not observed on a live Excel by this project. XLSX files9written by ORIX Sheet were checked with openpyxl 3.1.5 and headless LibreOffice 26.8.2 only. Nothing10here claims that Excel opens these files without a repair prompt.1112Related: [formats.md](formats.md) (all formats, limits, timings), [formulas.md](formulas.md) (the13function catalogue and per-function deviations),14[../mathematics/numerical-precision.md](../mathematics/numerical-precision.md),15[../architecture/persistence.md](../architecture/persistence.md) (import-as-untitled, export16preflight).1718## 1. How an Excel file is handled1920Opening an `.xlsx` or `.xlsm` file **imports** it into an untitled ORIX workbook; the original is21never modified. All formulas are recalculated by ORIX Sheet's engine at import (cached values in the22file are replaced by ours). Anything that could not be kept is listed in the import report. Writing23Excel files is *File ▸ Export To*, preceded by a preflight report.2425Parts that ORIX Sheet does not model are kept as raw bytes (`PreservedParts`), stored inside the26`.orixsheet` document, and written back on export to XLSX/XLSM. They are never interpreted.2728## 2. XLSX / XLSM feature matrix2930Legend: **R** read into the model · **W** written from the model · **P** preserved byte-for-byte,31not interpreted, not displayed · **≈** approximated, with an issue in the report · **✗** dropped,32with an issue.3334### Cells, formulas, values3536| Feature | Read | Write | Notes |37|---|---|---|---|38| Numbers, text, booleans, errors | R | W | the ORIX-only error `#CIRC!` is written as `#NUM!` |39| Shared strings, inline strings | R | W (shared) | rich-text runs flattened to plain text (≈); phonetic runs ignored |40| ISO date cells (`t="d"`) | R | – | converted to serial numbers; a date format is added when the cell has none |41| Date systems 1900 and 1904 | R | W | |42| Formulas with cached values | R | W | at import in the app, every formula is recalculated; a formula written without a cached value sets `fullCalcOnLoad` |43| Shared formulas | R (expanded) | – | written back as ordinary formulas |44| Legacy array formulas (Ctrl-Shift-Enter) | ≈ | – | become dynamic arrays; written back as dynamic arrays |45| Dynamic arrays | R | W | `cm` attribute + `xl/metadata.xml`, spill range in `ref`, spilled cells as cached values. Not verified in Excel |46| Functions newer than Excel 2007 | R | W | `_xlfn.`, `_xlfn._xlws.`, `_xlpm.` prefixes handled; `A1#` ⇄ `_xlfn.ANCHORARRAY`, `@x` ⇄ `_xlfn.SINGLE` |47| Functions ORIX Sheet does not implement | R | W | formula and cached value kept, one warning per function; the cell evaluates to `#NAME?` after recalculation |48| Formulas with external references (`[1]Sheet!A1`) | ✗ | – | replaced by the cached value, `loss` issue |49| What-if data tables | ✗ | – | cached values kept, `loss` issue |50| Defined names (workbook and sheet scope, hidden, comment) | R | W | |5152### Formatting and layout5354| Feature | Read | Write | Notes |55|---|---|---|---|56| Fonts, solid fills, borders, alignment, protection flags | R | W | styles deduplicated on write |57| Theme colours with tint, indexed colours | R (resolved to RGB) | W as RGB | the theme itself is preserved (P); the link between a cell and a theme colour is not |58| Gradient and patterned fills | ≈ | – | first stop / foreground colour |59| Diagonal borders, stacked vertical text | ✗ | – | |60| Text rotation, shrink to fit | R | W | stored and round-tripped, **not rendered** by the grid (section 4) |61| Number formats | R | W | built-in ids 0–22 and 37–49, custom formats from id 164 |62| Column widths, row heights | R | W | `points = width × 5.25` |63| Hidden rows/columns, outline levels, collapsed state | R | W | there is no outline (group) user interface in the grid |64| Row and column default styles | R | W | |65| Merged cells | R | W | overlapping merges dropped on write |66| Frozen panes, zoom, gridlines, headings | R | W | split (non-frozen) panes ignored |67| Tab colour, hidden sheets, active sheet | R | W | `veryHidden` becomes hidden |68| Sheet protection | R (flag) | W (flag) | the password hash is not kept; enforcement is partial (section 4) |69| Page setup, margins, header/footer, print options, page breaks | R | W | paper sizes Letter, Legal, Tabloid, Executive, A3, A4, A5, B4, B5; header/footer font codes ignored when printing |70| Print area, print titles | R | W | several print areas are merged into their bounding range |7172### Sheet features7374| Feature | Read | Write | Notes |75|---|---|---|---|76| Hyperlinks (external, internal, tooltip) | R | W | at most 65,530 per sheet |77| Data validation, including cross-sheet lists | R | W | long titles and messages truncated; inline lists over 255 characters dropped |78| Conditional formatting | R | W | cellIs, expression, colorScale (2–3 points), dataBar, iconSet, top10, aboveAverage, duplicate/unique, containsText, blanks, errors; differential formats: bold, italic, strike, colour, fill, number format. Other text/time rules are read as their equivalent formula. x14 extensions (negative bar colours, custom icons) ✗ |79| AutoFilter | R (range) | W | filter criteria ✗; rows they had hidden stay hidden |80| Tables | R | W | name, range, header/totals rows, columns, totals functions, calculated-column formula, style name |81| Notes (legacy comments) | R | W | |82| Threaded comments | ≈ | W as notes | replies merged into one text |83| Document properties (core) | R | W | |8485### Content that is carried, not understood8687| Feature | Read | Write | Notes |88|---|---|---|---|89| Charts, images, shapes (DrawingML) | P | P | not displayed, not editable, not updated when cells change |90| Pivot tables and caches | P | P | dropped if their sheet is deleted |91| VBA project | P | P in `.xlsm`, ✗ in `.xlsx` | **never executed** |92| External link definitions | P | P | **never fetched** |93| Custom XML, custom document properties, theme | P | P | |94| Chart sheets, macro sheets, dialog sheets | ✗ | – | warning at load |95| Sparklines, slicers, timelines, form and ActiveX controls, OLE objects, sheet background, data connections | ✗ | – | warning at load |96| Workbook-level protection, custom views, scenarios, ignored-error flags | ✗ | – | not modelled |9798### ORIX Sheet content that XLSX cannot hold99100| Content | On export |101|---|---|102| ORIX charts, figures and pivot tables (`SheetObject`) | ✗ — "not exported to XLSX yet" (`loss`) |103| Attachments (Python scripts, queries, workflows) | ✗ (`loss`) |104| Cells holding a LAMBDA value | written as `#CALC!` (`loss`) |105| Text longer than 32,767 characters | truncated (`loss`, with the cell address) |106107Source for the five tables above: `Packages/SheetIO/COMPATIBILITY.md` (each row is backed by a test in108`Packages/SheetIO/Tests/SheetIOTests`, per that document) and `Sources/SheetIO/Preflight.swift`.109Spot-checked in the code for this page: `#CIRC!` → `#NUM!` (`WorksheetWriter.errorText`),110`veryHidden` → hidden (`XLSXReader`), the 5.25 factor (`SheetUnits`), the limits (`ExcelLimits`),111`.xlsb` refusal (`FileFormat.detect` → `.xlsb`, `WorkbookReader.load`), rotation and shrink-to-fit read and written112(`StylesReader`, `StylesWriter`) and absent from `Packages/SheetUI/Sources`.113114A consequence worth spelling out: a workbook with Excel charts imported into ORIX Sheet shows **no115chart**; the charts reappear only when the workbook is exported back to XLSX and opened in a program116that renders them, and they still refer to the original ranges.117118## 3. Calculation engine differences119120Each item was checked in the source and, where marked *run*, by a scratch program linking `SheetCore`121on 2026-11-21 (the observed result is quoted).122123### Deliberately different124125| Topic | Excel | ORIX Sheet | Verified |126|---|---|---|---|127| Circular references | warning dialog, cell shows 0; optional iterative calculation | every cell of the cycle evaluates to the error **`#CIRC!`** (`CellError.circular`, `ERROR.TYPE` 15). No dialog | run: `A3: =A3+1` → `#CIRC!` |128| Iterative calculation | optional (maximum iterations / maximum change) | **not implemented**; the workbook setting is not read from XLSX | no occurrence of an iteration setting in `SheetCore` or `SheetIO` |129| Whole-column and whole-row references (`A:A`, `1:1`) | conceptually all 1,048,576 rows | clamped to the used part of the sheet when turned into arrays or iterated (`EvalContext.effectiveRange`). Aggregates give the same result; functions that return the *shape* of the reference see the clamped shape | code |130| Multi-threaded recalculation | yes | **no**: one calculation thread | [../architecture/calculation-graph.md](../architecture/calculation-graph.md) |131132Source: `Packages/SheetCore/Sources/SheetCore/Engine/CalcEngine.swift` (`need`, `store`), `Engine/Evaluator.swift` (`effectiveRange`), `Model/Value.swift` (`CellError`); scratch run of 2026-11-21.133134### Not implemented135136| Feature | What happens | Verified |137|---|---|---|138| 3-D references (`Sheet1:Sheet3!A1`) | the formula parses and evaluates to `#NAME?` | run: `=SUM(Sheet2:Sheet3!A1)` → `#NAME?` |139| Intersection operator (space) | the formula is rejected by the parser | run: `=B1:B3 B2:C2` → parse error |140| Union operator (comma inside parentheses) and multi-area references | rejected by the parser; `AREAS` always returns 1 | run: `=SUM((B1,B2))` → parse error |141| External workbook references | rejected by the parser; on XLSX import the cached value is kept | run: `=[1]Sheet1!A1` → parse error |142| R1C1 reference style | `R1C1` is read as a name | run: `=R1C1` → `#NAME?` |143| What-if data tables (`TABLE`) | cached values kept on import | package document |144| VBA, Office Scripts, XLL add-ins, user-defined functions in other languages | macros are preserved in `.xlsm` and never run. LAMBDA and LET are implemented; Python runs in a separate process ([../architecture/python-runtime.md](../architecture/python-runtime.md)) and is not Excel's `PY` | code |145| Localised function names | function names are English in every locale; only the decimal and argument separators change (period/comma or comma/semicolon) | `FormulaSyntax`, `FormulaPrinter` |146| `GETPIVOTDATA`, `CUBEVALUE`, `RTD`, `WEBSERVICE`, `FILTERXML`, `IMAGE`, `STOCKHISTORY`, linked data types | not registered: `#NAME?` | no registration of these names in `Packages/Functions*/Sources` or `SheetCore` (grep, 2026-11-21); complete list in [formulas.md](formulas.md) |147148Source: `Packages/SheetCore/Sources/SheetCore/Formula/Parser.swift`, `Formula/Printer.swift`; scratch run of 2026-11-21; function registrations searched with `grep` in `Packages/Functions*/Sources`.149150### Same as Excel (implemented quirks)151152| Topic | Behaviour | Verified |153|---|---|---|154| Unary minus binds tighter than `^` | `=-2^2` is 4 | run |155| `^` is left-associative | `=2^3^2` is 64 | run |156| A formula whose result is an empty cell displays 0 | `=B50` (empty) is 0; the same rule applies inside spilled arrays | run; `CalcEngine.store` |157| Percent postfix operator | `=50%*2` is 1 | run |158| Text that looks like a number is coerced by arithmetic operators, booleans count as 1/0 | `="3"+1` is 4, `=TRUE+1` is 2 | run |159| No coercion in comparisons; type order number < text < boolean | `=1="1"` is FALSE, `=1<"a"` is TRUE, `="a"<TRUE` is TRUE | run |160| Text comparison ignores case | `="a"="A"` is TRUE | run |161| `0^0` | `#NUM!` | run |162| 1900 date system with the 29 February 1900 leap-year bug; 1904 system | serial 60 is 29 Feb 1900 | `DateSerial` |163| Dynamic arrays and `#SPILL!` | a result array spills from its anchor; it is blocked — and the anchor shows `#SPILL!` — by any non-empty cell, formula, other spill, merged cell or table in the target area, or by the edge of the sheet; the spill re-attempts when the obstacle is removed | `CalcEngine.store`, `touchSpills`; run: `={1,2;3,4}` spills |164| `SUBTOTAL` / `AGGREGATE` and hidden rows | not volatile; re-evaluated when rows are hidden, unhidden or filtered (`CalcEngine.markVisibilityDependents`, called from `editMeta` and from undo) | code |165| Implicit intersection `@` | `@A1:A10` picks the cell on the formula's row (or column) | `Evaluator` |166| Nesting limit | 64 levels of nested expressions in the parser (Excel documents 64 nested functions) | `FormulaParser.maxDepth` |167168Source: `Formula/Parser.swift` (precedence table in `binaryOp`, `parseUnary`, `maxDepth`), `Engine/Evaluator.swift` (`binary`, `.implicit`), `Model/Value.swift` (`compareValues`, `TextOrder`), `Model/DateSerial.swift`, `Engine/CalcEngine.swift` (`store`, `touchSpills`, `markVisibilityDependents`); scratch run of 2026-11-21.169170### Floating-point comparison171172Comparison operators compare IEEE-754 doubles exactly (`compareValues`). Run: `=0.1+0.2=0.3` is173**FALSE** in ORIX Sheet. Microsoft documents that Excel treats values that agree to 15 significant174digits as equal in some comparisons and results near zero (stated from Microsoft's documentation;175not verified against a running Excel for this document); ORIX Sheet applies no such adjustment in176operators. Displayed values and `ROUND` do use the 15-significant-digit decimal expansion, so177`0.1+0.2` is *displayed* as 0.3. See178[../mathematics/numerical-precision.md](../mathematics/numerical-precision.md).179180### Function-level deviations181182They are listed per function in [formulas.md](formulas.md); the package documents are183`Packages/FunctionsNumeric/COMPATIBILITY.md`, `Packages/FunctionsText/COMPATIBILITY.md` and184`Packages/FunctionsLookup/COMPATIBILITY.md`. The ones most likely to surprise an Excel user:185186- **Dates given as text** to financial functions are `#VALUE!` (Excel parses them); date text in187  criteria and in `DATEVALUE` is read as ISO or month/day/year regardless of the locale.188- **Text comparison** (operators, lookups, `SORT`) is case-insensitive and uses one fixed collation189  on every Mac (`TextOrder`): accented letters sort next to their base letter (`"e"` < `"é"` < `"f"`),190  while equality stays strict apart from case (`"é"` ≠ `"e"`). Excel uses the collation of the system191  locale, so the order of some strings can differ on a non-English system.192- **`CHAR` / `CODE`** follow Windows-1252, not Mac OS Roman as Excel for Mac does.193- **Regular-expression functions** use ICU syntax (Excel uses PCRE2).194- **Iterative financial functions** (for example `IRR`, `RATE`, `YIELD`) converge more tightly than Excel195  (which stops at 1e-7) and may return a value where Excel returns `#NUM!`.196- **Bessel functions** are accurate beyond Excel's roughly 7 digits, so results differ after the 7th197  digit.198- **`MOD`**, `SIN`, `COS`… have no `#NUM!` limit on large arguments.199- **`CELL` and `INFO`** support a subset of types.200- **Not registered**: `ODDFPRICE`, `ODDFYIELD`, `ODDLPRICE`, `ODDLYIELD`, `AMORDEGRC`, `AMORLINC`,201  `GETPIVOTDATA`. (`ISOMITTED` is registered, by `FunctionsNumeric`.)202203Source: the three package documents named above ("Known deviations from Excel", "Known limits and204deviations (financial)").205206## 4. Grid and user-interface differences207208Verified in `Packages/SheetUI/Sources/SheetUI` unless stated otherwise.209210| Topic | ORIX Sheet |211|---|---|212| Opening and saving Excel files | imported as untitled; *Save* writes `.orixsheet` only; XLSX is an export |213| Default cell size | new workbooks: 80 pt columns, 20 pt rows (Excel: 8.43 characters = 48 pt, 15 pt). Imported XLSX files keep Excel's defaults |214| Text rotation | stored, not drawn (text is horizontal) |215| Shrink to fit | stored, not applied |216| Horizontal alignment *Fill*, *Distributed* | drawn as left-aligned |217| *Center Across Selection* | drawn centred in its own cell only |218| Vertical *Justify* / *Distributed* | drawn as centred |219| Double and accounting underlines | drawn as a single underline |220| Accounting formats with `*` fill | the fill character is not expanded: the currency symbol is not pushed to the left edge |221| `_x` in number formats | always one ordinary space, not the width of `x` |222| Numbers too wide for the cell | refitted (General drops decimals, then uses scientific notation), then `####`, as in Excel; text overflows into empty neighbours, numbers never do |223| Rich text inside a cell | not supported: one font and colour per cell |224| Embedded Excel charts, images, shapes, pivot tables | not displayed (preserved for export) |225| Outline / grouping | levels are stored; no group or ungroup command and no outline bar |226| Split panes | not supported; frozen panes are |227| Sheet protection | the flag blocks **starting an edit** in a locked cell (`WorkbookSession.beginEdit`). Paste, clear, fill, structural edits and formatting are not blocked; there is no password |228| AutoFilter | filtering exists as ORIX Sheet's own table/filter panel; Excel filter criteria are not imported and there are no in-cell filter buttons drawn by the grid |229| Insert rows / columns | one operation inserts at most 10,000 rows or 1,000 columns |230| Dates typed into cells | ISO dates, numeric dates in the locale's day/month order and dates with an English or French month name are recognised; the cell receives a fixed format chosen from the way the date was typed (`yyyy-mm-dd`, `m/d/yyyy`, `dd/mm/yyyy`, `d mmm yyyy`, `mmm yyyy`, `d mmm`), not the system short-date format. Two-digit years below 30 are 20xx, others 19xx |231| `TRUE` / `FALSE` typed into cells | `VRAI` / `FAUX` are also accepted, in every locale |232| Error indicators (green triangles), ignored-error flags | not present; auditing is a separate panel |233| Status-bar aggregates | present (`SelectionSummary`: sum, average and counts of the selection) |234| Flash Fill, threaded comments, co-authoring, sharing | not implemented |235236Source: `Grid/CellPainter.swift`, `Session/WorkbookSession.swift`, `Engine/InputParser.swift`237(SheetCore), `Model/Workbook.swift` (default sizes), `Packages/SheetFormat/COMPATIBILITY.md`.238239### Number formats240241The format engine (`Packages/SheetFormat`) implements Excel's format-code grammar: up to four242sections, conditions, the eight named colours and `[Color 1]`–`[Color 56]`, digit placeholders,243thousands scaling, percent, scientific and engineering notation, fractions, literals, text sections,244date and time tokens including elapsed `[h]` `[m]` `[s]`, and `General`. Known differences from245Excel, from `Packages/SheetFormat/COMPATIBILITY.md`:246247- Codes are interpreted in the invariant en-US grammar. The locale supplies separators and month/day248  names; a locale id in `[$-409]` does **not** switch the language of names.249- `[DBNum]`, `[NatNum]`, Buddhist and era tokens (`b`, `e`, `g`) and the system formats `[$-F800]` /250  `[$-F400]` are accepted and ignored.251- The sign rule for formats with explicit conditions follows the behaviour documented by Apache POI;252  not checked against Excel.253- Fractions use a continued-fraction algorithm; denominators are limited to five digits.254- Unquoted letters that are not format tokens are treated as literals (Excel refuses such codes).255- `General` in a narrow cell is fitted by character count, not by the pixel widths of a proportional256  font.257258**Built-in format 14.** `SheetIO` and the format engine share one built-in table259(`SheetFormat.BuiltinFormats`). Id 14 is `m/d/yyyy` and id 22 `m/d/yyyy h:mm`, so a date cell that260relies on the built-in id shows as, for example, `3/15/2026` after import, as Excel does in en-US.261Excel uses the system short date for id 14; ORIX Sheet always uses the en-US form. On export262`m/d/yyyy` is written back as id 14. (ECMA-376 Part 1 §18.8.30 prints `mm-dd-yy` and `m/d/yy h:mm`263for these ids; those literal codes are kept as custom formats when a workbook uses them.)264265## 5. Keyboard shortcuts266267ORIX Sheet's shortcuts are defined in three places: `GridView.keyDown` and `performKeyEquivalent`268(`Packages/SheetUI/Sources/SheetUI/Grid/GridView+Events.swift`), the menu bar269(`App/Sources/MainMenu.swift`) and the actions that features register270(`WorkspaceAction.shortcut`). The in-app list is `HelpView.shortcuts` in `App/Sources/Welcome.swift`.271272The "Excel for Mac" column is Microsoft's published shortcut list for Excel on macOS as known to the273author of this page; it was not checked against a running Excel and Excel's defaults change between274versions.275276### Same as Excel for Mac277278| Action | Shortcut |279|---|---|280| Move, extend selection | arrows, ⇧ + arrows |281| Jump to the edge of the data region (and extend) | ⌘ + arrow or ⌃ + arrow (with ⇧ to extend) |282| Edit the active cell | F2 or ⌃U; double-click |283| Commit and move down / up / right / left | Return / ⇧Return / Tab / ⇧Tab |284| Fill the selection with the entry | ⌃Return |285| Line break in a cell | ⌥Return |286| Cancel an entry | Esc |287| Select row / column | ⇧Space / ⌃Space |288| Select all | ⌘A (region, then sheet) |289| Go To | ⌃G |290| Fill down / right | ⌘D / ⌘R |291| Bold, italic, underline, strikethrough | ⌘B, ⌘I, ⌘U, ⇧⌘X |292| Cut, copy, paste, undo | ⌘X, ⌘C, ⌘V, ⌘Z |293| Find | ⌘F (opens the find-and-replace bar) |294| Create a table | ⌘T (*Data ▸ Convert to Table…*) |295| Page up / down | Page Up / Page Down |296| New, open, close, print | ⌘N, ⌘O, ⌘W, ⌘P |297| Recalculate | ⌘= (but see below) |298299Source: `GridView+Events.swift`, `GridView.handleEditorCommand`, `MainMenu.swift`, `FeatureAudit/AuditFeature.swift` (⌘T).300301### Different from Excel for Mac302303| Action | Excel for Mac | ORIX Sheet |304|---|---|---|305| Insert today's date | ⌃; | **⌘;** — types the date as `yyyy-mm-dd` into the cell editor (the entry is committed with Return) |306| Insert the current time | ⌘; | no shortcut (⌘; is the date) |307| Show formulas | ⌃` | **⌘`**. macOS assigns ⌘` to "Move focus to next window" by default; which one takes effect was not tested |308| Fill down / right with Control | ⌃D / ⌃R | not bound (⌘D / ⌘R only) |309| Next / previous sheet | ⌃Page Down / ⌃Page Up, ⌥→ / ⌥← | **⌥⌘→ / ⌥⌘←** |310| Insert a sheet | ⇧F11 | no shortcut (*Insert ▸ Sheet*, or the + button of the sheet tabs) |311| Rename the sheet | no default shortcut | ⌥⌘R |312| Beginning of the row | Home | Home moves to the first column **after the frozen columns** |313| Beginning of the sheet | ⌃Home | **⌘Home** (first cell after the frozen panes); ⌃Home is not bound |314| Last used cell | ⌃End | **⌘End**; End alone moves to the last used column of the row. There is no "End mode" (End followed by an arrow) |315| Recalculate | F9 or ⌘= recalculates what needs it | ⌘= **recalculates every formula** (`markAllDirty`); F9, ⇧F9 are not bound. Ordinary recalculation is always automatic; there is no manual calculation mode |316| Paste Special | ⌃⌘V opens a dialog | no dialog: ⇧⌘V pastes values, ⌥⌘V pastes formatting; *Formulas* and *Transposed* are menu items without shortcuts |317| Toggle absolute/relative reference while editing | ⌘T or F4 | not implemented |318| Redo | ⌘Y (and ⇧⌘Z) | ⇧⌘Z only |319| Zoom | ⌥⌘= / ⌥⌘− | ⌘+ / ⌘− / ⌘0, pinch, ⌘ or ⌃ + scroll wheel |320| Save As | ⇧⌘S | ⇧⌘S is **Duplicate** (macOS autosave document model; there is no Save As) |321| New from template | ⇧⌘P | **⇧⌘N**; ⇧⌘P is *Page Setup…* |322| AutoSum | ⇧⌘T | toolbar button only |323| Insert function / Formula Builder | ⇧F3 | no shortcut (function browser in the inspector) |324| Replace | ⌃H | same bar as Find (⌘F) |325| Delete rows/columns, insert cells | ⌘− / ⇧⌘= (⌃− / ⌃⇧=) | ⌘− is Zoom Out; rows and columns are inserted and deleted from menus. Inserting or deleting individual cells with a shift is not implemented |326| Context menu key, F6 pane cycling, F10 menu, key tips | various | not implemented beyond macOS defaults |327328Source: `GridView+Events.swift` (key codes 36/76, 48, 51/117, 53, 115, 119, 116/121, 120, 49 and the329`performKeyEquivalent` table), `MainMenu.swift`, `Welcome.swift`.330331### Shortcuts that exist only in ORIX Sheet332333| Shortcut | Action | Defined in |334|---|---|---|335| ⌥⌘M | Merge or unmerge cells | `MainMenu.swift` |336| ⌥⌘I | Show or hide the inspector | `MainMenu.swift` |337| ⌃⌘S | Show or hide the navigator | `MainMenu.swift` |338| ⇧⌘E | Export the active sheet to PDF | `MainMenu.swift` |339| ⇧⌘P | Page Setup | `MainMenu.swift` |340| ⌥⌘K, ⌥⌘1 … ⌥⌘5 | Insert chart…; quick column, line, scatter, pie, histogram chart | `FeatureCharts/ChartsFeature.swift`, `ChartBuilder.quickKinds` |341| ⇧⌘I | Import data… (data engine) | `FeatureData/DataFeature.swift` |342| ⌥⌘P | Python Studio | `FeaturePython/PythonFeature.swift` |343| ⌥⌘A | Audit Workbook | `FeatureAudit/AuditFeature.swift` |344| ⌥⌘N | Named Ranges… | `FeatureAudit/AuditFeature.swift` |345346Source: the files named in the table, read on 2026-11-21.347348No key equivalent is used twice in the menu bar:349350- *Insert ▸ Sheet* has no shortcut, so ⌥⌘N belongs to *Data ▸ Named Ranges…* only.351- Feature actions ask for their shortcut when they register. `MainMenu.workspaceItems` keeps a set of352  the shortcuts already given: when a second action asks for one that is taken, the first keeps it353  and the second gets a menu item without a key equivalent. This is the case of ⌥⌘A: *Audit354  Workbook* (Analyze menu, built first) keeps it, and the *Automation* action of the Tools menu, which355  asks for the same keys in `AutomationFeature.register()`, has no shortcut.356- The app-hosted test `testMenuBarHasNoDuplicateShortcuts` walks the main menu and fails on any357  duplicate; it passes (`docs/reports/app-tests.json`).358359Other notes: ⌃Space is also macOS's default "select the previous input source" when several input360sources are enabled; Delete and Forward Delete both clear the contents of the whole selection (or361delete the selected object); typing any printable character starts a "quick" edit in which the arrow362keys commit and move.363364## 6. What to expect when exchanging files with Excel users365366- **Excel → ORIX Sheet**: values, formulas, formats, tables, validation, conditional formats, names367  and print setup arrive. Charts, images, pivot tables and macros are not visible but are not lost368  as long as the workbook is later exported to `.xlsx` / `.xlsm`. Recalculated results can differ369  from Excel's cached ones where section 3 or [formulas.md](formulas.md) lists a deviation; the app370  does not compare the two and does not flag cells whose recalculated value differs from the cached371  value.372- **ORIX Sheet → Excel**: cells, formulas, formats and the modelled sheet features are written. ORIX373  charts, figures, pivot tables, Python scripts, queries and workflows are **not** exported; the374  preflight report says so before the file is written. Formulas using functions Excel does not have375  will show `#NAME?` in Excel.376- **Round trip Excel → ORIX → Excel**: rich text in cells, theme-colour links, threaded-comment377  structure, filter criteria, x14 conditional-format extensions, split panes and the items marked ✗378  above are lost or flattened; preserved parts (charts, pivots, VBA in `.xlsm`) come back unchanged379  and are therefore stale if the cells they depend on were edited.380
Files main
Menu

Theme