You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/07/08 00:34:46 UTC
DO NOT REPLY [Bug 45358] New: (3.1-FINAL) Array size should be (0)
but was
(114)
https://issues.apache.org/bugzilla/show_bug.cgi?id=45358
Summary: (3.1-FINAL) Array size should be (0) but was (114)
Product: POI
Version: unspecified
Platform: PC
OS/Version: Linux
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: zack.manning@gmail.com
When running HSSFFormulaEvaluator.evaluateAllFormulaCells(wb); the following
exception occurs:
java.lang.IllegalArgumentException: Array size should be (0) but was (114)
at
org.apache.poi.hssf.record.formula.eval.AreaEvalBase.<init>(AreaEvalBase.java:50)
at
org.apache.poi.hssf.record.formula.eval.Area3DEval.<init>(Area3DEval.java:32)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateArea3dPtg(HSSFFormulaEvaluator.java:510)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateCell(HSSFFormulaEvaluator.java:414)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:338)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:183)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:278)
at inavero.excelReporter.Generator.start(Generator.java:59)
at inavero.excelReporter.App$2.handleEvent(App.java:58)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at inavero.excelReporter.App.main(App.java:70)
I will try and put together a sanitized spreadsheet as soon as I can that still
reproduces the error.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45358] (3.1-FINAL) Array size should be (0) but
was (114)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45358
Tim <bo...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |bogguard@gmail.com
Status|NEEDINFO |ASSIGNED
--- Comment #2 from Tim <bo...@gmail.com> 2008-08-07 03:17:22 PST ---
I have the same issue and it is reproduced by the VLOOKUP function
for example : VLOOKUP(D28;$Z$129:$AE$276;2;0)
All the data within the VLOOKUP does not contain functions.
Kind regards
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45358] (3.1-FINAL) Array size should be (0) but
was (114)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45358
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution| |FIXED
--- Comment #4 from Josh Micich <jo...@gildedtree.com> 2008-08-31 19:34:47 PST ---
There were 3 problems encountered getting the sample spreadsheet to work with
HSSFFormulaEvaluator.evaluateAllFormulaCells(wb).
The first bug was that 3-d area refs like "Sheet1!A10:A40000" had a 16-bit
signed/unsigned error. Fixed and junit added in svn r690772.
Secondly there was a major performance problem with all the recursive
evaluation of the large areas referenced by the formulas. Before the fix,
evaluation was extremely slow (a test run was terminated after 4 minutes, with
no sign of progress). After the fix, the whole spreadsheet evaluates in about
10 seconds. It's also likely that the fix for bug 45376 (when it happens) will
alleviate things further. This was fixed in r690835.
Lastly there was a ClassCastException in the implementation of 'IF' due to the
first arg not being a plain BoolEval. Fix and junit added in svn r690836.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45358] (3.1-FINAL) Array size should be (0) but
was (114)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45358
--- Comment #3 from Antonio <am...@citic.es> 2008-08-14 03:41:28 PST ---
Created an attachment (id=22446)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22446)
Template that produce the error
This file produce a similar error:
java.lang.IllegalArgumentException: Array size should be (-2) but was (1998)
at
org.apache.poi.hssf.record.formula.eval.AreaEvalBase.<init>(AreaEvalBase.java:50)
at
org.apache.poi.hssf.record.formula.eval.Area3DEval.<init>(Area3DEval.java:32)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateArea3dPtg(HSSFFormulaEvaluator.java:510)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateCell(HSSFFormulaEvaluator.java:414)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:338)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:183)
I hope that it is a help to resolve the problem.
PS: The file is compress because it's was so big.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45358] (3.1-FINAL) Array size should be (0) but
was (114)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45358
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|major |normal
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2008-07-10 14:56:52 PST ---
Alas without the sample spreadsheet, we won't be able to figure out what's
going wrong (none of our current tests manage to trigger this)
If you could please upload a spreadsheet that triggers this, that'd be
wonderful.
(You'll probably find that replacing all the strings and numbers with dummy
values using poi will yield a file that triggers the error, but is uploadable
to bugzilla)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org