Bug 17483 - template problems
Summary: template problems
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.5.1
Hardware: PC All
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-02-27 12:21 UTC by Stephen
Modified: 2005-03-20 17:06 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stephen 2003-02-27 12:21:41 UTC
I am using 1.5.1

In Excel, I create a "template" xls file, with 14 worksheets.
Sheet 0 has stuff on it. The other 13 are blank.

Then, using POI API, I put some stuff on sheets 1 and 2.

Then, I remove the sheets that are not being used.

When I remove 5 sheets, it works ok.
When I remove 6 sheets, it works ok.
When I remove 7 sheets, it works ok.

When I remove 8 or more sheets, the results is that
the spreadsheet opens with only the initial sheet 0,
and no other tabs.

I am removing from the highest sheets, downward.
I look for the name of the sheet and find the index.
Then I remove the sheet based on the index.

There do not seem to be any "exceptions" created.

WHEN I LIMIT THE INITIAL NUMBER OF SHEETS TO 11,
IT WORKS FINE.  FORTUNATELY, THAT SUFFICES
FOR ME FOR NOW.
Comment 1 Jason Height 2003-02-27 21:12:48 UTC
Upload your template file (use create attachment) and a simple piece of code 
that uses your template to demonstrate the problem.
Comment 2 Andy Oliver 2003-07-24 15:51:13 UTC
info asked for but not received.