We’re excited to announce the release of several new features and enhancements we've been busy working on during the past few months:
In addition to these improvements, we’ve fixed over 66 bugs in this release and published the first version of the Spreadsheet.com Roadmap in the community.
We’ve completely rewritten how cut, copy, and paste operations work in Spreadsheet.com, including how Spreadsheet.com data is stored in the clipboard. Now all data types, styling, and formulas can be cut or copied as-is from one worksheet to another, even across workbooks in different browser windows. Data in attachment cells, related row cells, collaborator cells, etc., is preserved.
Pasting data into a Spreadsheet.com worksheet from other spreadsheet applications (e.g. Excel, Google Sheets) and external applications (e.g. web browsers, word processors) has been substantially improved, with pasted data automatically converted to target data types. Formatting and styling is also maintained where possible.
In addition, copying and pasting data from Spreadsheet.com to other spreadsheets and applications has been substantially improved, with rich data type values replaced by human readable text where applicable.
We’ve also added a “paste values only” option that appears after a paste operation is completed, providing an option to remove copied styles and data types from the paste operation, similar to the behavior of traditional spreadsheet applications.
Workbooks can now be exported to Excel (an XLSX file) by selecting the “Export to Excel” option in the File menu. This feature is a work in progress that has been in high demand by early Spreadsheet.com users, so we decided to launch it in its current beta state. Please let us know if you run into issues with an exported file and we will prioritize a fix.
Cells with data types that have no equivalent in Excel (e.g. Attachments, Related rows, Collaborators, etc.) will be converted to the closest human readable text equivalent value.
After observing many early Spreadsheet.com users interacting with the table header row, we’ve added context menus to table header row cells to make this feature more intuitive and behave more like table headers in traditional spreadsheet applications. This new context menu provides faster access to sorting, filtering, and changing column data types within a worksheet's table region.
It’s been a surprise to us how many people use the formula bar to view and edit formulas rather than the in-cell formula editor. We’re excited to now bring the same cell-level formula assistant-based editor experience to the formula bar.
We’ve added a formula calculation progress bar to make it clear when the formula engine is busy calculating. Often in worksheets with large numbers of formulas or complex calculations, worksheets may appear slow to respond when the worksheet is first loaded because the formula engine is busy. The new formula calculation progress bar provides a visual indication when this is happening.
Checkbox cells now adopt each cell's foreground color, allowing you to choose any color for your checkboxes as easily as changing the color of text.
As usual, whenever we release updates to the product we share more details of new features, enhancements, and fixes in the What’s New? section of the Spreadsheet.com Community.
We're also excited to announce the first version of the Spreadsheet.com Roadmap. Please let us know if any item in particular is critical for you. This will help us adjust priorities based on demand.
