This section documents all changes and bug fixes applied to MySQL for Excel since the release of 1.1.0.
Bugs Fixed
The Export data and Append data action buttons were visible when no data was present, but they are now hidden. (Bug #16495151)
Imported data would become corrupt if the Excel cell format was different than the format of the data being imported. The cell format is now reset before import. (Bug #16495155)
Even with the Remove columns that contain no data,
otherwise flag them as Excluded option disabled, the
data type for empty columns would become undefined. Blank
columns are now defined as VARCHAR(255).
(Bug #16495493)
Refresh would not refresh MySQL for Excel with connection changes that were made in MySQL Workbench while MySQL for Excel was open. (Bug #16493129)
Automatic mapping would not function in Edit or Append mode if only one row was selected. (Bug #16493139)
The MySQL performance_schema database was
listed under Schemas, which is reserved for
user created databases, but it is now listed under
System Schemas.
(Bug #16473033)
While using the Export Data dialog, clicking on the First Row Contains Column Names checkbox repeatedly after excluding some columns would cause MySQL for Excel to freeze. (Bug #16419402)
Adding a new MySQL Server connection would cause the connection list to flicker. (Bug #16392862)
Checking the Exclude Column checkbox from within the preview grid would always change the cursor focus to the first column. The current focus is now preserved. (Bug #16397637)
The Import Table Data dialog for the Edit Data operations did not display a horizontal scrollbar on the preview grid. (Bug #16239011)
An About section was added to MySQL for Excel, which contains version and copyright information. (Bug #16238860)
When using the Export Data dialog with Auto-Detection of data types enabled (default), the Create Index checkbox is now checked by default when the data type is an detected as an integer. (Bug #16238445)
The context menu from right-clicking a preview grid in the Import Data form is now aware of its context. The Select All and Select None options will only be available where applicable. (Bug #16238663)
The Remote Connections list is now expanded by default while MySQL for Excel is initialized, when before only the Local Connections listing was expanded. (Bug #16238782)
On systems that define number format using European regional
settings, MySQL for Excel would fail on INSERT
because it would attempt to split these into two numbers at the
comma. As a result, the query would fail with an error such as
"Column count doesn't match value count." These commas are now
converted to periods.
(Bug #15903921)
