poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 50867] Problems adding a new XSSFSheet before a sheet containing a table
Date Tue, 08 Mar 2011 07:27:11 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=50867

Donato <d_tagliabue2@yahoo.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #2 from Donato <d_tagliabue2@yahoo.it> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message