MySQL for Excel Release Notes  /  Changes in MySQL for Excel 1.3.6 (2016-01-07, General Availability)

Changes in MySQL for Excel 1.3.6 (2016-01-07, General Availability)

Functionality Added or Changed

  • A new Generate an INSERT statement for each data row option was added to the Advanced Options dialog for Append and Export Data operations. This is disabled by default. A single INSERT statement is generated that inserts all affected rows, unless this option is enabled.

    When checked, an INSERT statement for each data row being appended or exported is generated in the resulting SQL query sent to the MySQL server. When unchecked, a single INSERT statement is generated as a bulk data operation, which performs better than multiple INSERT statements.

    While row-by-row inserts are slower, for debugging errors it could help determine which row causes an error, since the MySQL Server will process them row by row.

  • Added column properties to the Export Data dialog to support the definition of Auto Increment and Default Value for new MySQL tables where the data will be exported.

    Added a context menu to declare a numeric field to be Unsigned or to have Zero-Fill, accessible by right-clicking the Data Type combo box.

    Added the TIMESTAMP data type to the full list of valid data types, as it was not being shown before. Added help tool tips to fields in the Export Data dialog that explain in detail how the column properties work in a MySQL database.

Bugs Fixed

  • The Pivot Table feature was updated to work with Excel 2016. (Bug #22387425)

  • Closing the plugin via the Close button in the panel would not toggle the MySQL for Excel check box in the Data ribbon. (Bug #22374026, Bug #79655)

  • Fixed the content detector for the active Excel cell after importing data and after loading database objects when a database is opened. Now, the data options are not enabled until a table is selected. (Bug #22372915)

  • Append and Export operations would not append/export boolean data. (Bug #22138966)

  • The MySQL for Excel Refresh All function would throw an unhandled exception. (Bug #22110627, Bug #78941)

  • With Office 2007, data would not auto-save after closing Excel. (Bug #22081313, Bug #78910)

  • Numeric data stored in text columns is now correctly formatted by Excel as text, and not as the "General" format that automatically formats cells as numbers when the data is stored in a text object. This fixes the issue where text columns were formatted as numbers, which stripped leading zeros. (Bug #20905284, Bug #76738)

  • Changed settings for containers and forms to let all UI components automatically scale on different DPI settings. Also removed the restriction to resize the MySQL for Excel task pane, so in case a different DPI setting is used and the fonts look too big, the pane can be resized to see contents as best as possible. (Bug #18099454, Bug #71389)