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: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
