Holarch

Plan

Spreadsheets

Excel-compatible workbooks inside the project: sheets, formulas with Excel's functions, formats, tables, validation, named views with filters and sort, live model data, charts, Excel import and export, and AI formula help. A spreadsheet is an Artifact labeled Spreadsheet.

Where to find it

  • In the navigation rail: Plan → Spreadsheets.
  • Plan → Spreadsheets (spreadsheets); a spreadsheet opens at spreadsheets/<id>. ⌘K / Ctrl+K → New Spreadsheet… or Import Excel Workbook as a Spreadsheet….

Main actions

  • List: search and + New Spreadsheet. Card ⋯ (or right-click): Open, Rename…, Duplicate, Open Item View, Move to Trash.
  • Toolbar: Edit (Undo, Redo, Cut, Copy, Paste ▾ with Paste Special…, Cells ▾, Fill ▾) · View (Freeze ▾, Gridlines, Sort & Filter ▾, Find) · Format (Recalculate, B, I, U, fill and text colour, Borders ▾, Alignment ▾, Number Format ▾, %, thousands, decimals, Conditional ▾) · Insert (Note, Table ▾, Validation ▾, Model Table…, Chart ▾) · ✦ AI ▾ · ⋯ (Keyboard Shortcuts, Rename Spreadsheet, Open Item View, All Spreadsheets, Help, Export to Excel, CSV or TSV, Show Import Summary, Move to Trash).
  • Formula bar: the Name Box (go to an address or name, or type a name to define it; ⌃G / Ctrl+G), ƒx, the formula as typed, ✕ and ✓. Function names autocomplete (Tab inserts) and an argument hint follows. F4 switches a reference between relative and absolute; arrow keys while typing a formula point at cells.
  • Formulas: Excel's formula language with English function names and commas, calculated by the Holarch Calc Engine: dynamic arrays and spills, LET, LAMBDA and named LAMBDA functions, REGEX functions, and structured references such as Parts[Mass]. Edits recalculate at once; Recalculate calculates everything again, with progress and Cancel for long runs.
  • Sheet tabs: + adds a sheet, All Sheets lists them, double-click renames, drag reorders. Right-click: Insert Sheet, Rename, Move Left/Right, Tab Color, Hide Sheet, Unhide Sheet…, Delete Sheet.
  • Named views: Default, shared (👥, made by editors, seen by everyone) and personal (👤, only you; saved with your account). A view keeps filters, sort, hidden and reordered columns, widths and frozen panes, and never changes cells. Totals ignore personal view filters, so every viewer sees the same values; use SUMIFS to total a filtered subset. Changes show Unsaved changes with Save View and Revert; + New View and the view ⋯ (Save as New View…, Rename View…, Delete View).
  • Sort and filter: on the data block around the active cell (its first row is the header row; one filter range per view). Sort & Filter ▾: Sort A to Z, Sort Z to A, Custom Sort… (up to 8 levels), Filter Buttons (⇧⌘F / Ctrl+Shift+F), Clear All Filters, Clear Sort. A filter button filters by value or by condition.
  • Editing: copy and paste with Excel (formats and formulas), Paste Special (All, Values, Formulas, Formats, Notes, Transpose, Skip blanks), the fill handle and Fill ▾ (Down, Right, Up, Left, Series…), Insert and Delete Cells, Rows and Columns, Hide and Unhide, Row Height… and Column Width….
  • Formats: Format Cells… (Number, Alignment, Font, Border, Fill; Excel format codes), Conditional ▾ (Highlight Cells Rules, Top and Bottom Rules, Colour Scales, Clear Rules, Manage Rules…).
  • Tables: Table ▾ or ⌘T / Ctrl+T: header row, name and style; Total Row, Banded Rows, Rename Table, Convert to Range. Renaming a table or its headers updates the formulas that name them (a single Undo takes it all back).
  • Validation, notes, find: Data Validation… (whole number, decimal, list, date, text length; input message; Stop, Warning or Information alert), Note (⇧F2 / Shift+F2), Find and Replace (⌘F / Ctrl+F, ⇧⌘H / Ctrl+Shift+H) in the sheet or the workbook.
  • Model data: Model Table… inserts a live, read-only table of a class, a saved view or a query, with chosen columns, converted to one unit per column (in SysML v2 projects, optionally definitions instead of usages). HOLARCH.VALUE(item, attribute, [unit]) and HOLARCH.COUNT(query) read the model in formulas. A spreadsheet never writes to the model.
  • Excel: import .xlsx/.xlsm with formulas live. Cells whose formula is not calculated here keep Excel's value and are marked Value only, not recalculating (a struck-through fx badge, a note under the formula bar, the reason as tooltip and screen-reader description); the Import Summary lists them with address and reason and compares every other formula with Excel. Export to .xlsx with formulas, formats, tables and charts (linked charts stay linked to their cells, stacked charts stay stacked); model data is written as values with an About this export sheet.
  • Charts: Chart ▾ (column, bar, line, pie, donut, scatter, stacked and 100% stacked) over the selected cells; move and resize by mouse or keyboard. A chart goes exactly where it is dropped; hold ⌥ / Alt (Alt) while dragging to snap it to cell edges, or turn on Snap to Cells in the chart menu to snap by default (⌥ / Alt then drops freely). The chart menu has Format Horizontal Axis…, Format Vertical Axis…, Format Chart Title…, Format Legend… and Format Data Series…; clicking an axis, the title, the legend or a series of a selected chart also selects it. The Format panel sets axis bounds, units, crossing point, log scale, order, title and number format, the title, the legend position and series colours; a single Undo takes back each change. Copy for a Whiteboard pastes a linked chart on a board.
  • ✦ AI ▾: Explain Formula (nothing changes) and Write a Formula… (previewed with its result, then inserted; a single Undo takes it back).

Tips

  • Limits: 100,000 filled cells per spreadsheet and 250,000 per project; Excel imports up to 50 MB. A formula result over 1,000,000 cells (more than one whole column) is #NUM!.
  • REGEX functions run on a linear-time engine: look-around, back-references and other backtracking-only patterns, and repetitions of repetitions such as (a+)+, are #VALUE!. The note under the formula bar names the cause.
  • Single-key shortcuts such as ? do not work while a cell has focus. Use ⋯ → Help for Spreadsheets, or F6 to leave the grid.
  • Validation checks typed entries only, as in Excel: pasted, filled and formula cells are not checked.
  • ⋯ → Keyboard Shortcuts lists every shortcut.

Related

Build a Budget Spreadsheet · Whiteboards · Charts · Import and Export