SQL Spreads 3.1.0 is now available for download. The new release includes support to manage data in SQL Server tables that does not have any identity key.
- The 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 refresh 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.
