SQL Spreads 5.0.55 is now available for download.
SQL Spreads 5.0 is the largest SQL Spreads update in over two years with several long-wished features and improvements such as data pivoting, the table creator and database, and table search.
- Introducing the new Pivoting feature to update pivoted data in columns in Excel into rows in SQL Server.
- Introducing the new Table Creator to easily create new SQL Server tables from within Excel in just a few clicks.
- New database and table search in the SQL Spreads Designer to quickly find your SQL Server databases and tables.
- Improved support to deploy SQL Spreads Excel documents from test databases to production databases. You can now easily switch the connection in a SQL Spreads Excel document to a new server, database, or table while keeping all the settings in the document.
- Improved the new subscription engine to support monthly and annual subscriptions. We will soon start to offer monthly subscriptions.
- Improved document compatibility – SQL Spreads documents are from release 5.0 backward compatible so no need to upgrade all users to the same SQL Spreads version.
- Improved Enterprise Deployment Package which supports large scale installations with one common license key for all users and a web application to manage licenses.
- Improved the database key selection dialog.
- Fixed issue with loading and saving data during document opening and closing to be done for all worksheets in a document.
- Fix issue with drop-down lists to make drop-down lists case insensitive.
