MySQL Bugs: #71389: Mysql for Excel Sidebar not displaying correctly

Bug #71389	Mysql for Excel Sidebar not displaying correctly
Submitted:	15 Jan 2014 8:17	Modified:	18 Dec 2015 17:35
Reporter:	Andre Fourie	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.1.3	OS:	Windows (7)
Assigned to:		CPU Architecture:	Any

Description:
The sidebar gets cut off and cannot be resized.

How to repeat:
I am running Excel 32 bit on a Windows 7 64 bit installation.

Screenshot of Mysql For Excel Addin Sidebar

Attachment: Mysql_Addin_Sidebar_Screenshot.PNG (image/png, text), 178.56 KiB.

cut-off sidebar

Attachment: Cut-off sidebar.png (image/png, text), 154.67 KiB.

Could reproduce the problem only when bumping the text size on windows control panel's display settings to more than 100%.

The workaround for now is to reset the text size to the default 100%.

I'm using version 1.2.1 with Windows 7 64-bit (Korean) and it's worse.
Rright side is cut-off (the same as this bug) and 
bottom is not displayed - no buttons showed.

Both right side and bottom cut-off

Attachment: side-bottom-cut-off.png (image/png, text), 23.71 KiB.

Above work around (setting to 100%) didn't work for me.

Hi everyone, 

the issue relates also to my case. Win 8.1 64bit + Excel 32 bit + most recent MySQL for Excel version. 

During istallation of MfE I was asked to add MS Visual Studio Tools for Office RT 2010, what I did, but in fact I'm having VS 2013 installed.

The suggested workaround works partially: proper height of inner parts of sidebar but width is still set up to 1/2 of total sidebar width. 

My screen is HD screen. So, when I decrease text and elements' size (according to suggested workaround), the side panel's look improves (as mentioned above), but cannot work with Excel . Do not know what is worse:)

Regards, 

mmi

Also having this problem.  

Office 2013 64 bit running on Windows 10.  Surface Pro 3.

Fix would be greatly appreciated - thx.

This remains an issue. Problem on laptop but not desktop using WIN 8.1 64 on lenovo ideapad

I can confirm this also affects on Windows 10 as of today with the latest version installed.

I have the same problem on Windows 10 (MySQL for Excel 1.3.5). The workaround doesn't work at all on my Lenovo laptop. I effectively cannot import data into MySQL from Excel.

Posted by developer:
 
Changed settings for containers and forms to let all UI components to automatically scale on different DPI settings. Removed the restriction to resize the add-in's pane, so in case a different DPI setting is used and the fonts look too big, the add-in pane can be resized to let users see contents as best as possible.

Great news. 
Which version ofeat news MySQL for Excel should the improvement be included to? 
And when?:)

Regards, 
mmi

This change will be released in MySQL for Excel 1.3.6.
Sorry but by company policy we can't disclose any release dates.

Fixed as of the upcoming MySQL for Excel 1.3.6 release, and here's the changelog entry:

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.

Thank you for the bug report.

Confirmed working now:
- Excel 2013
- W10, 64 bit
- MS surface 3

Thanks!

hello, 
maybe there is incompatibility between mysql and your OS.
<a href="http://www.2upimg.com/1460022486.html"><img src="http://www.2upimg.com/img/1460022486.jpg"></a>