Product updates: Public workbook sharing and embedding, autofill with auto-increment, selection calculator, and more
co-founder & CEO
We're excited to launch the ability to publicly share and embed workbooks along with a number of popular enhancement requests and fixes. Plus some new ways to :sparkle: ✨ with emojis and stay rightly aligned.
Public workbook sharing and embedding
You can now publish workbooks publicly in a read-only state, and embed them in other websites and apps, with the new Public share and embed option available in the workbook File menu. This same feature is what allows us to embed live template previews in the Spreadsheet.com Template Gallery today.
Autofill with auto-increment
As with traditional spreadsheets, you can now select two or more cells in Spreadsheet.com and drag vertically or horizontally to automatically fill a range with auto-incremented values. Ranges of numbers, currencies, dates, percentages, and strings with a sequence of numbers, are supported. This also includes day and month names and abbreviations, and data types such as Rating, which is number-based.
You may have already noticed the new selection calculator in the bottom right corner of your worksheets when you have 2 or more cells selected, showing you a calculated value of the selected range. As with traditional spreadsheets, you can choose different calculation options depending on the type of data selected. This is a great way to do a quick calculation without writing a formula.
We're excited to share that we’ve finally rolled out multi-column delete, one of the most commonly requested enhancements we’ve received since opening up Spreadsheet.com for early access. Perhaps we’ll share more in the future about the complexities of building an online real-time collaborative spreadsheet. Suffice it to say, things like this are often more complicated than they sound!
Emoji autosuggest 🎉 🎊 🥳
Emoji fans will be delighted 😊 to know that you can now insert emojis into channels by typing a colon : followed by an emoji symbol name to find and select a matching emoji, as in Slack and other popular collaboration tools.
Duplicate automation actions
Often when creating an automation you need to perform multiple actions in sequence. Sometimes those actions are nearly identical, so it’s much faster to be able to copy existing actions rather than create each one from scratch. Now you can quickly create copies of actions with the new Duplicate action option. Hover over any action and click the copy icon to duplicate it, as shown below.
Overflow for right-aligned text
Most of us take so many complex things in traditional spreadsheets for granted, like the positioning of text that overflows into adjacent empty cells when the cell is left aligned, center aligned, or right aligned. At Spreadsheet.com, we can't take anything spreadsheety for granted 😅. Today we’re happy to share that right aligned text now overflows to adjacent empty cells to the left of the originating cell, as shown below.
Fixes and enhancements
Improved Gantt rendering performance and fixed several Gantt view scrolling issues that were specific to Firefox and Safari.
Gantt dependency lines are now rendered even if a taskbar is out of the currently visibile view.
Added support for importing TSV files (tab separated values).
Fixed an issue that caused cells and ranges to be unselectable in Safari when using the mouse to create a formula.
The color selector now lets you change the foreground or background color of a range to the same color of the top-most selected cell.
Deleting the last column in a worksheet no longer scrolls the user to the bottom of the sheet.
Increased the maximum number of rows that can be pasted from 1,000 to 10,000.
Sharing by link We’re expanding the set of sharing options for folders and workbooks allowing them to be shared using a preconfigured link. Options will include sharing to only a specific set of users, any users who belong to a specific set of named domains, or anyone with the link.
Zapier integration We’re in the process of being added to the Zapier app directory, which will allow you to create zaps that connect Spreadsheet.com worksheets with over 3,000 other apps and sites.
Named ranges Full support for defining and editing names ranges, as in traditional spreadsheets. Today named ranges can be imported as part of existing spreadsheets, and referenced in formulas, but cannot yet be defined and edited within Spreadsheet.com.
Hide worksheets As with traditional spreadsheets, Spreadsheet.com will soon support the ability to hide worksheets. Imported workbooks with hidden worksheets will work as expected, with hidden worksheets remaining hidden by default.
Duplicate worksheets Ability to copy worksheets within and across workbooks, including all data types, attachments, and relationships.
Duplicate columns Ability to copy columns within and across worksheets and workbooks, including column-level data type settings.
Workbook loading speed improvements Several optimizations are underway that we expect will improve the speed of workbook loading significantly.