A1 notation, Docker self-hosting, optimized builds, more formulas

In January, we shipped:

• A1 notation
• Docker self-hosting
• Optimized builds
• More formulas
• Numerous small improvements and fixes

A1 notation

We switched all references to A1 notation for simpler references in Quadratic. This is the same notation used in traditional spreadsheet software.

You can learn more about the new references in our docs.
You can let us know what you think about the new references in our community forum.

You can now easily reference entire columns, rows, and selections from Python.

Docker self-hosting

Individual users and teams can now self-host Quadratic using Docker. This is the fastest way for self-hosting users to get started with Quadratic.

You can learn more about self-hosting Quadratic with Docker in our docs.

Optimized builds

We've heavily optimized builds in Quadratic by optimizing Docker images and switching to GitHub Actions from Vercel for previews. Our builds run significantly faster as a result.

More formulas

We've added a bunch of new formulas to Quadratic. Additions include:

• EDATE
• EOMONTH
• IFNA
• VAR
• STDEV
• PMT
• IFNA
• ROUND
• ROUNDUP
• ROUNDDOWN
• TRUNC
• SUMPRODUCT

Small improvements and papercut fixes

We resolved a number of outstanding minor improvements and papercuts; these fixes significantly improve the overall experience in Quadratic. Some of these fixes from the last month include:

• Marching ants on copy targets
• JavaScript 1-D vs 2-D fix
• Persist sheet name in URL
• Show import data dialogue on new file
• Let AI use Formulas instead of Python for simple calculations
• Copy-paste code cells should change relative reference
• Right-click column should work on multi-select columns
• A1 references shouldn't overrun their bounds
• Support for more parquet compression types

Follow our roadmap on GitHub.