New build of Devart Excel Add-ins 1.5.319 is available for download now.
In this version:
- TLS 1.1 is supported
- 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)
- The bug with determining added/deleted records, when there are some user data in the cell to the right of the imported table, is fixed
- The bug with deleting user data outside of the edited table when deleting records from the edited table is fixed
- The bug with unreadable cell comments, showing validation errors of enum values, in case of enums with a large number of elements is fixed
- The bug with not saving changes made on the Import -> Data tab of the Options dialog box is fixed
- The bug with deleting a row when there are some user data in cells to the right of the imported table is fixed
- The bug with connecting to a PostgreSQL database via SSL is fixed (PostgreSQL)
- The bug with 100 records limitation when selecting data from the ABTestingCampaigns table is fixed (MailChimp)
- The bug with SQL generation when editing tables via linked server is fixed (SQL Server)
- The bug when a mandatory field has a null value and both where and order by clauses are used in Zoho CRM, is fixed (Zoho CRM)
http://www.devart.com/excel-addins/