https://issues.apache.org/bugzilla/show_bug.cgi?id=50867
Donato <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #2 from Donato <[email protected]> 2011-03-08 02:27:09 EST --- (In reply to comment #1) > Bad news - I can't see anything wrong with what POI is doing > I've looked at the POI output xlsx file, and all the relationships and links > look just fine to me. I've added a unit test in r1078065 which loads the > original file, checks it, adds the new sheet and re-orders, checks, saves + > reloads, and checks. All passes just fine. > Incidentally, OpenOffice has no problems opening the POI saved file, and the > table is writable. Unfortunately, that either means you've hit an Excel bug, > or > you've found an area where Excel is much stricter than it needs to be (and > also > stricter than POI + OpenOffice are) > What I'd suggest you do is firstly try a different version of excel, in case > it > is an excel bug. Failing that, perform the same action in excel as you did in > poi, and see if you can identify (by unzipping and comparing the xml) what > excel does differently Hi Nick, I tested the workbook created with POI on different Excel 2007 installations and as a matter of fact sometimes the bug happens and sometimes does not. I found that the problem is that more than one sheet are selected by default when the workbook is opened (and this prevents updating the table). The simple workaround I found is to use: workBook.getSheetAt(j).setSelected(false); on ALL sheets in the workBook. This solves the problem (so I think the bug can be closed). Thanks! -- 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: [email protected] For additional commands, e-mail: [email protected]
