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.
