Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

Devart Excel Add-ins History

This page lists the functionality added in each version of Devart Excel Add-ins.

The current build is 1.7.797 (30-May-2018).

19-Mar-2018 New features in Devart Excel Add-ins 1.7

  • 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
    • The new "Keep hidden columns" check box for determining whether to show hidden columns when refreshing data is added to Refresh Options
    • 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
    • The behaviour is changed: now hidden columns are not unhidden after refresh by default
  • 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
    • The progress bar is added for starting Edit Mode
    • The speed of starting Edit Mode is greatly improved for large tables
    • The speed of the commit operation is greatly improved for large tables
    • The speed of a query with a LIMIT clause (with or without OFFSET) and without other not required clauses (like WHERE, ORDER BY, etc.) is greatly improved for Freshdesk (Freshdesk)
    • The speed of a query with a LIMIT clause and without other not required clauses (like WHERE, OFFSET, ORDER BY, etc.) is greatly improved for Salesforce Marketing Cloud (Salesforce Marketing Cloud)
    • The behaviour is changed: now if a multicolumn unique or primary index is violated, you can change a value in any of the index columns in order to fix the uniqueness violation
  • 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

27-Jan-2017 New features in Devart Excel Add-ins 1.6

  • Freshdesk is now supported
  • G Suite is now supported
  • HubSpot is now supported
  • Marketo is now supported
  • NetSuite is now supported
  • Shopify is now supported
  • Zendesk is now supported
  • The new option "Read-only primary key columns for the existing (committed) records" is added to Options > Edit > General

11-Feb-2016 New features in Devart Excel Add-ins 1.5

  • Excel 2016 is supported
  • Magento is now supported
  • ExactTarget is now supported
  • Web Login for Salesforce is supported
  • TLS 1.1 is supported
  • The ABTestingCampaigns table for getting Campaigns with the A/B testing type is added for MailChimp (MailChimp)
  • A progress indicator for execution of a query for data preview in Import Data Wizard with the possibility to cancel the operation has been added
  • The implementation of refresh is improved: now data in Excel worksheet columns not belonging to an imported table is not deleted after refreshing
  • Field validation for cases when values must be unique or NULL is implemented
  • The new option "Escape text values that end with '%' so Excel does not treat them as percentage" is added to
  • Options -> Import -> Data -> Escaping
  • The new option "Escape text values that contain special chars so Excel does not treat them as datetime" is added to Options -> Import -> Data -> Escaping
  • A new required column "Item" is added to the OrderShipments table for BigCommerce (BigCommerce)
  • The "is null" and "is not null" filter operators for mandatory fields in Zoho CRM is added (Zoho CRM)
  • The speed of processing of modifying a large number of cells at once when the edit mode is on is greatly improved
  • The behaviour is changed: now the default value for the 'Unicode' parameter of the connection to a PostgreSQL database is True (PostgreSQL)

26-Aug-2015 New features in Devart Excel Add-ins 1.2

  • FreshBooks and BigCommerce support is added
  • The MergeFieldsDetectionBehavior connection string parameter is implemented for MailChimp to determine which merge tags to add to the ListMembers table
  • 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
  • Validation of entered unsigned number values is implemented
  • Validation of entered enum field values for all supported cloud sources is implemented
  • The performance of importing data to Excel was significantly improved with memory use optimizations

18-Jun-2015 New features in Devart Excel Add-ins 1.1

  • QuickBooks and MailChimp support is added

17-Apr-2015 New features in Devart Excel Add-ins 1.0

  • The first release of Devart Excel Add-ins