Skip to content

Workbooks

Workbooks

Collaborative spreadsheets combining formula calculations, named ranges, inline chart rendering, and data validation rules.

Workbooks spreadsheet interface showing formula bar, sheet tabs along the bottom, and an inline chart
  • Formula Calculation Engine & Function Set. Full formula bar supporting address referencing (`A1:C10`), function autocomplete, and functions including SUM, AVERAGE, COUNT, MIN, MAX, IF, VLOOKUP, and CONCATENATE.
  • Named Ranges & Address Box. Define custom named ranges (`Sales_2026`) in the Named Ranges dialog and jump to ranges directly using the formula address box.
  • Live Status Bar Statistics. Highlighting cell ranges automatically calculates and displays aggregate metrics in the status bar: SUM, AVERAGE, MIN, MAX, and COUNT.
  • Inline Charts Wizard. Generate Bar, Line, Pie, and Area charts rendered directly over spreadsheet cell ranges.
  • Formatting & Validation Rules. Define conditional formatting rules (value threshold or custom formula), number formatting (currency, percent, date, plain text), cell border styles, and data validation drop-down lists.
  • Multi-Sheet Management. Organise workbooks using sheet tabs to add, rename, reorder, delete, and colour-code individual sheets.
  • Import & Export. Full support for importing and exporting CSV and XLSX spreadsheet files.
  • Edit Conflict Handling. Real-time edit conflict notification banner surfaces simultaneous cell edits to prevent silent data overwrites.