MySQL Bugs: #74351: Import of any row over 65535 fails

Bug #74351	Import of any row over 65535 fails
Submitted:	13 Oct 2014 10:12	Modified:	14 Oct 2014 22:20
Reporter:	Adam Kłos	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S2 (Serious)
Version:	1.3.2	OS:	Windows (7 sp1)
Assigned to:		CPU Architecture:	Any
Tags:	Import excel 2003 limit 65535

Description:
I'm using MySQL for Excel together with Excel 2003. I'm aware of Excels row limit, but that doesn't seem to be the case.
MySQL for Excel seems to forbid importing any row over 65535 even if that's only one row.

How to repeat:
1. Prepare table with 66000 rows in it.
2. Create empty Excel 2003 spreadsheet and save it as xml (I can reproduce that also in Excel 2007 running in compatibility mode). 
3. Run MySQL for Excel and connect to db with prepared table.
4. Select table and press Import MySQL Data
5. In Import Data from MySQL dialog window check chceckbox next to "Limit to".
6. Enter 1000 in first spinbox and 65000 in second so the line says
"Limit to 1000 Rows and Start with Row 65000"
7. Hit Import.

Expected result is rows from 65000 to 66000 get imported into excel spreadsheet.
Actual result is content of first spin box change to 536 as soon as Import button is pressed.

Thank you for the bug report. I couldn't repeat with Excel 2010.