Version 11: Enhanced Features, Fixes, and Changes

SpreadsheetConverter 11 brings powerful new capabilities, improved functionality, and streamlined performance to enhance your spreadsheet conversion experience. With support for the latest Office 365 Excel (as of November 2024) and Excel 2021, as well as Google Analytics 4, this release keeps you ahead of the curve. New features like the HideRowIF and HideColumnIF functions offer dynamic row and column management, while added support for advanced Excel functions like TEXTJOIN, SUMIFS, COUNTIFS, AVERAGEIFS, and XLOOKUP expands your conversion possibilities. Bug fixes and updates ensure a smoother workflow, while certain legacy features, such as Node.js flavor and real-time sync, have been retired for a more focused toolset. Read more about version 11.

 

ExcelWraps + SpreadsheetConverter = True!

SpreadsheetConverter merges with ExcelWraps, an Excel-based knowledge engine with workflow support, to provide an even more efficient server solution for powerful web apps.

The advanced ExcelWraps server is available also to SpreadsheetConverter users and adds many features like database support, aggregation of spreadsheet data and advanced workflow support with user authentication and secure sign-off using individual signatures. ExcelWraps is optimized for complex workflows in large companies and has a monthly subscription fee that is based on the number of users.

In a vertical venture established in 2016, ExcelWraps also offers complete workflow skills and solutions to the British railway industry.

Read more about ExcelWraps.

 

Version 10.2 enhances the Calendar widget and printed output

Version 10.2 offers an enhanced Calendar widget with automatic translation to the developer’s language. Example: when converted with Swedish regional settings, the calendar will appear as in the image. The new Calendar widget also allows you to use formulas to calculate a more exact default date. A date field can be selected as one of the Required fields.

You can use a separate Print Sheet to improve the appearance of the web page when it is printed. When a user prints an advanced web form, a hidden Print Sheet enables you to assemble all the required information on just one page, and format this page for printing.

Read more about version 10.2.

 

With version 10, conversion is automatic with Live Preview

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. No more waiting for conversions! The only thing holding you back will be the speed of thought. No more interruptions. No more concentration loss.

If your development environment doesn’t have multiple screens, you can use any old laptop or tablet to show the live preview and just put it next to your primary screen. You can open as many preview windows as you like; in the development environment, in other computers on the network and in iPhone and Android mobile devices.

Version 10 also increases productivity by introducing a new responsive ribbon layout, with direct shortcuts to the tabs and windows you use most often. You can access widget settings and conversion messages directly from the ribbon menu.

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.

Read more about version 10.

 

Version 9.4 adds Barcode and QR code widgets

Two new widgets in SpreadsheetConverter version 9.4 let you generate barcodes and QR codes directly in your web page, either from static content or calculated by formulas and live data in a web form.

The Errors tab now alerts you with a red notification containing the number of messages during the most recent conversion. For your convenience, we have made it possible to report conversion errors directly from the Errors tab.

And we have included a new example for checking that your installation of the Excel add-in works as it should.

For more information, visit the version 9.4 news page.

 

Version 9.3 enhances Advanced submit, Responsive design and Conditional formatting

In version 9.3 we have worked on getting more advanced data types like charts, images and maps into the PDF file for each submitted form. If your form contains hidden rows or sheets, these are now also hidden in the PDF file.

Speaking of maps, images and charts, you can now use them in responsive blocks to automatically optimize your web page layout to the width of each screen.

Version 9.3 extends conditional formatting by adding support for 3-color scale and basic support for Data bar. So, now it is even easier to present your numbers in a colorful and appealing way.

The new Theme Preview toolbar let’s you compare different visual themes directly in the web browser.

For more information, visit the version 9.3 news page.

 

Version 9.2 provides instant Publish to Cloud

The new version 9.2 introduces the Publish to Cloud feature for the HTML and iPhone/Android flavors. It lets you upload anything you convert with SpreadsheetConverter to the web with just a few mouse clicks. There is a convenient Test feature that allows you to test a new version online before you replace the Production version.

Version 9.2 also supports Calculated columns and Structured references, which are important when you use Excel tables. We also support tables with styles, banded rows and a header row.

The installation script for 9.2 installs an example spreadsheet that you can use to verify that your installation is complete and correct.

Learn more about version 9.2.

Introducing version 9 with interactive charts, WordPress plugin and many other powerful features

Version 9 introduces interactive charts that help your users understand and analyze the underlying data. Hover your cursor over the chart or click on a series in the legend to see how it works.

A web publishing plug-in for WordPress makes it easy to upload a live spreadsheet or smart form to your blog or website.

With Secure Login for the Node.js flavor, you can ensure that a form or calculator is only available to approved users.

We have extended the support for Excel Data Validation, to ensure that all the fields in a form are valid before the form is submitted. All rules you define in Excel are carried over to the converted web page.

The new version also adds a new Stepper widget, enhanced submit options, better handling of system and workbook settings and enhanced translation features.

Learn more about the new version 9.

 

Google requires "API key" for Google Map widget

Google Maps may not appear as expected on your website. This is because Google now requires an API key to document your use of their services. Instead of the map, you get the message in the screenshot. Read the instructions on how to solve this.

 

All existing calculators in Dropbox will soon disappear from the web

SpreadsheetConverter previously had a convenient click-to-publish feature that let users publish converted spreadsheets as live calculators on the web via their Dropbox accounts. Now, Dropbox has decided to discontinue this service, with very short notice.

All your calculators or forms will disappear from the web pages where you have embedded them. Any web links to the calculators or forms in Dropbox will stop working. Your visitors will no longer be able to see or use these calculators or forms in their web browsers.

Read more about the Dropbox announcement.

 

Version 8.4 supports file attachments with Secure Delivery

In version 8.4, the new File Attachment widget enables your visitors to include documents, charts, images, videos or any other kinds of files with their form submission. Job applicants can include their CV, and expense reports can include scanned copies of receipts.

With Secure Delivery, the e-mail you get for each form no longer contains any sensitive form contents or  file attachments. It just contains a link to the Advanced Submit Server where you can login to access the form and its attachments securely.

Real-time Sync reconnects after a link failure. And we are demonstrating our new web chart technology.

Read more about version 8.4

 

Version 8.3 adds the Link Image widget and Instant Testing

In version 8.3, the new Link Image widget allows you to show different images in the web page depending on cell values or formulas. Now you can show the right picture of a product depending on what options the user has selected, or show the right map depending on if someone’s arriving by air or train.

If you develop for mobile devices, the new Instant Testing feature will save you a lot of time. The converted web page can be immediately accessed from other devices on the same network, without uploading to a web server. A link to the just converted web page is provided in the form of a barcode that can be scanned using the camera in a mobile device or laptop to open the web page.

Read more about version 8.3 

 

Version 8.2 offers Dynamic Dropdown menus

With a Dynamic dropdown menu you can set a dropdown menu’s options from cells in the spreadsheet. This allows you to use assembled, calculated or conditional content in the menu.

Previously, you could only move step-by-step through a multi-page form using Next and Previous buttons. Using internal links allows you insert direct links to any input cell or heading, on any sheet in the form.

The History list contains the most recently converted web pages. Just click a button and the selected calculator or form opens in any installed web browser.

All this and much more in version 8.2.

Read more about version 8.2.

 

 

Use Excel 2016 with the new version 8.1

Version 8.1 adds support for Excel 2016.

It has faster access to browser storage, and allows you to disable browser storage.

We have also worked very hard on our online documentation. There are now dozens of useful new Help pages and Tutorials to help you get started and past any obstacles. As always, if you need any additional assistance, just contact our Help Desk.

Read more about the new version 8.

Upgrade to version 8 now!

 

Version 8 is here with Responsive design, Node.js support and much more

SpreadsheetConverter 8 has seen the light of day. You can now divide your calculator into responsive blocks that flow dynamically onto the screen to fill its width. Using only one source spreadsheet you can create an optimized layout for both laptops, tablets and smartphones.

The family has a new sibling: the Node.js flavor. Using industry standard, open source technology from Google, we can proudly offer you a free, lightweight and easy-to-use server environment that among other things protects the business formulas you use in Excel.

Read more about the new version 8.

Upgrade to version 8 now!

News Archive

There’s always something new to tell about SpreadsheetConverter, but we seem to have run out of space here. Please continue reading the archived news below.