Little correction: Currently I use "3.0.1 final" successfully, not
2.5.1.
Should have read the manifest before mailing :-(
--cg
> -----Original Message-----
> From: Christian Gosch
> Sent: Wednesday, August 27, 2008 7:02 PM
> To: user
> Subject: Problem with POI-3.1-final-20080629, HSSF:
> HSSFRow.createCell((short)0) throws IllegalStateException
>
> Hi,
>
> I use POI 2.5.1 so far and plan to migrate to 3.1 now and actually do
> the first tests -- and they fail.
>
> Purpose of POI for me: Generate XLS files (simple tables, 1 sheet per
> WB) from scratch for download by Windows users
>
> Scenario: My code queries a DB and prepares lists from the results as
> Excel files for download by users. No formulas, no special data, no
> embedded objects. Formatting only requires things like boldface and
> borders and repeatable rows / freeze panes.
>
> Problem with 3.1 final (20080629): When I start to generate and fill a
> new workbook from scratch, I receive:
>
> java.lang.IllegalStateException: Cannot create value records before
row
> records exist
>
>
> Code dealing with POI HSSF looks like:
>
> HSSFWorkbook workbook = new HSSFWorkbook();
> HSSFSheet sheet = workbook.createSheet(name);
> // name.equals("Vorschauliste")
> HSSFRow row = sheet.createRow((short)xlsZeile);
> // xlsZeile == 0
> HSSFCell cell = row.createCell((short)0);
>
>
> Stack trace of POI code is:
>
> [27.08.08 13:25:06:825 CEST] 00000020 SystemErr R
> java.lang.IllegalStateException: Cannot create value records before
row
> records exist
> at org.apache.poi.hssf.model.Sheet.checkCells(Sheet.java:497)
> at
org.apache.poi.hssf.model.Sheet.addValueRecord(Sheet.java:1041)
> at
> org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:134)
> at
> org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:115)
> at
> de.dc.jnet.frame.servlet.XLSViewSrv.specialList(XLSViewSrv.java:1605)
> // last row: my code.
>
>
> I looked around and found that there were the following changes in the
> code base which may belong to this problem:
>
> Bug: https://issues.apache.org/bugzilla/show_bug.cgi?id=45145
> SVN: r663765
>
>
> I inspected the source code around the stack trace and found that in
> Sheet.checkCells() a condition (dealing with the binary sequence of
data
> records building the Excel file) is checked, but nothing is done
before
> in "my sequence of calls" to meet this condition. Moreover, I cannot
> force or tackle things like dimsloc in my code since they are part of
> the private HSSF data model.
>
> What can I do to get my code work with 3.1? (I do not plan to use
> template files.)
>
> tia,
> --
> Dipl.-Inform. Christian Gosch
> Systems Development
> inovex GmbH
> Karlsruher Strasse 71
> D-75179 Pforzheim
> Tel: 07231 3191-85
> Fax: 07231 3191-91
> [EMAIL PROTECTED]
> www.inovex.de
>
> Sitz der Gesellschaft: Pforzheim
> AG Mannheim, HRB 502126
> Geschäftsführer: Stephan Müller
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> !DSPAM:48b58acf22931046596568!
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
