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 17483] New: - template problems
Date Thu, 27 Feb 2003 12:21:41 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17483>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17483

template problems

           Summary: template problems
           Product: POI
           Version: 1.5.1
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: stephen@basit.com


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.

Mime
View raw message