← back to blog

Spreadsheet formulas, formatting, and the new toolbar

A spreadsheet is only useful if the math stays correct after you close the tab. v0.7.0 fixes a quiet but painful class of bugs around formula evaluation and persistence, and adds a value-formatting toolbar so a column of numbers can actually look like currency without manual workarounds.

Formulas now persist reliably. If you type =SUM(A1:A10) in a cell, save the page, navigate away, and come back, the formula is still there — the cell shows the computed value, but the underlying expression is preserved and re-evaluated. The same applies to references between sheets and to chained formulas where one cell feeds another.

Merged cells also persist correctly. Previously, merging cells, saving, and reopening the page could quietly drop the merge. That is fixed. Whatever you merge stays merged across reloads, navigations, and exports.

The toolbar gets a new value-formatting button. Pick a range, choose a format — number, currency, percent, date, or a custom pattern — and the cells render accordingly. The underlying value does not change, only its display. That matters because formulas keep operating on the raw number even when the cell shows '$1,234.56' or '12%'.

Together, these three changes make the spreadsheet page feel like a real tool instead of a placeholder. You can build a small budget sheet, a weekly tracker, or a lightweight CRM and trust that what you typed yesterday will still be there tomorrow.

There is more on the way — chart insertions, named ranges, and lookup functions are the obvious next steps — but the foundation is finally solid. If you tried the spreadsheet page in 0.6.0 and bounced off because formulas felt fragile, 0.7.0 is the version to come back to.