CAPABILITY / SPREADSHEET APP
A spreadsheet app, not just a grid
The composable shell puts an Excel-style ribbon, name box, formula bar and sheet tabs around one grid. Everything here is the public API.
- Chrome
- Ribbon, formula bar, tabs
- Workbook
- 2 sheets, cross-sheet SUMIF
- Setup
- createSpreadsheetShell({ ribbon: true })
Try it
- Total a columnSelect Sales!G2:G49, then Home › Editing › AutoSum.A SUM lands under the last row.
- Format a regionPick a region cell, then Fill Color, Borders or Merge & Center.The format is stored on the cells and survives XLSX export.
- Change a priceEdit a unit price on the Sales sheet.Summary recalculates across sheets.
- Read a notePoint at the amber corner on Sales!G3 to read it. Select the cell and press Shift+F2 to edit.The note opens beside the cell. Clear the note to delete it.
- Use the right-click menuRight-click a cell, then Insert › Row above. The arrow keys work too.Undo removes the new row.
- Narrow the windowUse the button to switch between a wide and narrow window.Groups shrink, then fold into dropdowns, as in Excel.
How it is built
// The full app: ribbon, name box, formula bar, tabs
// The same ribbon on a grid of its ownEvery ribbon command calls grid.actions, so your own toolbar can call the same methods.
Keyboard
- Tab
- Reach the ribbon tabs
- ←→
- Move between tabs
- Esc
- Return to the grid
Hide or show the panel (double-click a tab).