| Bug #72972 | Pivot Table dialog not displayed for tables holding large data | ||
|---|---|---|---|
| Submitted: | 12 Jun 2014 2:05 | Modified: | 30 Jun 2014 23:15 |
| Reporter: | Javier Treviño | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL for Windows: MySQL for Excel | Severity: | S2 (Serious) |
| Version: | 1.3.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[16 Jun 2014 21:09]
Javier Treviño
Posted by developer: Modified the way PivotTables are created to pass to the Excel native methods addresses in R1C1 notation rather than the actual range objects which works in all scenarios (even with big data).
[26 Jun 2014 19:53]
Rafael Antonio Bedoy Torres
Posted by developer: Fixed, checked using mysql-for-excel-commercial-1.3.1.
[30 Jun 2014 23:15]
Philip Olson
Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry: With the "Create a Pivot Table with the imported data" option enabled, "Data Import" failed to create a PivotTable for tables that contained a large data set. Thank you for the bug report.
Description: MySQL for Excel fails to create a PivotTable for a table holding large data in its columns. How to repeat: 1. Enable MySQL for Excel Plugin in MS Excel "Data" tab. 2. Import a table/view which the last column contains a HUGE amount of data (sakila.actor_info). 3. Make sure to check the "Create a Pivot Table with the imported data.". box before import. 4. Note there's no "PivotTable" created at all and no actual error message. The MySQL for Excel log contains this entry: MySQLForExcel Error: 1 : Application Exception on MySqlDataTable.CreatePivotTable - Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)) at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.PivotCaches.Create(XlPivotTableSourceType SourceType, Object SourceData, Object Version) at MySQL.ForExcel.Classes.MySqlDataTable.CreatePivotTable(Range atCell, Range dataRange) DateTime=2014-05-22T21:11:41.4253810Z Timestamp=4091095155 Callstack= at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)