Intro
This new release includes a long-wished improvement to preserve Excel table filters and sorting during data refresh. We have also improved handling of default values, and working with temporal tables and done a number of stability improvements.
Watch the release video below:
What’s New
- Preserving Excel Table filters and sort
Excel table filters and sorting are now preserved when refreshing the data from SQL Server. - SQL Server default values
Added support for SQL Server default values when inserting new rows. - Temporal Tables improvements
Enhanced the user experience when working with temporal tables and their history tables.
The Table Creator tool now lets you convert Excel tables directly into SQL Server temporal tables. - Support for Azure AD UPN
Change Tracking now supports using Azure AD User Principal Name (UPN). - SQL Syntax highlighting
To improve the readability when working with larger Data Processing SQL scripts, we have added syntax highlighting in the editor.
Improvements and Fixes:
- Special letters ő and ű: Fixed issue with special letters ő and ű were not working in Tree Filters.
- Date Key values in Pivoting: Fixed issue with pivot component not fetching key values for Date columns.
- Formula columns failing: Fixed issue with Formula columns failing on tables that contain hidden columns.
- Disable refresh during load for Tree Filters: Improved the “Refresh import data when the document is opened” setting now works better with Tree Filters.
- General stability and performance improvements.
Get the latest version
If you are a SQL Spreads customer, learn how to upgrade here.
To try SQL Spreads, download the free 14-day trial here.
