The new SpreadsheetConverter version 10

Version 10 increases your productivity by up to 33% with automatic, background conversions. The live preview windows are always in sync with what you do in Excel. When you use a tool that supports your creative process, it’s easy to stay focused. 

Spiderman movie poster from 2002

What do you remember best from the year 2002? Watching Tobey Maguire in his first appearance as Peter Parker in Spiderman? The Olympic games in Salt Lake City? The introduction of the euro as the common currency in the European Union? Listening to Shakira sing Whenever, Wherever? The release of SpreadsheetConverter 1.0?

Well, if you chose the last item in the list, we don’t believe you 🙂 We’re just trying to put things in perspective. SpreadsheetConverter was designed at a time when a powerful laptop was running Windows XP on a 1 GHz Pentium processor. Nobody had yet invented Facebook, Skype, Spotify or the iPhone. And Justin Bieber was eight years old.

We’re just saying this so that you can forgive some of the design decisions we made back in the days. Like having a Convert button that you had to press every time you want to see what the converted web page looks like.

Well, that is about to change.

Moving forward

From a user interface point of view, we have passed through two generations.

  • Versions 1-5 had a wizard-style design where you set various options in the initial steps and then ended at the Convert button.
  • Versions 6-9 added a task pane to the Excel user interface, where you could set the Workbook and Worksheet options before you pressed the Convert button in the menu.
  • Version 10 marks the beginning of the third SpreadsheetConverter generation, where conversion is automatic in the background.

Version 10 also increases productivity by introducing a new responsive ribbon layout, with direct shortcuts to the tabs and windows you use most often.

Version 10 lets you copy and paste widgets, and if you need to insert many widgets of the same kind there are now two ways to do this with just one click.

Introducing Live Preview

Photo of a laptop with a form developed in Excel and a desktop with the same form as a web page in Google Chrome

The biggest new feature in version 10 is called Live Preview. Thanks to the increased computing power of a modern laptop, the web page can now update itself automatically, in the background, without any intervention from you. As you start to use the new version, you will notice that you work much more efficiently when you can focus on your design work in Excel. There are no more interruptions, since you never have to wait for the converter to update the web page.

When we tested version 10, we found that we wanted to have the web page always visible on a separate screen, so that we could just glance at it to see the progress we were making. But not everybody has a second screen, so we made the preview function so flexible that you can run it also on your old laptop, a clunky second-generation iPad, your Android phone from 2011 – Live Preview just works, with everything, you can have an unlimited number of preview windows, running on an unlimited number of devices. Fill your desk with them!

To see Live Preview in action, watch this video introduction.

Our studies show that version 9 users may spend up to a quarter of their time waiting for the web page to be updated when the conversion is complete. As we automate the conversion step in version 10, developers can continue uninterrupted throughout the entire design process, with an expected productivity gain of up to 33%.

Learn more about Live Preview.

The new SpreadsheetConverter ribbon menu

The new responsive ribbon increases productivity for both new and experienced users.

We added a few powerful shortcuts to let you go directly from the menu to insert a widget or edit Workbook or Worksheets settings.

Screenshots showing the direct links to the task pane in version 10

If there is already a widget in the current cell, the Insert Widget button changes into Edit widget to let you access the widget’s settings directly from the ribbon.

Screenshot of the Edit Widget button in version 10

The settings for worksheet-level widgets like Hide Rows/Sheets and Responsive Blocks are always accessible directly from the ribbon.

Screenshot of the Insert Widget menu in version 10

We changed the History list into a Recent file list on the left-hand side of the ribbon, making it much easier to open or share a recently converted web page. The Recent list has a timestamp for the most recent conversion.

Screenshot of the Recent files list in version 10

We split the Sharing section into two: Test and Publish. This gives you direct links to upload a web page to the Test and Production locations on our cloud servers. There is a help page about Publish to Cloud. In the Node.js flavor, **QuickNode** appears in the **Test in Cloud** menu.

Screenshot of the Test and Publish sections of the ribbon

For those of you using our online spreadsheet database solution SpreadsheetServer, it is now directly integrated into SpreadsheetConverter.

Screenshot of the SpreadsheetServer menu in the Publish section of the ribbon

The WordPress plugin button lets you create an SSC calculator file for export to WordPress where you can import it with our WordPress plugin. If you use another content management system, check if there is a shortcut to an integration document for your specific CMS on our website.

Screenshot of the WordPress menu in the ribbon

If you have a problem, use Report issue to request help. Adding lots of troubleshooting information is very easy thanks to the convenient checkboxes.

Screenshot of the Report Issue window

The Convert section needed a few new options to support Live Preview. Tick the Live Preview checkbox and the Convert button gets a new “repeat” arrow. Click on the Convert button to activate Live Preview. With Live Preview active, the web page is automatically regenerated when you make changes in Excel and save.

Screenshot of the Convert section of the version 10 ribbon

The Options menu now appears in the Convert group.

Screenshot of the Options in the Convert section of the ribbon

We changed the name of the Errors tab in the task pane to Messages. You can review the messages from the most recent conversion using the Messages section of the ribbon. With version 10, the messages from the most recent conversion of a spreadsheet are saved indefinitely.

Screnshot of the Messages section of the ribbon and the task pane

We updated the ribbon to better expose some of the most used features for new users. SpreadsheetConverter comes with a handful of examples so that you can test it right away.

The new Learn section of the version 10 ribbon

There is a help page for the SpreadsheetConverter ribbon. 

Other enhancements in version 10

The new version 10 comes with several other enhancements.

Cell widgets can be copied and inserted in batch

Widgets make your web page more expressive and increase the quality of the input data. However, adding many widgets of the same kind used to be time-consuming. Version 10 adds two simple ways to quickly insert many cell widgets.

  • Cell widgets can be copied using Ctrl+C and then pasted into one or more other cells with Ctrl+V. This makes it easy to define a prototype widget, e.g. a text field, and afterward easily “clone” this widget and its settings to an unlimited number of cells.
  • You can select multiple cells and insert a batch of the same type of cell widget in all selected cells with a single click.

As before, cell widgets can also be moved using Ctrl+X  and then pasted into one or more other cells with Ctrl+V, or dragged and dropped into the right cell.

You can easily remove multiple cell widgets in the same operation.

  • Select all the cells that contain the widgets you want to remove.
  • In the ribbon, open the small menu next to Edit widget and select Remove widget.

Regardless of how you insert cell widgets, you must still select them one by one to edit their properties. Copying widgets by selecting a cell and pressing Enter or using AutoFill (Fill Down/Fill Right) is not supported. Widgets that use image placeholders like Link Image and Google Map cannot be copied. The Dropdown, Dynamic Dropdown and Radio widgets still need to be inserted one by one.

Standard Edition users get Interactive charts

So far, our powerful interactive charts have been a Pro-only feature. With version 10, all users get access to the new chart engine. Visit the help page for Interactive charts to learn how to enable them.

Miscellaneous

  • Any messages from the most recent conversion of a spreadsheet are saved indefinitely.
  • In Excel, the SpreadsheetConverter menu tab no longer shows the version number if you only use one version of SpreadsheetConverter.

Download version 10 now!

Upgrading to version 10

Version 10 is available on the Download page.

The prices for version 10 are the same as for version 9.

If you purchased version 9 or upgraded to version 9 on or after October 1, 2017, you get a license key for the same edition and flavor of version 10 for free.

Upgrade links will appear here when beta testing is finished.

 

Notes about the upgrade

Upgrade the WordPress plugin

We offer a free WordPress plugin to publish calculating web pages in WordPress.

For licensing reasons, the plugin must be of the same major version as SpreadsheetConverter when you add or modify existing calculators or forms in WordPress.

  • If you have calculators or forms embedded in your website with version 9 of the WordPress plugin, they are unaffected by the version change and continue to work as before.
  • Version 9 of the plugin only handles calculators generated by version 9 of SpreadsheetConverter. If you want to add new calculators or forms converted with SpreadsheetConverter version 10 to your WordPress website, you must upgrade to version 10 of the WordPress plugin.
  • Version 10 of the plugin only handles calculators generated by version 10 of SpreadsheetConverter. If you need to update or edit an existing version 9 calculator using version 10 of the plugin, you must convert the spreadsheet with SpreadsheetConverter 10 and upload the version 10 SSC calculator file to WordPress.

The WordPress plugin and the upgrade to version 10 of the plugin are free of charge for users with a Professional Edition license for SpreadsheetConverter.

Talk to us

What do you think of the new version? Are we going in the same direction as you? What new feature do you personally need the most? Don’t hesitate to give us your opinion. Just send an e-mail to support@spreadsheetconverter.com and let us know what you think.