Bug #78548 Append Data - Problems when scrolling target table grid
Submitted: 25 Sep 2015 4:38 Modified: 20 Oct 2015 4:05
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
Category:MySQL for Windows: MySQL for Excel Severity:S4 (Feature request)
Version:1.2.0 OS:Any
Assigned to: CPU Architecture:Any

[25 Sep 2015 4:38] Javier Treviño
There are 2 cosmetic problems when scrolling horizontally scrolling the target MySQL table grid.

1. The column headers containing the names of mapped source columns (let's call it the upper headers) are not rendering their texts like the column headers containing the names of the target columns (the lower headers). The upper headers render the text so that it "moves" while scrolling the horizontal scroll bar instead of being "fixed" like the texts in the lower headers.

2. The "upper headers" column separator disappears when scrolling to the right.

How to repeat:
1. Open MySQL for Excel
2. Open a connection to a MySQL server, select a schema and a table
3. Import the contents of any table that contains a lot of columns (10 or more) to Excel
4. Select 1 or more rows of the imported data
5. Click Append Excel Data to Table
6. The lower target grid should show a horizontal scroll bar, since there are more columns than it can display. Scroll to the right to see the 2 problems.
[14 Oct 2015 19:34] Javier Treviño
Posted by developer:
Rewrote the logic that calculates areas for spanning columns to clip and paint visible areas of additional headers correctly.
[20 Oct 2015 4:05] Philip Olson
Posted by developer:
Fixed as of the upcoming MySQL for Excel 1.3.5 release, and here's the changelog entry:

When scrolling the target MySQL table grid horizontally, the upper column
headers that contained names of the mapped source columns were not
rendering text properly. The text moved while scrolling, and the column
separators disappeared when scrolling to the right.

Thank you for the bug report.