Devart is glad to announce the release of the new version of Devart Excel Add-ins - add-ins for Microsoft Excel that allow importing cloud and database data to Excel, editing this data, and saving it back to the data source.
Now Devart Excel Add-ins include the add-in for FreshBooks - a cloud-based accounting software, and Bigcommerce - the leading e-commerce platform for running online store.
Here is the complete list of Devart Excel Add-ins 1.2.126 features:
- FreshBooks is now supported
- Bigcommerce is now supported
- The new option "Refresh all columns after commit" with default value true for refreshing data after commit is added to Options -> Edit -> General
- The new option "Read-only cells of new row" for changing color for read-only cells in a new row is added to Options -> Edit -> Appearance
- The new option "Show commit error message" is added to Options -> Edit -> Error Handling
- The performance of importing data to Excel was significantly improved with memory use optimizations
- The bug with the "Object reference not set to an instance of an object" error during execution of SQL operations which do not return result set is fixed
- The bug with committing data that was rolled back earlier in the current Edit Mode session during the Commit operation is fixed
- The bug with identity primary key column when editing data for SQL Server is fixed
- The bug with opening Import Data Wizard when executing Refresh or Edit Mode for SQL Server database with Windows Authentication is fixed
- The bug with not refreshing data if an Edit data session was not finished correctly is fixed
- The bug with freezing when importing a large number of rows is fixed
- The bug with calling Cancel during data import is fixed
https://www.devart.com/excel-addins/