Web lists-archives.com

MySQL for Excel 1.3.6 has been released




Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.6. This is a maintenance
release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts
to very easily access and manipulate MySQL data within Microsoft
Excel. It enables you to directly work with a MySQL database from
within Microsoft Excel so you can easily do tasks such as:

  * Importing MySQL Data into Excel

  * Exporting Excel data directly into MySQL to a new or existing table

  * Editing MySQL data directly within Excel


MySQL for Excel is installed using the MySQL Installer for Windows.

The MySQL Installer comes in 2 versions

- Full (150 MB) which includes a complete set of MySQL products with
  their binaries included in the download.

- Web (1.5 MB - a network install) which will just pull the MySQL for
  Excel over the web and install it when run.

You can download MySQL Installer from our official Downloads page at
http://dev.mysql.com/downloads/installer/

The MySQL for Excel product can also be downloaded by using the product
standalone installer found at this link
http://dev.mysql.com/downloads/windows/excel/

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

     * Functionality Added or Changed

     * Bugs Fixed

   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 checkbox 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's 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)

Quick links:
MySQL for Excel documentation: http://dev.mysql.com/doc/en/mysql-for-excel.html.
Inside MySQL blog (NEW blog home): http://insidemysql.com/
MySQL on Windows blog (OLD blog home): http://blogs.oracle.com/MySQLOnWindows.
MySQL for Excel forum: http://forums.mysql.com/list.php?172.
MySQL YouTube channel: http://www.youtube.com/user/MySQLChannel.

Enjoy and thanks for the support!
The MySQL on Windows team at Oracle.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql