Product Updates: New Rich Text data type, new import capabilities, 27 new templates, and more
co-founder & CEO
What's new in Spreadsheet.com?
We’re wrapping up the final week of 2022 with the launch of two new features and a handful of enhancements we think you’ll enjoy:
A new Rich Text data type with markdown support
A new tool for importing data via CSV into existing worksheets
Ability to delete dependencies visually in Gantt charts
Enhanced Project Management settings dialog
Improvements to the mobile and tablet browser user experience
In addition, we added 27 new templates for use cases ranging from Roadmap Reviews to Construction Timelines, Workload Management, Email Campaign Calendars, Party Planning, and more.
Last but not least, we published new Work Management Articles and Guides for you to learn from.
Let’s take a look!
1. Rich Text data type with markdown support
The new Rich Text data type allows you to work with cells like mini documents within your spreadsheets.
As with other data types, columns, ranges, and individual cells can now be set to use the Rich Text data type.
Text in rich text cells can be formatted as:
Bold, Italic, and Strikethrough
Inline code blocks
Formatting can be applied using a floating toolbar that appears above the rich text cell being edited, or by using basic markdown syntax.
For example, typing "[ ] Option 1" will result in:
For a full guide to basic markdown syntax, see Basic Syntax. Note that Spreadsheet.com currently supports a subset of this syntax.
Unlike other data types, pressing the ENTER or RETURN key creates a new line within a Rich Text cell. This allows you to work in a cell as you would a multi-paragraph document. To end and accept cell edits, you can use the Done button at the bottom right of the active rich text cell, or use the TAB key to accept edits and move to the adjacent cell.
2. Import data via CSV into existing worksheets
Now you can easily import data into the table region of existing worksheets. Select the new Import from CSV option from any Sheet view’s options menu and choose a CSV file to import.
A column mapper will allow you to map data from your CSV file to columns in your worksheet, and you’ll see a full preview of what that imported data will look like once it's converted to your worksheet’s assigned column data types.
3. Easily remove dependencies in Gantt charts
With the latest update you can now easily remove dependencies from Gantt views by simply clicking on a dependency line and choosing to delete it.
As with other actions, dependency deletion is undoable and re-doable using standard keyboard shortcuts, e.g. CTRL + Z (Windows) and Command + Z (Mac).
4. New Project Management settings dialog
To accommodate a growing number of project management settings, we reorganized the Project Management settings dialog into a new tabbed interface for easier management.
5. Enhancements to the responsive mobile and tablet user experience
More than 10% of all Spreadsheet.com traffic comes from users on mobile or tablet devices. That's why we’ve been enhancing the responsive mobile and tablet browser experience over the past few weeks with many improvements and bug fixes, including better support for touch gestures.
Stay tuned. We’re on a roll and can’t wait to remove the “Mobile devices not supported” banner from the login page!
New Work Management Resources
In our new Checklists in Project Management article you’ll learn all about project management checklists for successfully conducting research, forming a team, planning a project, and executing it on time and within budget.
In addition, we published 27 new templates for use cases ranging from Roadmap Reviews to Construction Timelines, Workload Management, Email Campaign Calendars, Party Planning, and more.
For example, the Bathroom Construction Plan template is designed for managing a construction schedule, connecting each task with the appropriate contractor, and keeping the project’s costs under control with a built-in budget.
The Roadmap Review template is designed for keeping a list of key roadmap tasks using rich data types and conditional formatting so that overdue tasks automatically get highlighted.
The Email Campaign Calendar template makes it easy to record information about different email campaigns, see all campaigns laid out in a calendar view, and import campaign schedules into external calendar applications like Outlook or Google Calendar.
Dashboards Create and share documents that aggregate and visualize data from multiple workbooks and reports to present a real-time view of information in a variety of ways such as embedded Views, Charts, key metrics, videos, text, and more.
Row Movement Ability to drag and drop rows to reposition them in Sheet and Gantt views. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Drag & Drop Cell and Range Movement Similar to traditional spreadsheets, we’re adding the ability to drag and drop individual cells and ranges to move them in the grid.
Notifications An in-app notifications list updated in real time showing each user all of the row assignments, @mentions, alerts, and reminders meant for them.
Mobile Apps V1 of the Spreadsheet.com mobile app for iOS and Android.
Stay tuned for these and more updates coming soon ...