Changelog

Product updates and more

Follow on Twitter

Performance Improvements

Cover Image for Performance Improvements

We shipped a big performance improvement in this release. Everything from uploading files to calculating formulas should run faster now. And undo redo history should be preserved nearly perfectly.

In addition, we made a handful of other quality of life improvements

  • Fixed plain text HTML pasting into Subset
  • Fixed changing decimals on number formats that use semi-colons
  • Added support for IFERROR formula
  • Double clicking a cell opens the formula editor in edit mode
  • Cutting a cell with a formula that references other cells will translate the formula references automatically
  • Undo and redo now supports cell formats and translated formulas
  • Tab moves the cursor to the right

Command K

Cover Image for Command K

A command line for all spreadsheet commands. Just hit cmd + K. Never again forget how to do something in a spreadsheet. And learn the keyboard shortcut for that exact command for the next time!

Website Refresh

Cover Image for Website Refresh

We decided it was time to dust off the mysterious dark mode landing page drop and share a little more about what we're working on! We hope you like it.

Import XLSX

Cover Image for Import XLSX

Import XLSX into Subset by simply double clicking them. We're continuing to add more support for features in xlsx files, so let us know if anything doesn't import correctly.

Autofit column width

Cover Image for Autofit column width

Alt HOI for those who know. Select any range of data, and automatically fit the column width.

Other fixes

  • Numbers that are entered with a % sign are automatically percent formatted
  • Added blank as the last value in the color cycle
  • Fixed an issue with undo not restoring cell formats
  • Removed non-breaking spaces when pasting HTML
  • Automatically translates full size formula ranges into row or column ranges
  • Fixed an issue where % was not parsed correctly in formulas
  • Fixed an issue where dividing by zero failed
  • Fixed an issue with pressing an arrow key after opening the editor not referencing other cells

Import CSV files

Cover Image for Import CSV files

We added support for importing CSVs. Simply double click the CSV and it will open in Subset.

Other fixes

  • Fixed an issue with negative dollar sign serialization
  • Fixed a bug in file deletion when offline
  • Fixed an issue with referencing cells that are non-existent
  • Automatically append rows or columns if pasting data larger than the sheet
  • Fixed an issue with deleting a format when multiple formats overlap
  • Fixed an issue where negative row or column indexes were incorrectly showing up
  • Fixed an issue with format colors overlapping

A lot of little fixes

Cover Image for A lot of little fixes

No major theme on this edition. Just a lot of little fixes. Here's what we shipped:

  • Fixed an issue where the scrollbar is visible by default
  • Fixed the general default number format
  • Added support for arrow keys in color dropdown menu
  • Fixed the loading screen showing up on reload incorrectly
  • Added an email us support button
  • Added support for undo redo on desktop with shortcut keys
  • Fixed an issue with deleting a file not returning to home screen
  • Added support for handling decimals with no preceding digit
  • Fixed an issue where grid scrolled off screen when using command+arrow keys
  • Fixed a CYCLE error where there shouldn't be one
  • Added support for argument hints when editing formulas
  • Fixed an issue with MIN and MAX on empty ranges

Copy and paste

Cover Image for Copy and paste

We've finally added support for copy and paste. Paste special is on the way as well. Right now, cut, copy, and paste work for all values, formats, and data. Even paste data from one cell into multiple cells.

The hardest part was getting formula translation and references to work across cut and copy, both of which have different behaviors.

Accelerator keys

Cover Image for Accelerator keys

We love shortcut keys at Subset. Especially ones you can trigger using Alt, aka accelerator keys in other spreadsheets. This is just the start, but now you can start formatting without ever touching a mouse.

Try using Option HOI or Option AC. Alt is the option key on the mac if you didn't know!

New landing page and branding

Cover Image for New landing page and branding

We're finally getting to releasing the new Subset color scheme and landing page. We're keeping it minimal for now, but we jumped on the dark mode bandwagon.

The templates pages have downloadable files for all templates, and Canvas is now linked in the main menu.

Formula cell selection

Cover Image for Formula cell selection

The ability to select cells when typing a formula is another essential part of a spreadsheet. Click or use your keyboard to select cells as references in formulas.

Cell formatting

Cover Image for Cell formatting

We're grinding through support for all the basics. Cell colors, text formatting, borders, alignment, and more. No spreadsheet is complete without these essentials.

Introducing Subset

Cover Image for Introducing Subset

Hey there! We're a small team of developers and finance professionals obsessed with spreadsheets. Now we're building Subset to scratch our own itch of a modern, no-frills, high quality, local-first, multiplayer spreadsheet.