Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Save Pivot Grid in Excel 2007 with more than 65532 fails with : Unknown Area=Grid Results
1. Connect to Oracle 9i server at 10.168.1.54 properties is attached
2. Put max results 70,000 before you execute the query
3. Go to Pivot Grid
4. Right Click and try to save Pivot Grid Results as Excel 2007
I executed below Script
|
|
286 KB
|
|
28 KB
The error is from Aspose library, please see stack trace below for details.
In my test, I set max. rows to 70000; the "Unkown Area: ='Grid Results'!B4:H70004'"
is the area where grid data resides, and Aspose was not able to handle it.
It seems that this problem has been fixed in trunk; I could not produce this problem in trunk, please double check.
This problem exists in ADS 11.0 branch, though.
java.lang.IllegalArgumentException: Unkown Area: ='Grid Results'!B4:H70004
at com.aspose.cells.bY.a(Unknown Source)
at com.aspose.cells.bY.b(Unknown Source)
at com.aspose.cells.bY.<init>(Unknown Source)
at com.aspose.cells.jH.a(Unknown Source)
at com.aspose.cells.PivotTables.add(Unknown Source)
at com.aspose.cells.PivotTables.add(Unknown Source)
at com.common.export.excel.PivotWorksheet.createPivot(PivotWorksheet.java:43)
at com.aquafold.aquacore.etl.ETLExcel.exportPivot(ETLExcel.java:291)
at com.aquafold.datastudio.mainframe.dialog.SaveResultsExtDialog.outputResults(SaveResultsExtDialog.java:1078)
......
ADS 11.0 branch is linked with Aspose 2.5.3.
ADS trunk is linked with Aspose 7.1.0.
ADS 11.0 branch is linked with Aspose 2.5.3.
ADS trunk is linked with Aspose 7.1.0.
Also tried ADS 11.0 branch with Aspose 2.5.4, same error as Aspose 2.5.3.
Also tried ADS 11.0 branch with Aspose 2.5.4, same error as Aspose 2.5.3.
Aspose versioning history is ...
2.5.3 -
2.5.4 -
7.0.0 - Large API changes. Notes ...
A move towards using the Aspose Unified Framework which dictates an improved API for loading and saving. This makes
for a more organized and consistent API to be used across all Aspose products.
The source code from the .NET platform will now be automatically ported to the Java platform. This will enable Aspose.Cells
for Java to match Aspose.Cells for .NET feature-by-feature.
Aspose versioning history is ...
2.5.3 -
2.5.4 -
7.0.0 - Large API changes. Notes ...
A move towards using the Aspose Unified Framework which dictates an improved API for loading and saving. This makes
for a more organized and consistent API to be used across all Aspose products.
The source code from the .NET platform will now be automatically ported to the Java platform. This will enable Aspose.Cells
for Java to match Aspose.Cells for .NET feature-by-feature.
Aqua Data Studio is bundled with Aspose in the following version mappings ...
ADS 10.0 -> Aspose 2.5.3
ADS 11.0 -> Aspose 2.5.3
ADS 12.0 -> Aspose 7.1.0
We can upgrade 10.0 and 11.0 to Aspose 2.5.4, but we can't upgrade them to Aspose 7.1.0 because of all the API changes.
A fix for this bug will need to wait for ADS 12.0 which is schedule for the end of 2012.
Aqua Data Studio is bundled with Aspose in the following version mappings ...
ADS 10.0 -> Aspose 2.5.3
ADS 11.0 -> Aspose 2.5.3
ADS 12.0 -> Aspose 7.1.0
We can upgrade 10.0 and 11.0 to Aspose 2.5.4, but we can't upgrade them to Aspose 7.1.0 because of all the API changes.
A fix for this bug will need to wait for ADS 12.0 which is schedule for the end of 2012.
This is fixed for ADS 12.0 only. Need to do full regression testing.
This is fixed for ADS 12.0 only. Need to do full regression testing.
No more java.lang.IllegalArgumentException: Unkown Area: ='Grid Results'!B4:H70004 in the latest build
Tested with
70000
90000
120000
200000 rows with Oracle 9i SH.SALES table and Saved Pivot Grids in Win 7 OS
No more java.lang.IllegalArgumentException: Unkown Area: ='Grid Results'!B4:H70004 in the latest build
Tested with
70000
90000
120000
200000 rows with Oracle 9i SH.SALES table and Saved Pivot Grids in Win 7 OS
Issue #6537 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
The error is from Aspose library, please see stack trace below for details.
In my test, I set max. rows to 70000; the "Unkown Area: ='Grid Results'!B4:H70004'"
is the area where grid data resides, and Aspose was not able to handle it.
It seems that this problem has been fixed in trunk; I could not produce this problem in trunk, please double check.
This problem exists in ADS 11.0 branch, though.
java.lang.IllegalArgumentException: Unkown Area: ='Grid Results'!B4:H70004
at com.aspose.cells.bY.a(Unknown Source)
at com.aspose.cells.bY.b(Unknown Source)
at com.aspose.cells.bY.<init>(Unknown Source)
at com.aspose.cells.jH.a(Unknown Source)
at com.aspose.cells.PivotTables.add(Unknown Source)
at com.aspose.cells.PivotTables.add(Unknown Source)
at com.common.export.excel.PivotWorksheet.createPivot(PivotWorksheet.java:43)
at com.aquafold.aquacore.etl.ETLExcel.exportPivot(ETLExcel.java:291)
at com.aquafold.datastudio.mainframe.dialog.SaveResultsExtDialog.outputResults(SaveResultsExtDialog.java:1078)
......