Aug 9, 2021

Product updates: Public workbook sharing and embedding, autofill with auto-increment, selection calculator, and more

Matt Robinson
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.

Public workbook sharing and embedding in Spreadsheet.com
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.

Autofill with auto-increment in Spreadsheet.com

Selection calculator

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.

Selection calculator in Spreadsheet.com
Multi-column delete

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!

Multi-column delete in Spreadsheet.com

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.

Emoji autosuggest in Spreadsheet.com
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.

Duplicating automation actions in Spreadsheet.com

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.

Overflowing right aligned text in Spreadsheet.com

Fixes and enhancements

Read more in the community: Product Updates - August 9, 2021

What's next?

A few features we're busy working on now:

… and more. Stay tuned!

More blog posts ...