SpreadsheetConverter version 7 adds many highly anticipated features. It becomes much easier to create calculators, forms and charts for mobile devices, and to dynamically adapt the formatting depending on cell contents.
If you have previously been using version 5 or older versions, you may want to read about the new features in version 6, too.
Most mobile devices don’t support Flash, so we added the ability to generate charts from a spreadsheet directly in HTML5. This enables you to display charts also on iPads and Android tablets.
Not that we expect charts to be equally popular on iPhones and Android smartphones, but we support them anyway. Naturally, what you see is what there’s room for, depending on the size of the display.
With charts in native HTML, you can now also easily print charts from most modern web browsers.
Wouldn’t it be nice if a cell changed color depending on it’s value? With Excel, conditional formatting provides an excellent way to highlight abnormal values or to focus attention on the most important rows or columns in a spreadsheet. With SpreadsheetConverter 7, conditional formatting is also supported on web forms and calculators converted for iPhone/Android.
When you design forms, it is often useful to be able to hide sections of the form depending on the user’s answers to previous questions. Perhaps you wish to hide questions about current employment for full-time students or people that have retired.
Hidden rows can also provide dynamic selection of text and image in interactive handbooks and debugging wizards, all controlled by the user’s responses.
To the left is an example from a form where the age needs to be specified for all the children in a family. Regardless of the number of children, there is always one Age field per child.
When a form is submitted, an e-mail copy of the submitted form can be sent to the submitter, or to any other e-mail address. Just give a cell the reserved name “email” and have the user enter the e-mail address there.
Like any other named cell, the e-mail address can also be set from the form’s URL, e.g. “…/firstname.lastname@example.org”.
When forms are submitted from mobile devices, it is often essential that the file that is sent is as small as possible. Customers that use the Advanced Submit Service can dramatically reduce the size of the data sent from the mobile device for each form by using the index-quick.htm file that is created during conversion.
You must submit the full form once, for example directly after each conversion from your local PC. The Advanced Submit Service will automatically retain all information from the full electronic form and use it for subsequent “quick” submissions using the index-quick.htm file.
We have also made numerous minor improvements to the product in this new version.
If you have an existing license for SpreadsheetConverter, you need to upgrade the license key for version 7 using the upgrade page. If you have a version 6 license purchased on or after Jan 1, 2013, you will receive a version 7 license key for free.
New versions co-exist with older versions of SpreadsheetConverter, so you can test a new version without removing the old.