We proudly announce the release of Devart Excel Add-ins 1.7 — add-ins for Microsoft Excel that allow connecting Excel to cloud and database data, edit this data, and save it back to the data source. The new versions of Devart Excel Add-ins allow much more convenient and flexible editing and refreshing cloud and database data.
Advanced Edit Mode
Excel Add-ins 1.7 present a completely new advanced Edit Mode, eliminating a lot of previous limitations. Now you can freely copy and paste data in the Edit Mode, including pasting multiple rows, and copying data in the same workbook and worksheet with the imported table.
The new Edit Mode allows you to use many Excel editing features, like formulas, scripts, AutoFill, etc. It allows sorting and filtering of the table with imported data, hiding and unhiding columns, allows editing data outside of the imported table on the same worksheet, etc.
If you prefer old, 1.6 and pre, Edit Mode, you can disable the new advanced Edit Mode in Excel Add-ins options.
Refresh Improvements
In the new version of Devart Excel Add-ins, user-made changes are better preserved when refreshing data. Excel Add-ins now preserve user's data, entered outside of the table with imported data on the same worksheet, data sorting settings in this table and table styles. You can now freely move the imported table within the worksheet, and this does not break refreshing or editing data.
Sometimes refresh of a large set of data can take much time. Excel Add-ins now display the refresh operation progress and allow you to cancel it if necessary. Additionally, new Refresh options allow you to disable confirmation dialog boxes when starting refresh.
Other Improvements
Devart Excel Add-ins now fully support Windows scaling for high-DPI devices. Besides, they now display progress of commit changes operations.
Excel Add-in for Zendesk has supported custom fields for certain Zendesk objects, and Excel Add-in for Magento offers a more convenient connection editor for connecting to Magento 2 servers. Excel Add-in for Salesforce now allows connecting to Salesforce Sandbox.
Complete List of Changes
Here is the complete list of Devart Excel Add-ins 1.7.748 features:
- Data refresh is significantly improved:
- Refresh now preserves user's data on the same worksheet outside of the table with imported data
- Data sorting in the table with imported data is now preserved if Keep table if exists and Keep table sorting check boxes are selected in Refresh Options
- Table style the table with imported data is now preserved if Keep table if exists check box is selected in Refresh Options
- Excel Add-ins now display the progress of Refresh and Refresh All operations and allow canceling them
- Refresh Options are added:
- Confirm 'Refresh' action - determines whether to display the confirmation dialog box when refreshing data on the current worksheet
- Confirm 'Refresh All' action - determines whether to display the confirmation dialog box when refreshing data on all the worksheets
- Keep table if exists - determines whether to re-create an Excel table with imported data or to keep an existing one when refreshing data
- Keep table sorting - Determines whether to keep sorting settings in an Excel table with imported data when refreshing data
- Refresh now preserves references to imported table cells in Excel formulas if there is no user data under the table with imported data
- The behaviour is changed: now Refresh is not allowed if there is a user's table below the table with imported data
- The behaviour is changed: now Refresh preserves the number of empty rows between the table with imported data and user's data below it
- Edit Mode is greatly improved:
- Edit Mode now allows using AutoFill using the fill handle
- Edit Mode now allows using formulas, scripts, comments, etc.
- Edit Mode now allows editing data on the same worksheet outside of the table with imported data
- Edit Mode now allows copying/pasting data from the same workbook with the table with imported data
- Edit Mode now allows copying/pasting of multiple rows
- Edit Mode now allows and preserves sorting and filtering (AutoFilter) of the table with imported data
- Edit Mode now preserves comments for the cells of the table with imported data
- Edit Mode now allows and preserves hiding and unhiding columns
- For cloud sources, if a field accepts only a value from a fixed list of allowed values, Devart Excel Add-ins support selecting a value from a drop-down list of allowed values both when editing a cell and in table filters
- Optional underlining is now used instead of the popup comments when inserting a new row and moving focus out of it without filling all the required columns
- The Advanced edit mode check box (selected by default) is added to the Edit - General options for reverting back to pre-1.7 Edit Mode
- Options for selecting underlining color for cells of a new row are added
- Excel Add-ins now check if a value is set for relational database columns that are declared as NOT NULL in the database and have no default value when the "Validate required (not null without default value) columns for RDBMS" check box is selected in the Edit - General options
- Excel Add-ins now display the progress of committing changes to the data source
- The table with the imported data now can be moved to any place on the worksheet, and after this can be correctly refreshed or edited in the Edit Mode
- Windows scaling for high-DPI devices is supported
- The RegionId field is added to CustomerAddresses for Magento 2 (Magento)
- The Magento connection editor is improved for Ver2 servers (Magento)
- The "Use Custom Fields" parameter is added to Zendesk connections to determine whether to read custom fields for Ticket, Request, View, User, Organization objects (Zendesk)
- The possibility to connect to Salesforce Sandbox is implemented (Salesforce)
- INSERT and UPDATE operations support for AccountUser in Salesforce Marketing Cloud is added (Salesforce Marketing Cloud)
- The behaviour is changed: now date values for filters are generated with the time 00:00 by default. This behaviour can be changed with the Options > Import > Filter > "DateTime picker editor default value" option
- Now Excel Add-ins do not try to load more then 65536 records for the Excel 97-2003 file format and more than 16384 records for the Excel 5.0 and Excel 95 file format and display the corresponding warning message
- The bug with corrupting unicode characters for the SQL Server source is fixed (SQL Server)
- The bug for the SQL Server source with not starting Edit Mode when primary key columns of a table are not imported, but a unique column is imported is fixed (SQL Server)
- The bug with processing records with GUID in SQLite when the edit mode is on is fixed (SQLite)
- The bug for the PostgreSQL source with not starting Edit Mode when a base table is imported with related table columns is fixed (PostgreSQL)
- The bug for the MySQL source with not starting Edit Mode when a base table is imported with related table columns is fixed (MySQL)
https://www.devart.com/excel-addins/