What's new - release log

2018-11-01 SQL Spreads release 4.3.1

SQL Spreads 4.3.1 is now available for download.
  • Fixed issue connecting to Azure SQL databases when opening an older SQL Spreads document.
  • Fixed issue when creating a new Database Import.

2018-10-25 SQL Spreads release 4.3.0

SQL Spreads 4.3.0 is now available for download.

This release adds a few new features and also improves working with data in Azure SQL.
  • Added support for working with contained databases, where the default database must be specified.
  • Added the Formula Row feature to be able to add summary rows within an Excel range that is synced with a SQL Server table.
  • Improved support for filtering data based on user when SQL Authentication is used. Mainly for Azure SQL implementations.
  • Improved support for inserting rows into Views with a base table having an Identity Key.
  • Improved seamless installation on both 32-bit and 64-bit Excel.
  • Fixed issue with Filter and Sort tabs in the Designer not being shown if Excel is updated to a July 2018 release and Windows is still on an earlier release.
  • Fixed issue with editing Excel workbook embedded into Word.
  • Fixed issue with default database not cleared when a new database is selected.
  • Fixed issue with conflict detection when the data in the database is set to a date before 1900-02-26.
  • Fixed issue with check for VSTO Runtime during installation.
2018-05-08 SQL Spreads release 4.2.5
SQL Spreads 4.2.5 is now available for download.
  • Fixed issue with working with SQL Spreads when the Excel document is in Read-Only mode.
  • Fix issue with cursor not returning from wait state after loading document.
  • Minor other fixes and stability improvements.

2018-01-26 SQL Spreads release 4.2.4

SQL Spreads 4.2.4 is now available for download.
  • Added possibility to auto-save the Excel file after data has been saved to the database.
  • Added support for XML data type columns.
  • Added warning of FIPS encryption is enabled.
  • Fixed issue with loading SQL Spreads document when opening a document without having Excel running.
  • Fixed issue with loading SQL Spreads when opening a document stored in SharePoint.
  • Fixed issue restoring a previous document version from SharePoint.
  • Stability improvements.

2017-09-12 SQL Spreads release 4.2.2

SQL Spreads 4.2.2 is now available for download.
  • Fixed issue with columns not shown for table names with Cyrillic characters.
  • Fixed issue with ordering of the databases in the Designer.
  • Minor bug fixes and improvements.

2017-07-07 SQL Spreads release 4.2.0

SQL Spreads 4.2.0 is now available for download.

With this new release, SQL Spreads has support for updating and managing data in cloud-based Azure SQL databases. SQL Spreads supports updating data in tables and views in Azure SQL.
  • Added support for Azure SQL databases.
  • Added remembering the last used SQL Server instances.
  • Added possibility to locally store password.
  • Fixed issue to insert null during the inserting of new rows. Non-edited cells for nullable number and date columns are now stored as NULL in the database.
  • Fixed issue with duplicate user panel shown when saving an empty Excel file.
  • Bug fixes and stability improvements.

2017-04-06 SQL Spreads release 4.1.7

SQL Spreads 4.1.7 is now available for download.
  • Added the new setting to scroll to the first row after data has been refreshed.
  • Added new info panel when the Designer’s preview mode is turned on. The info panel will be shown below the last loaded data row and inform the user that preview mode is turned on.
  • Added the possibility to paste several rows over the Excel table border.
  • Added the new BeforeSave event to the VBA API.
  • Added the new HasUnsavedChanges property to the VBA API.
  • The VBA API method RefreshImportData is updated to be able to refresh data, also if there are unsaved changes. Use the new HasUnsavedChanges property to check if there are unsaved changes.
  • Fixed issue with drop-down lists not being correctly deleted when a worksheet is deleted.

2017-02-17 SQL Spreads release 4.1.4

SQL Spreads 4.1.4 is now available for download.
  • Improved license key handling.
  • Added the possibility to force an update of columns that saves
    the result of an Excel formula to the database.
  • Bug fixes and minor updates.

2016-12-05 SQL Spreads release 4.1.3

SQL Spreads 4.1.3 is now available for download.
  • Fixed issue with case sensitive collation.

2016-12-02 SQL Spreads release 4.1.2

SQL Spreads 4.1.2 is now available for download.
  • Bug fixes and minor updates.

2016-11-17 SQL Spreads release 4.1.1

SQL Spreads 4.1.1 is now available for download.

The major improvement in this release is support for updating data in SQL Server Views from Excel. The new View support also includes updating data in Views that join data from multiple base tables. 
  • Added support for updating data in SQL Server Views.
  • Added automatic detection of 32- or 64-bit Excel.
  • Fixed issue with named ranges not being deleted.
  • Fixed issue in Custom SQL-filter after SQL error was given.
  • Fixed issue that second value in a between filter was not shown correctly in filter tab.

2016-11-14 SQL Spreads release 4.0.27

SQL Spreads 4.0.27 is now available for download.
  • Improved support for installing on Terminal Server
  • Fixed issue when saving documents with +250k database rows

2016-09-01 SQL Spreads release 4.0.23

SQL Spreads 4.0.23 is now available for download.
  • Improved Undo when working with SQL Server data.
  • Fixed issue with the length of text and ntext columns.

2016-08-15 SQL Spreads release 4.0.22

SQL Spreads 4.0.22 is now available for download.
  • Added subscription license model.
  • Bug fixes and minor updates.

2016-07-20 SQL Spreads release 4.0.21

SQL Spreads 4.0.21 is now available for download.
  • Fixed issue with settings when using a document created with SQL Spreads 3.0.
  • Fixed issue with pasting into filtered rows.
  • Fixed issue with when updating cells in a hidden sheet via VBA.
  • Fixed issue with loading table in Designer in Excel 2010 64-bit.

2016-06-08 SQL Spreads release 4.0.17

SQL Spreads 4.0.17 is now available for download.
  • Added support for showing and updating NULL values in cells and in Drop Down Lists
  • Advanced setup is now shown by default
  • Fixed issue that a document that only contains a database connection was treated as a SQL Spreads document
  • Bug fixes and minor updates.  

2016-05-16 SQL Spreads release 4.0.10

SQL Spreads 4.0.10 is now available for download.
  • Bug fixes and minor updates.

2016-04-22 SQL Spreads release 4.0

SQL Spreads 4.0 is now available for download.

This release contains the new SQL Spreads Designer, which adds the possibility to configure columns, filters and sorting from the new Designer Panel on the right side in Excel. 
  • Added the new SQL Spreads Designer.
  • Added preview mode that will load only the first 50 rows by default.
  • Improved conflict detection dialog with the possibility to select which rows to overwrite.   
  • License settings are moved to the new About dialog.
  • Dialogs for creating Database Imports and Database Mappings (previous Database Exports) are moved to the Advanced Setup menu.

2016-03-22 SQL Spreads release 3.1.53

SQL Spreads 3.1.53 is now available for download.
  • Fixed issue with tables not being shown for Case Sensitive databases.

2016-03-04 SQL Spreads release 3.1.52

SQL Spreads 3.1.52 is now available for download.
  • Added support for drag and drop in Excel tables.
  • Fixed issue with copy and paste between documents.
  • Minor updates.

2016-02-24 SQL Spreads release 3.1.51
SQL Spreads 3.1.51 is now available for download. 

  • Minor updates.

2016-02-12 SQL Spreads release 3.1.50  

SQL Spreads 3.1.50 is now available for download.

The new release includes better handling and display of the database schema and a fix for the issue with the license being lost when upgrading Excel to a new version.
  • Improved display of schema in Wizard and database export.
  • Improved detection of column names in Edit Export Dialog.
  • Fixed issue with the license being lost in Office 365 after an automatic upgrade.
  • Fixed issue with two tables with the same name in two different schemas.
  • Fixed issue that Manage Export dialog was not shown after closing the Post Save SQL dialog.
  • Fixed issue with sorting a table in Excel.
  • Disabled drag and drop in SQL Spreads tables as it is currently not supported.
2016-02-04 SQL Spreads release 3.1.4
SQL Spreads 3.1.4 is now available for download. 
  • Minor updates.
  • Fixed issue with pasting into a filtered range with hidden rows.
2015-11-30 SQL Spreads release 3.1.3
SQL Spreads 3.1.3 is now available for download.
  • Fixed issue with Num Lock being turned off.
2015-11-24 SQL Spreads release 3.1.2
SQL Spreads 3.1.2 is now available for download. 

The new release includes an update that will auto-detect available SQL Server instances. When selecting columns, there is a new Select All/Select None feature for tables with a large amount of columns. The column width of the data imported into Excel will now auto-adjust the column size to create a smoother look. See the full list of changes below:
  • Added automatic detection of SQL Server instances.
  • Added auto-adjust for table columns.
  • Added Select All/Select None when selecting columns.
  • Added info message if wrong 32/64 bit version was installed.
  • Improved loading speed when using protected spreadsheets.
  • Added support for canceling out from dialogs by pressing ESC.
  • Database Connection dialog is now disabled for data user role - only shown if a password is missing.
  • Fixed issue with feedback dialog shown after upgrade to new version.
  • Fixed issue with Drop Down Lists referring a table with no values.
  • Fixed issue when copying a document and having both documents opened at the same time.
  • Fixed issue with showing filter panel after the Macro security warning is accepted.
2015-08-19 SQL Spreads release 3.1.1
SQL Spreads 3.1.1 is now available for download. The release includes a few minor updates
  • Added support for using columns with numbers-only names.
  • Fixed issue with installing for 64-bit Office 365.
2015-08-13 SQL Spreads release 3.1.0
SQL Spreads 3.1 is now available for download. The new release includes support to manage data in SQL Server tables that do not have any identity key. 
  • A major change in 3.1 is the ability to use a combination of key columns in a table. This removes the previous requirement for an Identity column in the table. 
  • Added improved database selection without the need for the 'View any definition' permission.
  • Added automatic detection of key columns based on primary key or identity column.
  • Added Feedback dialog.
  • Added new 'Document Settings': “Refresh Import Data after save to database”. If this new setting is enabled, the spreadsheet data from SQL Server will be automatically refreshed immediately after changes are submitted to the database. 
  • Improved the screen for selecting 32- or 64-bit Excel when installing for Office 365.
  • Fixed issue with Execute button in Setup Filter dialog when using the @WindowsUser parameter in the SQL Query.
  • Fixed issue when exporting a fixed number of rows.
  • Fixed issue when mapping an Import filter to a Primary Key column in the database.
2015-04-07 SQL Spreads release 3.0.6
A new release of SQL Spreads is now available for download. The new release contains a number of updates and fixes: 
  • Improved support for Office 365.
  • New improved layout of the import filter panel which now has buttons for Refresh and Save. 
  • New name on the "Database Submit" button: "Save to Database".
  • Fixed issue with selected columns in the wizard when moving back and forth between wizard dialogs.
  • Fixed issue when creating an import data filter with an empty name.
  • Fix issue when canceling out from the intro dialog.
2015-02-27 SQL Spreads release 3.0.4
With this new release, SQL Spreads is now an Excel only Add-In. The new Excel Add-In will connect directly from Excel to a SQL Server database. 

The SQL Spreads Excel Add-In makes it possible to manage data in SQL Server tables using Microsoft Excel. 

Feedback and Knowledge Base