The PDF file that you get for each submitted form now includes a snapshot of each chart, map and linked image. We provide responsive design for charts, images and maps. There is conditional formatting with 3-color scale and data bars. 

And there is a new ThemePreview toolbar that allows you to test variations of a theme directly in the web browser.

Enhancements for Advanced Submit

SpreadsheetConverter offers a fee-based Advanced Submit Service to help users collect electronic forms. The submitted form is directly delivered to the Inbox of the form owner along with the form contents encoded in PDF and CSV files. In version 9.3 we have worked on getting also advanced data types like charts, images and maps into the PDF file.

The PDF file now contains all Interactive Charts

Any Interactive Chart is now included in the PDF file as a static image of the chart as it appeared in the form when the form was submitted.

To get better output in the PDF, please put the chart in a single big cell, e.g. by merging all the cells that the chart covers.

The PDF file now contains all Google Maps

Any Google Map in the form is now also included in the PDF as a clickable image. Click on the image to get to the interactive version of the Google Map with the exact center location and zoom level from when the form was submitted. Only the center marker is present in the PDF file. If you have additional markers in a Google Map they will not be included.

For this to work, the Google Static Map API must be enabled for your Google account. Please read our tutorial about how to obtain a Google API key. There are also instructions on how to verify that the Google API key is properly set up for use with SpreadsheetConverter.

With the free quota, you can use map sizes up to 640 x 640 pixels.

The PDF file contains all Link Image widgets

The PDF file now includes the image that was selected by each Link Image widget in a form. We may need to reduce the size of the image to make it fit the PDF. Click on the image to see the image in full size.

The PDF file contains a list of all File Attachments

The PDF file contains the names of all files added with the File Attachment widget for the submitted form.

The PDF file does not contain hidden rows or sheets

If your form contains hidden rows or sheets, these are now also hidden in the PDF file.

Responsive design

More and more web users have small devices with narrow screens. When you create web pages, you must ensure that these can be easily viewed also on mobile devices. Otherwise, your calculator may become difficult to understand or use for some of your most important visitors.

SpreadsheetConverter supports industry-standard responsive web design, a methodology that automatically optimizes the layout of a web page for each screen. In the example below, the web design responds to the screen width by showing six column on a desktop, three on a tablet but there is only room for two columns on the narrow smartphone screen.

Most spreadsheets have historically been very wide, which makes them difficult to use on smaller devices with narrow screens. The wide layout requires a lot of horizontal scrolling. With other solutions you may have to create a separate “mobile” version of each spreadsheet. With SpreadsheetConverter you can instead easily divide the spreadsheet into responsive blocks that flow naturally across the screen regardless of what device is being used.

New support for Interactive Charts, Images and Google Maps

With version 9.3 you can use Interactive charts, Images and Google Maps as separate Responsive Blocks.

To see this in action on a laptop, open the Responsive Chart demo and resize the browser window to see the effect on the page layout.

To view the demo on your mobile device, scan the QR code below.

For maps, open the Responsive Google Map demo from your laptop and resize the browser window to see the effect on the page layout.

To view the demo on your mobile device, scan the QR code below.

Always use merged cells for graphical objects

When you use graphical items like charts, maps and some of the widgets, it is easy to just drag the placeholder to the right spot on the sheet. In many cases the resulting web page will look fine anyway. This is thanks to Excel’s graphical layers, that allow you to position stuff freely on top of a spreadsheet.

Don’t just float the chart on top of the worksheet. As you can see in the screenshot below, the chart is not properly enclosed in a single cell.

Screenshot of a chart placeholder covering multiple cells

With responsive design, it may be difficult to place a chart or map in exactly the right position on the web page just based on where you put the placeholder in the graphical layer. To ensure a correct result with responsive design, always place charts, maps and graphical widgets in their own cell.

Do merge cells to make room for each chart or map. In the screenshot below, the cells A2:E13 have been merged to become a much more reliable home for the chart.

Screenshot of a chart in a merged cell

Learn more about responsive design

 

Read the help page for Responsive Design.

Conditional formatting enhancements

Support for 3-color scale and Data bar

Version 9.3 extends conditional formatting by supporting all condition types such as Number, Percent, Formula and Percentile of 2-color scale and adding support for 3-color scale. We’ve added basic support for Data bar too. So, now it is even easier to present your numbers in a colorful and appealing way.

The Theme Preview toolbar

SpreadsheetConverter uses visual themes to control some of the layout and design aspects of the converted web page. The new Theme Preview toolbar let’s you tamper with some of these settings directly in the web browser. You can apply different themes, test the Material design, center the page on the screen and change the width of the web page.

The video below shows a few examples of what you can do.

 

Your changes to the settings are saved automatically with the converted web page. If you upload the page to the web it will use your most recent settings.

If you convert the same spreadsheet again, remember to first apply the theme you decided on. After conversion you will have to open Theme Preview again to reapply any other settings.

Theme Preview is currently supported in the HTML flavor only. Support for Node.js is being developed.

There is an online help page for Theme Preview.

Other Enhancements

Partial Support for the WEBSERVICE function

The WEBSERVICE(url) function in Excel is partially supported. This means you can get JSON results from external web services and use them in your calculations.

Here is a demo that fetches exchange rates from fixer.io and manually parses the returned JSON values through use of MID, LEN etc functions. Currently there is no function available to filter the JSON result in Excel.

 Miscellaneous

  • The Stepper and Link image widgets are now supported also in the iPhone/Android flavor.
  • The Toggle switch, a variant of Checkbox widget, is now supported also in the Html and Node.js flavors.
  • The links in the Errors tab are now clickable and take you directly to the corresponding help page.
  • Charts now support a discontinuous cell range as source data.
  • With Interactive Charts, there is a new Download chart button and the axis labels fit better.
  • Responsive Blocks now integrate well with the Hide Rows widget.
  • With the new Material style, a horizontal scrollbar is automatically displayed when the content of page becomes wider than the screen.

How can I use these new features?

This update is free to all version 9 users – just download and install the latest version of the program. If you are using version 8 or earlier, you must first upgrade to the latest version.

If you need help, don’t hesitate to contact our Help Desk.

Version 9

Did you miss the introduction of version 9?

Read more about the new features in version 9.