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 2009/03/24 09:27:30 UTC
DO NOT REPLY [Bug 46898] New: Unexpected Error -60 Circular
reference
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Summary: Unexpected Error -60 Circular reference
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: kokkik.cheong@streamsolutions.com.sg
CC: kokkik.cheong@streamsolutions.com.sg
Hi,
I've posted similar issue on Jan 2009. I thought the problem was solved but it
re-occur again. I've attached 2 java source files and an excel spreadsheet. As
mentioned, the unexpected error code -60 was stating circular reference which
is not found in excel spreadsheet.
Please update the source file as i've hardcoded the excel spreadsheet path into
it.
Regards,
KK
--
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
[Bug 46898] [PATCH] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |NEEDINFO
--- Comment #8 from Dominik Stadler <do...@gmx.at> ---
I have changed the tests via r1649122 to also run for XSSF, they run fine
currently so the cases verified for HSSF work fine for XSSF as well already.
For the proposed change to FormulaError to change the error to INVALID_VALUE I
am not sure if this is the right thing to do as it leaves ERROR_CIRCULAR_REF in
some places (e.g. value.getErrorValue()) and changes the error to VALUE_INVALID
in others, obviously I don't know this part of the code well enough to be sure,
but wouldn't we change the error-code in a more central place to have
INVALID_VALLUE everywhere?
--
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 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
--- Comment #1 from Cheong Kok Kik <ko...@streamsolutions.com.sg> 2009-03-24 05:12:21 PST ---
Hi,
I've tested the code using 3.5 beta 5 as well. The result return is same. I'll
upload the file via other website and provide a link later. (Due to 1 MB
constraint in bugzilla website)
Regards,
Kok Kik.
--
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
[Bug 46898] [PATCH] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |PatchAvailable
Summary|Unexpected Error -60 |[PATCH] Unexpected Error
|Circular reference |-60 Circular reference
--
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 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
--- Comment #2 from Cheong Kok Kik <ko...@streamsolutions.com.sg> 2009-03-24 08:01:45 PST ---
Created an attachment (id=23409)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23409)
Java Application
Small app to
a. Update parameter at worksheet "Parameters & Data"
b. Extract data on worksheet "SI".
Command to execute:
java -Xms128m -Xmx512m -cp "lib\poi-scratchpad-3.5-beta5-20090219.jar;lib\po
i-3.5-beta5-20090219.jar;lib\poi-contrib-3.5-beta5-20090219.jar;." poi_hssf
"spreadsheet name.xls"
Please note that the spreadsheet will be provided in URL later. (Once uploaded
successfully)
--
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
[Bug 46898] [PATCH] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #31349|1 |0
is patch| |
--
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 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #4 from Josh Micich <jo...@gildedtree.com> 2009-03-30 13:56:44 PST ---
Fixed in svn 760162
junit added
Thanks for the example - it would have been difficult to guess the cause of
this error. The problem was with the interaction between caching formula
results and detection of circular references. The bug depends on the order of
evaluation. This is probably why you mentioned the problem as being
intermittent. Take at look at the new unit test for an isolated example.
--
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
[Bug 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
--- Comment #5 from Cliff Binstock <cl...@xbrlcloud.com> ---
Created attachment 31349
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31349&action=edit
Patch which checks for circular reference error code
--
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
[Bug 46898] [PATCH] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Martin Studer <ma...@mirai-solutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |martin.studer@mirai-solutio
| |ns.com
--
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
[Bug 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
Cliff Binstock <cl...@xbrlcloud.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Version|3.2-FINAL |3.11-dev
Hardware|PC |HP
Component|HSSF |XSSF
CC| |cliff.binstock@xbrlcloud.co
| |m
Resolution|FIXED |---
Severity|major |blocker
OS|Windows XP |Linux
--- Comment #7 from Cliff Binstock <cl...@xbrlcloud.com> ---
It seems that circular references are handled correctly for HSSF, but not XSSF.
In fact, all of the circular reference tests cases (and most others for that
matter) seem to be related to HSSF, so I wasn't sure where to put an
XSSF-specific test case (or suite).
I have included a patch that works (doesn't create an Exception, and creates a
"VALUE#!" error in the spreadsheet. But, it seems like maybe there is an
architectual issue in that this isn't handled at the HSSF level.
--
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 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
--- Comment #3 from Cheong Kok Kik <ko...@streamsolutions.com.sg> 2009-03-24 09:08:20 PST ---
Please download the spreadsheet at ftp site located at
ftp.streamsolutions.com.sg.
User id is ftp@streamsolutions.com.sg and no password.
The file is poi-200903.zip.
--
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
[Bug 46898] Unexpected Error -60 Circular reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46898
--- Comment #6 from Cliff Binstock <cl...@xbrlcloud.com> ---
Created attachment 31350
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31350&action=edit
XLSX with circular reference
--
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