In February, we were laser-focused on shipping tables. This update added many new default features to the spreadsheet and support for the new family of Claude 3.7 models.
Tables
The default data format in Quadratic is now tables. Imported data is automatically placed in a table, which you can format to your preference.
Table basics
Tables have several features focused on formatting the data appropriately. You can access the primary table menu by right-clicking the table name or using the table dropdown button.
You can access column-specific options by right clicking on a column header.
You can view and navigate to all your tables and code from the navigation menu.
All code outputs are also now named and inherit many of the features of tables.
Table references
You can reference tables by their name, retrieving the entire table, specific columns, or table headers.
# Retrieves the entire table as a DataFrame
q.cells('table_name')
# Retrieves a specific column as a single-columnDataFrame
q.cells('table_name[column_name]')
# Retrieves the table headers as an empty DataFrame with the inherited column names
q.cells('table_name[#HEADERS]')DataFrames returned to the sheet from code inherit many of the features of tables, including sorting.
Sort
The columns of a table can be sorted by clicking on the sort button in the column header. The sort has three states: none, ascending, and descending.
A fun side-effect of sorting is that code referencing that sort will automatically update the sorted data.
AI outputs
AI understands tables and will automatically format data it inserts into the sheet as tables when appropriate. It also understands how to write code referencing tables and will default to table references whenever possible.
Claude 3.7 AI model family
As of this changelog, Claude 3.7 is the new default model for AI in Quadratic. It markedly improved the quality of AI outputs. We also added support for Claude 3.7 "Thinking" mode. This mode adds reasoning to the model, allowing the AI to plan its steps and go far further with its outputs than it would have otherwise.
We're most excited about Claude 3.7 Thinking, which has some novel behaviors in the spreadsheet.
PR links
Tables: PR link
Claude 3.7: PR link
Follow our roadmap on GitHub.
