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

- 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, andCONCATENATE. - 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, andCOUNT. - 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.