Bug #73866 MYSQL FOR EXCEL ERROR WHILE IMPORTING AT WORKSHEET BOTTOM

• Submitted: 9 Sep 2014 17:46
• Modified: 10 Oct 2014 4:08
• Reporter: Javier Rivera Zavala
• Status: Closed
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.0.2
• OS: Any
• CPU Architecture: Any

[9 Sep 2014 17:46] Javier Rivera Zavala

Description:
When you import a table which rowcount is higher than the number of rows you have until the bottom of the file, a COM error is displayed and it doesn't allow you to import.

How to repeat:
1. Position the Cursor at the bottom of the Worksheet (CTRL + down arrow).
2. Move the cursor a couple of rows upwards to attempt leaving some space to import some rows at the bottom of the worksheet.
3. Navigate through MySQL for Excel Welcome panel until you can choose a table to import.
4. Click Import on any table (sakila.actor will work perfectly).
5. Click the Import button on the Import dialog and see the message that appears<<check attachment>>.

Suggested fix:
This appears to happen due to an existing error inside the collision detector method in MySQL for Excel to validate any import table doesn't collide with other already imported table, which fails to validate the size of the excel worksheet first. 

There is a current validation that shows a warning to any table being imported which contains more than 65535 rows. The fix should at least attempt to show the warning when the combination of rows count to be imported + the number of the current row the cursor is located in sum more than the actual Worksheet limit. In compatibility mode it should be 65536 and in newer versions of Excel it should be 1408576.

[18 Sep 2014 18:50] Javier Rivera Zavala

Posted by developer:
 
- Improved handling of Worksheet space to honor both row and column limits to avoid high severity errors while importing data into Excel.

[19 Sep 2014 21:01] Javier Rivera Zavala

Posted by developer:
 
- Improved handling of Worksheet space to honor both row and column limits to avoid high severity errors while importing data into Excel.

[10 Oct 2014 4:08] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.3 release, and here's the changelog entry:

Importing a table with a row count that exceeded the number of rows below
the cursor would generate a fatal "High severity error" and fail to import
the data. Now, the import succeeds but the "Import will be truncated since
it exceeds the available worksheet space."

Thank you for the bug report.