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 2006/08/18 12:39:33 UTC
DO NOT REPLY [Bug 40283] New: - Cells which control radio buttons get reset when read by Excel
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40283>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40283
Summary: Cells which control radio buttons get reset when read by
Excel
Product: POI
Version: 2.5
Platform: Other
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: gareth.smith@certus-tech.com
CC: gareth.smith@certus-tech.com
To reproduce this behaviour: Create a workbook containing a named range on one
worksheet and a group of radio buttons which are governed by the named range on
another worksheet.
Read the workbook using POI, set the value of the named cell to be 1 (this
should then update the radio buttons and result in one of them having been
selected) and then write the file out again. When you load up the output file in
Excel the radio button is set correctly, however the named cell now has the same
value which the input file was saved with (if the input file had no value set
then the cell withh have the value 0). If you save the .xls file with the named
cell selected then when you open the file after it has been passed through POI
it is sometimes possible to observe the cell having the value 1 in it before the
sheet is updated by Excel and the value is reverted to what it was before POI
read the file.
The radio buttons on the output file still function correctly; the only issue is
that the named range has its value reverted when the file is opened. I assume
that this issue is caused by the synchronisation between the cell setting the
value of the radio buttons and the radio buttons setting the value of the cell.
It appears that this is probably an issue with the way Excel synchronises form
controls rather than POI having corrupted the data, however I will attach an
example file and test which exposes this behaviour just in case and if there is
a known work-around for this issue then any feedback would be greatly appreciated.
Thanks for your continued work on this project,
Gareth
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 40283] - Cells which control radio buttons get reset when read by Excel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40283>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40283
------- Additional Comments From gareth.smith@certus-tech.com 2006-08-18 10:40 -------
Created an attachment (id=18732)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=18732&action=view)
XLS file configured to expose this behaviour
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 40283] - Cells which control radio buttons get reset when read by Excel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40283>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40283
------- Additional Comments From gareth.smith@certus-tech.com 2006-08-18 10:41 -------
Created an attachment (id=18733)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=18733&action=view)
Test class which will expose the problem
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 40283] - Cells which control radio buttons get reset when read by Excel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40283>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40283
------- Additional Comments From gareth.smith@certus-tech.com 2006-08-18 10:52 -------
I forgot to mention: This test uses POI 2.5.1 final (poi-2.5.1-final-20040804.jar).
I tried using the latest POI alpha (poi-3.0-alpha2-20060616.jar) however this
caused Excel to fail to load the file propely and "repair" the workbook,
resulting in the form controls and all cell formatting being lost.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/